Invalid SQL: SELECT P.*
,(select count(*) from TACTIVITY A where A.ACTIVITYTYPE='COM' and A.TABLE_NAME='TBLOGPOST' and A.TABLE_ID=P.IDBLOGPOST and A.STATUS='OK') as COMMENTS
FROM TBLOGPOST P
WHERE 1=1
AND IDBLOG = 1
AND DATEFROM is not null and DATEFROM <= now()
ORDER BY IDBLOG,DATEFROM DESC,IDBLOGPOST DESC
Blog de @LauraFerrera
http://www.lauraferrera.com/m_blog.html
Soy consultora Social Media y estratega de Marketing online. Me encanta escribir artículos sobre Social Media, Marketing online, Community Management y habilidades y compartirlos contigo.es-esTue, 10 Sep 2014 00:00:00 CESTThu, 03 Apr 2025 18:47:15 CESTWeblog LauraFerrera.comemail@lauraferrera.commail@lauraferrera.com