SELECT ID, title, date_available FROM seminar WHERE provider_id='588' AND date_available <= '20180919' 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
Ethics of Law Practice Promotion    1.00      
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