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

Seminars	Tennessee Commission on CLE Approved CLE Credit
	Total General Hours	Dual	Including Ethics/Prof. (EP)
From Contracts to Closing
	1.00
Deposition Ethics
		1.00
Living Wills, Power of Attorney and Appointing a Health Care Agent
	1.00
Electronic Discovery: Making Sense of the New World of Electronic Discovery
	2.00
The Appellate Court Clerk's Office & the Appeal Process
	1.00
A Systematic Approach to the Execution of a Tennessee Judgment
	3.00
The New Tennessee LLC Statute
	1.00
Employing Foreign Workers - The Least You Should Know
	1.00
Extraordinary Relief
	1.00
Bankruptcy Abuse Prevention and Consumer Protection Act
	1.50	0.50
Selected Estate Planning and Probate Issues Update
	1.00
How Technology is Changing the Litigator's Practice
	3.00
Mediation - Methods for Success
	1.75	0.50
Intellectual Property Rights for the General Practitioner
	1.00
Comprehensive Government Ethics Reform Act of 2006
		1.50
Current Topics for the Nashville Entertainment Lawyer
	3.00	2.00
Choices in Dealing with the Insolvent Corporation
	2.00
Administrative Hearings: State Agency and Beyond
	2.00
Winning Your Case Before the Planning Commision or Board of Zoning Appeals
	2.00
Covenants Not to Compete
	1.00
Creating a Plan for Law Firm Success
	1.00
Appellate Practice
	3.00
Employment Law Institute
	4.00
Probate Institute
	3.50	0.50
Federal Court Update
	2.50
Ethics and Professionalism
		3.00
Family Law Institute
	4.00
Recent Developments in Intellectual Property Law
	3.00	1.00
Trends in Punitive Damages
	1.00
Annual Entertainment Law Year in Review
	2.00	1.00