University of Southern California

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