Place Adspeed Ads Locally

SELECT ad.ID, ad.post_title, ad.post_date, ad.post_name from wpld_posts ad INNER JOIN wpld_posts adv ON ad.post_parent = adv.ID AND adv.post_type LIKE 'advertiser' LEFT JOIN wpld_postmeta zpid ON ad.ID = zpid.post_id AND zpid.meta_key LIKE 'zone_pid' WHERE zpid.meta_value IS NULL and ad.post_type LIKE 'ad' ORDER BY ad.ID DESC