Couldn't execute query. SELECT * FROM scenes WHERE active = "yes" AND id in ( select tgs.scenes_id from talent_grouping_names as tgn, talent_grouping_scenes as tgs where tgn.talent_name='Karel Rok' and tgn.id = tgs.tg_names_id) ORDER BY display_name ASC LIMIT 0, 20