mysql Error [1064] : EXECUTE
URI: index.php?option=com_content&task=view&id=8&Itemid=49
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
FROM elx_content a
LEFT JOIN elx_categories cc ON cc.id = a.catid
LEFT' 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
FROM elx_content a
LEFT JOIN elx_categories cc ON cc.id = a.catid
LEFT JOIN elx_sections s ON s.id = cc.section AND s.scope='content'
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_core_acl_aro_groups g ON a.access = g.group_id
WHERE a.id='8'
AND (a.state = '1' OR a.state = '-1')
AND (a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2024-04-28 20:59:11')
AND (a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2024-04-28 20:59:11')
AND a.access IN (29)
AND ((a.language IS NULL) OR (a.language LIKE '%english%'))
AND ((cc.language IS NULL) OR (cc.language LIKE '%english%'))
AND ((s.language IS NULL) OR (s.language LIKE '%english%')) LIMIT 0,1
Error 404
We are sorry but the page you requested was not found.
/index.php?option=com_content&task=view&id=8&Itemid=49
Visit any of the following pages