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

Seminars	North Carolina State Bar Approved CLE Credit
	Total General Hours	Including Ethics/Prof. (EP)	Including Substance Abuse
A Blueprint for Stellar Appellate Litigation (2008)
	6.25
Absolute Medicare Compliance Part II (2009)
	6.00
Advanced DWI - 2010
	6.50
An Overview of Medicare and Medicaid What's the Difference and Why Should I Care? (2008)
	3.00
Are You Ready for Absolute Medicare Compliance? (2009)
	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 (2009)
	3.00
Civil and Criminal Masters in Advocacy
	3.00
Civil Case Law Update (2008)
	0.75
Continuing the Fight: Uncovering the Truth About DWI Laws in NC (2007)
	6.00
Crimes Against Children (2008)
	6.00
Criminal Case Law Update (2008)
	0.75
Criminal Evidence: What the Defenders Are Saying About Melendez-Diaz and Other Timely Topics
Criminal Masters in Advocacy
	2.00
David Ball on Damages - The Update (2007)
	6.00
David Ball on Damages- The New Research (2008)
	5.00
David Ball on Medical Malpractice (2008)
	5.00
Defense Poisoning of Treating Physicians (2008)
	1.00
Disbursements (2007)
	5.75	1.00
Disbursements (2008)
	5.75	1.00
Disbursements (2009)
	6.00	1.00
Disbursements (2010)
	6.00
Disbursements 2006
District Court Practice 101 (2008)
	6.25	1.00
DSS-CPS Investigations (2010)
	1.00
DWI: Winning With Motions and Preparing for the New Breath Machine (2008)
	6.00
E-Discovery and Evidence Best Practicies: Do You Need to Know About Electronic Discovery to Protect Your Clients? (2010)
	6.25
Ethical Issues Faced in DWI Cases
	1.00	1.00
Ethics FAQ's: How to Untie Those Knotty Issues (2010)
	1.00	1.00
Ethics Hot Issues (2010)
	4.00	3.00	1.00
Ethics in Your Office
	1.00	1.00
Ethics: Current Hot Issues (2009)
	3.00	3.00
Evidence Case Law Update (2008)
	0.75
Fall Conference for Paralegals (2008)
Fall Conference for Paralegals (2009)
FAMILY LAW HOW-TO'S - A Practical Guide for Handling a Family Law Case
	6.00
FastCLE DEMO Program (2009)
Federal Social Security District Court Practice (2007)
	6.50
Federal Social Security District Court Practice (2010)
	6.00
Fighting the DWI Exception to the Constitution
	5.50
Forensic Science: Talisman or Trickery? (2010)
	6.00
Getting the Goods on the Bad Guys: A Practical Demonstration and Ethical Discussion of Social Networking Sites (2008)
	1.00	1.00
Growing Your Trial Practice (2010)
	3.00	3.00
Immigration Consequences of Criminal Convictions (2008)
	1.00
Immigration Consequences of NC Criminal Convictions
	0.75
Insurance Case Law Update (2008)
	0.75
Insurance Law
	6.00	0.75
Insurance Law (2008)
	5.25	1.00
Insurance Law Update
	0.75
Insurance Law: What Carriers Do and How They Make Decisions (2009)
	6.00
Insurance Stacking Issues (2009)
	1.00
Law as an Addiction (2009)
	3.25	1.25	2.00
Legal Ethics for Paralegals (2007)
Legislative Changes to UM/UIM in North Carolina (2008)
	1.00
Lessons Learned from the Duke Lacrosse Case (2007)
	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 (2008)
	3.25
Marital Torts Seminar
	6.00	1.00
Mental Retardation and Adaptive Functioning (2010)
	3.00
Meth 101 (2007)
	6.50
Mountain Magic General Session: Superstar Trial Techniques (2008)
	3.00
Navigating Claims Through the Industrial Commission (2010)
	6.00
Nuts and Bolts of Appellate Procedure
	3.75
Nuts and Bolts of Personal Injury Law (2009)
	6.00
Parental Alienation (2008)
	5.50
Persuasion For the New Millennium
	4.00	1.00	1.00
Planning Settlements For The Disabled Client (2010)
	1.00
Pre-Suit Discovery, Investigation and Mediation (2007)
	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
Punitive Damages in DWI and Other Cases - 2010
	6.00
Responding to the Subprime Mortgage Meltdown (2008)
	4.00
Secrets of Mastering the Industrial Commission Hearing (2008)
	5.50
Sex Offender Registry Removal 101 (2010)
	1.00
So, You Want To Handle Motor Vehicle Torts? (2008)
	6.00	1.00
Social Security Disability for Beginners (2009)
	6.25
Social Security Law for New Practitioners
	5.75	0.50
Social Security Practice (2007)
	6.25	1.00
Social Security Practice (2008)
	6.00		1.00
Social Security Practice (2009)
	6.25
Social Security Practice 2006
	6.00
Solo and Small Firm Symposium
	4.50	4.50
Sources of Coverage (2009)
	6.25
Spring Seminar for Paralegals (2008)
Spring Seminar for Paralegals (2009)
Spring Seminar for Paralegals (2010)
Substance Abuse and Mental Health: Issues Attorneys Face (2010)
	1.00		1.00
Substance Abuse Dependency Issues and Attorneys (2010)
	1.00		1.00
Successful District Court Practice (2010)
	6.00	2.00
Superior Court Criminal Cases (2010)
	6.00
The Battle After the Battle (2007)
	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 RACIAL JUSTICE ACT - Proving Bias and Saving Your Client's Life (2009)
	8.00
Trial Tips from the Trenches (2009)
	6.00
Trying Your First Case (2009)
	5.50
Watching the Trial Unfold: Understanding Trial Evidence
What To Do With the Money: Disbursement Issues for Legal Assistants
Winning Auto Torts Cases (2009)
	6.00
Winning Strategies in Negotiation and Settlement
	6.00
Workers' Comp: Maximizing Your Case (2009)
	6.00	1.00
Workplace Torts and Workers' Comp (2008)
	6.00
Wrongful Death: Traps & Solutions (2010)
	1.00