mysql Greška [1064] : EXECUTE
URI: index.php?option=com_frontpage&Itemid=2
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 mar_content a INNER JOIN mar_content_frontpage f ON f.content_id =' 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 mar_content a INNER JOIN mar_content_frontpage f ON f.content_id = a.id INNER JOIN mar_categories cc ON cc.id = a.catid INNER JOIN mar_sections s ON s.id = a.sectionid LEFT JOIN mar_users u ON u.id = a.created_by LEFT JOIN mar_content_rating v ON a.id = v.content_id LEFT JOIN mar_core_acl_aro_groups g ON a.access = g.group_id WHERE a.state = '1' AND s.published = '1' AND cc.published = '1' AND ((a.language LIKE '%serbian%') OR (a.language IS NULL)) AND ((cc.language LIKE '%serbian%') OR (cc.language IS NULL)) AND ((s.language LIKE '%serbian%') OR (s.language IS NULL)) AND ( publish_up = '1979-12-19 00:00:00' OR publish_up <= '2024-10-09 12:52:31' ) AND ( publish_down = '2060-01-01 00:00:00' OR publish_down >= '2024-10-09 12:52:31' ) ORDER BY cc.ordering, a.created DESC
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 mar_content a INNER JOIN mar_content_frontpage f ON f.content_id =' 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 mar_content a INNER JOIN mar_content_frontpage f ON f.content_id = a.id INNER JOIN mar_categories cc ON cc.id = a.catid INNER JOIN mar_sections s ON s.id = a.sectionid LEFT JOIN mar_users u ON u.id = a.created_by LEFT JOIN mar_content_rating v ON a.id = v.content_id LEFT JOIN mar_core_acl_aro_groups g ON a.access = g.group_id WHERE a.state = '1' AND s.published = '1' AND cc.published = '1' AND ((a.language LIKE '%serbian%') OR (a.language IS NULL)) AND ((cc.language LIKE '%serbian%') OR (cc.language IS NULL)) AND ((s.language LIKE '%serbian%') OR (s.language IS NULL)) AND ( publish_up = '1979-12-19 00:00:00' OR publish_up <= '2024-10-09 12:52:31' ) AND ( publish_down = '2060-01-01 00:00:00' OR publish_down >= '2024-10-09 12:52:31' ) ORDER BY cc.ordering, a.created DESC
Upozorenje
Nema sadržaja za prikaz