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('+"|entertainment-entertainment|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|entertainment-entertainment^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"entertainment-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 = 'entertainment-entertainment'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 725
- Sometimes As a Mountain Lion You Have to Take a 6-Hour Nap in a Person's HomeBy Mountain LionJuly 25, 2018 | 9:00pm
- Don't Play Yaself TodayBy Clover HopeMarch 31, 2017 | 2:15pm
- Here It Is, Nick Jonas' Favorite SnackBy Patrick RedfordApril 2, 2016 | 12:03am
- You Need These Dope-Ass Wombats In Your LifeBy Giri Nathan & Patrick RedfordApril 1, 2016 | 9:35pm
- Samoyeds Are GoodBy Samer KalafApril 1, 2016 | 9:25pm
- Would You Let A Man Drink Your Vagina Beer?By Tom LeyApril 1, 2016 | 7:35pm
- Golf, Sport's Most Prominent Symbol Of The Patriarchy, Is Dying. We Should Dance On Its Grave.By Timothy BurkeApril 1, 2016 | 1:25pm
- Good Morning! We're From DeadspinBy Tim MarchmanApril 1, 2016 | 1:00pm