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 '[[:<:]]Mushroom Cloud[[:>:]]' OR st.sub_theme_name REGEXP '[[:<:]]Mushroom Cloud[[:>:]]' OR t.video_title REGEXP '[[:<:]]Mushroom Cloud[[:>:]]' OR t.reel_number REGEXP '[[:<:]]Mushroom Cloud[[:>:]]' OR tt.tag_name REGEXP '[[:<:]]Mushroom Cloud[[:>:]]'  )  group by t.video_id10,366,710,851,955,1021,1140,1211,2310,2581,2799,2802,3141,3426,3513,3515,3639,3905,4178,4483,4866,4884,5611,6950,6993,7000,7054,7532,8053,8086,8091,8094,8700,9186,9207,9312,9335,9579,10482,10500,10511,11017,11207,12734,12799,13031,13216,14266,14343,14547,14623,14624,14632,15015,15352,15401,15781,15908,16498,17561,17707,18128,18220,18664,19012,19282,19285,19579,19661,19663,19730,20168,20195,20196,20244,20281,20990,21533,21582,21880,21967,22067,22127,22682,22836,23264