-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathmissing_data_DELETE_3.sql
More file actions
24 lines (18 loc) · 30.9 KB
/
missing_data_DELETE_3.sql
File metadata and controls
24 lines (18 loc) · 30.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
SELECT nbk.*
FROM imdb.name_basics_knownfortitles as nbk
LEFT JOIN imdb.title_basics as tb
ON nbk.knownForTitles = tb.tconst
WHERE tb.tconst IS NULL ;
SELECT tcd.*
FROM imdb.title_crew_directors as tcd
LEFT JOIN imdb.name_basics as nb
ON tcd.directors = nb.nconst
WHERE nb.nconst IS NULL ;
SELECT tcw.*
FROM imdb.title_crew_writers as tcw
LEFT JOIN imdb.name_basics as nb
ON tcw.writers = nb.nconst
WHERE nb.nconst IS NULL ;
DELETE FROM imdb.name_basics_knownfortitles WHERE knownForTitles IN ('tt0269126','tt0014327','tt11352598','tt7380792','tt7558328','tt0228521','tt0047941','tt0275169','tt0319951','tt0122812','tt4916098','tt0377765','tt0178250','tt1077275','tt7794272','tt8766996','tt8768374','tt8753150','tt8803986','tt8809368','tt8517542','tt4779206','tt8848770','tt8170376','tt9511468','tt11241594','tt9031996','tt8988686','tt10592906','tt8997514','tt9032454','tt8404680','tt9064434','tt9081850','tt9120264','tt9186844','tt7301672','tt9309924','tt9156934','tt9208630','tt9322714','tt9224154','tt3247754','tt9265960','tt9288094','tt9340268','tt9372832','tt9441854','tt9465038','tt10888526','tt9477032','tt14675016','tt7829938','tt8081648','tt9584754','tt9531532','tt9578688','tt9749156','tt7131284','tt9630360','tt9431172','tt9664500','tt9284194','tt11725734','tt10676084','tt9746882','tt2369393','tt9838900','tt12433394','tt10466192','tt10036978','tt10115226','tt10165926','tt14722326','tt10228830','tt10219404','tt12537466','tt10256156','tt10267904','tt10273784','tt11217692','tt11290074','tt11593838','tt10250634','tt9369576','tt10305196','tt10313742','tt9146030','tt6733458','tt10356428','tt10370158','tt10408908','tt12415390','tt13996502','tt10971068','tt0247661','tt10530850','tt10503766','tt12347600','tt10094342','tt10522744','tt10556240','tt6767138','tt6767168','tt10580364','tt10608568','tt10641498','tt10687994','tt8721094','tt3912928','tt10731818','tt9614934','tt14630366','tt13106532','tt10828374','tt10641520','tt10220492','tt10868960','tt15442414','tt10958962','tt8017856','tt14716288','tt14780508','tt12571798','tt10966780','tt10436462','tt11735772','tt13920504','tt11062606','tt11055258','tt12175268','tt11121394','tt10887824','tt11166416','tt11459178','tt0305555','tt11240354','tt18987550','tt11248432','tt11274258','tt6117192','tt11388214','tt11331992','tt12764422','tt11355238','tt17380670','tt11773184','tt11912694','tt13008044','tt17491020','tt10965870','tt9910302','tt11431344','tt10110570','tt11448540','tt9735120','tt3809312','tt10681970','tt11486260','tt11516378','tt11517188','tt11519474','tt11519562','tt11519550','tt11546472','tt11541006','tt11547742','tt11459162','tt3351830','tt18276364','tt13097914','tt11690246','tt12043370','tt3410984','tt11230170','tt11616222','tt9842190','tt12172302','tt5692496','tt11814820','tt11828338','tt15400554','tt11873080','tt11908762','tt14169656','tt11942054','tt11951936','tt12841614','tt11650338','tt12880466','tt17716700','tt12406674','tt12169252','tt12180496','tt13766204','tt12372574','tt12173604','tt12173710','tt12190430','tt21941218','tt10572626','tt12286398','tt12226852','tt12226916','tt12234612','tt12244706','tt12280498','tt12373426','tt12294374','tt12294980','tt12294922','tt16549588','tt18070480','tt12789668','tt12368870','tt12373150','tt12397158','tt12409978','tt12889994','tt12446670','tt12466422','tt12467076','tt12467362','tt12484126','tt12477894','tt12587246','tt12546566','tt12561276','tt14759002','tt12585006','tt14371012','tt6760952','tt12593270','tt15506878','tt10071176','tt12154370','tt12646540','tt12473828','tt12661900','tt12676726','tt12680660','tt17047758','tt13152790','tt12919812','tt12745324','tt12764380','tt12748262','tt12741116','tt12767902','tt12793336','tt12794314','tt12799262','tt12816302','tt12663590','tt10946474','tt12844614','tt12888682','tt12992196','tt13072580','tt13082908','tt12847210','tt13130522','tt13090856','tt13847962','tt13027838','tt12098370','tt13080656','tt12346586','tt13186486','tt20853062','tt14867060','tt13670764','tt13292892','tt12223432','tt6302056','tt13327500','tt13327796','tt13242022','tt16259822','tt13416670','tt13428262','tt20219388','tt13470662','tt13450652','tt2237094','tt13592552','tt13604290','tt13614692','tt13657848','tt13672058','tt13831564','tt13700700','tt13707152','tt14669784','tt13735242','tt13742970','tt13400052','tt13791316','tt13824280','tt13830686','tt13829220','tt13606186','tt8826992','tt13853432','tt13861622','tt13478038','tt14557772','tt13959214','tt13931996','tt14669594','tt13187350','tt13938800','tt21158436','tt13987934','tt13989716','tt14691614','tt10333662','tt13503518','tt14077332','tt14102104','tt12093966','tt14124638','tt14134158','tt17012876','tt14169634','tt14182408','tt16360186','tt14235782','tt14209528','tt14137336','tt14270676','tt14272118','tt14328320','tt13987394','tt14362442','tt14395400','tt14406952','tt14408024','tt14453868','tt14431818','tt14508796','tt15027328','tt14569640','tt15598826','tt14584886','tt14612298','tt14821352','tt14176228','tt14588174','tt14671164','tt14656204','tt14664122','tt14693652','tt14837088','tt14815290','tt14828058','tt14891662','tt10928296','tt14894690','tt12410078','tt14922342','tt14932690','tt14307186','tt12677618','tt14988270','tt14990766','tt14991158','tt14992170','tt15033022','tt15186842','tt2091338','tt14764536','tt15078096','tt15180788','tt4730994','tt15225828','tt12385954','tt15331240','tt15353712','tt15368122','tt15386264','tt15427388','tt15458840','tt12776110','tt15459734','tt15477560','tt20217228','tt15503156','tt15422226','tt15712174','tt15696048','tt15744322','tt15777452','tt10545754','tt15791658','tt15792462','tt16047434','tt16116640','tt16124394','tt16124664','tt16152972','tt16222994','tt16261480','tt16282692','tt15003414','tt16755694','tt16420164','tt19528010','tt16437344','tt16437568','tt16793836','tt7600302','tt17052232','tt3033532','tt15200464','tt17080896','tt17338918','tt17371536','tt17492762','tt18075476','tt18300640','tt18290992','tt18311940','tt18374930','tt18339796','tt20877586','tt9130456','tt20302604','tt20412466','tt21078372','tt6494054','tt21203152','tt21062030','tt18766246','tt23062508','tt15446910','tt21825252','tt21279662','tt21327936','tt21809398','tt22015096','tt12104856','tt22816190','tt23777138','tt19719336','tt21071020','tt0319948','tt26006368','tt25957158','tt26151386','tt26345596','tt3179356','tt0319950','tt0319947','tt0108701','tt0384982','tt2613190','tt0392522','tt12957362','tt0389402','tt0088641','tt3377652','tt6270602','tt2752440','tt4361256','tt5428914','tt6748428','tt7279162','tt6436918','tt0319949','tt3423396','tt7277724','tt3215634','tt4888160','tt0431509','tt4008344','tt0117454','tt0786966','tt4850734','tt12258602','tt2396325','tt0101043','tt7577742','tt1961480','tt7377326','tt4958692','tt6395820','tt0360318','tt0835511','tt4767496','tt6555818','tt3662040','tt1419068','tt7716782','tt3659312','tt2115160','tt13340642','tt5200400','tt3686864','tt1010045','tt0164282','tt1053866','tt2242608','tt7755700','tt0059860','tt3698590','tt0103358','tt1995434','tt1675145','tt12769374','tt7655422','tt4833196','tt0201087','tt7759318','tt7744264','tt1183348','tt0338640','tt1194651','tt6528748','tt4566410','tt4651452','tt5472784','tt4397386','tt1213642','tt3984364','tt1615863','tt15201920','tt4022472','tt8268036','tt7099872','tt7350120','tt8047102','tt6543822','tt7409152','tt7600236','tt1536641','tt12811146','tt4337082','tt1288647','tt1286875','tt2923076','tt4563666','tt3403442','tt3577010','tt5662392','tt3244778','tt1340742','tt1337523','tt4083092','tt3115422','tt8982336','tt8461934','tt7757682','tt1370890','tt7338154','tt1389561','tt1389509','tt1389448','tt9596816','tt0162588','tt1762406','tt5866466','tt1429395','tt7073550','tt4575748','tt5365294','tt6930556','tt7124236','tt2224229','tt1339444','tt5814170','tt4642618','tt1661067','tt1381833','tt0973832','tt11214144','tt1466973','tt1465849','tt10560030','tt1821397','tt5773284','tt3453328','tt1512328','tt2299533','tt1517796','tt6978804','tt11835974','tt8262094','tt4254680','tt1551625','tt1551626','tt1715226','tt1561463','tt2960742','tt5805942','tt5828134','tt6858500','tt1552220','tt1599360','tt13023542','tt5606670','tt1622588','tt1632686','tt6164230','tt1637631','tt4336972','tt1646854','tt1311172','tt1824197','tt3350832','tt2233270','tt2907644','tt0405267','tt10772406','tt5810990','tt2102505','tt1696524','tt1693775','tt1880156','tt1698644','tt1316545','tt1709726','tt1832283','tt1711003','tt1571230','tt2603086','tt1732751','tt1736675','tt1739306','tt5718540','tt1748147','tt1754534','tt2869868','tt2244726','tt9172900','tt1766142','tt1772253','tt3493830','tt4846230','tt1780926','tt1786588','tt2133365','tt1797460','tt3608816','tt1808671','tt2596976','tt1822407','tt1813584','tt1816648','tt1817129','tt3908846','tt1895335','tt1836849','tt1842366','tt2362422','tt8296408','tt1855387','tt1858552','tt9725338','tt1860089','tt1865435','tt0266032','tt1880160','tt3605590','tt2251764','tt1821690','tt1922618','tt1392238','tt1941494','tt2309650','tt7714944','tt1566614','tt4717466','tt2339623','tt7688578','tt7682642','tt4054390','tt2040389','tt2043904','tt2044864','tt1919146','tt1980309','tt1988729','tt2006767','tt7286862','tt2056360','tt10611506','tt2064948','tt2619134','tt3256520','tt4532162','tt1729662','tt2339421','tt2076941','tt6282314','tt2090495','tt5328018','tt2097238','tt2100421','tt12663208','tt2101457','tt7554910','tt7554868','tt2104889','tt2111393','tt3638118','tt5290380','tt2129869','tt2132327','tt3304366','tt2149091','tt2133346','tt2100383','tt2167851','tt6179320','tt3566424','tt2137610','tt2193257','tt2114367','tt3410034','tt2160165','tt3116490','tt7176994','tt6845694','tt2271159','tt1914239','tt3570936','tt6700118','tt2355799','tt2361139','tt2363479','tt6981724','tt2388701','tt2391053','tt5144048','tt8227272','tt2397459','tt1389470','tt2400403','tt6339510','tt2401971','tt2154436','tt5462264','tt2404793','tt5508766','tt2182784','tt9864884','tt5594464','tt2198800','tt2202944','tt5589322','tt7409830','tt2229132','tt2481050','tt1173914','tt2844330','tt3711446','tt2252284','tt2257548','tt7642620','tt2275560','tt2276780','tt4379780','tt5190770','tt2293160','tt2310356','tt6659566','tt6700308','tt7401040','tt2315552','tt7225402','tt5323608','tt2333520','tt2334808','tt3531092','tt6079192','tt3992378','tt2360482','tt9890022','tt2358826','tt2367072','tt6567314','tt2368030','tt2371534','tt5360596','tt2376080','tt4135460','tt2387208','tt2391102','tt2385382','tt4025722','tt2433568','tt6956424','tt2447066','tt4633048','tt2248644','tt2592116','tt2401603','tt3836092','tt7406568','tt2460752','tt4354788','tt3124466','tt3106836','tt2479594','tt2505916','tt2547748','tt6715326','tt2550830','tt8200508','tt2573910','tt2579618','tt0255006','tt2584268','tt2584374','tt7262700','tt5718528','tt2611670','tt2619148','tt2629970','tt2631398','tt2632698','tt2634992','tt2634406','tt1876531','tt7376912','tt6058122','tt20242360','tt3014444','tt2584468','tt8946882','tt2722968','tt11391688','tt7094082','tt4529904','tt2732018','tt2738848','tt2747864','tt2771460','tt12531018','tt2773338','tt6017338','tt5207122','tt2784346','tt3597640','tt7771670','tt5726196','tt2831142','tt2824014','tt7707022','tt2834052','tt4936522','tt2848868','tt2849060','tt2949514','tt2858066','tt3676790','tt2880810','tt2883892','tt2888056','tt1643249','tt3390658','tt7433468','tt2902822','tt3418020','tt10207760','tt3896734','tt6744546','tt7349174','tt2927584','tt2944326','tt2951694','tt3011472','tt5471196','tt2965322','tt6350376','tt7375518','tt2990100','tt2991354','tt3001078','tt0395828','tt2987468','tt3020362','tt3025244','tt3044846','tt3052330','tt3069188','tt3069298','tt7517374','tt4174812','tt3089600','tt15317518','tt12598498','tt3098350','tt0794402','tt4105978','tt3121904','tt3121160','tt2707790','tt3129688','tt3131970','tt3135094','tt7027916','tt3142696','tt2769576','tt3149156','tt3154714','tt3163576','tt12274660','tt3171640','tt3194452','tt4920498','tt3213546','tt3216292','tt3219600','tt3661638','tt3233696','tt3244304','tt3106800','tt3245878','tt3253116','tt3253636','tt5928906','tt3272060','tt3276586','tt6672614','tt4739068','tt3292904','tt3300408','tt3309142','tt3268838','tt2418462','tt3334842','tt3340034','tt3342300','tt3349526','tt3355522','tt3355912','tt3343132','tt5131248','tt1894615','tt3370142','tt3381864','tt3375214','tt3399476','tt4143660','tt3408742','tt3556964','tt3428588','tt3433982','tt3438684','tt3451190','tt5028832','tt3471276','tt3477066','tt3479618','tt3477388','tt7310286','tt3224008','tt3826298','tt3751824','tt3609520','tt3488794','tt3505816','tt3488764','tt3511554','tt7550284','tt3512632','tt3916798','tt4560322','tt3520298','tt3522976','tt3524286','tt3527650','tt3529758','tt6017988','tt5992270','tt3534174','tt10404100','tt10399112','tt2772774','tt3668240','tt3544538','tt3724072','tt3572892','tt3574960','tt3575550','tt5612240','tt3577200','tt3583154','tt3583726','tt3585010','tt3587850','tt3596170','tt5614462','tt3601460','tt3604064','tt3655926','tt3605588','tt5249156','tt3615956','tt3624486','tt3605534','tt3633708','tt3643888','tt3647936','tt3651982','tt3653704','tt6175262','tt3660134','tt3661876','tt3664798','tt3562068','tt4477548','tt3667868','tt3650552','tt4464752','tt3673768','tt3951236','tt3677734','tt3684478','tt14212798','tt3645870','tt5715602','tt3689748','tt7162026','tt12622404','tt3696482','tt3696488','tt3696576','tt3697296','tt3759156','tt3713194','tt3743952','tt3701504','tt6538224','tt3715354','tt5289408','tt1592514','tt3734724','tt21108982','tt3741764','tt3745538','tt3552086','tt4712550','tt5592278','tt3768384','tt3768648','tt3782682','tt3358084','tt3790992','tt3794148','tt5572822','tt3805336','tt3807184','tt3807438','tt3815996','tt3412860','tt3804734','tt3818766','tt3828144','tt5620452','tt3829108','tt3833342','tt3832338','tt3851208','tt3853454','tt3853732','tt3857056','tt3859038','tt3861420','tt4320510','tt3873570','tt5160122','tt3877638','tt6267906','tt3881536','tt3886092','tt3896148','tt3702512','tt7616192','tt3906142','tt7058516','tt3913142','tt3924344','tt5998030','tt3950498','tt4028032','tt3953114','tt2380462','tt4914244','tt3967570','tt3858428','tt3958538','tt3107132','tt3791064','tt3975066','tt3724518','tt3975854','tt3979008','tt3982906','tt4004802','tt4017544','tt4028770','tt5244250','tt4026436','tt4027648','tt4029206','tt4037604','tt4040734','tt4054122','tt3902312','tt4058978','tt4314838','tt4042302','tt4449790','tt4061920','tt12351090','tt4035564','tt4064192','tt4073300','tt4050052','tt4079954','tt4081696','tt4088504','tt5585868','tt4095318','tt5926140','tt4097382','tt3241016','tt4110740','tt4200614','tt4124936','tt4159196','tt4159168','tt4159146','tt4186360','tt7374352','tt7374384','tt7374456','tt3687302','tt0217929','tt4128530','tt4162212','tt4151496','tt4154632','tt3397704','tt5187536','tt4172552','tt4173750','tt4176344','tt4179968','tt5272332','tt4193114','tt4194660','tt4195070','tt4064496','tt4205204','tt4207066','tt4201856','tt4196000','tt4230626','tt4221612','tt4816860','tt4244088','tt4219686','tt4247248','tt4247368','tt4247412','tt4249992','tt4255292','tt5599338','tt4256732','tt6790782','tt4259272','tt4283768','tt4285998','tt4286718','tt4293814','tt4294118','tt4294516','tt4236876','tt4262150','tt4295836','tt9223580','tt4307786','tt4317528','tt7304244','tt7575278','tt4323168','tt3552044','tt10036732','tt7189148','tt4327374','tt4330052','tt4445628','tt4336932','tt4338062','tt4339986','tt4154236','tt8332654','tt4326400','tt4344056','tt4079144','tt4104342','tt4274812','tt6128224','tt4369124','tt4382940','tt4386714','tt3747098','tt4112846','tt3924216','tt4401762','tt4404914','tt4406176','tt4335450','tt4413234','tt4413470','tt6327196','tt4419236','tt4421312','tt5088802','tt6298128','tt4434210','tt4339616','tt4443586','tt6495674','tt4438496','tt7581668','tt4471948','tt6706222','tt4463006','tt4465656','tt4432034','tt3919014','tt4402018','tt1646201','tt4465512','tt4854354','tt5337110','tt4484658','tt4700150','tt4250222','tt4490482','tt4122792','tt4472236','tt4501870','tt4502836','tt4303014','tt4390532','tt4509202','tt4515246','tt4516244','tt5951238','tt4525798','tt4532890','tt4445662','tt5869318','tt7385108','tt2994716','tt4538714','tt3886736','tt4530472','tt4564492','tt4564564','tt7285384','tt4567016','tt4571336','tt4574458','tt4529444','tt4586140','tt4587654','tt4589794','tt3914360','tt4588746','tt4591454','tt4603456','tt4614120','tt4614734','tt4619650','tt4621524','tt4621610','tt3540174','tt4641588','tt4641804','tt4642736','tt4644422','tt4648214','tt4679072','tt4653394','tt5113976','tt5134562','tt4664046','tt4666888','tt4669132','tt4672394','tt4567322','tt3953522','tt4675430','tt4676130','tt4677342','tt4679246','tt7392082','tt4517806','tt4922580','tt5333050','tt4711636','tt4689834','tt4722158','tt5628312','tt4705336','tt8454294','tt6250176','tt5424818','tt4727520','tt4732586','tt4737644','tt4004794','tt13409112','tt4768650','tt4768846','tt4774212','tt6060484','tt7525096','tt4089188','tt4781936','tt4787668','tt4658260','tt4533880','tt7721196','tt6542990','tt4508864','tt4805926','tt4798954','tt4813416','tt4814914','tt5599288','tt4818706','tt4809954','tt4813328','tt4819970','tt4820172','tt4824148','tt4825412','tt3356784','tt4839298','tt4712504','tt4842288','tt4848862','tt4849924','tt6128170','tt4771416','tt4690128','tt4864644','tt4866132','tt4867172','tt0485843','tt4870216','tt4830652','tt4885024','tt4885230','tt4578792','tt4909734','tt5376486','tt4893882','tt4898816','tt2222280','tt8631700','tt4922758','tt10117070','tt6682540','tt4929270','tt6362198','tt4026014','tt4935144','tt4701510','tt4945924','tt4949026','tt4955298','tt4956214','tt7980288','tt6538374','tt4942230','tt5838480','tt4968668','tt4969682','tt4972454','tt4820982','tt5083982','tt4981686','tt4976116','tt4983640','tt4991274','tt4933738','tt5001966','tt5011036','tt6335840','tt5018126','tt4679652','tt7328504','tt5023870','tt4892202','tt5034778','tt4732938','tt5046142','tt5047596','tt5058696','tt5060956','tt3007600','tt5063356','tt5068874','tt5070014','tt5852236','tt7308592','tt5073828','tt5073830','tt5076262','tt5076278','tt5067182','tt6003394','tt3506512','tt14324850','tt7647602','tt5089864','tt4991770','tt5095646','tt4220746','tt5097524','tt5090824','tt5100418','tt7638326','tt4970792','tt5106378','tt5127688','tt5127832','tt5128472','tt5129820','tt5134780','tt5136028','tt5132254','tt5140640','tt6846688','tt5144402','tt6342030','tt5149738','tt5152944','tt5157912','tt5451204','tt5163938','tt5273234','tt5166680','tt0176385','tt9848532','tt4357098','tt5180034','tt5184664','tt5185950','tt7041662','tt5186992','tt4974344','tt4058314','tt5197804','tt5344004','tt5206744','tt5208650','tt5211630','tt5212936','tt3417374','tt5219148','tt5204162','tt5225228','tt5220872','tt4674752','tt7216384','tt5237556','tt5249384','tt7677348','tt5255496','tt4666528','tt5265754','tt5255742','tt5271394','tt4067660','tt6994734','tt5274614','tt12007070','tt5087784','tt5277212','tt5050152','tt5278136','tt5280544','tt5987816','tt5288280','tt5269568','tt7124800','tt5292326','tt7868932','tt8896802','tt4959410','tt5299524','tt5299532','tt5301932','tt5310682','tt5306064','tt5310456','tt5377076','tt5770420','tt5372246','tt5311916','tt5312636','tt5243146','tt5317288','tt5444438','tt7759666','tt5359100','tt5329774','tt5712810','tt5337698','tt5341240','tt5341810','tt5342204','tt5342850','tt5345694','tt5349160','tt5350380','tt6156400','tt5797734','tt13374732','tt5358786','tt5361318','tt7170414','tt5161084','tt3503616','tt5369062','tt5362794','tt5376658','tt3100046','tt5419946','tt5428786','tt5431460','tt4368478','tt5436212','tt5441704','tt5444324','tt5450852','tt5945808','tt5454480','tt5798454','tt5461620','tt5087234','tt5469716','tt5473672','tt5474974','tt5477372','tt5478302','tt5483196','tt5490348','tt4573662','tt6410224','tt5840082','tt5657828','tt5498038','tt4676134','tt6908990','tt5245806','tt5520536','tt5521156','tt5524298','tt5524812','tt3839618','tt5533982','tt5534476','tt5297400','tt5189734','tt6183906','tt5297050','tt4837086','tt5494512','tt5564520','tt5544310','tt5544748','tt5869072','tt5553344','tt6716638','tt5558394','tt5473824','tt5575474','tt5578664','tt5575220','tt6883688','tt5591150','tt5591364','tt5592216','tt5594032','tt5893180','tt5600740','tt15186094','tt5592682','tt5668248','tt5602420','tt5603360','tt5603872','tt5607392','tt5609870','tt5612388','tt5611394','tt5613866','tt5615758','tt4878592','tt4829378','tt5622370','tt5501120','tt5626516','tt5608346','tt3498638','tt10283050','tt6341046','tt5619668','tt5638358','tt5640896','tt5643744','tt5603064','tt7667682','tt5651126','tt4024600','tt4220582','tt5657834','tt5324664','tt4488678','tt6678288','tt5882046','tt5670850','tt5674410','tt5680124','tt5688576','tt5689398','tt5657372','tt7509072','tt6837160','tt5434688','tt6293556','tt5706448','tt5709152','tt5715546','tt5719374','tt5720054','tt5721568','tt7376476','tt7062750','tt4212940','tt6086794','tt5734754','tt5745720','tt7457040','tt5666588','tt5094236','tt5753170','tt5760602','tt1508656','tt5772604','tt7018178','tt5779108','tt5783552','tt5794520','tt5516298','tt5796994','tt5798074','tt5803494','tt5810056','tt5781164','tt5814234','tt5612400','tt5908970','tt5609980','tt5609768','tt5643060','tt5821990','tt4902240','tt5817072','tt7145176','tt5827356','tt3244216','tt5829314','tt5836974','tt5837536','tt5839544','tt5841110','tt5841116','tt5842546','tt7313632','tt5855604','tt5866880','tt6131702','tt5871106','tt5871236','tt5875388','tt5876440','tt5881534','tt5648984','tt5888244','tt7705040','tt6896480','tt5889398','tt5891116','tt6585668','tt5895832','tt6900344','tt6900350','tt6900374','tt6970666','tt5900308','tt5110734','tt5905380','tt5906984','tt5363864','tt5902900','tt5913728','tt7686560','tt5916036','tt5918914','tt5918940','tt4249568','tt5932554','tt5940358','tt5763456','tt5943486','tt15909200','tt5944502','tt5947372','tt5947938','tt5950216','tt5952576','tt5953828','tt7666562','tt5957442','tt7057020','tt5960018','tt5963888','tt5652656','tt6019630','tt5975484','tt5911902','tt5981422','tt5982554','tt5983488','tt5986940','tt5991244','tt5994494','tt5997520','tt6849084','tt7704924','tt6011030','tt6011032','tt6011538','tt6245236','tt6015640','tt6016764','tt6019450','tt6602402','tt5527638','tt5950094','tt6032728','tt6037306','tt6576880','tt6415760','tt6046656','tt6035606','tt6054080','tt6054992','tt6390372','tt5578096','tt6158844','tt4005826','tt6072560','tt6077758','tt6063364','tt5640838','tt6079390','tt6080472','tt6081322','tt6086136','tt5940810','tt6089470','tt6089972','tt6090972','tt6091002','tt5997008','tt6095108','tt6096976','tt5969510','tt6108904','tt6099444','tt6560780','tt6072196','tt6112682','tt6115774','tt5846948','tt7621156','tt6123636','tt7111876','tt6137856','tt5293026','tt6108984','tt6138304','tt6139834','tt6140844','tt6142322','tt6144438','tt6145892','tt5999800','tt6149624','tt6152062','tt7082242','tt6131836','tt6154216','tt3523032','tt6082852','tt6156982','tt6158186','tt6036484','tt5065828','tt6167658','tt8780586','tt6179352','tt6098282','tt6182918','tt4969732','tt6189990','tt6195296','tt8363726','tt4702670','tt5163382','tt6210732','tt7444898','tt6228874','tt5992170','tt6235968','tt6236014','tt6236848','tt6028368','tt5861752','tt6244604','tt6251172','tt6246704','tt6247046','tt6247300','tt6254396','tt6254950','tt6254988','tt6255158','tt6255974','tt6256534','tt6256718','tt6257084','tt6257100','tt5493874','tt6259316','tt6260740','tt6261516','tt6264514','tt6266244','tt6268278','tt3286276','tt6278268','tt6279224','tt7370870','tt6283450','tt6286570','tt6287802','tt6288880','tt6295070','tt6303044','tt6304004','tt6877690','tt6314286','tt6313696','tt6314094','tt6324800','tt7239454','tt6325136','tt6327232','tt6327678','tt4900068','tt7461262','tt7453556','tt6335074','tt6335310','tt6335368','tt6349012','tt6356224','tt6360772','tt6360880','tt6066256','tt5062786','tt6365922','tt6366140','tt6883260','tt6371930','tt6373654','tt6374864','tt5613210','tt6197292','tt6380176','tt6380844','tt6380868','tt6380874','tt6380898','tt5973244','tt6320732','tt6391444','tt6398172','tt5910572','tt6664138','tt6413498','tt9541104','tt6011776','tt6412814','tt6414320','tt6022936','tt6415038','tt6416108','tt6416204','tt6416710','tt6427626','tt6459618','tt6790638','tt6440338','tt6440388','tt6440406','tt6440428','tt6440462','tt6440500','tt6443566','tt6450500','tt6223452','tt7533002','tt6456810','tt12235554','tt13463840','tt6463188','tt6468784','tt6473924','tt6919878','tt6379412','tt6487578','tt6487628','tt6422444','tt6044144','tt6494528','tt6128218','tt6881476','tt8187868','tt6502166','tt6502112','tt6394830','tt7525556','tt6432496','tt7594104','tt6536134','tt10183422','tt6542178','tt7314788','tt6543526','tt5302494','tt6535624','tt6548230','tt6710452','tt6403682','tt6739262','tt6511608','tt6562324','tt6402328','tt6568416','tt6578764','tt6027310','tt6583330','tt6583490','tt6587714','tt6591432','tt6594358','tt6595904','tt6600120','tt5996866','tt6613626','tt6613936','tt7018846','tt7114952','tt7173780','tt10245904','tt6034094','tt6608394','tt6778868','tt6778872','tt6630038','tt6650650','tt3679294','tt6656616','tt6684804','tt6677568','tt7235456','tt6603060','tt6684192','tt6684396','tt15227542','tt6683348','tt8242100','tt6393540','tt6696740','tt6704978','tt6696714','tt6621156','tt6717782','tt6638730','tt6713876','tt6736154','tt6738602','tt6739502','tt6744432','tt8075626','tt6745682','tt6746836','tt6747950','tt6748878','tt6762992','tt7456034','tt6770938','tt6756658','tt7732014','tt6773086','tt6594448','tt6773638','tt6767106','tt6782234','tt6789198','tt6311886','tt6809084','tt6403778','tt6791112','tt6744102','tt6795328','tt7312952','tt6805942','tt6811682','tt6812278','tt6812436','tt6812480','tt6817974','tt6817990','tt6813738','tt6821300','tt6829572','tt9828428','tt6832814','tt6833022','tt5424572','tt6839434','tt6857086','tt6843512','tt6852426','tt6853686','tt6854294','tt6911168','tt6855896','tt6189776','tt4914404','tt4690090','tt6870524','tt6870622','tt6873798','tt6867486','tt6735282','tt6879470','tt5357138','tt6341352','tt6882248','tt8509770','tt5973760','tt6890908','tt6830320','tt6610412','tt6899462','tt6902006','tt6905968','tt6906412','tt6874364','tt7048500','tt5602042','tt6917196','tt7164562','tt6912162','tt7087686','tt6933086','tt7336878','tt6933412','tt13530424','tt6944506','tt6945420','tt6945622','tt6949108','tt6950600','tt7413876','tt6958700','tt6959394','tt6959652','tt6962088','tt4533908','tt6651120','tt6975962','tt6979652','tt6982836','tt6983394','tt6986322','tt6987158','tt6992084','tt6995982','tt6999084','tt11518260','tt7514344','tt7376270','tt7007744','tt6867538','tt3109042','tt7018684','tt7026560','tt7029524','tt7030356','tt7029782','tt7030272','tt7010048','tt7157912','tt7033936','tt7268142','tt7043814','tt7044168','tt7400440','tt7138200','tt7071268','tt7036838','tt7085198','tt7061664','tt6950328','tt7068010','tt6509602','tt4095816','tt7080042','tt6889300','tt6754906','tt7070594','tt7085778','tt7086876','tt7485470','tt7079354','tt4079500','tt7092836','tt7119794','tt7110478','tt7114826','tt7115054','tt7116154','tt7116212','tt7066018','tt6344850','tt7119846','tt6387528','tt7122984','tt7129818','tt6487508','tt7137334','tt7138250','tt7138490','tt7143740','tt6916322','tt8656046','tt7147784','tt7147888','tt6982250','tt7214464','tt7157894','tt7158724','tt7159234','tt7162334','tt6844560','tt6374870','tt6306104','tt7168728','tt7169172','tt7170498','tt3334286','tt7173940','tt7174840','tt7176812','tt7183034','tt2784392','tt7184884','tt7377996','tt7200558','tt7267464','tt7214236','tt7215610','tt7222178','tt6904480','tt7212860','tt7224030','tt4542328','tt7223222','tt7230854','tt7230882','tt7160308','tt7231762','tt7243136','tt6844106','tt7242792','tt6919780','tt7559832','tt7252886','tt7256454','tt7259482','tt5632570','tt7271608','tt7272682','tt7311496','tt6607954','tt7279010','tt7281320','tt7285512','tt4509906','tt6808298','tt7294364','tt7161650','tt7306104','tt7310190','tt7316840','tt7305512','tt7324826','tt7345470','tt9546158','tt7374944','tt7326878','tt7760162','tt7750486','tt7239028','tt7335844','tt7340606','tt7143374','tt7337274','tt7339370','tt7339636','tt7342274','tt7218680','tt7532656','tt14404318','tt7353442','tt7353432','tt7354644','tt6969860','tt7357304','tt7732248','tt7689308','tt7360396','tt7365474','tt7367816','tt7374516','tt7374756','tt7379538','tt7461252','tt7382984','tt7388346','tt7389724','tt7466948','tt7203170','tt7593312','tt7400608','tt7733778','tt7282052','tt7428928','tt7409600','tt7184154','tt7736508','tt6566116','tt7420726','tt7421780','tt7423818','tt7428156','tt14243932','tt7430188','tt7433830','tt7436172','tt7440942','tt7443138','tt7443164','tt7445134','tt6178144','tt6995980','tt7447688','tt7449258','tt7450334','tt13298712','tt5945070','tt5968190','tt7467956','tt7472234','tt7150618','tt7466400','tt7478754','tt11239104','tt7489190','tt7458704','tt6940686','tt7497136','tt7481960','tt11057552','tt7497788','tt7488936','tt6957306','tt7459108','tt7169758','tt6837728','tt5492960','tt7510298','tt7366312','tt7511200','tt7478860','tt7497130','tt7521012','tt7509396','tt7524556','tt7526752','tt7527012','tt7530054','tt7524246','tt7532292','tt7353820','tt4972810','tt7535762','tt7537128','tt7537240','tt7538334','tt7539416','tt7542438','tt7671314','tt7549976','tt7550068','tt7620792','tt7563492','tt7567358','tt7571122','tt8235364','tt5630286','tt7575848','tt7583552','tt7577550','tt7585452','tt7587976','tt7589696','tt7400734','tt7592706','tt7250832','tt7718552','tt7596384','tt7599606','tt7713224','tt7728678','tt7441252','tt3905890','tt7608106','tt7608420','tt7607802','tt7598558','tt10747048','tt7631818','tt7633010','tt7634390','tt7598832','tt7635904','tt7713054','tt7638764','tt6185762','tt7681688','tt7642310','tt7628004','tt7732738','tt7188952','tt7664366','tt7665018','tt8132340','tt7647702','tt7668550','tt7682352','tt7683154','tt7689594','tt7705492','tt7734378','tt7710654','tt7082476','tt7179874','tt7700580','tt7723890','tt7511926','tt7265316','tt7709906','tt7489158','tt7174046','tt7749126','tt7715998','tt7716844','tt8101474','tt7717882','tt7725990','tt7730528','tt7733686','tt7260718','tt7738378','tt6421046','tt7748410','tt7745360','tt7732394','tt7743394','tt7746938','tt7747152','tt7598044','tt9266482','tt8813820','tt7593758','tt7453474','tt7721614','tt7555880','tt6916334','tt7757108','tt7762144','tt7764644','tt7765348','tt7857432','tt11415572','tt8063608','tt10777360','tt8097138','tt6730652','tt11218164','tt11217810','tt7967502','tt8164870','tt8180350','tt8150626','tt8211254','tt8136128','tt16608112','tt8228386','tt8219844','tt8237246','tt8181612','tt8174886','tt8247382','tt7998744','tt8146524','tt5336076','tt8256182','tt7211356','tt8277698','tt8256960','tt7709004','tt8291234','tt8165872','tt13474896','tt8307650','tt8319362','tt8328660','tt8192368','tt8318362','tt8355592','tt7842356','tt8385974','tt8394516','tt8405878','tt8406694','tt7939266','tt8421326','tt12816750','tt8463442','tt10431426','tt7769604','tt8505314','tt8517176','tt8523128','tt8526118','tt8128798','tt8434042','tt8546432','tt8571236','tt10294818','tt12667344','tt6413346','tt9412492','tt5626520','tt8649694','tt4921664','tt8650872','tt8653852','tt8656764','tt11924856','tt12020992','tt13847232');
DELETE FROM imdb.title_crew_directors WHERE directors IN ('nm3249172','nm12336988','nm10558688','nm11169818','nm8404896','nm11987538','nm12190315','nm12327135','nm13351201','nm13351201','nm13693900','nm5280357','nm7676982','nm13931580','nm9060662','nm9273256','nm8207092','nm9892911');
DELETE FROM imdb.title_crew_writers WHERE writers in ('nm0799875','nm3249172','nm081187','nm12336988','nm10591900','nm4274288','nm11169818','nm8404896','nm10991318','nm12327135','nm13','nm2481066','nm11921310','nm11921311','nm4444963','nm4944977','nm14239029','nm5298455','nm4274288','nm7676982','nm8324210','nm8819233','nm8207092','nm9201980');