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('+"|in-depth|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|in-depth^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"in-depth|"' 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 = 'in-depth'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 4450
- 10 of the Spookiest Scary Stories You'll Ever ReadBy Dodai StewartOctober 31, 2013 | 8:50pm
- Tell Us Your Spookiest Scary StoriesBy Dodai StewartOctober 24, 2013 | 8:50pm
- Heterosexual Cisgender Queering of Transgender SexualityBy Kat CallahanSeptember 9, 2013 | 2:36pm
- Cis Feminists Need To Understand “Provisional” Male PrivilegeBy Kat CallahanJuly 14, 2013 | 12:09pm
- Indigo Girls Drop Out of MichFest Over Trans Exclusionary PolicyBy Kat CallahanApril 13, 2013 | 9:49am
- Ask a Trans WomanBy Kat CallahanApril 8, 2013 | 1:37pm
- Let's Scare the Crap Out of Everyone: Tell Us Your Most Terrifying TalesBy Dodai StewartOctober 25, 2012 | 8:45pm
- Ten Super-Spooky Ghost Stories To Keep You Awake At NightBy Anna NorthOctober 31, 2011 | 10:00pm
- Ten Super-Spooky Ghost Stories To Keep You Awake At NightBy Anna NorthOctober 31, 2011 | 10:00pm
- Send Us Your Scariest Ghost StoriesBy Anna NorthOctober 28, 2011 | 6:10pm