Invalid SQL: SELECT S.* ,T.DESCRIP as TEMPLATE_DESCRIP ,P.DESCRIP as PLACE_DESCRIP ,(select CONCAT(PI.PICFILEPATH,PI.PICFILENAME) from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICFILE ,(select PI.DETAIL from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICDETAIL ,(select DI.DESCRIP from TDIC DI where DI.TABLE_NAME='TSECTION' and DI.TABLE_FIELD='DESCRIP' and DI.TABLE_ID = S.IDSECTION AND DI.IDLAN= 2 LIMIT 1) as DICDESCRIP ,(select DI.DESCRIP from TDIC DI where DI.TABLE_NAME='TSECTION' and DI.TABLE_FIELD='DETAIL' and DI.TABLE_ID = S.IDSECTION AND DI.IDLAN= 2 LIMIT 1) as DICDETAIL FROM TSECTION S LEFT JOIN TTEMPLATE T on (S.IDTEMPLATE=T.IDTEMPLATE) LEFT JOIN TPLACE P on (S.IDPLACE=P.IDPLACE) WHERE 1=1 AND IDSECTIONROOT = 1 AND S.VISIBLE = 'S' ORDER BY NUMORDER

Invalid SQL: SELECT U.* ,L.DESCRIP as LAN_DESCRIP FROM TDIC U LEFT JOIN TLAN L on (U.IDLAN = L.IDLAN) WHERE 1=1 AND U.IDLAN = '2' AND TABLE_NAME = 'PALABRAS' ORDER BY TABLE_NAME,TABLE_FIELD,TABLE_ID,IDLAN,DESCRIP

Invalid SQL: SELECT S.* ,(select CONCAT(PI.PICFILEPATH,PI.PICFILENAME) from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICFILE ,(select PI.DETAIL from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICDETAIL FROM TSECTION S WHERE IDSECTION = 1

 María Laura Ferrera Van Thienen
Invalid SQL: SELECT S.* ,T.DESCRIP as TEMPLATE_DESCRIP ,P.DESCRIP as PLACE_DESCRIP ,(select CONCAT(PI.PICFILEPATH,PI.PICFILENAME) from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICFILE ,(select PI.DETAIL from TPIC PI where PI.TABLE_NAME='TSECTION' and PI.TABLE_ID=S.IDSECTION AND PI.VISIBLE='S' AND PI.HIGHLIGHT='S' LIMIT 1) as PICDETAIL ,(select DI.DESCRIP from TDIC DI where DI.TABLE_NAME='TSECTION' and DI.TABLE_FIELD='DESCRIP' and DI.TABLE_ID = S.IDSECTION AND DI.IDLAN= 2 LIMIT 1) as DICDESCRIP ,(select DI.DESCRIP from TDIC DI where DI.TABLE_NAME='TSECTION' and DI.TABLE_FIELD='DETAIL' and DI.TABLE_ID = S.IDSECTION AND DI.IDLAN= 2 LIMIT 1) as DICDETAIL FROM TSECTION S LEFT JOIN TTEMPLATE T on (S.IDTEMPLATE=T.IDTEMPLATE) LEFT JOIN TPLACE P on (S.IDPLACE=P.IDPLACE) WHERE 1=1 AND IDSECTIONROOT = 1 AND S.VISIBLE = 'S' AND S.IDSECTIONPARENT = 1 AND S.IDTEMPLATE = 7 ORDER BY NUMORDER