Untitled query #64023

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

SELECT DISTINCT pl_title#, COUNT(*)
FROM pagelinks
LEFT JOIN page ON 
	pl_title = page_title 
	AND pl_namespace = page_namespace
WHERE
	pl_from_namespace IN (0, 120, 146)
	AND pl_namespace IN (0, 120, 146)
	AND pl_title in ("Q15635725","Q1547041","Q1532428","Q1491577","Q1390879","Q1357409","Q12950719","Q12867818","Q12781188","Q12773271","Q12680881","Q12661083","Q12394423","Q12389033","Q123558189","Q123500043","Q123413446","Q123377485","Q123221671","Q123167232","Q123167165","Q123094806","Q123091245","Q123010652","Q122942500",
"Q12293944","Q122931238","Q122580232","Q12221567","Q122194928","Q122146677","Q121909442","Q121752964","Q121748756","Q121678621","Q121622879","Q12160502","Q121377127","Q12121141","Q12111872","Q120850320","Q120802869","Q120736906","Q120692824","Q120689492","Q120646151","Q120498364","Q120355707","Q1203247","Q12002266",
"Q11996166","Q119773792","Q11947913","Q119238659","Q119132784","Q119083267","Q118799245","Q118765666","Q118732672","Q11871197","Q118547331","Q118547330","Q118543207","Q118323432","Q11825525","Q118250020","Q11822469","Q118216917","Q11815555","Q118130471","Q118118381","Q117833690","Q117816218","Q11780398","Q117802492",
"Q117747805","Q117477549","Q11747036","Q117460238","Q117435931","Q117418489","Q117348405","Q117321324","Q117237142","Q117235037","Q117161103","Q11714344","Q11708423","Q117076018","Q117075089","Q117041854","Q11700250","Q11700020","Q116974579","Q116971826","Q116918558","Q116883115","Q116877783","Q116818440","Q116770860",
"Q116764599","Q116761975","Q116737804","Q116733124","Q116732335","Q116689861","Q116689326","Q116602982","Q116457194","Q116433069","Q116413342","Q116402067","Q116344987","Q116337267","Q116304090","Q116303651","Q116241756","Q116204876","Q116197175","Q116192976","Q116189321","Q116181793","Q116159870","Q116151263","Q116026888",
"Q116025298","Q115960103","Q115955652","Q115946474","Q115868937","Q115857259","Q115813109","Q115743484","Q115649365","Q1156425","Q115622004","Q115594696","Q115577749","Q115439032","Q115438959","Q115436627","Q115436606","Q115436577","Q115282270","Q115244736","Q115183710","Q115052593","Q115027718","Q114902861","Q114902854",
"Q114873707","Q114852990","Q114771101","Q1147169","Q11458442","Q114353387","Q114342288","Q114341107","Q114330981","Q114265803","Q114216564","Q114152142","Q114137335","Q114053629","Q114050137","Q113964211","Q1139545","Q113806110","Q113800843","Q113735817","Q113661513","Q113622243","Q113561226","Q113543597","Q113536468",
"Q113529687","Q113498363","Q11349298","Q113483507","Q113394451","Q113372640","Q113331395","Q113290769","Q113051771","Q112985934","Q112982041","Q112782116","Q112781400","Q112781383","Q112765313","Q112663968","Q112591988","Q112577646","Q112342217","Q112159626","Q112077756","Q112077627","Q111740827","Q111736685","Q111551977",
"Q111218061","Q111140054","Q111077107","Q110983424","Q110867049","Q110866973","Q110866946","Q110866829","Q110859119","Q110857400","Q110854810","Q110616496","Q110401487","Q110393904","Q110377205","Q110246600","Q110162075","Q110161944","Q110147917","Q110147698","Q110147696","Q110147500","Q110087053","Q109866949","Q109860019",
"Q109446797","Q109446092","Q109094678","Q109072075","Q109070689","Q108941358","Q108871001","Q108853526","Q108816500","Q108771787","Q108759041","Q108668800","Q108648887","Q108647265","Q108528949","Q108483471","Q108328771","Q108275949","Q108255643","Q108166568","Q107580899","Q1075481","Q10748697","Q107025315","Q106960678",
"Q106889251","Q106502210","Q106328218","Q106097490","Q10585199","Q105412517","Q10371630","Q10356911","Q10314206")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q15635725","Q1547041","Q1532428","Q1491577","Q1390879","Q1357409","Q12950719","Q12867818","Q12781188","Q12773271","Q12680881","Q12661083","Q12394423","Q12389033","Q123558189","Q123500043","Q123413446","Q123377485","Q123221671","Q123167232","Q123167165","Q123094806","Q123091245","Q123010652","Q122942500",
"Q12293944","Q122931238","Q122580232","Q12221567","Q122194928","Q122146677","Q121909442","Q121752964","Q121748756","Q121678621","Q121622879","Q12160502","Q121377127","Q12121141","Q12111872","Q120850320","Q120802869","Q120736906","Q120692824","Q120689492","Q120646151","Q120498364","Q120355707","Q1203247","Q12002266",
"Q11996166","Q119773792","Q11947913","Q119238659","Q119132784","Q119083267","Q118799245","Q118765666","Q118732672","Q11871197","Q118547331","Q118547330","Q118543207","Q118323432","Q11825525","Q118250020","Q11822469","Q118216917","Q11815555","Q118130471","Q118118381","Q117833690","Q117816218","Q11780398","Q117802492",
"Q117747805","Q117477549","Q11747036","Q117460238","Q117435931","Q117418489","Q117348405","Q117321324","Q117237142","Q117235037","Q117161103","Q11714344","Q11708423","Q117076018","Q117075089","Q117041854","Q11700250","Q11700020","Q116974579","Q116971826","Q116918558","Q116883115","Q116877783","Q116818440","Q116770860",
"Q116764599","Q116761975","Q116737804","Q116733124","Q116732335","Q116689861","Q116689326","Q116602982","Q116457194","Q116433069","Q116413342","Q116402067","Q116344987","Q116337267","Q116304090","Q116303651","Q116241756","Q116204876","Q116197175","Q116192976","Q116189321","Q116181793","Q116159870","Q116151263","Q116026888",
"Q116025298","Q115960103","Q115955652","Q115946474","Q115868937","Q115857259","Q115813109","Q115743484","Q115649365","Q1156425","Q115622004","Q115594696","Q115577749","Q115439032","Q115438959","Q115436627","Q115436606","Q115436577","Q115282270","Q115244736","Q115183710","Q115052593","Q115027718","Q114902861","Q114902854",
"Q114873707","Q114852990","Q114771101","Q1147169","Q11458442","Q114353387","Q114342288","Q114341107","Q114330981","Q114265803","Q114216564","Q114152142","Q114137335","Q114053629","Q114050137","Q113964211","Q1139545","Q113806110","Q113800843","Q113735817","Q113661513","Q113622243","Q113561226","Q113543597","Q113536468",
"Q113529687","Q113498363","Q11349298","Q113483507","Q113394451","Q113372640","Q113331395","Q113290769","Q113051771","Q112985934","Q112982041","Q112782116","Q112781400","Q112781383","Q112765313","Q112663968","Q112591988","Q112577646","Q112342217","Q112159626","Q112077756","Q112077627","Q111740827","Q111736685","Q111551977",
"Q111218061","Q111140054","Q111077107","Q110983424","Q110867049","Q110866973","Q110866946","Q110866829","Q110859119","Q110857400","Q110854810","Q110616496","Q110401487","Q110393904","Q110377205","Q110246600","Q110162075","Q110161944","Q110147917","Q110147698","Q110147696","Q110147500","Q110087053","Q109866949","Q109860019",
"Q109446797","Q109446092","Q109094678","Q109072075","Q109070689","Q108941358","Q108871001","Q108853526","Q108816500","Q108771787","Q108759041","Q108668800","Q108648887","Q108647265","Q108528949","Q108483471","Q108328771","Q108275949","Q108255643","Q108166568","Q107580899","Q1075481","Q10748697","Q107025315","Q106960678",
"Q106889251","Q106502210","Q106328218","Q106097490","Q10585199","Q105412517","Q10371630","Q10356911","Q10314206")
    )
#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...
