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 ("Q10213911","Q32786327","Q32786357","Q32786401","Q32786436","Q32786441","Q32786454","Q32786456","Q32786464","Q32786470","Q32786471","Q32786492","Q32786495","Q32786496","Q32786545","Q32786547","Q32786553","Q32786566","Q32786574","Q32786582","Q32786588","Q32786590","Q32786598","Q32786628","Q32786633","Q32786640","Q32786704","Q32786708","Q32786721","Q32786735","Q32786740","Q32786744","Q32786748","Q32786751","Q32786755","Q32786759","Q32786761","Q32786791","Q32786800","Q32786819","Q32786824","Q32786835","Q32786836","Q32786838","Q32786854","Q32786858","Q32786861","Q32786863","Q32786867","Q32786870","Q32786872","Q32786876","Q32786877","Q32786881","Q32786894","Q32786902","Q32786906","Q32786910","Q32786989","Q32786990","Q32786992","Q32786993","Q32787002","Q32787008","Q32787011","Q32787021","Q32787029","Q32787342","Q32787665","Q32787778","Q32787808","Q32787855","Q32787933","Q32787956","Q32787963","Q32788001","Q32788025","Q32788035","Q32788058","Q32788059","Q32788104","Q32788117","Q32788158","Q32788218","Q32788243","Q32788246","Q32788254","Q32788257","Q32788272","Q32788283","Q32788293","Q32788315","Q32788323","Q32788334","Q32788549","Q32788562","Q32788564","Q32788567","Q32788569","Q32788570","Q32788571","Q32788582","Q32788584","Q32788602","Q32788648","Q32797543","Q32798984","Q32800653","Q32801199","Q32801348","Q32801506","Q32801651","Q32802151","Q32802363","Q32802500","Q32802557","Q32802895","Q32803055","Q32803096","Q32803648","Q32803992","Q32804301","Q32804422","Q32804612","Q32804924","Q32993746","Q32994180","Q32994185","Q32994191","Q32994195","Q32994204","Q32994215","Q32994216","Q32994217","Q32994218","Q32994222","Q32994225","Q32994226","Q32994227","Q32994232","Q32994235","Q32994236","Q32994237","Q32994238","Q32994241","Q32994244","Q32994246","Q32994249","Q32994252","Q32994255","Q32994256","Q32994257","Q32994260","Q32994261","Q32994262","Q32994263","Q32994264","Q32994265","Q32994266","Q32994267","Q32994268","Q32994269","Q32994271","Q32994272","Q32994273","Q32994275","Q32994276","Q32994277","Q32994282","Q32994283","Q32994284","Q32994285","Q32994286","Q32994287","Q32994288","Q32994289","Q32994290","Q32994291","Q32994292","Q32994294","Q32994295","Q32994299","Q32994301","Q32994302","Q32994304","Q32994305","Q32994306","Q32994307","Q32994308","Q32994309","Q32994310","Q32994311","Q32994314","Q32994315","Q32994316","Q32994317","Q32994318","Q32994320","Q32994323","Q32994324","Q32994325","Q32994326","Q32994328","Q32994329","Q32994330","Q32994331","Q32994332","Q32994337","Q32994338","Q32994339","Q32994342","Q32994343","Q32994344","Q32994345","Q32994347","Q32994348","Q32994349","Q32994352","Q32994354","Q32994355","Q32994357","Q32994358","Q32994359","Q32994360","Q32994362","Q32994364","Q32994365","Q32994366","Q32994367","Q32994376","Q32994377","Q32994378","Q32994379","Q32994382","Q32994383","Q32994384","Q32994386","Q32994387","Q32994388","Q32994389","Q32994394","Q32994397","Q32994398","Q32994399","Q32994400","Q32994401","Q32994402","Q32994403","Q32994404","Q32994406","Q32994407","Q32994409","Q32994413","Q32994415","Q32994419","Q32994420","Q32994422","Q32994423","Q32994424","Q32994427","Q32994428","Q32994429","Q32994430","Q32994434","Q32994435","Q32994440","Q32994441","Q32994442","Q32994443","Q32994444","Q32994449","Q32994450","Q32994451","Q32994452","Q32994456","Q32994459","Q32994461","Q32994463","Q32994466","Q32994469","Q32994470","Q32994471","Q32994472","Q32994474","Q32994476","Q32994477","Q32994478","Q32994479","Q32994481","Q32994483","Q32994484","Q32994486","Q32994488","Q32994489","Q32994491","Q32994493","Q32994494","Q32994495","Q32994496","Q32994498","Q32994499","Q32994504","Q32994506","Q32994507","Q32994509","Q32994510","Q32994512","Q32994514","Q32994515","Q32994516","Q32994517","Q32994518","Q32994519","Q32994521","Q32994523","Q32994524","Q32994525","Q32994530","Q32994531","Q32994533","Q32994534","Q32994539","Q32994540","Q32994542","Q32994544","Q32994545","Q32994546","Q32994547","Q32994550","Q32994553","Q32994558","Q32994559","Q32994561","Q32994562","Q32994564","Q32994565","Q32994568","Q32994569","Q32994570","Q32994571","Q32994572","Q32994573","Q32994574","Q32994575","Q32994576","Q32994577","Q32994579","Q32994580","Q32994584","Q32994585","Q32994587","Q32994588","Q32994589","Q32994590","Q32994592","Q32994595","Q32994596","Q32994597","Q32994598","Q32994600","Q32994606","Q32994608","Q32994611","Q32994613","Q32994614","Q32994615","Q32994616","Q32994624","Q32994625","Q32994629","Q32994631","Q32994632","Q32994633","Q32994634","Q32994635","Q32994652","Q32994658","Q32994659","Q32994663","Q32994667","Q32994668","Q32994679","Q32994680","Q32994683","Q32994709","Q32994710","Q32994712","Q32994716","Q32994723","Q32994724","Q32994725","Q32994726","Q32994728","Q32994735","Q32994736","Q32994738","Q32994743","Q32994746","Q32994748","Q32994749","Q32994752","Q32994753","Q32994754","Q32994757","Q32994759","Q32994761","Q32994762","Q32994763","Q32994765","Q32994766","Q32994767","Q32994770","Q32994773","Q32994776","Q32994777","Q32994780","Q32994781","Q32994782","Q32994783","Q32994784","Q32994788","Q32994791","Q32994794","Q32994795","Q32994796","Q32994798","Q32994799","Q32994801","Q32994802","Q32994803","Q32994807","Q32994808","Q32994811","Q32994812","Q32994813","Q32994814","Q32994815","Q32994816","Q32994817","Q32994821","Q32994822","Q32994824","Q32994825","Q32994826","Q32994831","Q32994834","Q32994836","Q32994837","Q32994839","Q32994841","Q32994843","Q32994846","Q32994847","Q32994849","Q32994851","Q32994852","Q32994854","Q32994855","Q32994856","Q32994862","Q32994864","Q32994865","Q32994866","Q32994867","Q32994869","Q32994870","Q32994871","Q32994876","Q32994878","Q32994880","Q32994881","Q32994883","Q32994884","Q32994888","Q32994889","Q32994890","Q32994893","Q32994894","Q32994896","Q32994901","Q32994903","Q32994906","Q32994907","Q32994908","Q32994909","Q32994911","Q32994912","Q32994913","Q32994914","Q32994915","Q32994916","Q32994917","Q32994919","Q32994920","Q32994921","Q32994923","Q32994926","Q32994928","Q32994931","Q32994934","Q32994936","Q32994938","Q32994939","Q32994940","Q32994941","Q32994943","Q32994944","Q32994945","Q32994949","Q32994951","Q32994952","Q32994954","Q32994956","Q32994958","Q32994959","Q32994960","Q32994961","Q32994962","Q32994963","Q32994965","Q32994966","Q32994968","Q32994970","Q32994972","Q32994974","Q32994976","Q32994977","Q32994978","Q32994979","Q32994980","Q32994981","Q32994982","Q32994983","Q32994985","Q32994988","Q32994989","Q32994995","Q32994996","Q32995001","Q32995002","Q32995003","Q32995008","Q32995017","Q32995020","Q32995028","Q32995029","Q32995030","Q32995033","Q32995034","Q32995036","Q32995038","Q32995039","Q32995041","Q32995045","Q32995046","Q32995049","Q32995054","Q32995056","Q32995057","Q32995058","Q32995062","Q32995063","Q32995070","Q32995082","Q32995084","Q32995085","Q32995086","Q32995087","Q32995088","Q32995089","Q32995090","Q32995091","Q32995092","Q32995093","Q32995094","Q32995095","Q32995096","Q32995097","Q32995098","Q32995099","Q32995100","Q32995101","Q32995104","Q32995105","Q32995108","Q32995109","Q32995340","Q32995341","Q32995342","Q32995343","Q32995344","Q32995345","Q32995346","Q32995347","Q32995348","Q32995350","Q32995352","Q32995353","Q32995354","Q32995355","Q32995356","Q32995357","Q32995358","Q32995359","Q32995360","Q32995363","Q32995364","Q32995365","Q32995368","Q32995369","Q32995372","Q32995374","Q32995375","Q32995376","Q32995377","Q32995379","Q32995380","Q32995381","Q32995382","Q32995384","Q32995385","Q32995389","Q32995391","Q32995392","Q32995394","Q32995395","Q32995396","Q32995397","Q32995399","Q32995400","Q32995401","Q32995402","Q32995404","Q32995406","Q32995407","Q32995410","Q32995411","Q32995412","Q32995414","Q32995415","Q32995418","Q32995419","Q32995421","Q32995422","Q32995430","Q32995432","Q32995434","Q32995435","Q32995440","Q32995441","Q32995442","Q32995445","Q32995446","Q32995447","Q32995448","Q32995449","Q32995450","Q32995451","Q32995454","Q32995455","Q32995456","Q32995457","Q32995460","Q32995461","Q32995462","Q32995463","Q32995464","Q32995465","Q32995470","Q32995471","Q32995473","Q32995474","Q32995475","Q32995476","Q32995477","Q32995479","Q32995484","Q32995485","Q32995486","Q32995489","Q32995494","Q32995496","Q32995497","Q32995499","Q32995500","Q32995502","Q32993881","Q32993892","Q32994070","Q32994146","Q32994159","Q32994193","Q32994208","Q32994298","Q32994300","Q32994350","Q32994390","Q32994393","Q32994462","Q32994526","Q32994537","Q32994692","Q32994739","Q32994771","Q32994772","Q32994786","Q32994818","Q32994819","Q32994823","Q32994829","Q32994830","Q32994832","Q32994833","Q32994840","Q32994842","Q32994844","Q32994848","Q32994850","Q32994853","Q32994857","Q32994859","Q32994861","Q32994863","Q32994868","Q32994872","Q32994873","Q32994874","Q32994875","Q32994882","Q32994885","Q32994886","Q32994887","Q32994891","Q32994892","Q32994895","Q32994897","Q32994898","Q32994899","Q32994900","Q32994902","Q32994904","Q32994905","Q32994910","Q32994918","Q32994922","Q32994924","Q32994925","Q32994927","Q32994929","Q32994930","Q32994932","Q32994933","Q32994935","Q32994937","Q32994942","Q32994947","Q32994950","Q32994953","Q32994957","Q32994964","Q32994967","Q32994969","Q32994971","Q32994973","Q32994975","Q32994986","Q32994987","Q32994991","Q32994992","Q32994993","Q32994997","Q32994998","Q32994999","Q32995000","Q32995005","Q32995006","Q32995007","Q32995009","Q32995010","Q32995011","Q32995012","Q32995013","Q32995014","Q32995015","Q32995016","Q32995018","Q32995021","Q32995022","Q32995023","Q32995025","Q32995026","Q32995027","Q32995031","Q32995032","Q32995035","Q32995037","Q32995042","Q32995043","Q32995047","Q32995059","Q32995060","Q32995064","Q32995066","Q32995072","Q32995073","Q32995075","Q32995076","Q32995078","Q32995079","Q32995080","Q32995081")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10213911","Q32786327","Q32786357","Q32786401","Q32786436","Q32786441","Q32786454","Q32786456","Q32786464","Q32786470","Q32786471","Q32786492","Q32786495","Q32786496","Q32786545","Q32786547","Q32786553","Q32786566","Q32786574","Q32786582","Q32786588","Q32786590","Q32786598","Q32786628","Q32786633","Q32786640","Q32786704","Q32786708","Q32786721","Q32786735","Q32786740","Q32786744","Q32786748","Q32786751","Q32786755","Q32786759","Q32786761","Q32786791","Q32786800","Q32786819","Q32786824","Q32786835","Q32786836","Q32786838","Q32786854","Q32786858","Q32786861","Q32786863","Q32786867","Q32786870","Q32786872","Q32786876","Q32786877","Q32786881","Q32786894","Q32786902","Q32786906","Q32786910","Q32786989","Q32786990","Q32786992","Q32786993","Q32787002","Q32787008","Q32787011","Q32787021","Q32787029","Q32787342","Q32787665","Q32787778","Q32787808","Q32787855","Q32787933","Q32787956","Q32787963","Q32788001","Q32788025","Q32788035","Q32788058","Q32788059","Q32788104","Q32788117","Q32788158","Q32788218","Q32788243","Q32788246","Q32788254","Q32788257","Q32788272","Q32788283","Q32788293","Q32788315","Q32788323","Q32788334","Q32788549","Q32788562","Q32788564","Q32788567","Q32788569","Q32788570","Q32788571","Q32788582","Q32788584","Q32788602","Q32788648","Q32797543","Q32798984","Q32800653","Q32801199","Q32801348","Q32801506","Q32801651","Q32802151","Q32802363","Q32802500","Q32802557","Q32802895","Q32803055","Q32803096","Q32803648","Q32803992","Q32804301","Q32804422","Q32804612","Q32804924","Q32993746","Q32994180","Q32994185","Q32994191","Q32994195","Q32994204","Q32994215","Q32994216","Q32994217","Q32994218","Q32994222","Q32994225","Q32994226","Q32994227","Q32994232","Q32994235","Q32994236","Q32994237","Q32994238","Q32994241","Q32994244","Q32994246","Q32994249","Q32994252","Q32994255","Q32994256","Q32994257","Q32994260","Q32994261","Q32994262","Q32994263","Q32994264","Q32994265","Q32994266","Q32994267","Q32994268","Q32994269","Q32994271","Q32994272","Q32994273","Q32994275","Q32994276","Q32994277","Q32994282","Q32994283","Q32994284","Q32994285","Q32994286","Q32994287","Q32994288","Q32994289","Q32994290","Q32994291","Q32994292","Q32994294","Q32994295","Q32994299","Q32994301","Q32994302","Q32994304","Q32994305","Q32994306","Q32994307","Q32994308","Q32994309","Q32994310","Q32994311","Q32994314","Q32994315","Q32994316","Q32994317","Q32994318","Q32994320","Q32994323","Q32994324","Q32994325","Q32994326","Q32994328","Q32994329","Q32994330","Q32994331","Q32994332","Q32994337","Q32994338","Q32994339","Q32994342","Q32994343","Q32994344","Q32994345","Q32994347","Q32994348","Q32994349","Q32994352","Q32994354","Q32994355","Q32994357","Q32994358","Q32994359","Q32994360","Q32994362","Q32994364","Q32994365","Q32994366","Q32994367","Q32994376","Q32994377","Q32994378","Q32994379","Q32994382","Q32994383","Q32994384","Q32994386","Q32994387","Q32994388","Q32994389","Q32994394","Q32994397","Q32994398","Q32994399","Q32994400","Q32994401","Q32994402","Q32994403","Q32994404","Q32994406","Q32994407","Q32994409","Q32994413","Q32994415","Q32994419","Q32994420","Q32994422","Q32994423","Q32994424","Q32994427","Q32994428","Q32994429","Q32994430","Q32994434","Q32994435","Q32994440","Q32994441","Q32994442","Q32994443","Q32994444","Q32994449","Q32994450","Q32994451","Q32994452","Q32994456","Q32994459","Q32994461","Q32994463","Q32994466","Q32994469","Q32994470","Q32994471","Q32994472","Q32994474","Q32994476","Q32994477","Q32994478","Q32994479","Q32994481","Q32994483","Q32994484","Q32994486","Q32994488","Q32994489","Q32994491","Q32994493","Q32994494","Q32994495","Q32994496","Q32994498","Q32994499","Q32994504","Q32994506","Q32994507","Q32994509","Q32994510","Q32994512","Q32994514","Q32994515","Q32994516","Q32994517","Q32994518","Q32994519","Q32994521","Q32994523","Q32994524","Q32994525","Q32994530","Q32994531","Q32994533","Q32994534","Q32994539","Q32994540","Q32994542","Q32994544","Q32994545","Q32994546","Q32994547","Q32994550","Q32994553","Q32994558","Q32994559","Q32994561","Q32994562","Q32994564","Q32994565","Q32994568","Q32994569","Q32994570","Q32994571","Q32994572","Q32994573","Q32994574","Q32994575","Q32994576","Q32994577","Q32994579","Q32994580","Q32994584","Q32994585","Q32994587","Q32994588","Q32994589","Q32994590","Q32994592","Q32994595","Q32994596","Q32994597","Q32994598","Q32994600","Q32994606","Q32994608","Q32994611","Q32994613","Q32994614","Q32994615","Q32994616","Q32994624","Q32994625","Q32994629","Q32994631","Q32994632","Q32994633","Q32994634","Q32994635","Q32994652","Q32994658","Q32994659","Q32994663","Q32994667","Q32994668","Q32994679","Q32994680","Q32994683","Q32994709","Q32994710","Q32994712","Q32994716","Q32994723","Q32994724","Q32994725","Q32994726","Q32994728","Q32994735","Q32994736","Q32994738","Q32994743","Q32994746","Q32994748","Q32994749","Q32994752","Q32994753","Q32994754","Q32994757","Q32994759","Q32994761","Q32994762","Q32994763","Q32994765","Q32994766","Q32994767","Q32994770","Q32994773","Q32994776","Q32994777","Q32994780","Q32994781","Q32994782","Q32994783","Q32994784","Q32994788","Q32994791","Q32994794","Q32994795","Q32994796","Q32994798","Q32994799","Q32994801","Q32994802","Q32994803","Q32994807","Q32994808","Q32994811","Q32994812","Q32994813","Q32994814","Q32994815","Q32994816","Q32994817","Q32994821","Q32994822","Q32994824","Q32994825","Q32994826","Q32994831","Q32994834","Q32994836","Q32994837","Q32994839","Q32994841","Q32994843","Q32994846","Q32994847","Q32994849","Q32994851","Q32994852","Q32994854","Q32994855","Q32994856","Q32994862","Q32994864","Q32994865","Q32994866","Q32994867","Q32994869","Q32994870","Q32994871","Q32994876","Q32994878","Q32994880","Q32994881","Q32994883","Q32994884","Q32994888","Q32994889","Q32994890","Q32994893","Q32994894","Q32994896","Q32994901","Q32994903","Q32994906","Q32994907","Q32994908","Q32994909","Q32994911","Q32994912","Q32994913","Q32994914","Q32994915","Q32994916","Q32994917","Q32994919","Q32994920","Q32994921","Q32994923","Q32994926","Q32994928","Q32994931","Q32994934","Q32994936","Q32994938","Q32994939","Q32994940","Q32994941","Q32994943","Q32994944","Q32994945","Q32994949","Q32994951","Q32994952","Q32994954","Q32994956","Q32994958","Q32994959","Q32994960","Q32994961","Q32994962","Q32994963","Q32994965","Q32994966","Q32994968","Q32994970","Q32994972","Q32994974","Q32994976","Q32994977","Q32994978","Q32994979","Q32994980","Q32994981","Q32994982","Q32994983","Q32994985","Q32994988","Q32994989","Q32994995","Q32994996","Q32995001","Q32995002","Q32995003","Q32995008","Q32995017","Q32995020","Q32995028","Q32995029","Q32995030","Q32995033","Q32995034","Q32995036","Q32995038","Q32995039","Q32995041","Q32995045","Q32995046","Q32995049","Q32995054","Q32995056","Q32995057","Q32995058","Q32995062","Q32995063","Q32995070","Q32995082","Q32995084","Q32995085","Q32995086","Q32995087","Q32995088","Q32995089","Q32995090","Q32995091","Q32995092","Q32995093","Q32995094","Q32995095","Q32995096","Q32995097","Q32995098","Q32995099","Q32995100","Q32995101","Q32995104","Q32995105","Q32995108","Q32995109","Q32995340","Q32995341","Q32995342","Q32995343","Q32995344","Q32995345","Q32995346","Q32995347","Q32995348","Q32995350","Q32995352","Q32995353","Q32995354","Q32995355","Q32995356","Q32995357","Q32995358","Q32995359","Q32995360","Q32995363","Q32995364","Q32995365","Q32995368","Q32995369","Q32995372","Q32995374","Q32995375","Q32995376","Q32995377","Q32995379","Q32995380","Q32995381","Q32995382","Q32995384","Q32995385","Q32995389","Q32995391","Q32995392","Q32995394","Q32995395","Q32995396","Q32995397","Q32995399","Q32995400","Q32995401","Q32995402","Q32995404","Q32995406","Q32995407","Q32995410","Q32995411","Q32995412","Q32995414","Q32995415","Q32995418","Q32995419","Q32995421","Q32995422","Q32995430","Q32995432","Q32995434","Q32995435","Q32995440","Q32995441","Q32995442","Q32995445","Q32995446","Q32995447","Q32995448","Q32995449","Q32995450","Q32995451","Q32995454","Q32995455","Q32995456","Q32995457","Q32995460","Q32995461","Q32995462","Q32995463","Q32995464","Q32995465","Q32995470","Q32995471","Q32995473","Q32995474","Q32995475","Q32995476","Q32995477","Q32995479","Q32995484","Q32995485","Q32995486","Q32995489","Q32995494","Q32995496","Q32995497","Q32995499","Q32995500","Q32995502","Q32993881","Q32993892","Q32994070","Q32994146","Q32994159","Q32994193","Q32994208","Q32994298","Q32994300","Q32994350","Q32994390","Q32994393","Q32994462","Q32994526","Q32994537","Q32994692","Q32994739","Q32994771","Q32994772","Q32994786","Q32994818","Q32994819","Q32994823","Q32994829","Q32994830","Q32994832","Q32994833","Q32994840","Q32994842","Q32994844","Q32994848","Q32994850","Q32994853","Q32994857","Q32994859","Q32994861","Q32994863","Q32994868","Q32994872","Q32994873","Q32994874","Q32994875","Q32994882","Q32994885","Q32994886","Q32994887","Q32994891","Q32994892","Q32994895","Q32994897","Q32994898","Q32994899","Q32994900","Q32994902","Q32994904","Q32994905","Q32994910","Q32994918","Q32994922","Q32994924","Q32994925","Q32994927","Q32994929","Q32994930","Q32994932","Q32994933","Q32994935","Q32994937","Q32994942","Q32994947","Q32994950","Q32994953","Q32994957","Q32994964","Q32994967","Q32994969","Q32994971","Q32994973","Q32994975","Q32994986","Q32994987","Q32994991","Q32994992","Q32994993","Q32994997","Q32994998","Q32994999","Q32995000","Q32995005","Q32995006","Q32995007","Q32995009","Q32995010","Q32995011","Q32995012","Q32995013","Q32995014","Q32995015","Q32995016","Q32995018","Q32995021","Q32995022","Q32995023","Q32995025","Q32995026","Q32995027","Q32995031","Q32995032","Q32995035","Q32995037","Q32995042","Q32995043","Q32995047","Q32995059","Q32995060","Q32995064","Q32995066","Q32995072","Q32995073","Q32995075","Q32995076","Q32995078","Q32995079","Q32995080","Q32995081")
    )
#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...
