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 ("Q33299706","Q33301137","Q33301377","Q33301967","Q33302023","Q33302053","Q33302067","Q33302095","Q33302130","Q33302159","Q33302218","Q33302328","Q33302334","Q33302358","Q33302401","Q33302417","Q33302565","Q33302579","Q33303066","Q33303466","Q33303577","Q33303608","Q33303790","Q33303996","Q33304010","Q33304194","Q33304210","Q33304283","Q33304312","Q33304437","Q33304767","Q33304873","Q33304928","Q33304958","Q33304973","Q33305002","Q33305029","Q33305042","Q33305057","Q33305071","Q33305085","Q33305099","Q33305114","Q33305127","Q33305184","Q33305212","Q33305228","Q33305258","Q33305280","Q33305293","Q33305336","Q33305431","Q33305473","Q33305595","Q33305638","Q33305694","Q33305722","Q33305764","Q33305779","Q33305793","Q33305810","Q33305899","Q33305913","Q33305929","Q33305958","Q33305972","Q33305998","Q33306055","Q33306070","Q33306114","Q33306128","Q33306145","Q33306159","Q33306187","Q33306233","Q33306278","Q33306296","Q33306310","Q33306385","Q33306400","Q33306443","Q33306475","Q33306503","Q33306542","Q33306555","Q33306607","Q33306646","Q33306659","Q33306701","Q33306770","Q33306796","Q33306810","Q33306825","Q33306869","Q33306900","Q33306915","Q33306929","Q33306962","Q33307039","Q33307053","Q33307068","Q33307097","Q33307110","Q33307124","Q33307137","Q33307150","Q33307165","Q33307181","Q33307195","Q33307424","Q33307452","Q33307508","Q33307522","Q33307567","Q33307581","Q33307597","Q33307625","Q33307726","Q33307740","Q33307833","Q33307868","Q33307882","Q33307924","Q33307938","Q33307985","Q33308000","Q33308015","Q33308030","Q33308091","Q33308106","Q33308119","Q33308134","Q33308149","Q33308194","Q33308237","Q33308318","Q33308330","Q33308344","Q33308359","Q33308414","Q33308429","Q33308487","Q33308500","Q33308517","Q33308531","Q33308545","Q33308676","Q33308706","Q33308720","Q33308793","Q33308810","Q33308878","Q33308893","Q33308921","Q33308936","Q33308997","Q33309025","Q33309061","Q33309071","Q33309111","Q33309124","Q33309139","Q33309182","Q33309198","Q33309215","Q33309228","Q33309272","Q33309303","Q33309334","Q33309352","Q33309366","Q33309381","Q33309411","Q33309461","Q33309508","Q33309557","Q33309592","Q33309642","Q33309724","Q33309790","Q33309826","Q33309845","Q33309863","Q33309881","Q33309917","Q33309934","Q33309950","Q33309965","Q33309998","Q33310016","Q33310034","Q33310081","Q33310096","Q33310128","Q33310146","Q33310181","Q33310265","Q33310282","Q33310357","Q33310373","Q33310391","Q33310457","Q33310491","Q33310517","Q33310538","Q33310569","Q33310586","Q33310601","Q33310635","Q33310651","Q33310677","Q33310710","Q33310727","Q33310744","Q33310760","Q33310811","Q33310998","Q33311039","Q33311145","Q33311163","Q33311179","Q33311234","Q33678070","Q33678104","Q33678122","Q33678158","Q33678167","Q33678171","Q33678224","Q33678229","Q33678291","Q33678295","Q33678322","Q33678329","Q33678376","Q33678420","Q33678440","Q33678447","Q33678451","Q33678490","Q33678708","Q33678728","Q33678739","Q33678746","Q33678761","Q33678773","Q33678797","Q33678809","Q33678861","Q33678894","Q33678968","Q33678999","Q33679004","Q33679011","Q33679662")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q33299706","Q33301137","Q33301377","Q33301967","Q33302023","Q33302053","Q33302067","Q33302095","Q33302130","Q33302159","Q33302218","Q33302328","Q33302334","Q33302358","Q33302401","Q33302417","Q33302565","Q33302579","Q33303066","Q33303466","Q33303577","Q33303608","Q33303790","Q33303996","Q33304010","Q33304194","Q33304210","Q33304283","Q33304312","Q33304437","Q33304767","Q33304873","Q33304928","Q33304958","Q33304973","Q33305002","Q33305029","Q33305042","Q33305057","Q33305071","Q33305085","Q33305099","Q33305114","Q33305127","Q33305184","Q33305212","Q33305228","Q33305258","Q33305280","Q33305293","Q33305336","Q33305431","Q33305473","Q33305595","Q33305638","Q33305694","Q33305722","Q33305764","Q33305779","Q33305793","Q33305810","Q33305899","Q33305913","Q33305929","Q33305958","Q33305972","Q33305998","Q33306055","Q33306070","Q33306114","Q33306128","Q33306145","Q33306159","Q33306187","Q33306233","Q33306278","Q33306296","Q33306310","Q33306385","Q33306400","Q33306443","Q33306475","Q33306503","Q33306542","Q33306555","Q33306607","Q33306646","Q33306659","Q33306701","Q33306770","Q33306796","Q33306810","Q33306825","Q33306869","Q33306900","Q33306915","Q33306929","Q33306962","Q33307039","Q33307053","Q33307068","Q33307097","Q33307110","Q33307124","Q33307137","Q33307150","Q33307165","Q33307181","Q33307195","Q33307424","Q33307452","Q33307508","Q33307522","Q33307567","Q33307581","Q33307597","Q33307625","Q33307726","Q33307740","Q33307833","Q33307868","Q33307882","Q33307924","Q33307938","Q33307985","Q33308000","Q33308015","Q33308030","Q33308091","Q33308106","Q33308119","Q33308134","Q33308149","Q33308194","Q33308237","Q33308318","Q33308330","Q33308344","Q33308359","Q33308414","Q33308429","Q33308487","Q33308500","Q33308517","Q33308531","Q33308545","Q33308676","Q33308706","Q33308720","Q33308793","Q33308810","Q33308878","Q33308893","Q33308921","Q33308936","Q33308997","Q33309025","Q33309061","Q33309071","Q33309111","Q33309124","Q33309139","Q33309182","Q33309198","Q33309215","Q33309228","Q33309272","Q33309303","Q33309334","Q33309352","Q33309366","Q33309381","Q33309411","Q33309461","Q33309508","Q33309557","Q33309592","Q33309642","Q33309724","Q33309790","Q33309826","Q33309845","Q33309863","Q33309881","Q33309917","Q33309934","Q33309950","Q33309965","Q33309998","Q33310016","Q33310034","Q33310081","Q33310096","Q33310128","Q33310146","Q33310181","Q33310265","Q33310282","Q33310357","Q33310373","Q33310391","Q33310457","Q33310491","Q33310517","Q33310538","Q33310569","Q33310586","Q33310601","Q33310635","Q33310651","Q33310677","Q33310710","Q33310727","Q33310744","Q33310760","Q33310811","Q33310998","Q33311039","Q33311145","Q33311163","Q33311179","Q33311234","Q33678070","Q33678104","Q33678122","Q33678158","Q33678167","Q33678171","Q33678224","Q33678229","Q33678291","Q33678295","Q33678322","Q33678329","Q33678376","Q33678420","Q33678440","Q33678447","Q33678451","Q33678490","Q33678708","Q33678728","Q33678739","Q33678746","Q33678761","Q33678773","Q33678797","Q33678809","Q33678861","Q33678894","Q33678968","Q33678999","Q33679004","Q33679011","Q33679662")
    )
#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...
