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