SELECT p.id, p.title, DATE_FORMAT(p.release_date,'%M %e, %Y') AS release_date_f, p.release_date, DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 7 DAY),'%Y-%m-%d') AS seven_days_ago, a.company_name, a.id AS company_id FROM mc_cms_article_press_release p, mc_cc_advertiser a WHERE p.active = '1' AND p.show_in_dc = '1' AND a.id = p.advertiser AND a.test_account = '0' AND p.release_date <= now() AND (p.pr_type IS NULL OR p.pr_type = '') ORDER BY p.release_date DESC
Industry News

To report inappropriate ads, click here.