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 '[[:<:]]Gas Warfare[[:>:]]' OR st.sub_theme_name REGEXP '[[:<:]]Gas Warfare[[:>:]]' OR t.video_title REGEXP '[[:<:]]Gas Warfare[[:>:]]' OR t.reel_number REGEXP '[[:<:]]Gas Warfare[[:>:]]' OR tt.tag_name REGEXP '[[:<:]]Gas Warfare[[:>:]]'  )  group by t.video_id11,546,557,558,741,753,770,876,919,1828,5105,5699,6152,6165,6194,6635,6693,8868,9463,13102,13331,15163,15878,15884,16144,16515,16890,17508,18183,18210,18256,20203,21082,21088,21895,21898,21900,21912,22359,23099,23302