SELECT ID, title, date_available FROM seminar WHERE provider_id='35' AND date_available <= '20100313' 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
	6.25
Absolute Medicare Compliance Part II
	6.00
Advanced DWI
	6.50
An Overview of Medicare and Medicaid What's the Difference and Why Should I Care?
	3.00
Are You Ready for Absolute Medicare Compliance?
	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
Disbursements 2010
	6.00
District Court Practice 101
	6.25	1.00
DSS-CPS Investigations
	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 FAQ's
	1.00	1.00
Ethics for Trial Lawyers
	2.00	2.00
Ethics Hot Issues
	4.00	3.00	1.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
Fall Conference for Paralegals 2009
FastCLE DEMO Program
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
Growing Your Trial Practice
	3.00	3.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 2009: What Carriers Do and How They Make Decisions
	6.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
Learn@Lunch Webcast: Substance Abuse and Mental Health: Issues Attorneys Face
	1.00		1.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
Nuts and Bolts of Personal Injury Law
	6.00
Parental Alienation
	5.50
Persuasion For the New Millennium
	4.00	1.00	1.00
Planning Settlements For The Disabled Client
	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
Punitive Damages in DWI and Other Cases
	6.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
Social Security Practice 2009
	6.25
Solo and Small Firm Symposium
	4.50	4.50
Sources of Coverage
	6.25
Spring Seminar for Paralegals
Spring Seminar for Paralegals
Spring Seminar for Paralegals 2009
Substance Abuse Dependency Issues and Attorneys
	1.00		1.00
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
Trial Tips from the Trenches
	6.00
Trying Your First Case
	5.50
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
Wrongful Death: Traps & Solutions
	1.00

Seminars	North Carolina State Bar Approved CLE Credit
	Total General Hours	Including Ethics/Prof. (EP)	Including Substance Abuse
Federal Social Security District Court Practice
	6.00
Live Webinar: Sex Offender Registry Removal 101
	1.00