SELECT SQL_CALC_FOUND_ROWS ID, post_title, post_date, IF(lead_img_url_cdn IS NULL OR lead_img_url_cdn='', lead_img_url, lead_img_url_cdn) AS lead_img_url, permalink, co_authors, rating FROM pm_article_index AS a WHERE 1=1 AND post_status = 'publish' AND (MATCH(article_category) AGAINST('+"|in-depth|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|in-depth^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"in-depth|"' IN BOOLEAN MODE)) AND ID NOT IN (SELECT ai.ID FROM `pm_article_index` as ai inner join pm_top_article_display as d ON (d.id=ai.id) where position IN (1,2,3) AND d.section = 'in-depth' ORDER BY position) ORDER BY post_date DESC LIMIT 25 OFFSET 475