SELECT ID, title, date_available FROM seminar WHERE provider_id='588' AND date_available <= '20190123' AND invitationonly=0 AND (expiration_date > NOW() OR expiration_date < '2000-1-1')ORDER BY title ASC
Seminars
Nevada Board of Continuing Legal Education Approved CLE Credit
  General Credits Ethics Credits Total Credits A.A.MH. Credit
Managing Client Expectations: The Key to Avoiding Complaints    1.00      
Service Dogs, Therapy Dogs and Emotional Support Dogs 1.00         
Transitioning into Practice (TIP) Mentorship Program