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 ("Q65614465","Q65614519","Q65614233","Q65614601","Q65614132","Q65614111","Q65614442","Q65614155","Q65614130","Q65614116","Q65614669","Q65614181","Q65614646","Q65614173","Q65614766","Q65614168","Q65614125","Q65614177","Q65614416","Q65614358","Q65614197","Q65614429","Q65614592","Q65614643","Q65614529","Q65614387","Q65614732","Q65614124","Q65614672","Q65614146","Q65614211","Q65614472","Q65614165","Q65614610","Q65614353","Q65614673","Q65614161","Q65614326","Q65614231","Q65614473","Q65614219","Q65614193","Q65614332","Q65614406","Q65614632","Q65614179","Q65614482","Q65614515","Q65614129","Q65614764","Q65614330","Q65614190","Q65614207","Q65614147","Q65614329","Q65614546","Q65614559","Q65614402","Q65614608","Q65614540","Q65614609","Q65614548","Q65614736","Q65614205","Q65614437","Q65614188","Q65614471","Q65614606","Q65614426","Q65614474","Q65614399","Q65614227","Q65614357","Q65614435","Q65614432","Q65614477","Q65614771","Q65614419","Q65614183","Q65614645","Q65614674","Q65614163","Q65614134","Q65614746","Q65614138","Q65614664","Q65614667","Q65614117","Q65614135","Q65614741","Q65614665","Q65614748","Q65614743","Q65614209","Q65614760","Q65614498","Q65614160","Q65614140","Q65614136","Q65614444","Q65614346","Q65614217","Q65614377","Q65614394","Q65614202","Q65614390","Q65614213","Q65614157","Q65614524","Q65614464","Q65614175","Q65614334","Q65614603","Q65614462","Q65614662","Q65614370","Q65614328","Q65614590","Q65614598","Q65614335","Q65614215","Q65614122","Q65614653","Q65614222","Q65614185","Q65614675","Q65614756","Q65614656","Q65614144","Q65614153","Q65614349","Q65614347","Q65614344","Q65614149","Q65614433","Q65614594","Q65614195","Q65614761","Q65614679","Q65614366","Q65614159","Q65614110","Q65614166","Q65614171","Q65614152","Q65614459","Q65614652","Q65614341","Q65614654","Q65614360","Q65614481","Q65614469","Q65614599","Q65614325","Q65614535","Q65614550","Q65614372","Q65614141","Q65614121","Q65614167","Q65614154","Q65614666","Q65614750","Q65614407","Q65614755","Q65614448","Q65614351","Q65614199","Q65614229","Q65614644","Q65614115","Q65614423","Q117079301","Q117079181","Q117079182","Q117079302","Q117079052","Q117079222","Q117079138","Q117079275","Q117079276","Q117079146","Q117079190","Q117079283","Q117079284","Q117079110","Q117079168","Q117079169","Q117079170","Q117079253","Q117079221","Q117079304","Q117079140","Q117079306","Q117079056","Q117079223","Q117079224","Q117079307","Q117079308","Q117079311","Q117079142","Q117079143","Q117079273","Q117079226","Q117079066","Q117079073","Q117079145","Q117079189","Q117079147","Q117079078","Q117079148","Q117079278","Q117079191","Q117079080","Q117079082","Q117079084","Q117079192","Q117079228","Q117079279","Q117079150","Q117079229","Q117079195","Q117079153","Q117079091","Q117079198","Q117079200","Q117079201","Q117079156","Q117079235","Q117079157","Q117079097","Q117079287","Q117079100","Q117079312","Q117079101","Q117079202","Q117079158","Q117079204","Q117079160","Q117079107","Q117079249","Q117079161","Q117079207","Q117079163","Q117079165","Q117079166","Q117079208","Q117079109","Q117079167","Q117079171","Q117079172","Q117079254","Q117079173","Q117079176","Q117079214","Q117079113","Q117079114","Q117079178","Q117079179","Q117079119","Q117079120","Q117079121","Q117079180","Q117079218","Q117079263","Q117079123","Q117079265","Q117079266","Q117079126","Q117079129","Q117079130","Q117079219","Q117079314","Q117079220","Q117079133","Q117079316","Q117079135","Q117079300")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q65614465","Q65614519","Q65614233","Q65614601","Q65614132","Q65614111","Q65614442","Q65614155","Q65614130","Q65614116","Q65614669","Q65614181","Q65614646","Q65614173","Q65614766","Q65614168","Q65614125","Q65614177","Q65614416","Q65614358","Q65614197","Q65614429","Q65614592","Q65614643","Q65614529","Q65614387","Q65614732","Q65614124","Q65614672","Q65614146","Q65614211","Q65614472","Q65614165","Q65614610","Q65614353","Q65614673","Q65614161","Q65614326","Q65614231","Q65614473","Q65614219","Q65614193","Q65614332","Q65614406","Q65614632","Q65614179","Q65614482","Q65614515","Q65614129","Q65614764","Q65614330","Q65614190","Q65614207","Q65614147","Q65614329","Q65614546","Q65614559","Q65614402","Q65614608","Q65614540","Q65614609","Q65614548","Q65614736","Q65614205","Q65614437","Q65614188","Q65614471","Q65614606","Q65614426","Q65614474","Q65614399","Q65614227","Q65614357","Q65614435","Q65614432","Q65614477","Q65614771","Q65614419","Q65614183","Q65614645","Q65614674","Q65614163","Q65614134","Q65614746","Q65614138","Q65614664","Q65614667","Q65614117","Q65614135","Q65614741","Q65614665","Q65614748","Q65614743","Q65614209","Q65614760","Q65614498","Q65614160","Q65614140","Q65614136","Q65614444","Q65614346","Q65614217","Q65614377","Q65614394","Q65614202","Q65614390","Q65614213","Q65614157","Q65614524","Q65614464","Q65614175","Q65614334","Q65614603","Q65614462","Q65614662","Q65614370","Q65614328","Q65614590","Q65614598","Q65614335","Q65614215","Q65614122","Q65614653","Q65614222","Q65614185","Q65614675","Q65614756","Q65614656","Q65614144","Q65614153","Q65614349","Q65614347","Q65614344","Q65614149","Q65614433","Q65614594","Q65614195","Q65614761","Q65614679","Q65614366","Q65614159","Q65614110","Q65614166","Q65614171","Q65614152","Q65614459","Q65614652","Q65614341","Q65614654","Q65614360","Q65614481","Q65614469","Q65614599","Q65614325","Q65614535","Q65614550","Q65614372","Q65614141","Q65614121","Q65614167","Q65614154","Q65614666","Q65614750","Q65614407","Q65614755","Q65614448","Q65614351","Q65614199","Q65614229","Q65614644","Q65614115","Q65614423","Q117079301","Q117079181","Q117079182","Q117079302","Q117079052","Q117079222","Q117079138","Q117079275","Q117079276","Q117079146","Q117079190","Q117079283","Q117079284","Q117079110","Q117079168","Q117079169","Q117079170","Q117079253","Q117079221","Q117079304","Q117079140","Q117079306","Q117079056","Q117079223","Q117079224","Q117079307","Q117079308","Q117079311","Q117079142","Q117079143","Q117079273","Q117079226","Q117079066","Q117079073","Q117079145","Q117079189","Q117079147","Q117079078","Q117079148","Q117079278","Q117079191","Q117079080","Q117079082","Q117079084","Q117079192","Q117079228","Q117079279","Q117079150","Q117079229","Q117079195","Q117079153","Q117079091","Q117079198","Q117079200","Q117079201","Q117079156","Q117079235","Q117079157","Q117079097","Q117079287","Q117079100","Q117079312","Q117079101","Q117079202","Q117079158","Q117079204","Q117079160","Q117079107","Q117079249","Q117079161","Q117079207","Q117079163","Q117079165","Q117079166","Q117079208","Q117079109","Q117079167","Q117079171","Q117079172","Q117079254","Q117079173","Q117079176","Q117079214","Q117079113","Q117079114","Q117079178","Q117079179","Q117079119","Q117079120","Q117079121","Q117079180","Q117079218","Q117079263","Q117079123","Q117079265","Q117079266","Q117079126","Q117079129","Q117079130","Q117079219","Q117079314","Q117079220","Q117079133","Q117079316","Q117079135","Q117079300")
    )
#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...
