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 S.PAGENAME = 'promociones'
Página: promociones