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

Seminars	Colorado Bar Approved CLE Credit
	Total General Hours	Including Ethics
Trial Advocacy Ethics Program
	4.00	4.00
Workers Compensation Program
	5.00
Employment Law Program
	4.00
Trial Advocacy Program Business Torts Section
	4.00
Auto Litigation Program
	5.00
Trial Advocacy Program: Super Sunday
	4.00