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('+"|video-entertainment|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|video-entertainment^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"video-entertainment|"' 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 = 'video'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 50
- Let's Discuss the Wild 1996 Summer OlympicsBy Shannon MeleroAugust 6, 2021 | 6:45pm
- Someone Please Tell Us Who Gave the Greenlight to Man vs. Beast, And WhyBy Joyzel AcevedoJuly 16, 2021 | 7:05pm
- Who's the Himbo-iest Real Housewives Boy Toy?By Joel KahnJuly 15, 2021 | 2:05pm
- Revisiting Joe Millionaire, the Experimental 2003 Dating Show Built On an Elaborate LieBy Shannon MeleroJuly 12, 2021 | 3:20pm
- Zola Is a Spectacle, But Taylour Paige Says It Captures Something Real About Race, Gender, and Sex WorkBy Joyzel AcevedoJune 30, 2021 | 7:30pm
- Director Taylor Garron Wants to Let People of Color Be Mediocre on ScreenBy Joyzel AcevedoJune 23, 2021 | 3:00pm
- Which Real Housewife Has the Worst Husband?By Joel KahnJune 17, 2021 | 5:00pm
- Which Real Housewife Has the Best Gay Best Friend?By Joel KahnJune 4, 2021 | 4:45pm