fdsfdsfds
SELECT c.id AS id, c.title AS title, c.sectionid, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug, CASE WHEN CHAR_LENGTH(ct.alias) THEN CONCAT_WS(":", ct.id, ct.alias) ELSE ct.id END as catslug
, COUNT(cc.id) AS comments, MAX(cc.date) AS commentdate
FROM jos_content AS c
LEFT JOIN jos_jcomments AS cc ON c.id = cc.object_id
LEFT JOIN jos_categories AS ct ON ct.id = c.catid
WHERE c.state = 1
AND c.access <= '0'
AND cc.object_group = 'com_content'
AND (c.sectionid IN (3) )
GROUP BY c.id, c.title, c.sectionid, slug, catslug
ORDER BY commentdate DESC
LIMIT 5
