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 ("Q10036078","Q10160540","Q10249969","Q10750504","Q109901823","Q113949988","Q117275836","Q117328172","Q13305230","Q13305237","Q16771289","Q17121933","Q18749885","Q24867176","Q26259762","Q26762844","Q29647996","Q30814553","Q30814577","Q31064372","Q32240421","Q32363041","Q32622101","Q32697687","Q32725618",
"Q32755046","Q32755049","Q32903205","Q32903257","Q32905113","Q33026039","Q33047811","Q47495279","Q49656257","Q50824189","Q55977005","Q61371928","Q65654972","Q65733820","Q65735380","Q8313093","Q86308565","Q9610444","Q9892907","Q9897145","Q9920203","Q9941158","Q6220547","Q6282812","Q6289222",
"Q6355238","Q7196069","Q7765000","Q7810373","Q7833706","Q7876728","Q7877070","Q7920021","Q7922864","Q8121595","Q8133755","Q8181984","Q8248581","Q8286387","Q8294984","Q8306971","Q8313332","Q8337428","Q8463116","Q8463118","Q8463119","Q8463120","Q8463121","Q8463126","Q8468424",
"Q8476289","Q8476297","Q8476306","Q8476307","Q8476328","Q8476329","Q8476333","Q8476342","Q8476346","Q8476356","Q8476365","Q8476367","Q8543308","Q8544474","Q8544475","Q8596272","Q8603755","Q8633933","Q8636729","Q8661998","Q8668385","Q8668400","Q8670368","Q8670369","Q8670371",
"Q8670372","Q8670373","Q8670375","Q8670376","Q8670380","Q8670381","Q8670383","Q8670386","Q8670387","Q8670390","Q8670394","Q8670397","Q8670399","Q8670400","Q8670402","Q8670404","Q8670406","Q8670407","Q8670409","Q8670410","Q8670411","Q8670412","Q8670414","Q8670415","Q8670417",
"Q8670418","Q8670420","Q8670424","Q8670426","Q8670428","Q8670430","Q8670432","Q8670434","Q8670435","Q8670437","Q8670439","Q8670441","Q8670443","Q8670445","Q8670447","Q8670449","Q8670452","Q8670454","Q8670458","Q8670460","Q8670462","Q8670464","Q8670469","Q8670475","Q8690708",
"Q8705857","Q8713106","Q8724114","Q8804268","Q8808073","Q8816492","Q8885362","Q8925990","Q8948140","Q9061151","Q9073148","Q9148038","Q9240600","Q9241732","Q9317110","Q9317268","Q9443605","Q9443610","Q9443628","Q9443678","Q9443714","Q9448653","Q9449298","Q9456226","Q9462342",
"Q9480011","Q9481297","Q9486729","Q9527388","Q9527430","Q9564624","Q9565822","Q9584981","Q9586842","Q9587873","Q9596903","Q9599261","Q9602667","Q9602713","Q9618206","Q9625405","Q9652379","Q9684178","Q9695845","Q9697779","Q9697816","Q9706225","Q9712619","Q9713371","Q9722873",
"Q9723188","Q9725265","Q9727327","Q9755853","Q9774781","Q9794827","Q9801251","Q9801903","Q9815646","Q9825309","Q9825378","Q9825745","Q9826252","Q9826898","Q9864547","Q9868103","Q9871281","Q9936008","Q9937027","Q9941426","Q9941694","Q9945826","Q9957277","Q9998444","Q10024968",
"Q10050798","Q10055196","Q10069548","Q10092095","Q10100696","Q10118898","Q10127664","Q10128977","Q10130924","Q10131871","Q10150222","Q10182798","Q10192484","Q10213675","Q10248240","Q10255714","Q10786118","Q10813662","Q12142133","Q13236494","Q13265540","Q13276341","Q13276343","Q13276344","Q13276345"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10036078","Q10160540","Q10249969","Q10750504","Q109901823","Q113949988","Q117275836","Q117328172","Q13305230","Q13305237","Q16771289","Q17121933","Q18749885","Q24867176","Q26259762","Q26762844","Q29647996","Q30814553","Q30814577","Q31064372","Q32240421","Q32363041","Q32622101","Q32697687","Q32725618",
"Q32755046","Q32755049","Q32903205","Q32903257","Q32905113","Q33026039","Q33047811","Q47495279","Q49656257","Q50824189","Q55977005","Q61371928","Q65654972","Q65733820","Q65735380","Q8313093","Q86308565","Q9610444","Q9892907","Q9897145","Q9920203","Q9941158","Q6220547","Q6282812","Q6289222",
"Q6355238","Q7196069","Q7765000","Q7810373","Q7833706","Q7876728","Q7877070","Q7920021","Q7922864","Q8121595","Q8133755","Q8181984","Q8248581","Q8286387","Q8294984","Q8306971","Q8313332","Q8337428","Q8463116","Q8463118","Q8463119","Q8463120","Q8463121","Q8463126","Q8468424",
"Q8476289","Q8476297","Q8476306","Q8476307","Q8476328","Q8476329","Q8476333","Q8476342","Q8476346","Q8476356","Q8476365","Q8476367","Q8543308","Q8544474","Q8544475","Q8596272","Q8603755","Q8633933","Q8636729","Q8661998","Q8668385","Q8668400","Q8670368","Q8670369","Q8670371",
"Q8670372","Q8670373","Q8670375","Q8670376","Q8670380","Q8670381","Q8670383","Q8670386","Q8670387","Q8670390","Q8670394","Q8670397","Q8670399","Q8670400","Q8670402","Q8670404","Q8670406","Q8670407","Q8670409","Q8670410","Q8670411","Q8670412","Q8670414","Q8670415","Q8670417",
"Q8670418","Q8670420","Q8670424","Q8670426","Q8670428","Q8670430","Q8670432","Q8670434","Q8670435","Q8670437","Q8670439","Q8670441","Q8670443","Q8670445","Q8670447","Q8670449","Q8670452","Q8670454","Q8670458","Q8670460","Q8670462","Q8670464","Q8670469","Q8670475","Q8690708",
"Q8705857","Q8713106","Q8724114","Q8804268","Q8808073","Q8816492","Q8885362","Q8925990","Q8948140","Q9061151","Q9073148","Q9148038","Q9240600","Q9241732","Q9317110","Q9317268","Q9443605","Q9443610","Q9443628","Q9443678","Q9443714","Q9448653","Q9449298","Q9456226","Q9462342",
"Q9480011","Q9481297","Q9486729","Q9527388","Q9527430","Q9564624","Q9565822","Q9584981","Q9586842","Q9587873","Q9596903","Q9599261","Q9602667","Q9602713","Q9618206","Q9625405","Q9652379","Q9684178","Q9695845","Q9697779","Q9697816","Q9706225","Q9712619","Q9713371","Q9722873",
"Q9723188","Q9725265","Q9727327","Q9755853","Q9774781","Q9794827","Q9801251","Q9801903","Q9815646","Q9825309","Q9825378","Q9825745","Q9826252","Q9826898","Q9864547","Q9868103","Q9871281","Q9936008","Q9937027","Q9941426","Q9941694","Q9945826","Q9957277","Q9998444","Q10024968",
"Q10050798","Q10055196","Q10069548","Q10092095","Q10100696","Q10118898","Q10127664","Q10128977","Q10130924","Q10131871","Q10150222","Q10182798","Q10192484","Q10213675","Q10248240","Q10255714","Q10786118","Q10813662","Q12142133","Q13236494","Q13265540","Q13276341","Q13276343","Q13276344","Q13276345"
)
    )
#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...
