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

SQL

AخA
 
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 ("Q9839182","Q97360437","Q97359637","Q97197561","Q97086640","Q87830999","Q6786552","Q61128260","Q58415628","Q5236031","Q48967870","Q42936792","Q4280317","Q3337023","Q33104236","Q30943457","Q29458003","Q29442479","Q28912197","Q25679975","Q24568400","Q22918168","Q22349458","Q20882465","Q20479266",
"Q20094944","Q20094315","Q20075341","Q20057930","Q1723085","Q16824779","Q1672384","Q16398430","Q16393278","Q16290741","Q16255462","Q15867622","Q15402234","Q12166831","Q12151869","Q12094449","Q11877072","Q11762974","Q11143606","Q111012386","Q109699183","Q109483787","Q108778991","Q108730089","Q107012172",
"Q105227442","Q99299129","Q98664693","Q97086639","Q95470748","Q9272174","Q9270981","Q9270653","Q9270595","Q9270274","Q9270267","Q9270212","Q9269989","Q9269968","Q9269184","Q9269157","Q9269122","Q9269119","Q9269045","Q91915330","Q9188553","Q9007635","Q891840","Q890309","Q86598363",
"Q85883959","Q84436502","Q815643","Q809188","Q8069384","Q799923","Q799761","Q7939354","Q7924480","Q7920205","Q7915299","Q7850193","Q75208644","Q74417525","Q7410201","Q7410197","Q72977957","Q7235512","Q7101114","Q6941834","Q6933489","Q6715713","Q6695140","Q65597811","Q65236070",
"Q65127432","Q65053579","Q6456020","Q6444361","Q64009575","Q63409950","Q61751445","Q61418256","Q61116927","Q60970044","Q60835223","Q6007205","Q5992977","Q58325892","Q56887118","Q56526457","Q533906","Q529266","Q5260599","Q5221434","Q5124132","Q5065857","Q50579547","Q4969598","Q4968641",
"Q4927086","Q4904527","Q48813169","Q48550139","Q47307751","Q4668511","Q4658940","Q4516794","Q45030484","Q4495172","Q4479137","Q4467762","Q4410004","Q4396242","Q4396059","Q4391302","Q43883709","Q4331005","Q43303841","Q43294688","Q4293047","Q4291077","Q4240457","Q4153076","Q4126060",
"Q4088421","Q4087996","Q4075034","Q4068341","Q3604591","Q3579159","Q353535","Q349205","Q3475348","Q3454107","Q342118","Q3374930","Q3355175","Q33124139","Q3280582","Q3179268","Q3155468","Q30589246","Q30589173","Q303021","Q29973179","Q29631144","Q29627466","Q29623288","Q29598643",
"Q29592817","Q29466113","Q29461077","Q29448096","Q29442476","Q29421944","Q293582","Q29102304","Q29049232","Q28861929","Q28783757","Q28777133","Q28709006","Q28530223","Q28482348","Q28418642","Q28103828","Q28016641","Q27922386","Q27827202","Q27546546","Q26944169","Q2634255","Q25451981","Q25360576",
"Q2474936","Q24239617","Q23672320","Q23638197","Q2344090","Q22947608","Q2242205","Q22204488","Q22198658","Q22198249","Q22191681","Q22175201","Q22156167","Q2178169","Q21617427","Q21611355","Q21582171","Q2145901","Q2144603","Q2132681","Q20980675","Q20967307","Q20758414","Q20661437","Q20532005",
"Q20074317","Q19697798","Q1910732","Q18630040","Q1806917","Q1763974","Q17521180","Q1749001","Q17483992","Q16881862","Q16775363","Q1676389","Q16694596","Q16686527","Q1658499","Q16576878","Q16455183","Q16372723","Q16295801","Q16140447","Q15946622","Q15874580","Q15847072","Q15825566","Q15789245"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q9839182","Q97360437","Q97359637","Q97197561","Q97086640","Q87830999","Q6786552","Q61128260","Q58415628","Q5236031","Q48967870","Q42936792","Q4280317","Q3337023","Q33104236","Q30943457","Q29458003","Q29442479","Q28912197","Q25679975","Q24568400","Q22918168","Q22349458","Q20882465","Q20479266",
"Q20094944","Q20094315","Q20075341","Q20057930","Q1723085","Q16824779","Q1672384","Q16398430","Q16393278","Q16290741","Q16255462","Q15867622","Q15402234","Q12166831","Q12151869","Q12094449","Q11877072","Q11762974","Q11143606","Q111012386","Q109699183","Q109483787","Q108778991","Q108730089","Q107012172",
"Q105227442","Q99299129","Q98664693","Q97086639","Q95470748","Q9272174","Q9270981","Q9270653","Q9270595","Q9270274","Q9270267","Q9270212","Q9269989","Q9269968","Q9269184","Q9269157","Q9269122","Q9269119","Q9269045","Q91915330","Q9188553","Q9007635","Q891840","Q890309","Q86598363",
"Q85883959","Q84436502","Q815643","Q809188","Q8069384","Q799923","Q799761","Q7939354","Q7924480","Q7920205","Q7915299","Q7850193","Q75208644","Q74417525","Q7410201","Q7410197","Q72977957","Q7235512","Q7101114","Q6941834","Q6933489","Q6715713","Q6695140","Q65597811","Q65236070",
"Q65127432","Q65053579","Q6456020","Q6444361","Q64009575","Q63409950","Q61751445","Q61418256","Q61116927","Q60970044","Q60835223","Q6007205","Q5992977","Q58325892","Q56887118","Q56526457","Q533906","Q529266","Q5260599","Q5221434","Q5124132","Q5065857","Q50579547","Q4969598","Q4968641",
"Q4927086","Q4904527","Q48813169","Q48550139","Q47307751","Q4668511","Q4658940","Q4516794","Q45030484","Q4495172","Q4479137","Q4467762","Q4410004","Q4396242","Q4396059","Q4391302","Q43883709","Q4331005","Q43303841","Q43294688","Q4293047","Q4291077","Q4240457","Q4153076","Q4126060",
"Q4088421","Q4087996","Q4075034","Q4068341","Q3604591","Q3579159","Q353535","Q349205","Q3475348","Q3454107","Q342118","Q3374930","Q3355175","Q33124139","Q3280582","Q3179268","Q3155468","Q30589246","Q30589173","Q303021","Q29973179","Q29631144","Q29627466","Q29623288","Q29598643",
"Q29592817","Q29466113","Q29461077","Q29448096","Q29442476","Q29421944","Q293582","Q29102304","Q29049232","Q28861929","Q28783757","Q28777133","Q28709006","Q28530223","Q28482348","Q28418642","Q28103828","Q28016641","Q27922386","Q27827202","Q27546546","Q26944169","Q2634255","Q25451981","Q25360576",
"Q2474936","Q24239617","Q23672320","Q23638197","Q2344090","Q22947608","Q2242205","Q22204488","Q22198658","Q22198249","Q22191681","Q22175201","Q22156167","Q2178169","Q21617427","Q21611355","Q21582171","Q2145901","Q2144603","Q2132681","Q20980675","Q20967307","Q20758414","Q20661437","Q20532005",
"Q20074317","Q19697798","Q1910732","Q18630040","Q1806917","Q1763974","Q17521180","Q1749001","Q17483992","Q16881862","Q16775363","Q1676389","Q16694596","Q16686527","Q1658499","Q16576878","Q16455183","Q16372723","Q16295801","Q16140447","Q15946622","Q15874580","Q15847072","Q15825566","Q15789245"
)
    )
#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
All SQL code is licensed under CC0 License.

Checking query status...