Edge

In
SELECT m.filename AS filename, c.area_id AS area_id, e.* FROM content_entry e INNER JOIN content_entry p ON e.parent_id = p.id INNER JOIN content_module m ON e.module_id = m.id INNER JOIN content_category c ON e.category_id = c.id INNER JOIN content_area a ON c.area_id = a.id WHERE ((e.category_id = 20) AND (e.parent_id > 0) AND (e.feature_id = 5) or (e.feature_id = 10)) and month(e.article_date) = 8 AND year(e.article_date) = 2008 AND e.status_id = 2 and e.appearnews < 2 ORDER BY e.article_date desc
Edge