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 '[[:<:]]Richard Nixon[[:>:]]' OR st.sub_theme_name REGEXP '[[:<:]]Richard Nixon[[:>:]]' OR t.video_title REGEXP '[[:<:]]Richard Nixon[[:>:]]' OR t.reel_number REGEXP '[[:<:]]Richard Nixon[[:>:]]' OR tt.tag_name REGEXP '[[:<:]]Richard Nixon[[:>:]]'  )  group by t.video_id15,60,81,326,363,629,800,1374,1438,1507,1732,1874,2193,2327,2352,2412,2434,2441,2445,2472,2568,2771,2846,3093,3261,3327,3337,3434,3609,3814,4914,5029,5070,5343,5346,5351,5358,5364,5368,5371,5373,5629,5957,6396,6917,6920,7150,7310,8248,8251,8253,8256,8260,8265,8267,8282,8286,8289,8291,8292,8455,8515,8563,8750,8781,8801,9152,9155,9162,9169,9223,9317,9507,9528,9550,9645,9675,9677,9718,9890,9894,9899,9931,10153,10160,10168,10174,10220,10300,10304,10311,10521,10620,10703,10827,11350,11360,11369,11441,11445,11448,11452,11457,11461,11840,11869,11900,11902,12276,12295,12324,12356,12493,12602,12640,12810,12826,12835,12870,12989,13001,13351,13469,13888,14275,14336,14764,14765,15009,15237,15593,15683,15779,15872,16156,16158,16160,16162,16165,16168,16434,16542,16552,16660,16663,16701,16746,16845,16856,17722,17761,17778,17858,17864,18104,18109,18618,18619,18620,18621,18622,18623,18624,19248,19277,19278,19590,19615,19647,19678,19739,19915,20230,20355,20356,20692,20817,20818,20824,21128,21129,21150,21168,21385,21442,21443,21444,21445,21446,21447,21448,21449,21494,21499,21566,21582,21952,21955,21967,21968,21982,22658,22662,23269,23381