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|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|entertainment^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"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'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 10450
- Committed: In Which Elizabeth Gilbert Wrestles With More First-World Problems In The Third WorldBy Sadie SteinJanuary 5, 2010 | 8:00pm
- Last Titanic Survivor DiesBy Anna NorthJune 1, 2009 | 3:00pm
- Wintergirls: Possibly Triggering, Definitely Thought-ProvokingBy Anna NorthMay 19, 2009 | 6:00pm
- Bad Mother, Good WriterBy Anna NorthMay 11, 2009 | 10:40pm
- Bad Mother Promises "Maternal Crimes," Delivers MisdemeanorsBy Anna NorthMay 8, 2009 | 6:00pm
- Cosmo's Helen Gurley Brown: Maybe Not Such A Bad Girl After AllBy Anna NorthMay 4, 2009 | 6:00pm
- Women, Children, American Louts First!By Sadie SteinJanuary 29, 2009 | 11:15pm