SELECT DISTINCT post_title, post_date FROM mpm_posts_pl LEFT JOIN mpm_terms_relationships ON ( mpm_terms_relationships.object_id = mpm_posts_pl.ID )
LEFT JOIN mpm_terms_pl ON ( mpm_terms_relationships.term_id = mpm_terms_pl.term_id ) WHERE post_guid != "" AND mpm_terms_pl.term_id = 8
AND mpm_terms_pl.term_id = mpm_terms_relationships.term_id
AND mpm_posts_pl.ID = object_id AND mpm_terms_relationships.rel_type != "menu_term_link" AND post_active = 1 GROUP BY YEAR(post_date) DESC, MONTH(post_date) DESC LIMIT 0,999SELECT DISTINCT post_title, ID, post_excerpt, post_icon, post_icon_position, post_parent, post_guid, post_sidebar, post_type, post_template FROM mpm_posts_pl LEFT JOIN mpm_terms_relationships ON ( mpm_terms_relationships.object_id = mpm_posts_pl.ID )
LEFT JOIN mpm_terms_pl ON ( mpm_terms_relationships.term_id = mpm_terms_pl.term_id ) WHERE post_guid != "" AND mpm_terms_pl.term_id = 8
AND mpm_terms_pl.term_id = mpm_terms_relationships.term_id
AND mpm_posts_pl.ID = object_id AND mpm_terms_relationships.rel_type != "menu_term_link" AND post_active = 1 ORDER BY post_sticky DESC, post_order LIMIT 0,999
