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 = 83