Downloads

select p.*, t.*, coalesce(pm.meta_value, p.post_title) title, pm2.meta_value access from wp_7_posts p join wp_7_icl_translations t on t.element_id = p.ID and t.language_code = 'en' left join wp_7_postmeta pm on pm.post_id = p.ID and pm.meta_key = 'menuname' left join wp_7_postmeta pm2 on pm2.meta_key = '__wpdm_access' and pm2.post_id = p.ID where p.post_status = 'publish' and p.post_type = 'wpdmpro'