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

Seminars	Georgia Bar Approved CLE Credit
	Total General Hours	Including Ethics	Including Professionalism	Including Trial
2004 Ultimate Medical Malpractice
	6.00			2.50
2005 Nursing Home Litigation Seminar
	8.00	1.00		3.00
2007 Trial Practice Manual
	6.00	1.00	1.00	2.00
2008 Auto Torts Workshop
	9.00	1.00		3.00
Auto Tort Litigation 2005
	8.00		1.00	2.00
Back to the Basics with the Masters
	9.50		1.00	4.00
Back to the Basics with the Masters, Part II
	6.00		1.00	2.00
Championing Justice in the Age of Tort Reform: 2005 Annual Meeting
	8.00		1.00	1.00
Damages: The Full Measure of Justice
	8.00		1.00	4.50
Demystifying Daubert
	6.00	1.00	1.00	3.00
Evidence Seminar
	6.00		1.00	3.00
Expert Witnesses
	5.00			2.00
HIPAA Revealed
	6.00	1.00	1.00
Preparing Tractor-Trailer Cases for Trial
	6.00			3.00
Soft Tissue Cases
	6.00			4.50
Soft Tissue Injury Cases
	6.00		1.00	1.00
Southeastern Motor Carrier Liability Institute
	13.00			2.00
Stepping Up to the Plate
	7.00	1.00	1.00	3.00
Subrogation, Releases and Other Issues (2004 Holiday Seminar)
	6.00	1.00
Tales From the Dark Side
	6.00	1.00		1.00
The Ultimate Paralegal Workshop
	6.00
Traumatic Brain Injuries
	6.00		1.00	2.50
Trial Practice Manual
	6.00	1.00	1.00	3.00
Trial Preparation
	5.50		1.00	4.50
Trial: Start to Finish!
	6.00		1.00	4.00
Ultimate Discovery 2005
	6.00		1.00	4.00
Workers' Compensation: Nuts and Bolts
	6.00	1.00		1.00