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('+"|celebrities-entertainment|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|celebrities-entertainment^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"celebrities-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 = 'celebrities-entertainment'
ORDER BY position)
ORDER BY post_date DESC LIMIT 108 OFFSET 216
- Meet the Man Behind Gossip Cop, Which Keeps the Tabloids in CheckBy Madeleine DaviesApril 26, 2017 | 6:30pm
- How Real Is The Rock’s Feud with His Fate of the Furious Co-Star Vin Diesel? A Superfan ExploresBy Madeleine DaviesApril 19, 2017 | 6:00pm
- Does Anyone Care If Jamie Foxx and Katie Holmes Are Dating? All Signs Point to NoBy Madeleine DaviesApril 12, 2017 | 6:30pm
- Watch What Happens When You Work in Reality TVBy Bobby FingerApril 5, 2017 | 6:15pm
- Why Are We Still Obsessed with the Tonya Harding/Nancy Kerrigan Scandal of 1994?By Madeleine DaviesMarch 29, 2017 | 5:10pm
- DirtCast: A Jezebel Podcast About Celebrity GossipBy Jezebel AdminMarch 27, 2017 | 6:35pm
- Revisiting the Glory Days of Us WeeklyBy Bobby FingerMarch 22, 2017 | 3:15pm
- Will The Bachelor Ever Become the Honest Fuck Fest That We Know It to Be?By Madeleine DaviesMarch 16, 2017 | 5:05pm
- Is Scientology on the Way Out? By Bobby FingerMarch 9, 2017 | 3:45pm
- Is the 'Oscar Curse' Real, or Just More Fake News?By Bobby FingerMarch 1, 2017 | 3:40pm
- Get Ready for DirtCast, Jezebel's New Celebrity Gossip PodcastBy Madeleine DaviesJanuary 31, 2017 | 10:00pm
