| ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND a.datepublished <= NOW() AND a.flag_published = 1 GROUP BY a.articleid # ' at line 20 |
| ERROR SQL: SELECT a.*, c.categoryid as categoryid, c.section AS section, UNIX_TIMESTAMP(a.datepublished) AS unixPublished, UNIX_TIMESTAMP(a.datecreated) AS unixCreated, UNIX_TIMESTAMP(a.dateupdated) AS unixUpdated, imgh.extension AS gfx_heading_extension, imgh.width AS gfx_heading_x, imgh.height AS gfx_heading_y, imgl.extension AS gfx_list_extension, imgl.width AS gfx_list_x, imgl.height AS gfx_list_y, imgf.extension AS gfx_feature_extension, imgf.width AS gfx_feature_x, imgf.height AS gfx_feature_y, GROUP_CONCAT(at.tagid) AS tagIds, GROUP_CONCAT(t.tagname) AS tagNames, GROUP_CONCAT(ac.categoryid) AS categoryIds, GROUP_CONCAT(CONCAT(al.countryid,'-',al.stateid,'-',al.cityid)) AS locations FROM fridaeweb.article a LEFT JOIN fridaeweb.media_image imgh ON a.image_heading = imgh.imageid LEFT JOIN fridaeweb.media_image imgl ON a.image_list = imgl.imageid LEFT JOIN fridaeweb.media_image imgf ON a.image_feature = imgf.imageid LEFT JOIN fridaeweb.article_tag at ON a.articleid = at.articleid LEFT JOIN fridaeweb.tag t ON at.tagid = t.tagid LEFT JOIN fridaeweb.article_category ac ON a.articleid = ac.articleid LEFT JOIN fridaeweb.category c ON ac.categoryid = c.categoryid LEFT JOIN fridaeweb.article_location al ON a.articleid = al.articleid WHERE a.articleid IN () AND a.datepublished <= NOW() AND a.flag_published = 1 GROUP BY a.articleid # /svn/fridae/common/trunk/src/modules/articles/init.php, 757, /newsfeatures/article.php |
| /newsfeatures/1970/01/01/. |