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 ("Q10007788","Q10007812","Q10014836","Q10014871","Q10015833","Q10017849","Q10018339","Q10021170","Q10023142","Q10028029","Q10029068","Q10029136","Q10029208","Q10031942","Q10039021","Q10043470","Q10044375","Q10044457","Q10044908","Q10046388","Q10047081","Q10047107","Q10050026","Q10050814","Q10051153",
"Q10051329","Q10055809","Q10056347","Q10058210","Q10058942","Q10061287","Q10061610","Q10061900","Q10061940","Q10063368","Q10066649","Q10066849","Q10067409","Q10067418","Q10067591","Q10067616","Q10070837","Q10072282","Q10072403","Q10074697","Q10077353","Q10078016","Q10078024","Q10079658","Q10080362",
"Q10083519","Q10086431","Q10090006","Q10091034","Q10092982","Q10093856","Q10095069","Q10095093","Q10104639","Q10110345","Q10135093","Q10141651","Q10149733","Q10153361","Q10157772","Q10160995","Q10161609","Q10165345","Q10165430","Q10172360","Q10173629","Q10183625","Q10186363","Q10190464","Q10196445",
"Q10206062","Q10210869","Q10219898","Q10220566","Q10243547","Q10243693","Q10729531","Q10734759","Q10797625","Q10807766","Q10812743","Q12079531","Q13240163","Q13249529","Q13249555","Q13255105","Q13268288","Q13268446","Q13269386","Q13270737","Q13271942","Q13275039","Q13275102","Q13275192","Q13275235",
"Q13275313","Q13275366","Q13276352","Q13276615","Q13280522","Q13285824","Q13288723","Q13289025","Q13289047","Q13297317","Q13304778","Q13304779","Q14914851","Q15142181","Q15143156","Q15143159","Q15144946","Q15178217","Q15181129","Q15197188","Q15200790","Q15201310","Q15205413","Q15205461","Q15205633",
"Q15213649","Q15214126","Q15251612","Q15251619","Q15251635","Q15256685","Q15256841","Q15258369","Q15268935","Q15269213","Q15270822","Q15270975","Q15279893","Q15280159","Q15280268","Q15295405","Q15326274","Q15341213","Q15350105","Q15922272","Q15949257","Q16809203","Q16809209","Q16810559","Q16810565",
"Q16819476","Q17145349","Q18012932","Q18012933","Q18012938","Q18012939","Q18012940","Q18012941","Q18012943","Q18012944","Q18012946","Q18012947","Q18013060","Q18146880","Q18180763","Q18249094","Q18328828","Q18513262","Q18514419","Q18749954","Q18753859","Q18755557","Q19592109","Q19820712","Q19889313",
"Q20894050","Q20894051","Q20894091","Q20963928","Q20964026","Q21054957","Q21699967","Q22572773","Q23046833","Q23845869","Q24028528","Q24028529","Q24028628","Q24046830","Q24046847","Q24230483","Q24259182","Q24463973","Q24873367","Q24894235","Q24894244","Q24894246","Q24901861","Q24901869","Q24902589",
"Q24902921","Q24987827","Q24990675","Q25007910","Q25009197","Q25010327","Q25010613","Q25014232","Q25030315","Q25030426","Q25032054","Q25071681","Q25072501","Q25074193","Q25074194","Q25074195","Q25074197","Q25074198","Q25077512","Q25077513","Q25083038","Q25086959","Q25090365","Q25090753","Q25110316",
"Q25110317","Q25138842","Q25138845","Q25138846","Q25138847","Q25138848","Q25138853","Q25138863","Q25138865","Q25138866","Q25138867","Q25138872","Q25138875","Q25139089","Q25139091","Q25139092","Q25139097","Q25139098","Q25139099","Q25193554","Q25195641","Q25242131","Q25242185","Q25319147","Q25320345")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10007788","Q10007812","Q10014836","Q10014871","Q10015833","Q10017849","Q10018339","Q10021170","Q10023142","Q10028029","Q10029068","Q10029136","Q10029208","Q10031942","Q10039021","Q10043470","Q10044375","Q10044457","Q10044908","Q10046388","Q10047081","Q10047107","Q10050026","Q10050814","Q10051153",
"Q10051329","Q10055809","Q10056347","Q10058210","Q10058942","Q10061287","Q10061610","Q10061900","Q10061940","Q10063368","Q10066649","Q10066849","Q10067409","Q10067418","Q10067591","Q10067616","Q10070837","Q10072282","Q10072403","Q10074697","Q10077353","Q10078016","Q10078024","Q10079658","Q10080362",
"Q10083519","Q10086431","Q10090006","Q10091034","Q10092982","Q10093856","Q10095069","Q10095093","Q10104639","Q10110345","Q10135093","Q10141651","Q10149733","Q10153361","Q10157772","Q10160995","Q10161609","Q10165345","Q10165430","Q10172360","Q10173629","Q10183625","Q10186363","Q10190464","Q10196445",
"Q10206062","Q10210869","Q10219898","Q10220566","Q10243547","Q10243693","Q10729531","Q10734759","Q10797625","Q10807766","Q10812743","Q12079531","Q13240163","Q13249529","Q13249555","Q13255105","Q13268288","Q13268446","Q13269386","Q13270737","Q13271942","Q13275039","Q13275102","Q13275192","Q13275235",
"Q13275313","Q13275366","Q13276352","Q13276615","Q13280522","Q13285824","Q13288723","Q13289025","Q13289047","Q13297317","Q13304778","Q13304779","Q14914851","Q15142181","Q15143156","Q15143159","Q15144946","Q15178217","Q15181129","Q15197188","Q15200790","Q15201310","Q15205413","Q15205461","Q15205633",
"Q15213649","Q15214126","Q15251612","Q15251619","Q15251635","Q15256685","Q15256841","Q15258369","Q15268935","Q15269213","Q15270822","Q15270975","Q15279893","Q15280159","Q15280268","Q15295405","Q15326274","Q15341213","Q15350105","Q15922272","Q15949257","Q16809203","Q16809209","Q16810559","Q16810565",
"Q16819476","Q17145349","Q18012932","Q18012933","Q18012938","Q18012939","Q18012940","Q18012941","Q18012943","Q18012944","Q18012946","Q18012947","Q18013060","Q18146880","Q18180763","Q18249094","Q18328828","Q18513262","Q18514419","Q18749954","Q18753859","Q18755557","Q19592109","Q19820712","Q19889313",
"Q20894050","Q20894051","Q20894091","Q20963928","Q20964026","Q21054957","Q21699967","Q22572773","Q23046833","Q23845869","Q24028528","Q24028529","Q24028628","Q24046830","Q24046847","Q24230483","Q24259182","Q24463973","Q24873367","Q24894235","Q24894244","Q24894246","Q24901861","Q24901869","Q24902589",
"Q24902921","Q24987827","Q24990675","Q25007910","Q25009197","Q25010327","Q25010613","Q25014232","Q25030315","Q25030426","Q25032054","Q25071681","Q25072501","Q25074193","Q25074194","Q25074195","Q25074197","Q25074198","Q25077512","Q25077513","Q25083038","Q25086959","Q25090365","Q25090753","Q25110316",
"Q25110317","Q25138842","Q25138845","Q25138846","Q25138847","Q25138848","Q25138853","Q25138863","Q25138865","Q25138866","Q25138867","Q25138872","Q25138875","Q25139089","Q25139091","Q25139092","Q25139097","Q25139098","Q25139099","Q25193554","Q25195641","Q25242131","Q25242185","Q25319147","Q25320345")
    )
#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...
