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 ("Q100680964","Q10078841","Q100804839","Q10150200","Q102824987","Q104246513","Q104532031","Q104551205","Q104551749","Q104552103","Q104552184","Q104552337","Q104552704","Q104580380","Q104582871","Q104587406","Q104597230","Q104597441","Q104628795","Q104892806","Q105011380","Q105070796","Q105091545","Q105299397","Q105410205","Q105489077","Q105631900","Q105808561","Q105967805","Q106327046","Q106471883","Q106642125","Q106680512","Q106875550","Q107114470","Q107213004","Q107308304","Q107404818","Q107431392","Q107713954","Q107717835","Q107749158","Q107782266","Q108122423","Q108167168","Q108287917","Q108384155","Q108853259","Q109145845","Q109145846","Q109145847","Q109145848","Q109145849","Q109444106","Q109499442","Q109499480","Q109558147","Q109558160","Q109569074","Q109588478","Q109651131","Q109707187","Q109710370","Q109710481","Q109710558","Q109710657","Q109710815","Q109710845","Q109874623","Q109911284","Q109928802","Q109968703","Q110059679","Q110072329","Q110253241","Q110343302","Q110655880","Q110665723","Q110897980","Q110898012","Q111201092","Q111204475","Q111293164","Q111307126","Q111333808","Q111333826","Q111497932","Q111655297","Q111738281","Q111807470","Q111861005","Q111879392","Q111883048","Q111883050","Q111883052","Q111969421","Q112055152","Q112605687","Q112686821","Q112730296","Q112731101","Q112865553","Q113023451","Q113115930","Q113137356","Q113205550","Q113205699","Q113205813","Q113205864","Q113242919","Q113243148","Q113362669","Q113482059","Q113572604","Q113579121","Q113886681","Q114702692","Q114809934","Q13328576","Q13338109","Q13338110","Q13346470","Q14420528","Q14420547","Q15291867","Q16661074","Q16914701","Q17497542","Q17497559","Q17497562","Q17497588","Q17497591","Q17497593","Q18090204","Q18656319","Q18656669","Q18664703","Q18666069","Q18753891","Q18758853","Q18761624","Q18857704","Q19337301","Q21521194","Q21798188","Q21823251","Q24231476","Q25127983","Q25330942","Q25710885","Q25936795","Q25974323","Q26268501","Q27160595","Q27312724","Q27312733","Q27334987","Q27906885","Q27906886","Q28790527","Q29223594","Q29647651","Q30967058","Q31870679","Q31875355","Q31875376","Q31875392","Q31875406","Q31875416","Q31875439","Q31875490","Q31875492","Q31875498","Q31875516","Q31875518","Q31875525","Q31875547","Q31875565","Q31875576","Q31875582","Q31875625","Q31875648","Q32002645","Q32028311","Q32029412","Q32086671","Q32107599","Q32115668","Q32117665","Q32168980","Q32189589","Q32196231","Q32219382","Q32225525","Q32225529","Q32225595","Q32231034","Q32232982","Q32253979","Q32256846","Q32262003","Q32262008","Q32271123","Q32277927","Q32289248","Q32310804","Q32379889","Q32394386","Q32398783","Q32398850","Q32410527","Q32413928","Q32414433","Q32415317","Q32417115","Q32428395","Q32496884","Q32639246","Q32639566","Q32697311","Q32715512","Q32719284","Q32730125","Q32732822","Q32735942","Q32736063","Q32760619","Q32785983","Q32928358","Q32935411","Q43729467","Q44286693","Q44604430","Q45124240","Q47165904","Q49651363","Q49680763","Q49681479","Q49837864","Q49838057","Q49883484","Q50755691","Q52706480","Q52706525","Q52707491","Q55245886","Q55246099","Q55247185","Q55250807","Q55251245","Q55251909","Q55254358","Q55268554","Q55268729","Q55271164","Q55274895","Q55276425","Q55277812","Q55277873","Q55288218","Q55289954","Q55291004","Q55292371","Q55296172","Q55297321","Q55297398","Q55297504","Q55298805","Q55303291","Q55303574","Q55304667","Q55304695","Q55305565","Q55306595","Q55307005","Q55308779","Q55309342","Q55310296","Q55310337","Q55324472","Q55324765","Q55327798","Q55328182","Q55816910","Q55935995","Q55957585","Q59241123","Q60864713","Q60864716","Q60864722","Q60864944","Q60864945","Q60898733","Q60909152","Q60910360","Q60911407","Q60942975","Q60968278","Q61229893","Q61384408","Q61384413","Q61408842","Q61793828","Q64415652","Q65614536","Q65619442","Q65631868","Q65634327","Q65703883","Q65753448","Q66018307","Q66018341","Q66098751","Q66098815","Q66123956","Q66310911","Q66707912","Q66708194","Q68640355","Q68641082","Q68644398","Q69578101","Q70231182","Q70720949","Q77694918","Q77694935","Q77834261","Q77834477","Q78649149","Q80336752","Q80670110","Q81514156","Q81518767","Q82286293","Q83589849","Q84048762","Q84063556","Q84492946","Q85499389","Q85604171","Q86109054","Q86109583","Q86240931","Q86341673","Q86788358","Q8737747","Q8737752","Q87663610","Q88090765","Q88642299","Q8910349","Q89344784","Q89420153","Q89567470","Q91237287","Q91459275","Q9218344","Q9219727","Q9219737","Q9219770","Q9219943","Q9223553","Q9226836","Q9226936","Q9227663","Q92424088","Q9267859","Q92727004","Q94942583","Q94953308","Q95115388","Q9564421","Q9564780","Q95676335","Q96142799","Q9679391","Q97984691","Q98077414","Q98351353","Q98636276","Q98805163","Q98831596","Q99187044","Q99939408")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q100680964","Q10078841","Q100804839","Q10150200","Q102824987","Q104246513","Q104532031","Q104551205","Q104551749","Q104552103","Q104552184","Q104552337","Q104552704","Q104580380","Q104582871","Q104587406","Q104597230","Q104597441","Q104628795","Q104892806","Q105011380","Q105070796","Q105091545","Q105299397","Q105410205","Q105489077","Q105631900","Q105808561","Q105967805","Q106327046","Q106471883","Q106642125","Q106680512","Q106875550","Q107114470","Q107213004","Q107308304","Q107404818","Q107431392","Q107713954","Q107717835","Q107749158","Q107782266","Q108122423","Q108167168","Q108287917","Q108384155","Q108853259","Q109145845","Q109145846","Q109145847","Q109145848","Q109145849","Q109444106","Q109499442","Q109499480","Q109558147","Q109558160","Q109569074","Q109588478","Q109651131","Q109707187","Q109710370","Q109710481","Q109710558","Q109710657","Q109710815","Q109710845","Q109874623","Q109911284","Q109928802","Q109968703","Q110059679","Q110072329","Q110253241","Q110343302","Q110655880","Q110665723","Q110897980","Q110898012","Q111201092","Q111204475","Q111293164","Q111307126","Q111333808","Q111333826","Q111497932","Q111655297","Q111738281","Q111807470","Q111861005","Q111879392","Q111883048","Q111883050","Q111883052","Q111969421","Q112055152","Q112605687","Q112686821","Q112730296","Q112731101","Q112865553","Q113023451","Q113115930","Q113137356","Q113205550","Q113205699","Q113205813","Q113205864","Q113242919","Q113243148","Q113362669","Q113482059","Q113572604","Q113579121","Q113886681","Q114702692","Q114809934","Q13328576","Q13338109","Q13338110","Q13346470","Q14420528","Q14420547","Q15291867","Q16661074","Q16914701","Q17497542","Q17497559","Q17497562","Q17497588","Q17497591","Q17497593","Q18090204","Q18656319","Q18656669","Q18664703","Q18666069","Q18753891","Q18758853","Q18761624","Q18857704","Q19337301","Q21521194","Q21798188","Q21823251","Q24231476","Q25127983","Q25330942","Q25710885","Q25936795","Q25974323","Q26268501","Q27160595","Q27312724","Q27312733","Q27334987","Q27906885","Q27906886","Q28790527","Q29223594","Q29647651","Q30967058","Q31870679","Q31875355","Q31875376","Q31875392","Q31875406","Q31875416","Q31875439","Q31875490","Q31875492","Q31875498","Q31875516","Q31875518","Q31875525","Q31875547","Q31875565","Q31875576","Q31875582","Q31875625","Q31875648","Q32002645","Q32028311","Q32029412","Q32086671","Q32107599","Q32115668","Q32117665","Q32168980","Q32189589","Q32196231","Q32219382","Q32225525","Q32225529","Q32225595","Q32231034","Q32232982","Q32253979","Q32256846","Q32262003","Q32262008","Q32271123","Q32277927","Q32289248","Q32310804","Q32379889","Q32394386","Q32398783","Q32398850","Q32410527","Q32413928","Q32414433","Q32415317","Q32417115","Q32428395","Q32496884","Q32639246","Q32639566","Q32697311","Q32715512","Q32719284","Q32730125","Q32732822","Q32735942","Q32736063","Q32760619","Q32785983","Q32928358","Q32935411","Q43729467","Q44286693","Q44604430","Q45124240","Q47165904","Q49651363","Q49680763","Q49681479","Q49837864","Q49838057","Q49883484","Q50755691","Q52706480","Q52706525","Q52707491","Q55245886","Q55246099","Q55247185","Q55250807","Q55251245","Q55251909","Q55254358","Q55268554","Q55268729","Q55271164","Q55274895","Q55276425","Q55277812","Q55277873","Q55288218","Q55289954","Q55291004","Q55292371","Q55296172","Q55297321","Q55297398","Q55297504","Q55298805","Q55303291","Q55303574","Q55304667","Q55304695","Q55305565","Q55306595","Q55307005","Q55308779","Q55309342","Q55310296","Q55310337","Q55324472","Q55324765","Q55327798","Q55328182","Q55816910","Q55935995","Q55957585","Q59241123","Q60864713","Q60864716","Q60864722","Q60864944","Q60864945","Q60898733","Q60909152","Q60910360","Q60911407","Q60942975","Q60968278","Q61229893","Q61384408","Q61384413","Q61408842","Q61793828","Q64415652","Q65614536","Q65619442","Q65631868","Q65634327","Q65703883","Q65753448","Q66018307","Q66018341","Q66098751","Q66098815","Q66123956","Q66310911","Q66707912","Q66708194","Q68640355","Q68641082","Q68644398","Q69578101","Q70231182","Q70720949","Q77694918","Q77694935","Q77834261","Q77834477","Q78649149","Q80336752","Q80670110","Q81514156","Q81518767","Q82286293","Q83589849","Q84048762","Q84063556","Q84492946","Q85499389","Q85604171","Q86109054","Q86109583","Q86240931","Q86341673","Q86788358","Q8737747","Q8737752","Q87663610","Q88090765","Q88642299","Q8910349","Q89344784","Q89420153","Q89567470","Q91237287","Q91459275","Q9218344","Q9219727","Q9219737","Q9219770","Q9219943","Q9223553","Q9226836","Q9226936","Q9227663","Q92424088","Q9267859","Q92727004","Q94942583","Q94953308","Q95115388","Q9564421","Q9564780","Q95676335","Q96142799","Q9679391","Q97984691","Q98077414","Q98351353","Q98636276","Q98805163","Q98831596","Q99187044","Q99939408")
    )
#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...
