Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
DanHiggins (WMF)
.
Toggle Highlighting
SQL
SELECT DISTINCT cl_from AS Featured FROM nowiki_p.categorylinks AS cl WHERE cl.cl_from in (326234,968375,795462,681941,1083410,20183,20627,771392,19395,83453,104,98,267422,18720,18621,74060,22153,1103289,172731,111027,289990,203861,937147,277369,74669,25021,20844,18600,93558,5320,1229129,3410,521351,97412,798212,521289,1229236,1229237,796843,767165,832211,831534,283829,386362,735481,3926,4598,1229261,1226835,4649,134981,442855,215985,514072,69075,103969,103941,118640,838792,490202,279517,281899,43336,280162,173456,161162,195200,199570,160555,1091347,203883,650641,803656,411545,592020,411552,422837,440752,1181802,103944,292648,256535,274029,950530,23109,44650,44654,44655,44842,375983,562793,562797,562824,1229327,1224245,1229157,173000,161314,1229357,1204301,1229344,6421,482779,298665,727,1228532,1225474,99315,1229371,610980,688958,1229382,1229385,1228529,221105,40777,5476,1229454,541174,1229458,247163, 17577,1177768,1229482,758521,1223877,757205,539846,555539,753277,574187,574160,574184,78655,264515,1116592,574181,764515,762927,713412,758002,658255,261406,625008,73785,51592,814026,1227124,1229523,1060292,71375,320756,94508,1147020,965101,427619,285945,1229558,277290,1185026,285937,285923,285939,527400,285940,285986,285987,624590,285925,1229478,881513,285941,285942,27165,321441,442330,266896,456335,469134,762982,1229386,279572,847487,1229587,820881,1225626,1063932,33513,1064025,1220936,1225087,1225378,1229610,1202080,199705,393106,390193,26709,40877,40876,40836,352575,40833,902486,40830,216140,38339,40835,374512,40827,186328,790965,776673,39873,614454,578263,113431,39972,39570,26156,352620,864692,374667,40941,372639,329463,375602,376120,40891,40937,40106,372585,378573,864324,372845,793296,41003,222047,406574,364888,1115369,394000,314857,1121476,319461,970493,1118668,405407,405775,367342,405185,405764,529301,31892,405208,405189,405386,405388,405803,972368,972350,972363,972357,975436,803075,454903,454759, 626711,329381,161887,321320,454747,189240,189242,189241,708111,41620,113428,1058287,1056865,1055127,1047779,1053819,1067603,1054269,113416,18000,1070711,40099,664609,222037,41038,41029,460088,41012,463048,517401,29642,958362,334159,493818,1005230,1229456,177852,751908,778070,884381,788462,1227070,689005,594959,127125,181138,1181824,841020,777989,650151,889922,667400,901059,1022610,1122432,104636,17500,19683,971526,1167136,1229680,41998,174430,775728,401838,546881,1131416,703638,1079839,1224586,168054,779902,597205,409350,622397,1021020,244271,638175,657752,1097954,90123,343735,72327,448559,560166,15346,584792,976879,1229704,90652,558031,858281,693764,1104047,657643,588156,839999,432099,507372,1021018,726241,1229620,723635,119217,980907,666233,1133002,347773,211456,259173,814803,522287,299391,402463,202513,623411,525287,154338,1017455,1136284,178472,431019,679271,41005,39785,93837,67728,63378,40897,363857,174447,40133,39977,39996,38738,321046,703218,1155482,819327,995551,550985,839861,975820,1085141,717530, 969574,313349,1117013,717315,1058644,882183,1186300,155899,50230,718525,718581,424552,1179483,112314,769737,767101,563530,678,445368,505574,233067,105969,353424,349377,34921,989799,989797,1088098,1179693,1229818,1229819,1046947,76784,8023,8022,4842,253254,787851,1028983,818913,68856,299368,385956,338566,261625,1031192,400465,1030856,95266,476301,1229838,1229839,1229840,1229845,1229847,1229859,819333,1229879,8021,8025,1229831,1229889,34895,730200,777317,777536,774665,72775,233081,602765,53966,79969,1107723,7966,7936,1229870,88317,632343,54302,1229912,1229913,68525,1229919,23263,18626,819335,1214131,109697,1133824,1229960,1229964,137675,1229991,356983,626162,666961,37448,108041,1157329,1230116,1230137,200336,1060213,1059529,530257,1229975,1230145,1230155,1230151,565248,256790,156091,475979,471701,253353,484407,721273,133802,142473,428926,476773,475229,1066161,1009317,1003015,1024913,338720,503906,808880,1067776,299014,298999,1230174,1230203,1230204,1230216,1230223,1230224,1230226,1179734,1230236,766133,1216524, 1230239,897298,171029,599739,246700,1007467,183957,799243,635540,1230241,552701,670002,1172501,250294,7102,237914,178661,1230179,565239,484617,97290,77471,93260,467134,820862,134269,1190629,675368,1192371,1192451,1192454,1192465,400938,1230249,24327,359134,1204463,1206085,909095,1212923,257514,236531,1230284,1230171,1224573,1194670,494085,1147286,488045,1230283,7564,15449,346026,1230306,1230332,1230333,1230334,240433,1230285,141295,18030,1214137,1214148,1230363,1214142,984764,543573,52481,609998,27324,488193,1230384,272781,849858,587968,406222,730761,132917,333513,684105,1030233,19995,1230417,1230418,1230419,1230420,429970,413578,484007,159547,733114,1230433,761464,1230439,623412,454432,557986,1230367,1228054,1230458,1230459,1155658,1155656,1187034,915634,1230478,1230479,1230483,1230488,1230489,1230494,1230504,1179229,450819,1230508,1230514,1180402,1180427,1064635,1170095,990022,1230516,1168274,114219,1230535,1229136,640423,625032,50973,821387,1230567,1230568,791563,1230594,1230597,389371,823681,508003, 424404,1230605,398436,1230607,304455,575182,692570,21,448710,1230608,1230624,1230625,257418,388371,1230642,1230644,26788,92279,977445,1059313,615772,208526,1230654,1230655,1230657,1230659,1230669,1118660,1027409,1118707,1230446,95292,1010091,1010067,1013088,771984,834747,623861,1063737,77938,1063812,771217,624279,1063604,1063897,854449,606771,1064291,1063520,1063813,681313,1071123,1070314,1063617,1063591,681449,1063676,872902,1063526,625184,730455,74211,561761,315989,962267,1230673,9289,633020,504171,752995,336619,207323,7971,1183251,435280,1226775,817736,638219,140794,1216254,1230751,243748,989969,1230771,758789,1230780,128059,181808,152868,4122,1230816,1227483,1230830,757798,1227668,1227641,872895,758590,758592,746806,759111,757742,345164,430218,325955,1230781,135730,756277,1228217,1162880,570872,1162369,1230859,1162241,1162044,1161765,1116725,1161659,157299,71615,29585,606868,498476,462500,394317,359955,513763,263930,532373,163837,133403,42116,424777,1230910,696496,745320,1057039,1056706,485427,471130, 162254,1230919,40283,731007,141490,484008,1053146,259153,119064,604638,1230934,552368,484399,100854,54861,100846,1230969,1230971,1180563,1230976,763542,823931,1230980,636245,293917,188,355319,1208175,1180280,628473,1130722,380063,1231021,59276,1194651,69553,111545,1196708,1200856,1107681,1141614,1141628,1141815,486731,557705,1141833,72373,1231031,378919,15541,107313,381595,381984,338899,336784,43576,1231086,492826,336786,486523,1231090,753275,191865,854424,37804,1231121,299642,437379,1231130,1231131,1231123,64374,353630,1231140,1231004,626252,72319,137258,1231143,1231144,1231152,231385,1231178,1231184,1231194,750580,64,741075,1003989,233714,1231216,1231218,1231206,1231215,1090828,161436,531428,156701,476720,18629,281347,1231250,476969,476649,482216,478481,478732,1028635,471087,470040,1231267,653431,240443,237,505999,526588,111262,19384,111252,111651,1231284,1231291,58053,1210445,670086,783261,7986,1231309,26135,18543,813381,1231313,285950,1166871,285954,1231317,963694,215651,422491,1231328,1231329,1231337, 1223692,314375,83705,946651,233910,386148,1231363,57855,549061,53500,83724,375210,384711,456152,945608,998934,664354,945027,945234,230649,1221436,1219577,453980,514921,677334,948774,1231372,248203,531307,1005172,853016,440465,438899,969504,1221823,568578,401125,959684,944316,1007072,1109449,1231374,788420,947761,1221957,238505,169188,1231377,702426,1223794,285653,285706,1231391,1231416,1231426,1146185,1083044,1231433,1231434,1231441,299915,1231446,207681,1231473,1231487) and cl.cl_to in ("Anbefalte_artikler");
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
.
Checking query status...