Featured
SELECT ID, post_title, post_date, lead_img_url, permalink, co_authors, m.meta_value AS rating FROM pm_article_index AS a LEFT JOIN wppm_postmeta AS m ON (m.post_id=a.ID AND m.meta_key='additional_article_fields_rating') WHERE 1=1 AND post_status = 'publish' AND 2=2 AND article_type = '|features|' AND ID NOT IN (419871,419875,419851) AND ID NOT IN (SELECT ID FROM pm_top_article_display WHERE section='features' ) ORDER BY post_date DESC LIMIT 8
SELECT ID, post_title, post_date, lead_img_url, permalink, co_authors, m.meta_value AS rating FROM pm_article_index AS a LEFT JOIN wppm_postmeta AS m ON (m.post_id=a.ID AND m.meta_key='additional_article_fields_rating') WHERE 1=1 AND post_status = 'publish' AND 2=2 AND article_type = '|reviews|' AND ID NOT IN (SELECT ID FROM pm_top_article_display WHERE section='------' ) ORDER BY post_date DESC LIMIT 10
SELECT ID, post_title, post_date, lead_img_url, permalink, co_authors, m.meta_value AS rating FROM pm_article_index AS a LEFT JOIN wppm_postmeta AS m ON (m.post_id=a.ID AND m.meta_key='additional_article_fields_rating') WHERE 1=1 AND post_status = 'publish' AND 2=2 AND article_type = '|lists|' AND ID NOT IN (SELECT ID FROM pm_top_article_display WHERE section='------' ) ORDER BY post_date DESC LIMIT 8
SELECT ID, post_title, post_date, lead_img_url, permalink, co_authors, m.meta_value AS rating FROM pm_article_index AS a LEFT JOIN wppm_postmeta AS m ON (m.post_id=a.ID AND m.meta_key='additional_article_fields_rating') WHERE 1=1 AND post_status = 'publish' AND 2=2 AND article_type = '|news|' AND ID NOT IN (SELECT ID FROM pm_top_article_display WHERE section='------' ) ORDER BY post_date DESC LIMIT 10