mysql Error [1064] : EXECUTE
URI: index.php?option=com_content&task=blogcategory&id=18&Itemid=97
Message: 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 'groups, (SELECT COUNT(z.cid) FROM elx_comments z WHERE z.origin='1' AND z.articl' at line 2
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype,
cc.name AS category, cc.seotitle AS catseotitle, s.name AS section, s.seotitle AS secseotitle, g.name AS groups, (SELECT COUNT(z.cid) FROM elx_comments z WHERE z.origin='1' AND z.articleid = a.id AND z.published='1') AS comments
FROM elx_content a
LEFT JOIN elx_categories cc ON cc.id = a.catid
LEFT JOIN elx_users u ON u.id = a.created_by
LEFT JOIN elx_content_rating v ON a.id = v.content_id
LEFT JOIN elx_sections s ON a.sectionid = s.id
LEFT JOIN elx_core_acl_aro_groups g ON a.access = g.group_id
WHERE a.state = '1'
AND ( a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2024-04-24 06:49:24' )
AND ( a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2024-04-24 06:49:24' )
AND a.access IN (29)
AND a.catid IN (18)
AND s.access IN (29)
AND a.access IN (29)
AND cc.published = '1'
AND s.published = '1'
AND ((a.language LIKE '%english%') OR (a.language IS NULL))
AND ((cc.language LIKE '%english%') OR (cc.language IS NULL))
AND ((s.language LIKE '%english%') OR (s.language IS NULL))
ORDER BY a.created DESC
mysql Error [1146] : EXECUTE
URI: index.php?option=com_content&task=blogcategory&id=18&Itemid=97
Message: Table 'simmsee_db.elx_eblog' doesn't exist
SELECT b.id, b.title, b.seotitle, b.blogid, b.blogtext, s.seotitle AS seoblog FROM elx_eblog b
LEFT JOIN elx_eblog_settings s ON s.blogid = b.blogid
WHERE s.published = '1'
AND ((b.language IS NULL) OR (b.language LIKE '%english%'))
ORDER BY b.dateadded DESC LIMIT 0,5
