1064: 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 'GROUP BY pages.pid
ORDER BY pages.pid DESC
LIMIT 10' at line 19: SELECT pages.*, files.*,
rubrics.id AS rubric_id, rubrics.name as rubric_name, rubrics.image as rubric_image,
COUNT(DISTINCT comments.id) AS comments_count,
GROUP_CONCAT(tag_names.tag SEPARATOR '|') AS tags
FROM spekulant3_magazine_pages AS pages
LEFT JOIN spekulant3_magazine_files AS files
ON pages.pid=files.fpid
LEFT JOIN spekulant3_magazine_rubrics AS rubrics
ON pages.prid=rubrics.id
LEFT JOIN spekulant3_comments as comments
ON comments.itemid=pages.pid AND comments.mdirname='magazine'
LEFT JOIN spekulant3_tags AS tags
ON tags.itemid=pages.pid AND tags.mdirname='magazine'
LEFT JOIN spekulant3_tag_names AS tag_names
ON tag_names.id=tags.id
WHERE rubrics.id='4' AND pages.pid <=
GROUP BY pages.pid
ORDER BY pages.pid DESC
LIMIT 10
