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('+"|dirt-bag|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|dirt-bag^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"dirt-bag|"' 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 = 'dirt-bag'
ORDER BY position)
ORDER BY post_date DESC LIMIT 108 OFFSET 7776
- Lindsay & Sam Broke Up… Or Did They?By Dodai StewartJanuary 6, 2009 | 2:00pm
- Did Scientology "Kill" John Travolta's Son?By Dodai StewartJanuary 5, 2009 | 2:00pm
- Pete Wentz Probably Isn't Reading This Right NowBy Hortense SmithJanuary 4, 2009 | 3:30pm
- Katy Perry And Travis McCoy: Once Hot, Now ColdBy Hortense SmithJanuary 3, 2009 | 3:30pm
- Who Is Lily Allen's Mystery Man?By Margaret HartmannJanuary 2, 2009 | 2:00pm
- Courtney Love "Knows" Britney; Did J. Lo Have Twins?By dodaiFebruary 1, 2008 | 2:00pm
- Britney Hospitalized AgainBy dodaiJanuary 31, 2008 | 2:00pm
- Lindsay Lohan Needs A Well-Paying JobBy Dodai StewartOctober 15, 2007 | 1:00pm
- It's Ring Time For Rose And RobertBy Dodai StewartOctober 12, 2007 | 1:00pm
