select t.video_id from tbl_videos as t  join tbl_video_theme_subtheme_mapping as  sb on (t.video_id = sb.video_id)  join tbl_themes as  th on (th.theme_id = sb.theme_id)  join tbl_video_tag_mapping as  vtm on (vtm.video_id = t.video_id)  join tbl_tags as  tt on (tt.tag_id = vtm.tag_id) left join tbl_sub_themes as  st on (st.sub_theme_id = sb.sub_theme_id) left join tbl_video_country_location_mapping as  tclm on (tclm.video_id = t.video_id)  join tbl_country_location as  tcl on (tcl.country_location_id = tclm.country_location_id)  join countries as  tc on (tc.country_id = tcl.country_id)  where  1=1  && (th.theme_name REGEXP '[[:<:]]King George VI[[:>:]]' OR st.sub_theme_name REGEXP '[[:<:]]King George VI[[:>:]]' OR t.video_title REGEXP '[[:<:]]King George VI[[:>:]]' OR t.reel_number REGEXP '[[:<:]]King George VI[[:>:]]' OR tt.tag_name REGEXP '[[:<:]]King George VI[[:>:]]'  )  group by t.video_id35,53,99,303,1741,3000,3655,4201,4611,5042,5053,5464,5468,5616,5667,5678,5743,5854,5938,5975,6128,6753,6760,6765,6769,7225,7254,7301,8830,9049,9055,9153,9508,9719,11239,11456,11739,11810,11920,12583,12822,12901,13043,13260,13267,14419,14443,15032,15166,15392,15403,16078,16235,16284,16309,16312,16323,16334,16384,16568,16829,16879,17114,17350,17518,17521,17618,17621,17717,17882,18071,18075,18370,18503,18514,18768,19018,19852,19863,19912,20716,21505,21513,21538,21623,21729,21747,22246