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 ("Q105237515","Q105239761","Q105248530","Q105249313","Q105252538","Q105306465","Q105321584","Q105335471","Q105356784","Q105387771","Q105397383","Q105398977","Q1"05399414","Q105408458","Q105423081","Q105423438","Q105447431","Q105450597","Q105536476","Q105538311","Q105710747","Q105720687","Q105730060","Q105743230","Q105744506","Q106326459","Q106351490","Q106613539","Q106626193","Q106999548","Q107695934","Q107807057","Q107982988","Q108033619","Q108124449","Q108124454","Q108133235","Q108251584","Q108267746","Q108282963","Q108305819","Q108305829","Q108367796","Q108379809","Q108448621","Q108472683","Q108610033","Q109907242","Q109942609","Q110288796","Q110678120","Q110678123","Q110710153","Q110733515","Q110801334","Q110854051","Q110865142","Q110865548","Q110923414","Q111925244","Q111925600","Q111925782","Q111925838","Q111925935","Q111926326","Q111926348","Q111927803","Q112053198","Q112062101","Q112073180","Q112078967","Q112079117","Q112079218","Q112079230","Q112084545","Q112126348","Q112142032","Q112192124","Q112192132","Q112275691","Q112302292","Q112594580","Q112814524","Q112842161","Q112983041","Q112983818","Q112985029","Q112985061","Q113104919","Q113104940","Q113115833","Q113161449","Q113320493","Q113320821","Q113381232","Q113391604","Q113494399","Q113556022","Q113590799","Q113620819","Q113620823","Q113625784","Q113625874","Q113625914","Q113636298","Q113636313","Q113636315","Q113651364","Q113651463","Q113651475","Q113661175","Q113671361","Q113671492","Q113679017","Q113686462","Q113686465","Q113686555","Q113908507","Q113908509","Q113908511","Q113908513","Q113908517","Q113908521","Q114454179","Q114589500","Q114589568","Q114677975","Q115035063","Q115035312","Q115052794","Q115251071","Q115251120","Q115429611","Q115492406","Q115522104","Q115534945","Q115534980","Q115535393","Q115617049","Q115645721","Q115649394","Q115649409","Q115649432","Q115649437","Q115649443","Q115657106","Q115657262","Q115657291","Q115657299","Q115657370","Q115657383","Q115774283","Q115774299","Q115785632","Q115910068","Q115910072","Q115910075","Q116008547","Q116031717","Q116031821","Q116190871","Q116249916","Q116561289","Q116618169","Q116644647","Q116644997","Q116732007","Q116748264","Q116748624","Q116778926","Q116817484","Q116859818","Q116859865","Q116860253","Q116895938","Q116895953","Q116896350","Q116940255","Q116940297","Q116940378","Q116974954","Q117007449","Q117035160","Q117035174","Q117035337","Q117110967","Q117155969","Q117196913","Q117196932","Q117318741","Q117318782","Q117318807","Q117324491","Q117351760","Q117463401","Q117470183","Q117470224","Q117470228","Q117600260","Q117662829","Q117662835","Q117662851","Q117717658","Q15179597","Q15264139","Q15273997","Q15282796","Q15310270","Q15310271","Q15310514","Q15332424","Q15352705","Q15405275","Q24978236","Q24995116","Q25001790","Q25008039","Q25030368","Q25032086","Q25032114","Q25032331","Q25032591","Q25128477","Q25167428","Q25167600","Q25171889","Q27819806","Q28432393","Q28433640","Q28433642","Q30626539","Q30628894","Q30773102","Q49888867","Q50314178","Q55919821","Q55957626","Q55959565","Q60810488","Q8245143","Q8362129","Q8362146","Q8562513","Q8599133","Q86310521","Q86315165","Q86321529","Q8680634","Q8743342","Q8786932","Q8836089","Q97421980","Q97423940")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q105237515","Q105239761","Q105248530","Q105249313","Q105252538","Q105306465","Q105321584","Q105335471","Q105356784","Q105387771","Q105397383","Q105398977","Q1"05399414","Q105408458","Q105423081","Q105423438","Q105447431","Q105450597","Q105536476","Q105538311","Q105710747","Q105720687","Q105730060","Q105743230","Q105744506","Q106326459","Q106351490","Q106613539","Q106626193","Q106999548","Q107695934","Q107807057","Q107982988","Q108033619","Q108124449","Q108124454","Q108133235","Q108251584","Q108267746","Q108282963","Q108305819","Q108305829","Q108367796","Q108379809","Q108448621","Q108472683","Q108610033","Q109907242","Q109942609","Q110288796","Q110678120","Q110678123","Q110710153","Q110733515","Q110801334","Q110854051","Q110865142","Q110865548","Q110923414","Q111925244","Q111925600","Q111925782","Q111925838","Q111925935","Q111926326","Q111926348","Q111927803","Q112053198","Q112062101","Q112073180","Q112078967","Q112079117","Q112079218","Q112079230","Q112084545","Q112126348","Q112142032","Q112192124","Q112192132","Q112275691","Q112302292","Q112594580","Q112814524","Q112842161","Q112983041","Q112983818","Q112985029","Q112985061","Q113104919","Q113104940","Q113115833","Q113161449","Q113320493","Q113320821","Q113381232","Q113391604","Q113494399","Q113556022","Q113590799","Q113620819","Q113620823","Q113625784","Q113625874","Q113625914","Q113636298","Q113636313","Q113636315","Q113651364","Q113651463","Q113651475","Q113661175","Q113671361","Q113671492","Q113679017","Q113686462","Q113686465","Q113686555","Q113908507","Q113908509","Q113908511","Q113908513","Q113908517","Q113908521","Q114454179","Q114589500","Q114589568","Q114677975","Q115035063","Q115035312","Q115052794","Q115251071","Q115251120","Q115429611","Q115492406","Q115522104","Q115534945","Q115534980","Q115535393","Q115617049","Q115645721","Q115649394","Q115649409","Q115649432","Q115649437","Q115649443","Q115657106","Q115657262","Q115657291","Q115657299","Q115657370","Q115657383","Q115774283","Q115774299","Q115785632","Q115910068","Q115910072","Q115910075","Q116008547","Q116031717","Q116031821","Q116190871","Q116249916","Q116561289","Q116618169","Q116644647","Q116644997","Q116732007","Q116748264","Q116748624","Q116778926","Q116817484","Q116859818","Q116859865","Q116860253","Q116895938","Q116895953","Q116896350","Q116940255","Q116940297","Q116940378","Q116974954","Q117007449","Q117035160","Q117035174","Q117035337","Q117110967","Q117155969","Q117196913","Q117196932","Q117318741","Q117318782","Q117318807","Q117324491","Q117351760","Q117463401","Q117470183","Q117470224","Q117470228","Q117600260","Q117662829","Q117662835","Q117662851","Q117717658","Q15179597","Q15264139","Q15273997","Q15282796","Q15310270","Q15310271","Q15310514","Q15332424","Q15352705","Q15405275","Q24978236","Q24995116","Q25001790","Q25008039","Q25030368","Q25032086","Q25032114","Q25032331","Q25032591","Q25128477","Q25167428","Q25167600","Q25171889","Q27819806","Q28432393","Q28433640","Q28433642","Q30626539","Q30628894","Q30773102","Q49888867","Q50314178","Q55919821","Q55957626","Q55959565","Q60810488","Q8245143","Q8362129","Q8362146","Q8562513","Q8599133","Q86310521","Q86315165","Q86321529","Q8680634","Q8743342","Q8786932","Q8836089","Q97421980","Q97423940")
    )
#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...
