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.parent_id = '4'