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

Seminars	North Carolina Bar Approved CLE Credit
	Total General Hours	Including Ethics/Prof. (EP)	Including Substance Abuse
A Blueprint for Stellar Appellate Litigation
	6.25
After the Meltdown/Bailout
	6.25
An Overview of Medicare and Medicaid What's the Difference and Why Should I Care?
	3.00
Approaching the Bench
	4.00	1.00
Are You Ready for Absolute Medicare Compliance?
	6.00
Are You Ready for Absolute Medicare Compliance?(5/1/09)
	6.00
Auto Torts 2006
	6.00	1.00
Auto Torts 2007
	5.50	1.00
Basic Workers Comp Practice
	6.50
Best Practice Tips for Social Security Practitioners
	3.00
Civil and Criminal Masters in Advocacy
	3.00
Civil Case Law Update
	0.75
Continuing the Fight: Uncovering the Truth About DWI Laws in NC
	6.00
Crimes Against Children
	6.00
Criminal Case Law Update
	0.75
Criminal Masters in Advocacy
	2.00
David Ball on Damages - The Update
	6.00
David Ball on Damages- The New Research
	5.00
David Ball on Medical Malpractice
	5.00
Dealing with Rambo Tactics From Opposing Counsel While Promoting Professionalism
	1.00	1.00
Defending Parents in DSS Cases - Part 1
	1.50
Defending Parents in DSS Cases - Part 2
	1.00
Defense Poisoning of Treating Physicians
	1.00
Disbursements 2006
Disbursements 2007
	5.75	1.00
Disbursements 2008
	5.75	1.00
Disbursements 2009
	6.00	1.00
District Court Practice 101
	6.25	1.00
DWI: Winning With Motions and Preparing for the New Breath Machine
	6.00
Ethical Considerations in Representing Hispanic DWI Clients
	0.50	0.50
Ethical Issues Faced in DWI Cases
	1.00	1.00
Ethics for Trial Lawyers
	2.00	2.00
Ethics in Mediation and Settlement
	1.00	1.00
Ethics in Your Office
	1.00	1.00
Ethics: Current Hot Issues
	3.00	3.00
Evidence Case Law Update
	0.75
Fall Conference for Paralegals
Federal Social Security District Court Practice
	6.50
Fighting the DWI Exception to the Constitution
	5.50
FRIENDS and PALS: Presentation on Mental Health and Addiction Issues
	1.00		1.00
Getting the Goods on the Bad Guys: A Practical Demonstration and Ethical Discussion of Social Networking Sites
	1.00	1.00
Helping Parents Help Themselves in Changing Courts
	6.25	1.00
How to Get Major Damages in Every Case
	2.50
Immigration Consequences of Criminal Convictions
	1.00
Immigration Consequences of NC Criminal Convictions
	0.75
Insurance Case Law Update
	0.75
Insurance Law
	6.00	0.75
Insurance Law 2008
	5.25	1.00
Insurance Law Update
	0.75
Insurance Stacking Issues
	1.00
Intermediate Workers' Comp Practice
	3.00
Law as an Addiction
	3.25	1.25	2.00
Legal Ethics for Paralegals
Legislative Changes to UM/UIM in North Carolina
	1.00
Lessons Learned from the Duke Lacrosse Case
	3.00	0.50
License Issues for Immigrants and Non-Immigrants: Audio Only Seminar
	1.00
Liens & Claims Against Personal Injury Recoveries
	3.00
Litigating a Case Under the State Tort Claims Act
	3.25
Marital Torts Seminar
	6.00	1.00
Mental Health Concerns for Attorneys
	1.00		1.00
Meth 101
	6.50
Mountain Magic General Session: Superstar Trial Techniques
	3.00
Mountain Magic Workshop
	7.75
Nuts and Bolts of Appellate Procedure
	3.75
Parental Alienation
	5.50
Persuasion For the New Millennium
	4.00	1.00	1.00
Pre-Suit Discovery, Investigation and Mediation
	1.00	0.50
Pre-Trial Practice - Written Discovery and Depositions
	6.00
Professionalism & Substance Abuse/Mental Health Issues
	3.00	2.00	1.00
Professionalism for Workers' Comp
	3.00	3.00
Responding to the Subprime Mortgage Meltdown
	4.00
Secrets of Mastering the Industrial Commission Hearing
	5.50
So, You Want To Handle Motor Vehicle Torts?
	6.00	1.00
Social Security Disability for Beginners
	6.25
Social Security Law for New Practitioners
	5.75	0.50
Social Security Practice
	6.50	1.00
Social Security Practice 2006
	6.00
Social Security Practice 2007
	6.25	1.00
Social Security Practice 2008
	6.00		1.00
Solo and Small Firm Symposium
	4.50	4.50
Sources of Coverage
	6.25
Spring Seminar for Paralegals
Spring Seminar for Paralegals 2009
Summation by John Edwards
	1.75
Summation by the Masters
	4.50
The Battle After the Battle
	5.75	0.75
The Good, Bad, and Ugly of Dealing with the Other Side
	3.00	3.00
The Motor Vehicle Driver Protection Act
	6.75	1.00
The New Medicare Prescription Program
	3.00	1.00
What To Do With the Money: Disbursement Issues for Legal Assistants
Winning Auto Torts Cases
	6.00
Winning Strategies in Negotiation and Settlement
	6.00
Workers' Comp
	6.00	1.00
Workplace Torts and Workers' Comp 2008
	6.00