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 ("Q8857132","Q8857376","Q8857770","Q8860140","Q8860519","Q8860934","Q8860999","Q8861329","Q8861529","Q8861781","Q8862194","Q8862617","Q8862959","Q8863003","Q8871897","Q8885762","Q8886300","Q8886522","Q8886545","Q8886753","Q8887002","Q8887430","Q8896447","Q8896453",
"Q8896454","Q8900673","Q8915732","Q8917232","Q8917457","Q8918645","Q8920545","Q8920552","Q8920657","Q8920687","Q8920763","Q8920780","Q8921900","Q8925472","Q8925620","Q8925640","Q8940130","Q8940132","Q8940148","Q8947491","Q8980259","Q9002123","Q9002303","Q9002306","Q9054615",
"Q9099416","Q9099437","Q9099444","Q9220349","Q9234866","Q9422319","Q9431645","Q9456416","Q9464048","Q9474208","Q9512759","Q9518409","Q9524656","Q9545160","Q9573575","Q9607810","Q9620282","Q9624276","Q9680883","Q9733202","Q9736186","Q9738921","Q9742613","Q9757993","Q9760586",
"Q9761486","Q9765659","Q9765683","Q9779798","Q9791217","Q9791846","Q9792792","Q9792965","Q9794754","Q9796056","Q9797559","Q9803309","Q9809408","Q9809947","Q9813447","Q9814580","Q9814775","Q9815206","Q9817237","Q9817294","Q9817362","Q9818068","Q9820179","Q9820204","Q9820305",
"Q9820373","Q9820474","Q9820485","Q9820671","Q9822247","Q9823120","Q9823684","Q9829182","Q9832539","Q9834690","Q9835558","Q9837704","Q9837806","Q9841299","Q9842802","Q9851136","Q9851328","Q9851340","Q9851379","Q9851606","Q9852501","Q9852525","Q9856065","Q9857038","Q9857157",
"Q9858178","Q9858333","Q9858624","Q9859227","Q9861721","Q9862616","Q9862662","Q9862782","Q9864573","Q9866117","Q9866896","Q9868351","Q9871743","Q9872926","Q9873077","Q9873300","Q9873965","Q9874264","Q9876301","Q9878208","Q9878258","Q9883616","Q9887853","Q9887969","Q9888412",
"Q9888932","Q9888948","Q9890410","Q9890987","Q9894084","Q9894308","Q9895981","Q9896814","Q9897956","Q9898537","Q9899193","Q9899378","Q9899654","Q9899869","Q9900152","Q9902063","Q9902194","Q9908808","Q9909509","Q9914136","Q9914719","Q9919613","Q9921209","Q9922771","Q9924190",
"Q9924627","Q9927459","Q9927733","Q9929438","Q9929523","Q9930185","Q9931839","Q9932089","Q9934138","Q9935511","Q9936065","Q9936112","Q9938204","Q9939684","Q9941953","Q9942183","Q9942900","Q9942908","Q9943770","Q9945931","Q9946252","Q9949943","Q9950058","Q9950199","Q9951839",
"Q9951840","Q9952125","Q9952206","Q9952497","Q9953058","Q9953855","Q9953882","Q9954277","Q9954790","Q9955403","Q9956151","Q9956314","Q9956346","Q9956394","Q9956405","Q9958481","Q9958545","Q9958760","Q9958955","Q9959012","Q9959760","Q9959860","Q9963120","Q9964133","Q9968235",
"Q9969188","Q9969327","Q9969409","Q9969511","Q9970128","Q9970402","Q9976479","Q9976505","Q9976897","Q9976909","Q9978152","Q9979409","Q9979463","Q9979559","Q9981576","Q9982356","Q9985135","Q9985479","Q9986950","Q9989441","Q9991119","Q9994463","Q9995326","Q9996202","Q9996405")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q8857132","Q8857376","Q8857770","Q8860140","Q8860519","Q8860934","Q8860999","Q8861329","Q8861529","Q8861781","Q8862194","Q8862617","Q8862959","Q8863003","Q8871897","Q8885762","Q8886300","Q8886522","Q8886545","Q8886753","Q8887002","Q8887430","Q8896447","Q8896453",
"Q8896454","Q8900673","Q8915732","Q8917232","Q8917457","Q8918645","Q8920545","Q8920552","Q8920657","Q8920687","Q8920763","Q8920780","Q8921900","Q8925472","Q8925620","Q8925640","Q8940130","Q8940132","Q8940148","Q8947491","Q8980259","Q9002123","Q9002303","Q9002306","Q9054615",
"Q9099416","Q9099437","Q9099444","Q9220349","Q9234866","Q9422319","Q9431645","Q9456416","Q9464048","Q9474208","Q9512759","Q9518409","Q9524656","Q9545160","Q9573575","Q9607810","Q9620282","Q9624276","Q9680883","Q9733202","Q9736186","Q9738921","Q9742613","Q9757993","Q9760586",
"Q9761486","Q9765659","Q9765683","Q9779798","Q9791217","Q9791846","Q9792792","Q9792965","Q9794754","Q9796056","Q9797559","Q9803309","Q9809408","Q9809947","Q9813447","Q9814580","Q9814775","Q9815206","Q9817237","Q9817294","Q9817362","Q9818068","Q9820179","Q9820204","Q9820305",
"Q9820373","Q9820474","Q9820485","Q9820671","Q9822247","Q9823120","Q9823684","Q9829182","Q9832539","Q9834690","Q9835558","Q9837704","Q9837806","Q9841299","Q9842802","Q9851136","Q9851328","Q9851340","Q9851379","Q9851606","Q9852501","Q9852525","Q9856065","Q9857038","Q9857157",
"Q9858178","Q9858333","Q9858624","Q9859227","Q9861721","Q9862616","Q9862662","Q9862782","Q9864573","Q9866117","Q9866896","Q9868351","Q9871743","Q9872926","Q9873077","Q9873300","Q9873965","Q9874264","Q9876301","Q9878208","Q9878258","Q9883616","Q9887853","Q9887969","Q9888412",
"Q9888932","Q9888948","Q9890410","Q9890987","Q9894084","Q9894308","Q9895981","Q9896814","Q9897956","Q9898537","Q9899193","Q9899378","Q9899654","Q9899869","Q9900152","Q9902063","Q9902194","Q9908808","Q9909509","Q9914136","Q9914719","Q9919613","Q9921209","Q9922771","Q9924190",
"Q9924627","Q9927459","Q9927733","Q9929438","Q9929523","Q9930185","Q9931839","Q9932089","Q9934138","Q9935511","Q9936065","Q9936112","Q9938204","Q9939684","Q9941953","Q9942183","Q9942900","Q9942908","Q9943770","Q9945931","Q9946252","Q9949943","Q9950058","Q9950199","Q9951839",
"Q9951840","Q9952125","Q9952206","Q9952497","Q9953058","Q9953855","Q9953882","Q9954277","Q9954790","Q9955403","Q9956151","Q9956314","Q9956346","Q9956394","Q9956405","Q9958481","Q9958545","Q9958760","Q9958955","Q9959012","Q9959760","Q9959860","Q9963120","Q9964133","Q9968235",
"Q9969188","Q9969327","Q9969409","Q9969511","Q9970128","Q9970402","Q9976479","Q9976505","Q9976897","Q9976909","Q9978152","Q9979409","Q9979463","Q9979559","Q9981576","Q9982356","Q9985135","Q9985479","Q9986950","Q9989441","Q9991119","Q9994463","Q9995326","Q9996202","Q9996405")
    )
#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...
