select * from mos_program, jos_events_sessions, mos_program_cat, jos_events_venues where mos_program.events_id = jos_events_sessions.session_id and mos_program_cat.id = mos_program.cat_id and jos_events_venues.venue_id = jos_events_sessions.venue_id and jos_events_sessions.published = '1' and mos_program.is_hidden <> 'Y' and mos_program_cat.id IN ('21','121','122','123','124','125','135','136','137','138','139','140','141','142','143','144','145','146','147','148','181','182','183','184','185','186','187','188','201')

Program & Event Finder

Type
Program Name

Location
City/Town
State
City/Town
Date