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 ("Q32976753","Q32976757","Q32976760","Q32976763","Q32976766","Q32976768","Q32976773","Q32976776","Q32976778","Q32976782","Q32976785","Q32976789","Q32976791","Q32976794","Q32976797","Q32976800","Q32976803","Q32976806","Q32976809","Q32976812","Q32976815","Q32976818","Q32976821","Q32976825","Q32976828","Q32976831","Q32976833","Q32976838","Q32976840","Q32976843","Q32976846","Q32976849","Q32976852","Q32976854","Q32976858","Q32976862","Q32976865","Q32976868","Q32976871","Q32976874","Q32976877","Q32976882","Q32976884","Q32976885","Q32976889","Q32976891","Q32976895","Q32976898","Q32976901","Q32976904","Q32976906","Q32976910","Q32976913","Q32977081","Q32977083","Q32977087","Q32977090","Q32977092","Q32977096","Q32977099","Q32977102","Q32977106","Q32977109","Q32977113","Q32977115","Q32977119","Q32977122","Q32977124","Q32977128","Q32977131","Q32977133","Q32977137","Q32977140","Q32977143","Q32977146","Q32977150","Q32977151","Q32977155","Q32977158","Q32977161","Q32977164","Q32977166","Q32977170","Q32977893","Q32977895","Q32977898","Q32977902","Q32977905","Q32977907","Q32977911","Q32977914","Q32977917","Q32977920","Q32977923","Q32977926","Q32977929","Q32977932","Q32977935","Q32977936","Q32977939","Q32977942","Q32977945","Q32977948","Q32977952","Q32977954","Q32977957","Q32977960","Q32977963","Q32977966","Q32977969","Q32977972","Q32977975","Q32977977","Q32977981","Q32977984","Q32977987","Q32977991","Q32977995","Q32977998","Q32978000","Q32978005","Q32978007","Q32978010","Q32978012","Q32978016","Q32978019","Q32978022","Q32978025","Q32978028","Q32978029","Q32978034","Q32978037","Q32978040","Q32978043","Q32978046","Q32978049","Q32978052","Q32978055","Q32978058","Q32978061","Q32978063","Q32978067","Q32978070","Q32978073","Q32978076","Q32978079","Q32978083","Q32978085","Q32978088","Q32978091","Q32978094","Q32978098","Q32978099","Q32978103","Q32978106","Q32978108","Q32978112","Q32978115","Q32978118","Q32978121","Q32978124","Q32978128","Q32978130","Q32978133","Q32978136","Q32978139","Q32978142","Q32978146","Q32978149","Q32978152","Q32978155","Q32978158","Q32978163","Q32978166","Q32978169","Q32978172","Q32978175","Q32978180","Q32978181","Q32978184","Q32978187","Q32978190","Q32978430","Q32978436","Q32978439","Q32978442","Q32978446","Q32978448","Q32978452","Q32978455","Q32978459","Q32978463","Q32978466","Q32978469","Q32978472","Q32978476","Q32978479","Q32978483","Q32978486","Q32978489","Q32978493","Q32978496","Q32978499","Q32978562","Q32978567","Q32978568","Q32978570","Q32978576","Q32978579","Q32978582","Q32978586","Q32978590","Q32978593","Q32978596","Q32978599","Q32978603","Q32978606","Q32978608","Q32978614","Q32978615","Q32978618","Q32978622","Q32978624","Q32978627","Q32978630","Q32978633","Q32978636","Q32978639","Q32978642","Q32978645","Q32978648","Q32978651","Q32978654","Q32978657","Q32978659","Q32978664","Q32978669","Q32978672","Q32978674")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q32976753","Q32976757","Q32976760","Q32976763","Q32976766","Q32976768","Q32976773","Q32976776","Q32976778","Q32976782","Q32976785","Q32976789","Q32976791","Q32976794","Q32976797","Q32976800","Q32976803","Q32976806","Q32976809","Q32976812","Q32976815","Q32976818","Q32976821","Q32976825","Q32976828","Q32976831","Q32976833","Q32976838","Q32976840","Q32976843","Q32976846","Q32976849","Q32976852","Q32976854","Q32976858","Q32976862","Q32976865","Q32976868","Q32976871","Q32976874","Q32976877","Q32976882","Q32976884","Q32976885","Q32976889","Q32976891","Q32976895","Q32976898","Q32976901","Q32976904","Q32976906","Q32976910","Q32976913","Q32977081","Q32977083","Q32977087","Q32977090","Q32977092","Q32977096","Q32977099","Q32977102","Q32977106","Q32977109","Q32977113","Q32977115","Q32977119","Q32977122","Q32977124","Q32977128","Q32977131","Q32977133","Q32977137","Q32977140","Q32977143","Q32977146","Q32977150","Q32977151","Q32977155","Q32977158","Q32977161","Q32977164","Q32977166","Q32977170","Q32977893","Q32977895","Q32977898","Q32977902","Q32977905","Q32977907","Q32977911","Q32977914","Q32977917","Q32977920","Q32977923","Q32977926","Q32977929","Q32977932","Q32977935","Q32977936","Q32977939","Q32977942","Q32977945","Q32977948","Q32977952","Q32977954","Q32977957","Q32977960","Q32977963","Q32977966","Q32977969","Q32977972","Q32977975","Q32977977","Q32977981","Q32977984","Q32977987","Q32977991","Q32977995","Q32977998","Q32978000","Q32978005","Q32978007","Q32978010","Q32978012","Q32978016","Q32978019","Q32978022","Q32978025","Q32978028","Q32978029","Q32978034","Q32978037","Q32978040","Q32978043","Q32978046","Q32978049","Q32978052","Q32978055","Q32978058","Q32978061","Q32978063","Q32978067","Q32978070","Q32978073","Q32978076","Q32978079","Q32978083","Q32978085","Q32978088","Q32978091","Q32978094","Q32978098","Q32978099","Q32978103","Q32978106","Q32978108","Q32978112","Q32978115","Q32978118","Q32978121","Q32978124","Q32978128","Q32978130","Q32978133","Q32978136","Q32978139","Q32978142","Q32978146","Q32978149","Q32978152","Q32978155","Q32978158","Q32978163","Q32978166","Q32978169","Q32978172","Q32978175","Q32978180","Q32978181","Q32978184","Q32978187","Q32978190","Q32978430","Q32978436","Q32978439","Q32978442","Q32978446","Q32978448","Q32978452","Q32978455","Q32978459","Q32978463","Q32978466","Q32978469","Q32978472","Q32978476","Q32978479","Q32978483","Q32978486","Q32978489","Q32978493","Q32978496","Q32978499","Q32978562","Q32978567","Q32978568","Q32978570","Q32978576","Q32978579","Q32978582","Q32978586","Q32978590","Q32978593","Q32978596","Q32978599","Q32978603","Q32978606","Q32978608","Q32978614","Q32978615","Q32978618","Q32978622","Q32978624","Q32978627","Q32978630","Q32978633","Q32978636","Q32978639","Q32978642","Q32978645","Q32978648","Q32978651","Q32978654","Q32978657","Q32978659","Q32978664","Q32978669","Q32978672","Q32978674")
    )
#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...
