SELECT c . * , g.name AS groupname, cc.title AS name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author
FROM jos_content AS c
LEFT JOIN jos_categories AS cc ON cc.id = c.catid
LEFT JOIN jos_sections AS s ON s.id = c.sectionid
LEFT JOIN jos_groups AS g ON g.id = c.access
LEFT JOIN jos_users AS u ON u.id = c.checked_out
LEFT JOIN jos_users AS v ON v.id = c.created_by
LEFT JOIN jos_content_frontpage AS f ON f.content_id = c.id
WHERE c.state != -2
ORDER BY section_name, section_name, cc.title, c.ordering
LIMIT 0 , 20