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 ("Q28546138","Q28546140","Q28545732","Q28545734","Q28545744","Q28545871","Q27883701","Q28545922","Q17497526","Q31875670","Q31875672","Q31875635","Q31875661","Q31879502","Q23981403","Q28545727","Q31875669","Q28545958","Q28545991","Q28545993","Q27883702","Q28545995","Q31875327","Q17497587","Q17497586","Q17497568","Q17497564","Q17497554","Q17497552","Q17497550","Q17497534","Q17497531","Q17497522","Q17497524","Q31875365","Q31875367","Q31875370","Q31875375","Q31875382","Q31875388","Q31875403","Q31875677","Q31875665","Q31875690","Q31875407","Q31875666","Q31879492","Q31875414","Q31875421","Q31875667","Q31875425","Q31875427","Q31875431","Q31875433","Q31875441","Q31875448","Q29045428","Q31875459","Q31875678","Q31875464","Q31875477","Q31875478","Q31875479","Q31875482","Q31875491","Q31875496","Q31875500","Q31875503","Q31875673","Q31875520","Q31875524","Q31875530","Q31875529","Q31880345","Q31875522","Q31875537","Q31875539","Q31880887","Q31875682","Q31875558","Q31875681","Q31875570","Q31875685","Q31875579","Q31875581","Q31875686","Q31875590","Q17497722","Q42567399","Q17497720","Q31875687","Q31875598","Q31875600","Q31875605","Q31875606","Q31875607","Q31875688","Q29045432","Q31875613","Q31875622","Q31875624","Q27883706","Q31875631","Q31875643","Q31875655","Q31875656","Q31875658","Q31875379","Q31880306","Q31875651")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q28546138","Q28546140","Q28545732","Q28545734","Q28545744","Q28545871","Q27883701","Q28545922","Q17497526","Q31875670","Q31875672","Q31875635","Q31875661","Q31879502","Q23981403","Q28545727","Q31875669","Q28545958","Q28545991","Q28545993","Q27883702","Q28545995","Q31875327","Q17497587","Q17497586","Q17497568","Q17497564","Q17497554","Q17497552","Q17497550","Q17497534","Q17497531","Q17497522","Q17497524","Q31875365","Q31875367","Q31875370","Q31875375","Q31875382","Q31875388","Q31875403","Q31875677","Q31875665","Q31875690","Q31875407","Q31875666","Q31879492","Q31875414","Q31875421","Q31875667","Q31875425","Q31875427","Q31875431","Q31875433","Q31875441","Q31875448","Q29045428","Q31875459","Q31875678","Q31875464","Q31875477","Q31875478","Q31875479","Q31875482","Q31875491","Q31875496","Q31875500","Q31875503","Q31875673","Q31875520","Q31875524","Q31875530","Q31875529","Q31880345","Q31875522","Q31875537","Q31875539","Q31880887","Q31875682","Q31875558","Q31875681","Q31875570","Q31875685","Q31875579","Q31875581","Q31875686","Q31875590","Q17497722","Q42567399","Q17497720","Q31875687","Q31875598","Q31875600","Q31875605","Q31875606","Q31875607","Q31875688","Q29045432","Q31875613","Q31875622","Q31875624","Q27883706","Q31875631","Q31875643","Q31875655","Q31875656","Q31875658","Q31875379","Q31880306","Q31875651")
    )
#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...
