Untitled query #45602

This query is marked as a draft This query has been published by Miriam (WMF).
SQL

select count(il_to),il_from
from imagelinks
where il_from in (296246,9575832,12130531,1535983,3487956,981989,53596986,43545477,156222,11164932,983849,7456201,38245,5961506,36821178,12647331,33260703,22110321,167809,1600858,6095252,2367208,24158862,483745,16648109,8425661,312990,14774463,2993846,18912832,31428668,1488066,4702155,154699,47673417,37871582,443972,18952631,146595,6833084,25555004,24193429,4120842,27403920,303847,1765938,478684,28241098,446891,15516110,486195,21546442,218110,56201038,23058629,170858,2018921,1219214,2951117,62084,8818806,1364234,77744,8898667,15351941,42512150,799881,4406314,1972947,9032903,36448415,7626259,354536,22535918,6751,53964,1274863,29409425,48489130,39723138,5344149,299016,2177168,23625840,9974516,1330432,5024840,5982397,5952246,2338993,32565813,53027133,13786783,3717818,27444757,149789,2165639,10330008,10060183,97740,1197756,171568,37495513,12640256,48023607,6417790,41670200,5078159,49676389,31512146,1610940,382824,21254215,6081230,24498167,53168418,1826422,29735796,14195429,15969057,626916,425087,5513513,2932389,8611306,754323,53797776,31889792,7853339,308036,39563460,25915234,1458772,2098698,39923441,22462670,1708570,17151705,76402,8025116,5335922,25081016,30241769,2748547,208995,38639945,16150640,3138227,7758136,2303875,33796742,44706734,36035782,16472738,24211707,3831594,7865056,39484343,9110934,1320650,4162938,32869134,34525509,22543268,6126268,34657810,4045254,3448890,5141818,4396940,6643402,4191560,11938659,9550478,16430476,10531772,8026746,3606845,19351229,10396412,2819143,49668654,2267635,25829166,41886194,195797,41776052,3109101,5292920,77653,29914209,6037691,17022698,509792,11398844,3782892,8687544,4856981,8380456,42746245,8719979,537564,25677728,1238455,585824,51999545,16855103,56407071,42261248,226211,48283040,26018309,36890802,8714647,28365073,28645422,4607239,918901,518615,2237161,24069500,36890815,29462138,38888211,10446380,39393677,47346885,4312527,25541925,1952607,28986107,1916598,22031391,255049,21744986,25223887,44279559,46358968,196393,50147204,23947773,73575,3694699,24160634,6573528,12813606,4977538,47275767,45568,3415,48859197,25832,5884882,4040311,37854530,22156853,45332372,672934,17571858,5276168,10703371,4017383,22114132,10590353,18906393,48358507,47460310,2248157,12246739,962410,46860775,39685003,3454625,149875,646009,3111180,14332632,180968,3193176,49723726,2295405,497639,5248155,10185702,39790957,26350010,493333,34602448,19849373,29679642,8621074,7741538,163531,19268898,1979318,28355486,5198953,36415448,22449964,4681165,22114003,22815884,471488,1176717,6790169,285284,935892,6866387,5787216,9653770,3367123,35982356,1591989,9223398,1234079,7368926,4560018,16904693,47833947,46366999,13707253,50941458,3477349,57462339,31430255,1533182,15589712,37991562,14737225,9401743,4349389,19547540,39543827,2735755,5128528,652539,12816415,5408,30237722,2285357,19165776,230503,51419422,44080586,47634736,24229540,15365850,24449695,67417,2773473,254507,2493307,8558102,17315314,197415,9085771,17764658,4645567,1009041,7011007,7583494,53901,3312138,3822718,292993,46791149,3635561,276241,22123302,49605579,3497579,30575,11253233,7204495,2949735,6097240,48569801,21217240,8886709,2837025,2331380,36613262,48423097,1127874,337029,2745708,32855042,20206,3189853,40771445,48565123,1962520,2567839,56324133,21538066,12938853,129542,24779008,6109201,4481207,24093775,49241,15203910,4770345,2710478,56656,1412390,1567129,21762864,2046735,28791031,54389113,44200250,4010259,766348,2233095,8060080,21283763,20860135,43781368,113452,9441798,55979268,17509462,14471796,56583336,27665016,21703763,171540,603557,473086,424150,1988806,238428,6701452,2223589,147537,18231745,1343973,9951797,4003719,1228941,2217988,31197125,825149,284384,3693882,4923868,355236,43600956,50855788,672153,37640831,331425,8930957,5257678,179293,22516313,42470077,1405215,33013488,476239,2001301,9151759,48578580,50637175,849697,23239530,28370864,56908225,43351,25825614,84636,3857180,2541685,2217354,94339,577663,31065513,5672206,31978798,379635,42012,26608129,158835,24207129,4586623,23555063,26430438,4278437,14746919,18083698,25645,580673,315540,27223546,12216999,4413065,19980386,40400057,1679923,460656,60033,40152633,5238193,846311,11567553,21226360,639319,9223339,5018573,2666695,18985952,34210751,157481,17702522,29812,194664,17782843,20964295,35304999,12964276,6616765,77619,2183356,17049893,12149364,2782741,357525,5447,8031432,10860957,149131,217793,8360654,26508404,15573,14160641,4179770,18952357,12285168,44321327,14240262,47450065,3457,79448,2025985,44390351,1708475,31011170,41800341,26541,59729748,41029118,37026000,4851257,17286155,8928152,48643802,231234,2620748,937507,31424761,22092460,7286445,14716766,5608558,9530327,34340,17653287,11450884,590598,17288991,19940419,1788654,6733074,18766606,2162640,27279709,2384482,6803954,3843721,1188721,28859296,6440529,29890957,27506395,439458,34227276,5187488,10069910,10298609,4710606,55264408,175849,3524655,9144986,1731114,50186011,3408831,55858235,60016506,2162119,851285,44352417,58376,31255600,55233455,25080850,49140301,30881916,6632229,30983881,14995351,51394624,32332049,19036209,1367501,1438158,9695354,43993637,42910647,12823367,3737649,20754031,210155,816862,31710903,42036601,25495146,1723357,180714,4036006,27812724,6103640,9899953,12890638,1126401,54711451,5859950,6237735,11567269,39592589,3448942,4724575,8642505,9956444,48596690,14126900,23924,39137345,6876496,348979,28352747,186160,31463,1356982,2066600,3969,249601,12545571,25752436,1249019,5566354,17180952,45325716,45640705,1988236,37707144,23769406,15409406,2144,650922,6734914,24011854,43032753,4343453,47134700,22372814,25687480,2343735,1405895,22378121,14387276,26723623,12894849,32205817,10215404,149748,54920118,939670,11388236,59537875,23086136,3266309,3616144,49813404,1190305,963301,31321865,33944220,8351040,6231868,938699,55125362,3158351,642867,492056,2194799,1164579,21487047,1684124,39756211,14724263,29267698,612752,42739493,5239322,712240,36874390,20309964,6488571,50753748,8804408,11050727,3261501,31035839,7571090,10294806,4211292,42159,41914716,677389,3669968,21456296,40191899,18993006,16579,6341430,16705435,13978625,1576940,1783947,77127,32797228,5150937,612018,15167657,25104691,23574524,22516815,2973132,4526503,23505559,8465139,4714392,44449257,16894,2291440,16949337,7669549,2452747,24725063,57962797,24110107,23938010,5078515,30270338,18373853,37534,60070,19296306,1331978,2615708,172031,6787518,14231343,4700217,12466044,4693134,1083768,12918906,35527324,25536549,4326550,38934888,40908562,1343208,133462,2275790,6149419,28299508,21777295,3562929,32717999,15703454,8772083,788543,6276716,16522290,34615092,2504846,27387452,1336534,20168100,65450,80521,1091333,36102395,3780957,145492,202652,4188548,16260144,145975,44747859,16753523,19360778,4372977,3381361,23229173,24301630,3621799,1250208,31070456,22528630,586782,46201393,9457226,1641514,4367482,772732,36258161,49417954,3099417,26451186,18994363,10027586,379971,4717779,319149,1954198,3881308,3136520,433310,4610810,38252,71966,30782570,3894411,49728,1704458,49352427,47866924,1017772,28776966,3253210,9208103,29004443,163417,14737326,2556838,602501,3142340,43396648,1055920,14898345,9917168,17789399,1282407,35978329,140639,25854460,11020749,23953216,20520132,21055071,14582785,38731711,41928255,34277479,30723003,2527894,602965,28757535,27670293,30192355,9264215,55556828,242497,44379763,1608019,31976274,2482107,36816466,1866903,9481844,34421028,39922551,9384810,282964,184399,468342,2262072,2941812,25366020,7148350,3077184,10942685,45144844,51983,43449,48605829,101998,1210091,92596,25248397,17708853,23084130,29759425,1329390,20617798,27763376,195437,25121615,37125755,33580698,2304453,8267687,456959,9495654,14237082,874,2941852,133622,4628722,48452913,4941734,2187141,29082218,13393790,4691511,1634305,32806663,41035906,5206156,4204059,32612875,351949,1128240,15982164,24475766,10943915,7678668,58577794,18777685,24659118,4337705,13680702,51200136,9001422,7154010,43212643,920501,957871,6265220,32610315,45677618,31158938,2266087,52003796,52718212,40116327,38273987,46787898,38711,2011691,5162233,2013364,11064164,17617782,48682052,46222879,16808,18092214,25103025,28617466,28173490,10240061,24490679,22467,133574,11556847,29320113,948784,148003,671128,39377018,6542399,5422144,39553106,16396774,1482800,2283068,4226034,13992681,26262913,3239688,16304395,10525221,27081302,26000960,3799386,18926,19868945,2631788,20853333,7526692,9290073,32673599,811484,10850871,9595500,151143,5517291,23700090,56186412,11962392,91133,48358348,13466352,6085266,5082748,33427265,18633362,34410222,317828,5068852,615121,21433950,17932255,45062968,348994,5499331,185783,55021,58147,15996858,43736158,19034228,1880039,17961082,27716897,5541530,2207640,4798258,2890861,18836,489800,61168,4300779,2139989,37086759,33270003,23510332,1212256,2510385,7128210,209213,4750168,30885871,25202209,26683130,27131059,43516765,34258056,2537424,34961693,437829,3177256,26691985,2967115,547448,15577066,884742,3829646,23594997,6804649,39615199,16231566,75268,20795243,3705395,25751175,376179,24806261,26153527,1257935,37733321,5964231,2635192,20195915,28935479,1394037,56929426,862425,35164385,49659067,25180915,61527,171047,54360849,6884219,2910952,29894297,30871074,33687379,3736647,846354,3421031,8856020,4123241,28051279,36741,539816,3556701,22489,61519,45474,755231,31232513,3247979,7715240,1389264,41668588,12641187,14876301,3732862,3520833,2933910,53715349,1180124,8436645,45435308,8906905,262613,3761238,4731904,7816124,6719022,3641811,31165,7715229,32312042,26728670,6966587,26940014,8502589,770260,11087534,2368408,12731,9720148,24304179,19761638,42689546,28903466,49733603,4803289,2980679,113619,20678281,5995578,39327349,27428105,11407333,52624147,36480292,62371144,3598864,46984685,9056492,30236272,2005119,6935978,6752032,16252413,781629,32828136,7302414,43165862,222127,1389913,1244822,31163684,6100131,8887199,277049,8817538,1662223,37617614,6169073,26181579,6046767,3992212,28340151,1712237,15759166,24586901,882119,5079506,55129937,56922014,3566511,43653863,36234300,43736667,10417568,5429460,14723194,100730,1087247,14540806,53692650,26147349,67414,56186480,36354051,24480838,6676241,21302,10386770,49038325,163633,41739713,31403745,19318504,39412644,10672,12009929,33565082,47080958,4637590,18557533,42191366,2253390,3447064,4902239,24051463,46878341,3458487,6164542,3861685,6169108,7684120,50693,46958958,11729954,15852,23181726,2324980,34467400,3493786,28293297,820919,42778913,31473382,17384703,174609,1134155,51518400,36579504,6113391,3724436,9547806,37820416,5876878,255858,2055814,29636403,2725470,33651094,52437143,36873981,33963416,590462,1275551,4123826,23037,8289010,16035327,1091190,15789864,38098441,19165852,3288825,54097899,5082101,667925,1682418,360345,41950487,161781,1971307,269405,4343377,2806249,267366,53923310,8602643,5517329,4055736,4781857,1822878,651322,2611302,27710092,2474408,55298182,1074030,14746483,6538127,415109,187107,6584119,11699620,3331285,47298244,4185840,3781791,26100183,32841570,47063425,74971,10085,38682308,32134981,241469,31267756,27622457,2295231,48457211,36484005,4518378,2229439,65626,101813,1703792,38617009,3567408,7969401,3952475,322343,1328234,2971654,19107204,12213090,3055521,18842323,394310,144508,50185885,944960,37377624,2423917,18895191,21102984,51725290,3058148,2279186,5880273,6141619,7885996,7516835,39720864,1623960,3088822,558336,3300191,26608236,8355938,2554949,1471253,77856,47139653,4113991,52634040,226562,9264341,599435,189981,13286148,12611828,362719,600235,43715639,18785526,17443,2566582,16972981,3770679,39110374,45851,580994,24167614,2236146,60354360,4979871,1598996,8786,4900499,596639,52481184,34418416,7977406,8891528,32864663,42021511,3986674,51202264,385706,18758,417891,28722503,2709566,335298,9532999,6631386,6703617,14149884,747579,2021700,448331,71574,21642897,1865556,2465292,23736856,39538304,972958,3403739,7085931,10444955,30035732,2887314,20857500,21733496,888336,49740268,6469252,35784741,3391396,383851,37068,598363,43791803,52371,10335449,26640605,61189,193867,32300310,922861,9288,8914341,28745496,8124062,3303622,20580166,24272743,25687017,2325367,26393786,41981349,5818165,3791874,8279688,36567002,17706372,5275752,11885068,524813,35208949,23733675,27960307,390763,34312285,41496306,43850341,5654,14021789,55611304,3825785,16880,9497934,20506270,48927,16792210,43688437,47058330,6043036,1769626,2405186,2294584,33575198,30630279,877044,39682090,34222772,1141995,3733786,17308230,38813520,938564,5192298,39295834,6004372,28876,1354975,6524357,51053017,2763180,50426133,18778495,275915,16037718,93559,17571248,2870618,24772329,2631898,16731304,2699519,30320,60099998,12806049,23987542,5427784,41304417,14584097,2118495,14899108,14411595,41205461,200020,327421,42968024,42181703,11699443,4873690,1821202,20692991,12182188,43910702,144765,16368206,56998074,7048192,34440607,16703150,49086281,31683679,171545,27376480,56050812,144774,1622411,43655636,30875069,14683064,56532216,36655253,2525385,4836072,18787,6647287,6644383,1080994,28105466,15420536,3023543,29828688,15065390,17927279,6500339,686066,345245,4333107,20907274,39482836,568055,39462087,8308697,47521134,46426118,40282475,56978,594257,9555242,6720263,4227273,3860285,39756987,8224272,38934789,8457430,1152328,8152894,14533,5499083,18456072,31456927,24384740,6063237,1522855,3749096,37782942,27420347,313380,2317139,24725226,240376,6586469,8049233,23737096,8143396,3569886,327582,690237,28173585,33572843,32784130,15219564,13038387,6531454,67955,24142336,2150455,43568700,45363148,44942239,1157626,35027707,28358401,39469456,36217549,20219598,79491,473212,2821933,11867,8503373,32954280,1587300,35316287,46270306,94028,48378261,452246,55035890,60788399,1220522,3238135,441661,4616725,6251539,988503,38846433,36624220,1884712,19767434,49123013,50799334,4372744,51237365,1618577,37914,12685218,1237394,46710,37564743,379011,104916,57819489,7845053,2370658,42073011,4556334,164517,46991,70647,28273709,1575869,13522574,36991042,52234603,23749531,4329444,245515,42120613,12344891,146236,8279491,52432928,142463,46327863,7543423,28174450,38055726,76339,26100368,4721,6651585,1644192,382160,5716877,151535,14238656,56970172,41366275,34181921,62115,10781602,8164669,15349469,18515925,24503,44209988,8715,41602617,54891556,20919109,38890125,37773629,5034198,50501437,4696407,34439954,17764048,51580,12026400,698908,1353062,44353937,670514,36701552,42462424,30874039,43455,15777230,39369150,1808880,41826051,3476773,18756,4343478,73376,34953952,12417258,15530829,39399330,22872100,14672065,10149834,3383231,28269,655747,1923656,48553549,7677145,44700173,16980181,5098517,38267543,31427208,3966684,29680867,36801864,19420250,24817139,2372757,25038063,1051820,12696872,30707567,43949173,22152731,29717684,18386478,16013696,31495191,52339773,41572773,6020797,1801788,12124469,13903487,288490,40544397,5975630,52780,11445373,15721714,14037329,758319,12204434,5951,24611507,64598,12746429,4597853,2216309,140422,36294220,46913718,22428085,11260405,129585,43783191,11476109,2482322,8612307,4015188,1611072,54610948,15798260,54461515,2846126,1097249,41535,5079733,8679100,5875943,30040692,48229813,4320144,3111465,26217532,805642,5431194,18162734,8520,33208964,19590,537101,26178850,5080099,24048670,61213649,839579,26460871,43793866,10292462,25060109,24053482,36871298,32267545,5391943,26529539,3401001,46942853,1812238,50139805,3447166,878191,9034057,1586802,48710161,38206118,35961939,15763775,12378678,15216050,50342578,49260002,37939451,97817,4995581,40969350,3812366,12319832,894179,103021,5517284,9122363,18305011,10029635,7769076,3116944,14490488,14231624,23944914,22216002,14247608,1213319,35318297,15266287,46782445,977878,1308304,10856317,45345598,43757796,7837396,14419505,11662268,4191487,1118396,44844459,11417210,14856464,42906163,38330433,31176601,4069518,45379583,5082034,6414765,304428,2400255,11351598,17259004,39819373,32432,42968054,49595574,35663798,1969580,36857579,212090,222568,26452149,16067557,26393161,8632979,33066754,37439467,189695,1562557,16797102,1781048,31705641,142623,32555318,3343805,3598984,13514560,1300540,2950304,183417,32818151,16477368,1113278,46238456,25924934,1193390,54367863,48068,29763605,35689088,22162979,337069,20637977,26428,14353418,39181971,5655,6004827,17808534,35804217,64437,972816,53459456,6979276,463570,47216122,8436521,14350910,20731623,277158,65669,811812,35131754,38268807,20844864,3874380,27742629,30015309,6430372,48565947,43221463,1249630,13009391,1563060,18943833,43619750,3737258,26362281,32923055,214799,2268745,1298541,4784311,2114954,21239514,909664,51439395,74956,32111330,8506932,52055,25826180,19035964,897481,1623267,62117,1374201,17041756,25734402,9092660,6226,849186,5257371,51668536,6427576,27391398,55619105,147156,15021680,53133327,16225974,33336349,26197,32099336,173825,7767613,14076924,247098,13084794,51763,3389311,50520333,9513043,703970,14790659,36940825,12696164,19603,32246523,39655976,12108808,5964302,54206880,7892732,49661579,55935200,175668,8554766,57780919,42225268,36598114,9571945,5434141,73087,9617369,57071195,18921118,33938151,44930183,36931347,15703732,30697259,21778431,22188807,1533733,6000525,7852430,36873638,4432750,2279601,77604,2585705,27127942,21848113,37163037,2507217,493502,6520719,22558707,10364456,36939010,2379908,32978098,44824051,41094209,5517265,44722907,51295612,32220715,22281602,14640430,27683347,33577424,15155,44170923,17603695,33422540,6117093,56158959,156628,6446062,31911361,19383016,42711261,39022152,24228929,13393041,3815505,28042876,15079534,30784671,14679509,142510,12256764,35881126,2228717,35764429,12765279,25329994,295973,12794951,142417,11028867)
and il_from_namespace=0
group by il_from
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
