ERROR:
QUERY:
SELECT c.blog, c1.id as cid,a.id, a.add_date, a.show_date,a.location, a.thumb,a.article_hash, a.right_thumb, a.title, a.alt_title, a.short, a.extra_narrow, a.extra_wide, a.show_date,c1.name as pub_name,c1.sef as pub_sef,a.author,a.short,c.name as cat_name,c.sef as cat_sef,COUNT(DISTINCT cm.id) as comment
FROM vs_article a
LEFT JOIN vs_category_article ca ON a.id=ca.aid
LEFT JOIN vs_category c ON ca.cid=c.id AND a.status=c.status
LEFT JOIN vs_comments cm ON cm.aid=a.id AND cm.is_spec='0' AND cm.status IN('1','2')
WHERE c.sef='sport1' AND c.status='1' AND show_date<=UNIX_TIMESTAMP()
GROUP BY a.id
ORDER BY
Sport - page - 1 - Visions of Azerbaijan Magazine
