SQL: SELECT id, headline, byline, date, ct.num_comments, summary, photo AS image, photo_index AS image_198, photo_large AS image_476, headline_url FROM feature_article AS fa LEFT JOIN sitellite_user AS su ON su.username = fa.byline LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = "lifestyle" WHERE type = "lifestyle" AND date <= NOW() AND sitellite_status ="approved" ORDER BY fa.date DESC, fa.id DESC LIMIT 0, 28 NULL
SQL: SELECT id, headline, byline, date, ct.num_comments, summary, photo AS image, photo_index AS image_198, photo_large AS image_476, headline_url FROM feature_article AS fa LEFT JOIN sitellite_user AS su ON su.username = fa.byline LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = "lifestyle" WHERE type = "lifestyle" AND date <= NOW() AND sitellite_status ="approved" ORDER BY fa.date DESC, fa.id DESC LIMIT 0, 5 NULL
SQL: SELECT id, headline, summary, headline_url FROM feature_article AS fa WHERE type = "lifestyle" AND date <= NOW() AND sitellite_status ="approved" AND fa.date >= DATE_SUB(NOW(), INTERVAL 3 MONTH) ORDER BY fa.times_read DESC LIMIT 0,5 NULL
SQL: SELECT id, headline, summary, headline_url FROM feature_article AS fa LEFT JOIN comment_thread AS ct ON ct.article_id = fa.id AND ct.section_id = "" WHERE type = "lifestyle" AND date <= NOW() AND sitellite_status ="approved" AND fa.date >= DATE_SUB(NOW(), INTERVAL 3 MONTH) ORDER BY ct.num_comments DESC LIMIT 0,5 NULL