SELECT * FROM vdt_memb_postings LEFT JOIN vdt_memb_post_media ON vdt_memb_postings.posting_id = vdt_memb_post_media.media_post_id WHERE posting_type='media' AND posting_status='posted' AND ('2026-06-27 15:14:42' > posting_startdate AND '2026-06-27 15:14:42' < posting_enddate) AND posting_post_types IN(64,65) ORDER BY posting_date DESC

SELECT * FROM vdt_memb_postings LEFT JOIN vdt_memb_post_media ON vdt_memb_postings.posting_id = vdt_memb_post_media.media_post_id WHERE posting_type='media' AND posting_status='posted' AND ('2026-06-27 15:14:43' > posting_startdate AND '2026-06-27 15:14:43' < posting_enddate) AND posting_post_types IN(174,131,63,61,62,260,171,173,247)