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

Seminars	The State Bar of Texas Approved CLE Credit
	Total General Hours	Including Ethics
Adjudicating Tax Cases at the State Office of Administrative Hearings
	0.75
Aggressive Tax Planning, Unethical Conduct or Tax Fraud
	0.75	0.75
Choice of Entity
	1.00
Common Tax Issues Arising in Divorce
	0.75
Competent Authority and Advance Pricing Agreements
	0.75
Essentials on Substantial Economic Effect and Allocations
	1.50	0.50
Ethics and Liability Issues Arising from Representing Multiple Parties
	0.75	0.75
Ethics: A Checklist for Planning in a Changing Environment
	0.75	0.75
Examinations, Appeals and Litigation
	0.75
FAS 109 and International Operation
	0.75
Federal Tax Treatment of Debt Workouts
	1.00
FIN 48: Accounting for Uncertain Tax Positions
	1.00
Foreign Account Disclosures and Reporting Issues
	0.75	0.50
Fundamentals of Corporate Tax
	1.00
Fundamentals of Oil and Gas Taxation
	1.00
Fundamentals of US International Transfer Pricing
	0.75
Getting Along with the IRS
	1.00	0.50
Grantor Trusts: The Basics
	1.00
International Tax Update
	1.00
Issues to Consider When Drafting Partnership Agreements
	1.00	0.25
Managing a Transfer Pricing Controversy
	0.75
Nuts and Bolts of Oil and Gas Taxation
	1.00
Overview of Choice of Entity Considerations for Acquisitions in a Recovering Economy
	0.75
Overview of Section 409A (Or When Scoring a 99 Out of 100 on a Test Means You Failed)
	0.75
Planning Opportunities for Financially Distressed Entities and Related Issues
	0.75
Pricing Your Services: Legal Fee Issues for Small and Solo Tax Law Firms
	1.00	0.75
Representing Your Clients Before the Texas Comptroller of Public Accounts
	0.75
Tax Return Preparer Penalty Rules
	1.00	0.50
Texas Margin Tax: Common Substantive Issues Arising in Audits
	0.75	0.25
The Paperless Tax Law Office: Hints for a Successful Practice
	1.00
The Texas Sales and Use Tax: The Basics?
	0.75
Transfer Planning in the Shadow of Transfer Tax Reform Efforts
	0.75
Trust Planning for S Corporation Shareholders
	1.00
US Tax Court Judge John Vasquez Discussion of His Insights, Experience and Expectations in the Tax Court
	0.75	0.25
What You Need to Know if the IRS Special Agents Come a Calling
	1.00	0.25
When Two Worlds Collide: Issues to Consider when Taxable Parties Engage in Transactions with Charitable Organzations
	1.00