Videos

SELECT p.ID, p.post_status, p.post_title, p.post_type, p.post_name, pm.meta_value AS video_date FROM wp_posts p INNER JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = 'videos' AND p.post_status = 'publish' AND pm.meta_key = 'date' ORDER BY pm.meta_value DESC LIMIT 10 OFFSET 30 /* From [womeninlocalization.org/gated/videos/page/4/] in [/nas/content/live/globalcommunit/wp-content/themes/wlglobal/page-videos.php:149] */