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 ("Q32635024","Q111544454","Q112967096","Q113020645","Q113034031","Q113067258","Q113682336","Q115117994","Q114395960","Q117067587","Q117067586","Q117329989","Q117334949","Q118645591","Q119788558","Q119996807","Q119997653","Q119998504","Q120001749","Q120022523","Q120030822","Q120416106","Q120481690","Q120484083","Q18856202","Q20656013","Q32539190","Q33270261","Q33664645","Q47014248","Q47014268","Q49655288","Q60909348","Q65614128","Q82068117","Q86271421","Q89773935","Q98714936","Q98715174","Q98715528","Q99732630","Q105715139","Q105715422","Q105715632","Q106516732","Q109422833","Q111643139","Q112076294","Q112159701","Q113119451","Q113297049","Q114041834","Q115169824","Q9456007","Q15001684","Q18146188","Q19606125","Q30814410","Q32103304","Q33286607","Q49683042","Q63992983","Q65062154","Q65752558","Q86277720","Q86320781","Q97015528","Q97319735","Q98714951","Q98715050","Q98715103","Q98715139","Q98715255","Q98715379","Q98715389","Q100296470","Q102047846","Q105571963","Q105714114","Q105715126","Q105715460","Q105715621","Q111801326","Q111972101","Q111976425","Q112064600","Q112143708","Q112159653","Q113297029","Q113330424","Q113505374","Q113539801","Q113770638","Q114041683","Q114233625","Q114341498","Q114361258","Q115555900","Q115715304","Q32273942","Q33096237","Q33661468","Q47014220","Q55929562","Q60934830","Q61009027","Q61010999","Q63969873","Q65062440","Q65683362","Q71399920","Q98715000","Q98715221","Q111969110","Q112159464","Q112168762","Q112249600","Q113130173","Q113361206","Q114041776","Q115088919","Q116447476","Q8873276","Q28545723","Q29224699","Q32406910","Q33710742","Q47014222","Q60908777","Q65062121","Q65062196","Q65671116","Q65671122","Q71370008","Q86279057","Q89035165","Q96759849","Q97387513","Q98714939","Q98714998","Q98715278","Q98715482","Q99482230","Q100280356","Q105634471","Q105714936","Q106371589","Q106840915","Q106982633","Q107613916","Q107741112","Q110594837","Q98715240","Q98715397","Q105715176","Q105715410","Q105715483","Q105715522","Q106070189","Q107350027","Q110621384","Q111120907","Q111337700","Q111748332","Q111771480","Q111771659","Q112047181","Q112055751","Q112148851","Q112650768","Q112725518","Q113330357","Q113330429","Q113334494","Q113686353","Q113707161","Q113770068","Q114041744","Q114351172","Q13342875","Q15143382","Q31875275","Q32244567","Q33139181","Q47014221","Q47014247","Q49837868","Q49869817","Q55587950","Q63979368","Q64452872","Q65060265","Q65062197","Q65062692","Q65062710","Q65671118","Q65759755","Q86244549","Q86252348","Q98714981","Q98714995","Q98715058","Q98715132","Q98715259","Q98715264","Q100401292","Q101576658","Q104713382","Q105715463","Q106348749","Q107124415","Q111153861","Q111578224","Q111653977","Q111743092","Q111771487","Q112069344","Q112159040","Q112160824","Q112180542","Q113242342","Q113297050","Q113769811","Q113770627","Q114041731","Q114041768","Q114041865","Q115729951","Q32469087","Q42300570","Q47014219","Q49655296","Q60908770","Q65753876","Q66469098","Q68192711","Q84852874","Q85318401","Q86717445","Q98553578","Q98715147","Q98715253","Q98715394","Q98715534","Q98715541","Q104440627","Q105957033","Q106122861","Q109371202","Q111730410","Q111743374","Q111765558","Q111642788","Q111743667","Q111772003","Q111990164","Q112076293","Q112159589","Q112652479","Q112761790","Q113297048","Q113770075","Q113970494","Q24047598","Q30774394","Q33096248","Q34457766","Q47014218","Q49655279","Q49655298","Q49845879","Q55312371","Q76658283","Q79847804","Q86127379","Q91013017","Q95469511","Q97446725","Q98104007","Q98714978","Q98715006","Q98715021","Q98715027","Q98715200","Q98715391","Q98715460","Q101427560","Q105512094","Q105714061","Q105715129","Q105715383","Q106315337","Q106413687","Q106909620","Q106964144","Q107547557","Q108031460","Q108353354","Q110475874","Q111475957","Q111642319","Q111742628","Q113126654","Q113382018","Q113682329","Q114727808","Q115536930","Q10168512","Q10176234","Q32937560","Q32969374","Q49655285","Q61005507","Q63992494","Q65062143","Q96760509","Q96792463","Q98714941","Q98715095","Q98715226","Q98715385","Q98715432","Q98715550","Q101001028","Q104517463","Q105715135","Q107097245","Q110763512","Q111225484","Q111703410","Q111711394","Q111771526","Q111771541","Q111778040","Q112064599","Q112180755","Q112761755","Q113988566","Q114041682","Q114041724","Q114041741","Q33675775","Q116780280","Q116938159","Q116973346","Q116985271","Q117030537","Q117322079","Q117328227","Q115197791","Q117747536","Q118126958","Q107335225","Q113579828","Q21291641","Q32595793","Q35648679","Q54490238","Q54655019","Q54655312","Q56033877","Q65562822","Q65562976","Q97728293","Q97801094","Q32597493","Q35654159","Q54490699","Q54654832","Q54655179","Q55917800","Q56034234","Q56034370","Q65562765","Q70468631","Q97727585","Q117841950","Q118800085","Q31105041","Q32595590","Q54489805","Q56034556","Q59922181","Q65562879","Q65562949","Q97803763","Q22164287","Q35649807","Q35649880","Q36779085","Q54490462","Q54655266","Q56033857","Q56034001","Q56034106","Q56034227","Q56382058","Q65562977","Q97775150","Q109172221","Q8912656","Q10218120","Q33127689","Q35650995","Q42328667","Q54654903","Q56033859","Q56034182","Q56034220","Q56034616","Q65562886","Q86271065","Q97727144","Q97772078","Q22166131","Q22166229","Q49661043","Q49835170","Q54528052","Q54654598","Q54654640","Q54654801","Q54655327","Q54659094","Q56034212","Q65562925","Q65562981","Q54490395","Q54654809","Q54655061","Q54659097","Q56034335","Q60803906","Q60951998","Q65720999","Q97726174","Q28928826","Q32073138","Q32595580","Q35650842","Q49835160","Q49835164","Q54659774","Q54666003","Q56033965","Q56034094","Q56034110","Q60803894","Q60803896","Q60803899","Q97771946","Q97775683","Q97805853")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q32635024","Q111544454","Q112967096","Q113020645","Q113034031","Q113067258","Q113682336","Q115117994","Q114395960","Q117067587","Q117067586","Q117329989","Q117334949","Q118645591","Q119788558","Q119996807","Q119997653","Q119998504","Q120001749","Q120022523","Q120030822","Q120416106","Q120481690","Q120484083","Q18856202","Q20656013","Q32539190","Q33270261","Q33664645","Q47014248","Q47014268","Q49655288","Q60909348","Q65614128","Q82068117","Q86271421","Q89773935","Q98714936","Q98715174","Q98715528","Q99732630","Q105715139","Q105715422","Q105715632","Q106516732","Q109422833","Q111643139","Q112076294","Q112159701","Q113119451","Q113297049","Q114041834","Q115169824","Q9456007","Q15001684","Q18146188","Q19606125","Q30814410","Q32103304","Q33286607","Q49683042","Q63992983","Q65062154","Q65752558","Q86277720","Q86320781","Q97015528","Q97319735","Q98714951","Q98715050","Q98715103","Q98715139","Q98715255","Q98715379","Q98715389","Q100296470","Q102047846","Q105571963","Q105714114","Q105715126","Q105715460","Q105715621","Q111801326","Q111972101","Q111976425","Q112064600","Q112143708","Q112159653","Q113297029","Q113330424","Q113505374","Q113539801","Q113770638","Q114041683","Q114233625","Q114341498","Q114361258","Q115555900","Q115715304","Q32273942","Q33096237","Q33661468","Q47014220","Q55929562","Q60934830","Q61009027","Q61010999","Q63969873","Q65062440","Q65683362","Q71399920","Q98715000","Q98715221","Q111969110","Q112159464","Q112168762","Q112249600","Q113130173","Q113361206","Q114041776","Q115088919","Q116447476","Q8873276","Q28545723","Q29224699","Q32406910","Q33710742","Q47014222","Q60908777","Q65062121","Q65062196","Q65671116","Q65671122","Q71370008","Q86279057","Q89035165","Q96759849","Q97387513","Q98714939","Q98714998","Q98715278","Q98715482","Q99482230","Q100280356","Q105634471","Q105714936","Q106371589","Q106840915","Q106982633","Q107613916","Q107741112","Q110594837","Q98715240","Q98715397","Q105715176","Q105715410","Q105715483","Q105715522","Q106070189","Q107350027","Q110621384","Q111120907","Q111337700","Q111748332","Q111771480","Q111771659","Q112047181","Q112055751","Q112148851","Q112650768","Q112725518","Q113330357","Q113330429","Q113334494","Q113686353","Q113707161","Q113770068","Q114041744","Q114351172","Q13342875","Q15143382","Q31875275","Q32244567","Q33139181","Q47014221","Q47014247","Q49837868","Q49869817","Q55587950","Q63979368","Q64452872","Q65060265","Q65062197","Q65062692","Q65062710","Q65671118","Q65759755","Q86244549","Q86252348","Q98714981","Q98714995","Q98715058","Q98715132","Q98715259","Q98715264","Q100401292","Q101576658","Q104713382","Q105715463","Q106348749","Q107124415","Q111153861","Q111578224","Q111653977","Q111743092","Q111771487","Q112069344","Q112159040","Q112160824","Q112180542","Q113242342","Q113297050","Q113769811","Q113770627","Q114041731","Q114041768","Q114041865","Q115729951","Q32469087","Q42300570","Q47014219","Q49655296","Q60908770","Q65753876","Q66469098","Q68192711","Q84852874","Q85318401","Q86717445","Q98553578","Q98715147","Q98715253","Q98715394","Q98715534","Q98715541","Q104440627","Q105957033","Q106122861","Q109371202","Q111730410","Q111743374","Q111765558","Q111642788","Q111743667","Q111772003","Q111990164","Q112076293","Q112159589","Q112652479","Q112761790","Q113297048","Q113770075","Q113970494","Q24047598","Q30774394","Q33096248","Q34457766","Q47014218","Q49655279","Q49655298","Q49845879","Q55312371","Q76658283","Q79847804","Q86127379","Q91013017","Q95469511","Q97446725","Q98104007","Q98714978","Q98715006","Q98715021","Q98715027","Q98715200","Q98715391","Q98715460","Q101427560","Q105512094","Q105714061","Q105715129","Q105715383","Q106315337","Q106413687","Q106909620","Q106964144","Q107547557","Q108031460","Q108353354","Q110475874","Q111475957","Q111642319","Q111742628","Q113126654","Q113382018","Q113682329","Q114727808","Q115536930","Q10168512","Q10176234","Q32937560","Q32969374","Q49655285","Q61005507","Q63992494","Q65062143","Q96760509","Q96792463","Q98714941","Q98715095","Q98715226","Q98715385","Q98715432","Q98715550","Q101001028","Q104517463","Q105715135","Q107097245","Q110763512","Q111225484","Q111703410","Q111711394","Q111771526","Q111771541","Q111778040","Q112064599","Q112180755","Q112761755","Q113988566","Q114041682","Q114041724","Q114041741","Q33675775","Q116780280","Q116938159","Q116973346","Q116985271","Q117030537","Q117322079","Q117328227","Q115197791","Q117747536","Q118126958","Q107335225","Q113579828","Q21291641","Q32595793","Q35648679","Q54490238","Q54655019","Q54655312","Q56033877","Q65562822","Q65562976","Q97728293","Q97801094","Q32597493","Q35654159","Q54490699","Q54654832","Q54655179","Q55917800","Q56034234","Q56034370","Q65562765","Q70468631","Q97727585","Q117841950","Q118800085","Q31105041","Q32595590","Q54489805","Q56034556","Q59922181","Q65562879","Q65562949","Q97803763","Q22164287","Q35649807","Q35649880","Q36779085","Q54490462","Q54655266","Q56033857","Q56034001","Q56034106","Q56034227","Q56382058","Q65562977","Q97775150","Q109172221","Q8912656","Q10218120","Q33127689","Q35650995","Q42328667","Q54654903","Q56033859","Q56034182","Q56034220","Q56034616","Q65562886","Q86271065","Q97727144","Q97772078","Q22166131","Q22166229","Q49661043","Q49835170","Q54528052","Q54654598","Q54654640","Q54654801","Q54655327","Q54659094","Q56034212","Q65562925","Q65562981","Q54490395","Q54654809","Q54655061","Q54659097","Q56034335","Q60803906","Q60951998","Q65720999","Q97726174","Q28928826","Q32073138","Q32595580","Q35650842","Q49835160","Q49835164","Q54659774","Q54666003","Q56033965","Q56034094","Q56034110","Q60803894","Q60803896","Q60803899","Q97771946","Q97775683","Q97805853")
    )
#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...
