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 ("Q10255122","Q10255264","Q10255406","Q10255593","Q10255753","Q10255921","Q10256168","Q10256290","Q10256492","Q10256601","Q10258247","Q10258655","Q10258834","Q10258977","Q10259132","Q10259373","Q10259506","Q28847404","Q28847419","Q28847441","Q28847445","Q28847447","Q28847449","Q28847451","Q28847453","Q28847455","Q28847456","Q28847459","Q28847460","Q28847462","Q28847464","Q28847466","Q28847467","Q28847468","Q28847469","Q28847470","Q28847471","Q28847472","Q28847474","Q28847475","Q28847476","Q28847477","Q28847478","Q28847479","Q28847480","Q28847481","Q28847482","Q28847484","Q28847485","Q28847486","Q28847487","Q28847489","Q28847490","Q28847496","Q28847498","Q28847500","Q28847501","Q28847503","Q28847504","Q28847506","Q28847508","Q28847516","Q28847519","Q28847520","Q28847522","Q28847523","Q28847524","Q28847525","Q28847527","Q28847536","Q28847539","Q28847643","Q28847649","Q28847651","Q28847653","Q28847654","Q28847656","Q28847657","Q28847658","Q28847664","Q28847666","Q28847667","Q28847669","Q28847672","Q28847674","Q28847675","Q28847677","Q28847678","Q28847679","Q28847681","Q28847682","Q28847684","Q28847686","Q28847687","Q28847689","Q28847690","Q28847691","Q28847693","Q28847694","Q28847695","Q28847697","Q28847699","Q28847700","Q28847702","Q28847703","Q28847706","Q28847707","Q28847709","Q28847710","Q28847711","Q28847713","Q28847714","Q28847716","Q28847718","Q28847719","Q28847721","Q28847722","Q28847723","Q28847725","Q28847726","Q28847728","Q28847729","Q28847731","Q28847733","Q28847734","Q28847736","Q28847737","Q28847738","Q28847740","Q28847741","Q28847750","Q28847759","Q28847818","Q28847821","Q28847822","Q28847823","Q28847849","Q28847872","Q28847875","Q28847885","Q28847903","Q28847904","Q28847905","Q28847906","Q28847907","Q28847908","Q28847909","Q28847910","Q28847911","Q28847912","Q28847913","Q28847914","Q28847915","Q28847916","Q28847917","Q28847918","Q28847919","Q28847920","Q28847921","Q28847922","Q28847923","Q28847924","Q28847925","Q28847926","Q28847928","Q28847929","Q28847930","Q28847931","Q28847933","Q28847934","Q28847935","Q28847938","Q28847939","Q28847940","Q28847941","Q28847943","Q28847945","Q28847946","Q28847952","Q28847954","Q28847956","Q28847957","Q28847958","Q28847960","Q28847967","Q28847971","Q28847972","Q28847973","Q28847974","Q28847975","Q28847976","Q28847977","Q28847978","Q28847979","Q28848030","Q28848041","Q28848058","Q28848059","Q28848061","Q28848063","Q28848064","Q28848065","Q28848066","Q28848067","Q28848068","Q28848069","Q28848070","Q28848071","Q28848072","Q28848073","Q28848074","Q28848075","Q28848076","Q28848077","Q28848078","Q28848079","Q28848080","Q28848081","Q28848083","Q28848084","Q28848085","Q28848086","Q28848087","Q28848088","Q28848089","Q28848090","Q28848091","Q28848093","Q28848094","Q28848095","Q28848096","Q28848098","Q28848099","Q28848107","Q28848110","Q28848112","Q28848113","Q28848114","Q28848116","Q28848117","Q28848126","Q28848127","Q28848128","Q28848130","Q28848131","Q28848132","Q28848133","Q28848134","Q28848135","Q28848138","Q28848141","Q28848145","Q28848192")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10255122","Q10255264","Q10255406","Q10255593","Q10255753","Q10255921","Q10256168","Q10256290","Q10256492","Q10256601","Q10258247","Q10258655","Q10258834","Q10258977","Q10259132","Q10259373","Q10259506","Q28847404","Q28847419","Q28847441","Q28847445","Q28847447","Q28847449","Q28847451","Q28847453","Q28847455","Q28847456","Q28847459","Q28847460","Q28847462","Q28847464","Q28847466","Q28847467","Q28847468","Q28847469","Q28847470","Q28847471","Q28847472","Q28847474","Q28847475","Q28847476","Q28847477","Q28847478","Q28847479","Q28847480","Q28847481","Q28847482","Q28847484","Q28847485","Q28847486","Q28847487","Q28847489","Q28847490","Q28847496","Q28847498","Q28847500","Q28847501","Q28847503","Q28847504","Q28847506","Q28847508","Q28847516","Q28847519","Q28847520","Q28847522","Q28847523","Q28847524","Q28847525","Q28847527","Q28847536","Q28847539","Q28847643","Q28847649","Q28847651","Q28847653","Q28847654","Q28847656","Q28847657","Q28847658","Q28847664","Q28847666","Q28847667","Q28847669","Q28847672","Q28847674","Q28847675","Q28847677","Q28847678","Q28847679","Q28847681","Q28847682","Q28847684","Q28847686","Q28847687","Q28847689","Q28847690","Q28847691","Q28847693","Q28847694","Q28847695","Q28847697","Q28847699","Q28847700","Q28847702","Q28847703","Q28847706","Q28847707","Q28847709","Q28847710","Q28847711","Q28847713","Q28847714","Q28847716","Q28847718","Q28847719","Q28847721","Q28847722","Q28847723","Q28847725","Q28847726","Q28847728","Q28847729","Q28847731","Q28847733","Q28847734","Q28847736","Q28847737","Q28847738","Q28847740","Q28847741","Q28847750","Q28847759","Q28847818","Q28847821","Q28847822","Q28847823","Q28847849","Q28847872","Q28847875","Q28847885","Q28847903","Q28847904","Q28847905","Q28847906","Q28847907","Q28847908","Q28847909","Q28847910","Q28847911","Q28847912","Q28847913","Q28847914","Q28847915","Q28847916","Q28847917","Q28847918","Q28847919","Q28847920","Q28847921","Q28847922","Q28847923","Q28847924","Q28847925","Q28847926","Q28847928","Q28847929","Q28847930","Q28847931","Q28847933","Q28847934","Q28847935","Q28847938","Q28847939","Q28847940","Q28847941","Q28847943","Q28847945","Q28847946","Q28847952","Q28847954","Q28847956","Q28847957","Q28847958","Q28847960","Q28847967","Q28847971","Q28847972","Q28847973","Q28847974","Q28847975","Q28847976","Q28847977","Q28847978","Q28847979","Q28848030","Q28848041","Q28848058","Q28848059","Q28848061","Q28848063","Q28848064","Q28848065","Q28848066","Q28848067","Q28848068","Q28848069","Q28848070","Q28848071","Q28848072","Q28848073","Q28848074","Q28848075","Q28848076","Q28848077","Q28848078","Q28848079","Q28848080","Q28848081","Q28848083","Q28848084","Q28848085","Q28848086","Q28848087","Q28848088","Q28848089","Q28848090","Q28848091","Q28848093","Q28848094","Q28848095","Q28848096","Q28848098","Q28848099","Q28848107","Q28848110","Q28848112","Q28848113","Q28848114","Q28848116","Q28848117","Q28848126","Q28848127","Q28848128","Q28848130","Q28848131","Q28848132","Q28848133","Q28848134","Q28848135","Q28848138","Q28848141","Q28848145","Q28848192")
    )
#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...
