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('+"|music|"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"|music^"' IN BOOLEAN MODE) OR MATCH(article_category) AGAINST('+"music|"' 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 = 'music'
ORDER BY position)
ORDER BY post_date DESC LIMIT 25 OFFSET 750
- Y/N: Nicki Minaj's Personal Raps and Gwen's Emoji Video Fall ShortBy Clover HopeDecember 3, 2014 | 11:30pm
- Y/N: Top Model Chantelle Slays and Channels Sia in an Eminem VideoBy Clover HopeNovember 26, 2014 | 9:10pm
- Y/N: Lady Saw Devours a Cheating Dude, Meghan Trainor Gets CheekyBy Clover HopeNovember 19, 2014 | 11:50pm
- Y/N: Tweens and Moms Will Like This Acoustic Bieber SongBy Clover HopeNovember 13, 2014 | 12:00am
- Yes or No, Vol. 6: Kendrick Lamar, The Decemberists & K. MichelleBy Clover HopeNovember 6, 2014 | 12:10am
- Yes or No, Vol. 5: FKA Twigs, Baauer & Willow SmithBy Clover HopeOctober 29, 2014 | 10:40pm
- Yes or No, Vol. 4: Kiesza, Gwen Stefani & Nick JonasBy Clover HopeOctober 22, 2014 | 8:30pm
- Yes or No, Vol. 3: Meghan Trainor, JMSN & Run the JewelsBy Clover HopeOctober 15, 2014 | 10:50pm
- Yes or No, Vol. 2: Miguel, Jaden Smith and Tiger VillageBy Clover HopeOctober 11, 2014 | 12:00am
- Yes or No: Judging New Music in Three Sentences or LessBy Clover HopeOctober 8, 2014 | 7:50pm