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
Dynamic Chiropractic PracticeINSIGHTS
Get the Latest News FASTER - View Digital Editions Now!
Operate Your PracticeSupport Your PatientsExpand Your CareEquip Your Clinic

    Industry News

    White Papers

  Operate Your Practice   Support Your Patients   Expand Your Care   Equip Your Clinic  
Chiropractic Events
  • Seminar
  • Online

 


Operate Your Practice Support Your Patients Expand Your Care Equip Your Clinic