mysql Greška [1064] : EXECUTE
URI: index.php?option=com_content&task=blogcategory&id=27&Itemid=67
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 LEFT JOIN mar_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 mar_content a LEFT JOIN mar_categories cc ON cc.id = a.catid 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_sections s ON a.sectionid = s.id LEFT JOIN mar_core_acl_aro_groups g ON a.access = g.group_id WHERE a.state = '1' AND UNIX_TIMESTAMP(a.publish_up) <= '1728480599' AND (a.publish_down = '2060-01-01 00:00:00' OR UNIX_TIMESTAMP(a.publish_down) >= '1728480599') AND a.catid IN ( 27 ) AND s.access IN (29) AND cc.published = '1' AND s.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)) ORDER BY 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 LEFT JOIN mar_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 mar_content a LEFT JOIN mar_categories cc ON cc.id = a.catid 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_sections s ON a.sectionid = s.id LEFT JOIN mar_core_acl_aro_groups g ON a.access = g.group_id WHERE a.state = '1' AND UNIX_TIMESTAMP(a.publish_up) <= '1728480599' AND (a.publish_down = '2060-01-01 00:00:00' OR UNIX_TIMESTAMP(a.publish_down) >= '1728480599') AND a.catid IN ( 27 ) AND s.access IN (29) AND cc.published = '1' AND s.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)) ORDER BY a.created DESC
Betoven na uvce
Upozorenje
Nema sadržaja za prikaz