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('+"|tv|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|tv^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"tv|"' 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 = 'tv'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 0
GET SPLINTER RIGHT IN YOUR INBOX
The Truth Hurts
