Untitled query #64023

This query is marked as a draft This query has been published by Mahir256.
SQL

SELECT DISTINCT lt_title#, COUNT(*)
FROM pagelinks
LEFT JOIN linktarget ON pl_target_id = lt_id
WHERE
	pl_from_namespace IN (0, 120, 146)
	AND lt_namespace IN (0, 120, 146)
	AND lt_title in ("Q1017932","Q1043591","Q1275298","Q1304944","Q1311901","Q1669358","Q1693387","Q1778264","Q1844857","Q1906640","Q1933636","Q1940802","Q1959879","Q2004175","Q2010848","Q2017120","Q2050031","Q2052672","Q2077120","Q2126302","Q2171837","Q2095135","Q2151654","Q2155882","Q2159829",
"Q2160829","Q2162032","Q2166910","Q2177521","Q2178343","Q2180018","Q2186408","Q2194246","Q2196708","Q2198010","Q2207924","Q2240110","Q2286584","Q2269368","Q2270862","Q2272729","Q2272856","Q2300551","Q2302227","Q2326593","Q2336207","Q2358077","Q2361386","Q2372201","Q2399935",
"Q2401124","Q2404860","Q2489679","Q2498748","Q2513156","Q2520000","Q2546701","Q2566464","Q2596925","Q2599106","Q2608544","Q2666991","Q2682527","Q2683312","Q2787502","Q2789494","Q2802605","Q2838663","Q2846914","Q2876590","Q2916004","Q2995617","Q3035344","Q2949341","Q3139228",
"Q3269561","Q3722302","Q4005089","Q4048054","Q4272638","Q4319454","Q4441778","Q4458980","Q4855974","Q4988794","Q5157608","Q5446842","Q5563992","Q6037520","Q6697650","Q7046029","Q7125022","Q7226562","Q7338700","Q7523738","Q7499525","Q7442944","Q7672556","Q7742296",
"Q7746688","Q7714757","Q7643392","Q7902572","Q7987838","Q8075581","Q8077862","Q8084088","Q8196991","Q8770091","Q9128354","Q9097765","Q9231038","Q9285905","Q9325320","Q10352086","Q10380953","Q10497399","Q10504195","Q10510835","Q10513866","Q10523725","Q10655186","Q10682843","Q10877437",
"Q10909809","Q10957686","Q11079563","Q11167116","Q11257302","Q11340056","Q11351753","Q11418944","Q11451974","Q11555757","Q11673416","Q11722912","Q11742297","Q11736667","Q11790193","Q11835645","Q12030849","Q12042876","Q12088080","Q12089754","Q12194944","Q12338758","Q12341901","Q12344003",
"Q12399090","Q12600664","Q12595984","Q12765597","Q12861604","Q12809017","Q12961262","Q12965696","Q12994180","Q13059355","Q13425752","Q13631350","Q13571352","Q13571655","Q13459038","Q13468304","Q13510944","Q13222278","Q13731443","Q13731450","Q13744302","Q13873722","Q14253944","Q14517897","Q14525523",
"Q14626302","Q14777885","Q14957199","Q15687071","Q15690768","Q15302844","Q15785054","Q15788536","Q15792556","Q15804841","Q15837691","Q15849834","Q15849128","Q15875460","Q15889962","Q15893822","Q15894296","Q15906960","Q16036585","Q16054075","Q16084720","Q16237480","Q16249821","Q16278379",
"Q16275311","Q16317731","Q16291977","Q16348990","Q16445474","Q16643773","Q16644103","Q16652804","Q16664293","Q16627242","Q16677613","Q16723330","Q16768240","Q16774909","Q16798601","Q16799563","Q16820232","Q16832576","Q16864942","Q16874447","Q16867810","Q16867925","Q16946900","Q16963729",
"Q17098003","Q17127977","Q17331169","Q17481128","Q17504154","Q17521928","Q17591655","Q17996013","Q18026922","Q18211523","Q18064958","Q18142467","Q18326730","Q18375090","Q18384825","Q18411683","Q18520161","Q18577314","Q18616668","Q18626081","Q18890232","Q18924132","Q18757920","Q19296096","Q19024285",
"Q19024995","Q19106707","Q19796115","Q19816450","Q19697779","Q19919224","Q19920195","Q20037867","Q20111439","Q20094821","Q20202939","Q20380928","Q20433994","Q20469972","Q20470024","Q20470223","Q20688362","Q20753713","Q20758698","Q20772776","Q20968434","Q20996407","Q21079569","Q21096776","Q21096822",
"Q21178664","Q21198474","Q21605483","Q21500683","Q21531947","Q22143324","Q22156375","Q22174581","Q22183978","Q22225223","Q22226258","Q22227045","Q22666931","Q22349404","Q22704907","Q22941480","Q22945430","Q22829722","Q23049129","Q23541679","Q23541973","Q23636084","Q23668222",
"Q23670230","Q23671833","Q23674443","Q23996870","Q24193589","Q24207396","Q24209748","Q24216511","Q24704810","Q24737283","Q25432636","Q25193852","Q25194076","Q25194375","Q25194417","Q25194422","Q25194443","Q25194470","Q25469058","Q25469261","Q25435619","Q25491511","Q26269089","Q26308751","Q26703363",
"Q26905794","Q26938735","Q27574083","Q27796291","Q27839134","Q27951548","Q27951874","Q27875864","Q28023789","Q28004870","Q28048242","Q28415392","Q28340931","Q28148245","Q28336310","Q28698940","Q28692722","Q28696371","Q28770204","Q28597552","Q28609295","Q28923215","Q28947650",
"Q28963851","Q28964176","Q28966788","Q29021145","Q29043138","Q29078868","Q29080269","Q29081993","Q29351066","Q29367561","Q29390412","Q29399020","Q29400312","Q29424191","Q29432456","Q29537172","Q29589952","Q29589958","Q29590935","Q29591190","Q29591575","Q29592152","Q29592324","Q29592550","Q29592664",
"Q29593376","Q29594689","Q29595236","Q29596357","Q29620839","Q29620853","Q29622612","Q29684036","Q29960623","Q29981187","Q29981311","Q29980287","Q29980636","Q29980898","Q30098309","Q30323948","Q31086803","Q30702221","Q31306575","Q31792059","Q33082894","Q33108264","Q33133575","Q33496216","Q34628511",
"Q36472352","Q36581025","Q39165394","Q42173175","Q42298058","Q41500286","Q41176642","Q42403289","Q42439513","Q42884640","Q42580865","Q43041523","Q43132330","Q47008188","Q47087036","Q47537545","Q47537591","Q48688655","Q48977815","Q47814906","Q50023983","Q50242474","Q50246389","Q50309120","Q50818366",
"Q51480210","Q52092047","Q52094448","Q52762992","Q55129639","Q54802555","Q54865457","Q54867775","Q55197848","Q55197862","Q55688665","Q55691483","Q55698214","Q55586588","Q55643720","Q55403311","Q56280825","Q56244438","Q56370258","Q55873090","Q55905142","Q56478538","Q57416797","Q57653709","Q58410894",
"Q58871122","Q59772379","Q60010789","Q60153987","Q60426290","Q60717781","Q60485731","Q61129985","Q61423175","Q61427405","Q61427699","Q61427944","Q61428338","Q61429781","Q61432245","Q61672249","Q61719510","Q62056435","Q61998408","Q62128546","Q62336095","Q62521774","Q63109171","Q63226297","Q63649850",
"Q63994370","Q64415259","Q64737986","Q64866086","Q64877350","Q64929236","Q65132810","Q65248323","Q65271377","Q65620235","Q65724725","Q65766384","Q65968971","Q66023589","Q66092249","Q66132998","Q66619352","Q67205573","Q67638383","Q68186370","Q68966631","Q69631341","Q73364501","Q75101720","Q80009023",
"Q80009151","Q80009536","Q78569122","Q79326458","Q78193631","Q83162825","Q84412693","Q88930502","Q90884163","Q92767874","Q91023145","Q92781167","Q93930221","Q95979180","Q94997181","Q97206542","Q97216504","Q97219684","Q97575323","Q98077828","Q98209552","Q98637299","Q99399810","Q99752009","Q99754698",
"Q100323548","Q101036268","Q100368846","Q101419202","Q101786553","Q102050214","Q102078587","Q102355943","Q104527179","Q104545984","Q103829333","Q104005273","Q104029675","Q104776504","Q104831622","Q104835308","Q104907371","Q105108941","Q105336848","Q105378152","Q105550799","Q105672507","Q105689507","Q105710190","Q106269245",
"Q106636155","Q106647933","Q106676860","Q106691059","Q106704999","Q106713964","Q106824791","Q106898605","Q106947939","Q106967511","Q106979090","Q107290544","Q107132363","Q107341734","Q107358488","Q107399068","Q107986572","Q107494581","Q108036778","Q107567354","Q107583886","Q107749356","Q108631006","Q108876377",
"Q109074569","Q109085942","Q109097382","Q109381926","Q109417704","Q109626777","Q110110308","Q110147515","Q110147544","Q110147557","Q110147563","Q110147581","Q110147654","Q110147659","Q110147694","Q110147723","Q110147824","Q110147828","Q110147857","Q110161601","Q109994834","Q110729588","Q110780113",
"Q110857368","Q110859095","Q110859214","Q110859625","Q110859646","Q110865059","Q110866941","Q111134306","Q111285683","Q111419944","Q111627323","Q111649719","Q112084754","Q112115053","Q112168663","Q112184917","Q111943789","Q112580470","Q112981670","Q113498103","Q113445185","Q113231092","Q113260897","Q113325095","Q113502861",
"Q113615895","Q113665286","Q113827875","Q114353383","Q114158881","Q114362198","Q114450347","Q114609887","Q115108250","Q115175506","Q115346933","Q115437945","Q115791140","Q115940712","Q115973863","Q116025034","Q116060627","Q116353261","Q116468662","Q116479290","Q116735734","Q116766173","Q116709389","Q116838101","Q116948277",
"Q116985617","Q117310054","Q117439296","Q117440056","Q117471754","Q117800647","Q118146904","Q118162522","Q117814965","Q118440586","Q119359419","Q118645463","Q118898839","Q118898847","Q118930241","Q118953718","Q119004626","Q120197687","Q120329208","Q121010090","Q121078399","Q121136397","Q121159187","Q121304630","Q121356007",
"Q121412890","Q121422749","Q121783712","Q121889906","Q122222281","Q122231438","Q122681674","Q122754042","Q122978958","Q123376269","Q123377902","Q123407552","Q123407603","Q123412991","Q123196773","Q123250611","Q123296260","Q124020956","Q123509840","Q123556043","Q123584076","Q123631163","Q123982527","Q123746203","Q123786744",
"Q123819167","Q123822322","Q123865330","Q124372985","Q124049725","Q124102110","Q124102135","Q124150201","Q124151351","Q124250762","Q124259710","Q124260157","Q124336760","Q124399146","Q124414541","Q124422548","Q124458427","Q124651379","Q124468655","Q124477381","Q124498839","Q124666114","Q124731721","Q124760635","Q124765549",
"Q124765828","Q124766066","Q124766117","Q124766131","Q124766158","Q124766238","Q124766272","Q124766317","Q124766348","Q124766369","Q124766378","Q124766382","Q124766641","Q124766747","Q124792147","Q125210497","Q125211240","Q125000548","Q125096310","Q124815423","Q124843655","Q124844014","Q124846447","Q124846448","Q124846449",
"Q124846450","Q125405986","Q125470610","Q125676238","Q126229533","Q125728671","Q125732846","Q125919563","Q126364853","Q126369529","Q126493905","Q126554904","Q125926017","Q126047142","Q126107434","Q126683244","Q126710310","Q127601099","Q127231509","Q127261095"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q1017932","Q1043591","Q1275298","Q1304944","Q1311901","Q1669358","Q1693387","Q1778264","Q1844857","Q1906640","Q1933636","Q1940802","Q1959879","Q2004175","Q2010848","Q2017120","Q2050031","Q2052672","Q2077120","Q2126302","Q2171837","Q2095135","Q2151654","Q2155882","Q2159829",
"Q2160829","Q2162032","Q2166910","Q2177521","Q2178343","Q2180018","Q2186408","Q2194246","Q2196708","Q2198010","Q2207924","Q2240110","Q2286584","Q2269368","Q2270862","Q2272729","Q2272856","Q2300551","Q2302227","Q2326593","Q2336207","Q2358077","Q2361386","Q2372201","Q2399935",
"Q2401124","Q2404860","Q2489679","Q2498748","Q2513156","Q2520000","Q2546701","Q2566464","Q2596925","Q2599106","Q2608544","Q2666991","Q2682527","Q2683312","Q2787502","Q2789494","Q2802605","Q2838663","Q2846914","Q2876590","Q2916004","Q2995617","Q3035344","Q2949341","Q3139228",
"Q3269561","Q3722302","Q4005089","Q4048054","Q4272638","Q4319454","Q4441778","Q4458980","Q4855974","Q4988794","Q5157608","Q5446842","Q5563992","Q6037520","Q6697650","Q7046029","Q7125022","Q7226562","Q7338700","Q7523738","Q7499525","Q7442944","Q7672556","Q7742296",
"Q7746688","Q7714757","Q7643392","Q7902572","Q7987838","Q8075581","Q8077862","Q8084088","Q8196991","Q8770091","Q9128354","Q9097765","Q9231038","Q9285905","Q9325320","Q10352086","Q10380953","Q10497399","Q10504195","Q10510835","Q10513866","Q10523725","Q10655186","Q10682843","Q10877437",
"Q10909809","Q10957686","Q11079563","Q11167116","Q11257302","Q11340056","Q11351753","Q11418944","Q11451974","Q11555757","Q11673416","Q11722912","Q11742297","Q11736667","Q11790193","Q11835645","Q12030849","Q12042876","Q12088080","Q12089754","Q12194944","Q12338758","Q12341901","Q12344003",
"Q12399090","Q12600664","Q12595984","Q12765597","Q12861604","Q12809017","Q12961262","Q12965696","Q12994180","Q13059355","Q13425752","Q13631350","Q13571352","Q13571655","Q13459038","Q13468304","Q13510944","Q13222278","Q13731443","Q13731450","Q13744302","Q13873722","Q14253944","Q14517897","Q14525523",
"Q14626302","Q14777885","Q14957199","Q15687071","Q15690768","Q15302844","Q15785054","Q15788536","Q15792556","Q15804841","Q15837691","Q15849834","Q15849128","Q15875460","Q15889962","Q15893822","Q15894296","Q15906960","Q16036585","Q16054075","Q16084720","Q16237480","Q16249821","Q16278379",
"Q16275311","Q16317731","Q16291977","Q16348990","Q16445474","Q16643773","Q16644103","Q16652804","Q16664293","Q16627242","Q16677613","Q16723330","Q16768240","Q16774909","Q16798601","Q16799563","Q16820232","Q16832576","Q16864942","Q16874447","Q16867810","Q16867925","Q16946900","Q16963729",
"Q17098003","Q17127977","Q17331169","Q17481128","Q17504154","Q17521928","Q17591655","Q17996013","Q18026922","Q18211523","Q18064958","Q18142467","Q18326730","Q18375090","Q18384825","Q18411683","Q18520161","Q18577314","Q18616668","Q18626081","Q18890232","Q18924132","Q18757920","Q19296096","Q19024285",
"Q19024995","Q19106707","Q19796115","Q19816450","Q19697779","Q19919224","Q19920195","Q20037867","Q20111439","Q20094821","Q20202939","Q20380928","Q20433994","Q20469972","Q20470024","Q20470223","Q20688362","Q20753713","Q20758698","Q20772776","Q20968434","Q20996407","Q21079569","Q21096776","Q21096822",
"Q21178664","Q21198474","Q21605483","Q21500683","Q21531947","Q22143324","Q22156375","Q22174581","Q22183978","Q22225223","Q22226258","Q22227045","Q22666931","Q22349404","Q22704907","Q22941480","Q22945430","Q22829722","Q23049129","Q23541679","Q23541973","Q23636084","Q23668222",
"Q23670230","Q23671833","Q23674443","Q23996870","Q24193589","Q24207396","Q24209748","Q24216511","Q24704810","Q24737283","Q25432636","Q25193852","Q25194076","Q25194375","Q25194417","Q25194422","Q25194443","Q25194470","Q25469058","Q25469261","Q25435619","Q25491511","Q26269089","Q26308751","Q26703363",
"Q26905794","Q26938735","Q27574083","Q27796291","Q27839134","Q27951548","Q27951874","Q27875864","Q28023789","Q28004870","Q28048242","Q28415392","Q28340931","Q28148245","Q28336310","Q28698940","Q28692722","Q28696371","Q28770204","Q28597552","Q28609295","Q28923215","Q28947650",
"Q28963851","Q28964176","Q28966788","Q29021145","Q29043138","Q29078868","Q29080269","Q29081993","Q29351066","Q29367561","Q29390412","Q29399020","Q29400312","Q29424191","Q29432456","Q29537172","Q29589952","Q29589958","Q29590935","Q29591190","Q29591575","Q29592152","Q29592324","Q29592550","Q29592664",
"Q29593376","Q29594689","Q29595236","Q29596357","Q29620839","Q29620853","Q29622612","Q29684036","Q29960623","Q29981187","Q29981311","Q29980287","Q29980636","Q29980898","Q30098309","Q30323948","Q31086803","Q30702221","Q31306575","Q31792059","Q33082894","Q33108264","Q33133575","Q33496216","Q34628511",
"Q36472352","Q36581025","Q39165394","Q42173175","Q42298058","Q41500286","Q41176642","Q42403289","Q42439513","Q42884640","Q42580865","Q43041523","Q43132330","Q47008188","Q47087036","Q47537545","Q47537591","Q48688655","Q48977815","Q47814906","Q50023983","Q50242474","Q50246389","Q50309120","Q50818366",
"Q51480210","Q52092047","Q52094448","Q52762992","Q55129639","Q54802555","Q54865457","Q54867775","Q55197848","Q55197862","Q55688665","Q55691483","Q55698214","Q55586588","Q55643720","Q55403311","Q56280825","Q56244438","Q56370258","Q55873090","Q55905142","Q56478538","Q57416797","Q57653709","Q58410894",
"Q58871122","Q59772379","Q60010789","Q60153987","Q60426290","Q60717781","Q60485731","Q61129985","Q61423175","Q61427405","Q61427699","Q61427944","Q61428338","Q61429781","Q61432245","Q61672249","Q61719510","Q62056435","Q61998408","Q62128546","Q62336095","Q62521774","Q63109171","Q63226297","Q63649850",
"Q63994370","Q64415259","Q64737986","Q64866086","Q64877350","Q64929236","Q65132810","Q65248323","Q65271377","Q65620235","Q65724725","Q65766384","Q65968971","Q66023589","Q66092249","Q66132998","Q66619352","Q67205573","Q67638383","Q68186370","Q68966631","Q69631341","Q73364501","Q75101720","Q80009023",
"Q80009151","Q80009536","Q78569122","Q79326458","Q78193631","Q83162825","Q84412693","Q88930502","Q90884163","Q92767874","Q91023145","Q92781167","Q93930221","Q95979180","Q94997181","Q97206542","Q97216504","Q97219684","Q97575323","Q98077828","Q98209552","Q98637299","Q99399810","Q99752009","Q99754698",
"Q100323548","Q101036268","Q100368846","Q101419202","Q101786553","Q102050214","Q102078587","Q102355943","Q104527179","Q104545984","Q103829333","Q104005273","Q104029675","Q104776504","Q104831622","Q104835308","Q104907371","Q105108941","Q105336848","Q105378152","Q105550799","Q105672507","Q105689507","Q105710190","Q106269245",
"Q106636155","Q106647933","Q106676860","Q106691059","Q106704999","Q106713964","Q106824791","Q106898605","Q106947939","Q106967511","Q106979090","Q107290544","Q107132363","Q107341734","Q107358488","Q107399068","Q107986572","Q107494581","Q108036778","Q107567354","Q107583886","Q107749356","Q108631006","Q108876377",
"Q109074569","Q109085942","Q109097382","Q109381926","Q109417704","Q109626777","Q110110308","Q110147515","Q110147544","Q110147557","Q110147563","Q110147581","Q110147654","Q110147659","Q110147694","Q110147723","Q110147824","Q110147828","Q110147857","Q110161601","Q109994834","Q110729588","Q110780113",
"Q110857368","Q110859095","Q110859214","Q110859625","Q110859646","Q110865059","Q110866941","Q111134306","Q111285683","Q111419944","Q111627323","Q111649719","Q112084754","Q112115053","Q112168663","Q112184917","Q111943789","Q112580470","Q112981670","Q113498103","Q113445185","Q113231092","Q113260897","Q113325095","Q113502861",
"Q113615895","Q113665286","Q113827875","Q114353383","Q114158881","Q114362198","Q114450347","Q114609887","Q115108250","Q115175506","Q115346933","Q115437945","Q115791140","Q115940712","Q115973863","Q116025034","Q116060627","Q116353261","Q116468662","Q116479290","Q116735734","Q116766173","Q116709389","Q116838101","Q116948277",
"Q116985617","Q117310054","Q117439296","Q117440056","Q117471754","Q117800647","Q118146904","Q118162522","Q117814965","Q118440586","Q119359419","Q118645463","Q118898839","Q118898847","Q118930241","Q118953718","Q119004626","Q120197687","Q120329208","Q121010090","Q121078399","Q121136397","Q121159187","Q121304630","Q121356007",
"Q121412890","Q121422749","Q121783712","Q121889906","Q122222281","Q122231438","Q122681674","Q122754042","Q122978958","Q123376269","Q123377902","Q123407552","Q123407603","Q123412991","Q123196773","Q123250611","Q123296260","Q124020956","Q123509840","Q123556043","Q123584076","Q123631163","Q123982527","Q123746203","Q123786744",
"Q123819167","Q123822322","Q123865330","Q124372985","Q124049725","Q124102110","Q124102135","Q124150201","Q124151351","Q124250762","Q124259710","Q124260157","Q124336760","Q124399146","Q124414541","Q124422548","Q124458427","Q124651379","Q124468655","Q124477381","Q124498839","Q124666114","Q124731721","Q124760635","Q124765549",
"Q124765828","Q124766066","Q124766117","Q124766131","Q124766158","Q124766238","Q124766272","Q124766317","Q124766348","Q124766369","Q124766378","Q124766382","Q124766641","Q124766747","Q124792147","Q125210497","Q125211240","Q125000548","Q125096310","Q124815423","Q124843655","Q124844014","Q124846447","Q124846448","Q124846449",
"Q124846450","Q125405986","Q125470610","Q125676238","Q126229533","Q125728671","Q125732846","Q125919563","Q126364853","Q126369529","Q126493905","Q126554904","Q125926017","Q126047142","Q126107434","Q126683244","Q126710310","Q127601099","Q127231509","Q127261095"
)
    )
#GROUP BY pl_title
#ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
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...
