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 '[[:<:]]Washington[[:>:]]' OR st.sub_theme_name REGEXP '[[:<:]]Washington[[:>:]]' OR t.video_title REGEXP '[[:<:]]Washington[[:>:]]' OR t.reel_number REGEXP '[[:<:]]Washington[[:>:]]' OR tt.tag_name REGEXP '[[:<:]]Washington[[:>:]]'  )  group by t.video_id17,33,57,69,83,285,292,309,326,457,459,460,462,463,467,470,474,477,482,484,486,500,503,526,530,555,565,590,613,618,634,635,636,639,648,665,667,674,678,685,688,695,697,701,704,706,708,721,724,742,754,757,774,775,777,789,829,832,837,841,848,877,918,969,970,974,976,977,980,1044,1047,1084,1085,1087,1088,1098,1165,1193,1208,1215,1220,1225,1231,1267,1279,1310,1313,1319,1340,1345,1356,1358,1371,1376,1377,1381,1406,1433,1436,1440,1448,1475,1483,1485,1487,1490,1493,1509,1521,1523,1535,1559,1570,1611,1643,1668,1679,1753,1759,1775,1785,1870,1880,1967,1972,1997,2005,2041,2064,2069,2131,2227,2237,2272,2278,2372,2396,2434,2441,2442,2445,2469,2472,2476,2514,2554,2559,2574,2591,2610,2615,2616,2620,2673,2691,2742,2750,2771,2803,2814,2815,2819,2824,2830,2844,2848,2878,2894,2999,3067,3115,3121,3130,3136,3140,3142,3157,3171,3202,3224,3257,3259,3260,3261,3291,3299,3303,3313,3346,3394,3426,3434,3450,3460,3502,3510,3518,3541,3550,3556,3570,3618,3633,3635,3650,3653,3660,3670,3675,3677,3689,3694,3706,3716,3744,3753,3759,3774,3788,3790,3793,3808,3812,3820,3832,3833,3840,3843,3850,3884,3887,3889,3893,3904,3919,3923,3931,3942,3974,3988,3994,4003,4006,4011,4029,4078,4088,4091,4098,4102,4122,4130,4138,4166,4169,4177,4184,4188,4192,4205,4209,4231,4238,4242,4247,4266,4279,4291,4297,4304,4305,4309,4325,4329,4333,4338,4352,4357,4363,4375,4381,4383,4399,4400,4404,4406,4415,4421,4424,4438,4461,4490,4504,4512,4556,4623,4679,4695,4702,4705,4706,4717,4720,4722,4723,4725,4730,4744,4745,4748,4900,4908,4954,4962,4989,4992,5003,5024,5037,5057,5059,5064,5073,5076,5082,5086,5090,5093,5094,5095,5096,5098,5100,5115,5118,5130,5138,5140,5149,5151,5157,5158,5159,5178,5185,5186,5192,5209,5214,5215,5256,5270,5316,5319,5355,5364,5368,5371,5387,5406,5457,5460,5463,5465,5466,5470,5479,5498,5499,5519,5525,5542,5546,5578,5584,5588,5592,5593,5597,5601,5603,5605,5606,5607,5609,5622,5634,5641,5646,5657,5662,5678,5696,5715,5718,5733,5742,5746,5752,5763,5797,5827,5877,5879,5895,5912,5975,5979,6032,6053,6078,6143,6149,6187,6191,6194,6199,6202,6238,6259,6269,6274,6289,6316,6323,6331,6350,6366,6404,6413,6428,6429,6437,6444,6446,6458,6499,6565,6621,6653,6674,6680,6681,6691,6703,6744,6747,6751,6757,6760,6767,6789,6797,6817,6820,6840,6844,6856,6864,6868,6881,6890,6913,6917,6923,6939,6941,6942,7009,7024,7025,7044,7067,7083,7085,7088,7099,7100,7102,7120,7135,7137,7138,7150,7156,7162,7182,7193,7196,7205,7310,7311,7316,7338,7343,7347,7348,7361,7368,7384,7393,7436,7459,7462,7492,7495,7497,7501,7540,7638,7642,7643,7660,7665,7669,7704,7713,7714,7717,7726,7757,7764,7767,7771,7786,7794,7797,7801,7826,7840,7849,7850,7854,7859,7861,7867,7879,7890,7909,7912,7921,7927,7930,7977,7995,8010,8021,8028,8029,8063,8089,8106,8123,8136,8140,8158,8169,8172,8206,8250,8251,8252,8253,8256,8265,8273,8276,8282,8284,8286,8314,8319,8322,8323,8327,8340,8343,8351,8355,8379,8415,8448,8450,8487,8497,8500,8503,8509,8511,8514,8515,8522,8524,8528,8530,8538,8539,8541,8551,8561,8563,8566,8567,8573,8574,8612,8617,8619,8622,8623,8657,8660,8661,8666,8691,8707,8725,8728,8739,8742,8752,8763,8769,8773,8779,8781,8782,8785,8806,8840,8847,8860,8865,8881,8948,8950,8965,8970,8992,8999,9003,9009,9046,9061,9062,9097,9124,9152,9153,9155,9158,9162,9169,9194,9204,9223,9228,9234,9236,9239,9282,9298,9300,9301,9307,9308,9317,9333,9350,9357,9359,9368,9386,9394,9439,9468,9473,9475,9479,9489,9539,9551,9564,9577,9583,9592,9595,9596,9599,9605,9611,9613,9621,9626,9632,9634,9638,9641,9644,9645,9656,9666,9668,9674,9675,9676,9677,9691,9694,9719,9773,9777,9792,9798,9801,9819,9864,9876,9879,9890,9894,9899,9907,9916,9923,9956,9959,10046,10055,10082,10086,10100,10109,10114,10121,10128,10132,10153,10175,10194,10205,10223,10231,10300,10304,10311,10324,10344,10347,10376,10379,10500,10521,10620,10679,10699,10749,10770,10771,10806,10809,10825,10829,10833,10837,10841,10846,10851,10853,10854,10857,10869,10872,10877,10887,10890,10891,10896,10899,10902,10906,10913,10916,10920,10924,10928,10934,10943,10948,10953,10954,10956,10960,10961,10972,10973,10982,10986,10989,10993,11049,11053,11205,11232,11332,11382,11388,11393,11396,11398,11400,11401,11403,11405,11409,11416,11420,11425,11438,11440,11442,11465,11470,11473,11480,11508,11509,11510,11519,11521,11523,11528,11544,11548,11578,11606,11628,11635,11684,11702,11708,11713,11747,11749,11755,11794,11804,11814,11820,11825,11831,11834,11835,11836,11840,11842,11862,11869,11880,11892,11893,11895,11900,11902,11912,11935,11950,11960,11989,11995,12003,12006,12031,12042,12044,12054,12069,12074,12135,12190,12251,12289,12295,12296,12305,12307,12310,12314,12316,12319,12321,12324,12351,12355,12386,12395,12449,12456,12470,12493,12503,12543,12568,12580,12618,12637,12640,12644,12674,12679,12688,12696,12701,12706,12711,12754,12805,12807,12809,12818,12820,12826,12833,12835,12848,12851,12870,12921,12924,12927,12943,12948,12954,12961,12962,12965,12969,13022,13039,13050,13057,13061,13069,13104,13113,13117,13128,13140,13160,13163,13185,13227,13248,13251,13268,13295,13342,13344,13351,13369,13412,13433,13434,13450,13498,13501,13531,13539,13579,13626,13654,13661,13665,13703,13730,13744,13823,13841,13880,13883,13888,13908,13945,13972,13980,13982,13986,13998,14012,14026,14030,14058,14062,14066,14072,14073,14074,14076,14078,14081,14084,14086,14091,14093,14096,14098,14099,14100,14102,14119,14135,14172,14188,14190,14255,14266,14275,14282,14296,14389,14401,14413,14446,14454,14464,14471,14505,14520,14526,14537,14539,14545,14546,14554,14557,14559,14572,14574,14611,14616,14625,14633,14648,14664,14672,14675,14678,14682,14684,14687,14694,14710,14711,14713,14716,14720,14721,14723,14724,14726,14727,14729,14731,14733,14734,14740,14743,14748,14753,14755,14762,14793,14848,14850,14865,14870,14876,14889,14892,14945,14948,15004,15007,15010,15013,15035,15090,15104,15107,15111,15115,15119,15122,15171,15196,15243,15267,15322,15345,15350,15358,15365,15404,15432,15437,15468,15471,15500,15552,15562,15570,15615,15683,15694,15700,15704,15705,15730,15751,15763,15766,15770,15774,15777,15795,15800,15819,15830,15834,15872,15951,16011,16014,16114,16122,16160,16162,16164,16188,16190,16192,16217,16220,16221,16223,16229,16230,16273,16301,16316,16319,16321,16322,16333,16386,16387,16393,16400,16404,16410,16411,16413,16419,16424,16428,16433,16434,16436,16438,16442,16444,16446,16451,16454,16475,16503,16519,16532,16542,16552,16575,16579,16581,16584,16586,16588,16600,16642,16750,16799,16804,16808,16819,16821,16823,16825,16832,16840,16845,16852,16856,16865,16870,16879,16934,16937,16943,16960,16970,16994,17007,17036,17070,17096,17099,17104,17147,17163,17172,17269,17289,17294,17313,17315,17317,17323,17327,17339,17350,17354,17404,17405,17406,17423,17424,17441,17445,17460,17462,17465,17477,17484,17509,17519,17536,17539,17551,17554,17562,17608,17648,17669,17685,17701,17705,17706,17722,17724,17749,17754,17767,17769,17772,17774,17776,17778,17781,17783,17801,17803,17810,17813,17816,17825,17833,17834,17858,17864,17867,17887,17892,17912,17920,17931,17933,17935,17948,17963,17988,17989,17993,18002,18003,18054,18056,18067,18075,18085,18096,18101,18104,18107,18109,18150,18158,18170,18171,18174,18202,18221,18240,18249,18256,18263,18281,18288,18297,18299,18304,18305,18309,18325,18350,18375,18376,18389,18391,18393,18427,18436,18437,18486,18499,18504,18524,18525,18571,18598,18615,18620,18621,18622,18623,18624,18647,18676,18677,18678,18679,18680,18681,18682,18683,18695,18696,18698,18699,18701,18704,18705,18706,18707,18709,18711,18712,18717,18718,18719,18720,18759,18760,18763,18764,18766,18767,18768,18781,18858,18949,18989,18995,19042,19049,19050,19053,19054,19067,19075,19090,19095,19111,19118,19161,19170,19197,19206,19213,19217,19230,19231,19232,19236,19242,19244,19248,19250,19253,19264,19278,19280,19287,19295,19296,19299,19308,19310,19311,19336,19384,19386,19389,19390,19392,19407,19408,19409,19412,19446,19459,19460,19461,19469,19470,19471,19472,19473,19474,19475,19476,19477,19479,19481,19495,19496,19498,19500,19510,19511,19558,19562,19590,19609,19610,19619,19624,19639,19641,19642,19643,19652,19657,19659,19660,19667,19674,19675,19676,19677,19678,19709,19710,19711,19731,19738,19754,19762,19763,19765,19767,19772,19798,19799,19800,19803,19804,19817,19822,19830,19839,19858,19862,19865,19870,19875,19879,19885,19898,19910,19911,19915,19918,19919,19920,19923,19924,19934,19938,19940,19952,19972,20019,20052,20056,20065,20076,20086,20087,20092,20095,20105,20107,20108,20109,20110,20111,20112,20113,20114,20210,20211,20212,20213,20222,20232,20234,20235,20236,20237,20238,20239,20242,20243,20293,20333,20338,20339,20340,20341,20342,20343,20350,20351,20355,20356,20358,20403,20404,20412,20415,20416,20417,20480,20512,20554,20563,20571,20614,20629,20656,20659,20692,20716,20717,20772,20773,20774,20775,20776,20777,20778,20779,20780,20783,20784,20785,20786,20787,20788,20789,20790,20791,20795,20796,20798,20799,20800,20813,20814,20852,20901,20926,21018,21019,21038,21089,21094,21114,21133,21136,21147,21149,21150,21153,21172,21191,21192,21193,21211,21212,21221,21222,21223,21224,21228,21242,21244,21249,21254,21270,21305,21306,21308,21311,21385,21386,21387,21388,21389,21390,21391,21395,21397,21398,21434,21435,21436,21437,21438,21439,21440,21441,21442,21443,21444,21445,21446,21447,21448,21449,21472,21473,21475,21476,21489,21505,21507,21510,21511,21513,21516,21525,21527,21530,21532,21545,21556,21563,21571,21581,21710,21717,21721,21724,21727,21728,21879,21880,21883,21895,21951,21952,21953,21955,21959,21960,21962,21963,21968,21981,22034,22132,22195,22244,22314,22327,22328,22362,22363,22404,22418,22419,22612,22619,22637,22638,22651,22659,22679,22987,22988,22997,23003,23005,23040,23046,23111,23284,23290,23326,23327,23328,23329,23330,23331,23332,23333,23334,23335,23336,23337,23338,23339,23340,23341,23342,23343,23344,23345,23346,23347,23360,23371,23381,23407