Ну вот допустим этот большой селект. Что он пытается сделать в этом селекте?
SELECT a.images, a.introtext, a.id, a.title, a.sectionid, a.catid, cc.title as cattitle, cc.description as catdesc, sc.title as sectitle, sc.description as secdescription
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS sc ON sc.id = a.sectionid
WHERE ( a.state = 1 AND a.sectionid > 0
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-10-16 21:57' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-10-16 21:57' )
AND a.access <= 0 AND cc.access <= 0
AND ( a.catid = 37 )
AND cc.published = 1 )
ORDER BY a.created DESC limit 4
