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 ("Q13276346","Q13276347","Q13276349","Q13276350","Q13276351","Q13276354","Q13276355","Q13276356","Q13276361","Q15102055","Q15106574","Q15137575","Q15198237","Q15214366","Q15214511","Q15214514","Q15214524","Q15214536","Q15265507","Q15281278","Q15281279","Q15281281","Q15281282","Q15281284","Q15281285",
"Q15282134","Q15305739","Q15817760","Q15950580","Q16005978","Q16735827","Q16749235","Q16778621","Q16792469","Q16794443","Q16794452","Q16794488","Q16794497","Q16794616","Q16794636","Q16810552","Q16810983","Q16815028","Q16816389","Q16818759","Q18146329","Q18146342","Q18146354","Q18173924","Q18198723",
"Q18561612","Q18664148","Q18708475","Q18718185","Q18728627","Q18750534","Q18762404","Q19603486","Q20749528","Q20771668","Q20853193","Q20854813","Q20857706","Q21156069","Q21198389","Q21479700","Q22808131","Q23713772","Q24047606","Q24047612","Q24047754","Q24231200","Q24816537","Q24914803","Q24970558",
"Q24973614","Q24981589","Q25027556","Q25029504","Q25031299","Q25034327","Q25038278","Q25072413","Q25073036","Q25108727","Q25108761","Q25108906","Q25128387","Q25128393","Q25128395","Q25128396","Q25128595","Q25131008","Q25131012","Q25167109","Q25169412","Q25219440","Q25227436","Q25335474","Q25348115",
"Q25349634","Q25363803","Q26210399","Q26763443","Q26773954","Q26926765","Q26964000","Q26964033","Q26964036","Q26964039","Q27492175","Q27508917","Q28428984","Q28428985","Q28430159","Q28476383","Q28528734","Q30058055","Q30696196","Q30711521","Q30742948","Q30781697","Q30784968","Q30785644","Q30786642",
"Q30786966","Q30788742","Q30789399","Q30790865","Q30792952","Q30794744","Q30803853","Q30807217","Q30807227","Q30812488","Q30814720","Q30965513","Q30967332","Q31078260","Q31099492","Q31169930","Q31955428","Q32001166","Q32021159","Q32106259","Q32112497","Q32260145","Q32260158","Q32260169","Q32268706",
"Q32300861","Q32313680","Q32329756","Q32339899","Q32345518","Q32357577","Q32386635","Q32388118","Q32401365","Q32410027","Q32411666","Q32413662","Q32415698","Q32420951","Q32422262","Q32428937","Q32430276","Q32461206","Q32468899","Q32479584","Q32513425","Q32513766","Q32516618","Q32516621","Q32516666",
"Q32525428","Q32525456","Q32525555","Q32536842","Q32548884","Q32553858","Q32554148","Q32554210","Q32589835","Q32603021","Q32604218","Q32609138","Q32614916","Q32620930","Q32620940","Q32621960","Q32624724","Q32634785","Q32647583","Q32651810","Q32655679","Q32655731","Q32671646","Q32673149","Q32674455",
"Q32677379","Q32703312","Q32716237","Q32724667","Q32732375","Q32732376","Q32732392","Q32738743","Q32738745","Q32739390","Q32743765","Q32756493","Q32795116","Q32810904","Q32858286","Q32951568","Q32963637","Q32963639","Q32963837","Q32964261","Q33016924","Q33043403","Q33059192","Q33061200","Q33126304",
"Q33127690","Q33283078","Q33284860","Q33287795","Q33287901","Q33288608","Q33299225","Q33643724","Q33658300","Q33658362","Q33659861","Q33663748","Q33664456","Q33978335","Q34220020","Q34368601","Q34369149","Q34374312","Q34493328","Q34493846","Q34524444","Q34524808","Q35121115","Q35317050","Q35495333"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q13276346","Q13276347","Q13276349","Q13276350","Q13276351","Q13276354","Q13276355","Q13276356","Q13276361","Q15102055","Q15106574","Q15137575","Q15198237","Q15214366","Q15214511","Q15214514","Q15214524","Q15214536","Q15265507","Q15281278","Q15281279","Q15281281","Q15281282","Q15281284","Q15281285",
"Q15282134","Q15305739","Q15817760","Q15950580","Q16005978","Q16735827","Q16749235","Q16778621","Q16792469","Q16794443","Q16794452","Q16794488","Q16794497","Q16794616","Q16794636","Q16810552","Q16810983","Q16815028","Q16816389","Q16818759","Q18146329","Q18146342","Q18146354","Q18173924","Q18198723",
"Q18561612","Q18664148","Q18708475","Q18718185","Q18728627","Q18750534","Q18762404","Q19603486","Q20749528","Q20771668","Q20853193","Q20854813","Q20857706","Q21156069","Q21198389","Q21479700","Q22808131","Q23713772","Q24047606","Q24047612","Q24047754","Q24231200","Q24816537","Q24914803","Q24970558",
"Q24973614","Q24981589","Q25027556","Q25029504","Q25031299","Q25034327","Q25038278","Q25072413","Q25073036","Q25108727","Q25108761","Q25108906","Q25128387","Q25128393","Q25128395","Q25128396","Q25128595","Q25131008","Q25131012","Q25167109","Q25169412","Q25219440","Q25227436","Q25335474","Q25348115",
"Q25349634","Q25363803","Q26210399","Q26763443","Q26773954","Q26926765","Q26964000","Q26964033","Q26964036","Q26964039","Q27492175","Q27508917","Q28428984","Q28428985","Q28430159","Q28476383","Q28528734","Q30058055","Q30696196","Q30711521","Q30742948","Q30781697","Q30784968","Q30785644","Q30786642",
"Q30786966","Q30788742","Q30789399","Q30790865","Q30792952","Q30794744","Q30803853","Q30807217","Q30807227","Q30812488","Q30814720","Q30965513","Q30967332","Q31078260","Q31099492","Q31169930","Q31955428","Q32001166","Q32021159","Q32106259","Q32112497","Q32260145","Q32260158","Q32260169","Q32268706",
"Q32300861","Q32313680","Q32329756","Q32339899","Q32345518","Q32357577","Q32386635","Q32388118","Q32401365","Q32410027","Q32411666","Q32413662","Q32415698","Q32420951","Q32422262","Q32428937","Q32430276","Q32461206","Q32468899","Q32479584","Q32513425","Q32513766","Q32516618","Q32516621","Q32516666",
"Q32525428","Q32525456","Q32525555","Q32536842","Q32548884","Q32553858","Q32554148","Q32554210","Q32589835","Q32603021","Q32604218","Q32609138","Q32614916","Q32620930","Q32620940","Q32621960","Q32624724","Q32634785","Q32647583","Q32651810","Q32655679","Q32655731","Q32671646","Q32673149","Q32674455",
"Q32677379","Q32703312","Q32716237","Q32724667","Q32732375","Q32732376","Q32732392","Q32738743","Q32738745","Q32739390","Q32743765","Q32756493","Q32795116","Q32810904","Q32858286","Q32951568","Q32963637","Q32963639","Q32963837","Q32964261","Q33016924","Q33043403","Q33059192","Q33061200","Q33126304",
"Q33127690","Q33283078","Q33284860","Q33287795","Q33287901","Q33288608","Q33299225","Q33643724","Q33658300","Q33658362","Q33659861","Q33663748","Q33664456","Q33978335","Q34220020","Q34368601","Q34369149","Q34374312","Q34493328","Q34493846","Q34524444","Q34524808","Q35121115","Q35317050","Q35495333"
)
    )
#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...
