SELECT ID, title, date_available FROM seminar WHERE provider_id='36' AND date_available <= '20120127' AND invitationonly=0 AND (expiration_date > NOW() OR expiration_date < '2000-1-1')ORDER BY date_available ASC

Seminars	American Academy of Dermatology Approved CME Credit
	AMA PRA Category 1 Credits ™
2003 Annual Meeting
	0.00
2004 FSDDS Annual Meeting
	0.00
Live Patient Workshop on Botox and New Fillers
	0.00
Best Updates of 2004
	0.00
2005 Annual Meeting and 75th Anniversary Celebration
	0.00
2006 Annual Meeting
	0.00
2007 Annual Meeting
	0.00
2007 Lasers Package
	0.00
2007 Surgical Pearls Package
	0.00
2007 Cosmetic Dermatology Package
	0.00