Log-in

Medical Reserve Corps

Stop Smoking

Are You Ready?

Announcements

select distinct a.id, headline, ac.content, photo, caption, section_directory , DATE_FORMAT(run_date, '%c/%e'), author, affiliation, urgent from announcements as a INNER JOIN announcements_sections as s on s.announcement_id = a.id INNER JOIN announcement_contents as ac on ac.id = a.content_id and ac.announcement_id = a.id where 1=1 and a.id = ? and run_date <= NOW() and a_date > NOW() and s.section_id in ? and a.is_approved = '1' limit 14The article you are seeking is not available.