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

Seminars	Impact Learning Certificates Approved CLE Credit
Winning at Trial II
Pain, Sleep & Depression
Counsel Work at Its Finest
Medical and Legal Issues in Brain Injury
Inside ICBC
FREE Demo of TLABC's Online Streaming Programs
Proving Medical Causation
The Essential Soft Tissue Injury Conference 2006