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 ("Q10229991","Q15263695","Q15263845","Q15263857","Q15263876","Q16811477","Q32786719","Q32800665","Q32801931","Q32803102","Q32804124","Q32994497","Q8533816","Q8533825","Q8533874","Q8533875","Q8533882","Q8533890","Q8533915","Q8533930","Q8533951","Q8533959","Q8533960","Q8533962","Q8533963","Q8533965","Q8533968","Q8533970","Q8533971","Q8533972","Q8533999","Q8534014","Q8534015","Q8534033","Q8534039","Q8534056","Q8534064","Q8534072","Q8534076","Q8534081","Q8534092","Q8534108","Q8534109","Q8534128","Q8534129","Q8534140","Q8534177","Q8534186","Q8534241","Q8534260","Q8534268","Q8534288","Q8534307","Q8534308","Q8534334","Q8534345","Q8534374","Q8534398","Q8534421","Q8534450","Q8534460","Q8534461","Q8534479","Q8534500","Q8534515","Q8534516","Q8534518","Q8534519","Q8534567","Q8534569","Q8534577","Q8534627","Q8534629","Q8534654","Q8534721","Q8534739","Q8534748","Q8534749","Q8534751","Q8534758","Q8534765","Q8534772","Q8534791","Q8534792","Q8534793","Q8534823","Q8534882","Q8534883","Q8534889","Q8534934","Q8534935","Q8534936","Q8534943","Q8535001","Q8535090","Q8535091","Q8535113","Q8535141","Q8535155","Q8535193","Q8535208","Q8535209","Q8535216","Q8535247","Q8535293","Q8535301","Q8535309","Q8535310","Q8535327","Q8535330","Q8535336","Q8535337","Q8535346","Q8535347","Q8535360","Q8535366","Q8535370","Q8535375","Q8535378","Q8535392","Q8535393","Q8535414","Q8535455","Q8535490","Q8535535","Q8535589","Q8535616","Q8535617","Q8535620","Q8535627","Q8535642","Q8535698","Q8535733","Q8535770","Q8535800","Q8535859","Q8535866","Q8535878","Q8535900","Q8535903","Q8535912","Q8535964","Q8535975","Q8535976","Q8535977","Q8536025","Q8536027","Q8536037","Q8536083","Q8536126","Q8536135","Q8536171","Q8536191","Q8536213","Q8536245","Q8536262","Q8536266","Q8536272","Q8536273","Q8536282","Q8536283","Q8536309","Q8536327","Q8536328","Q8536342","Q8536348","Q8536387","Q8536403","Q8536408","Q8536447","Q8536502","Q8536534","Q8536543","Q8536568","Q8536570","Q8536572","Q8536575","Q8536580","Q8536612","Q8536615","Q8536617","Q8536623","Q8536640","Q8536676","Q8536679","Q8536744","Q8536752","Q8536759","Q8536764","Q8536767","Q8536795","Q8536821","Q8536822","Q8536823","Q8536825","Q8536869","Q8536885","Q8536916","Q8536921","Q8536922","Q8536924","Q8536965","Q8536970","Q8536971","Q8537000","Q8537064","Q8537087","Q8537171","Q8537187","Q8537192","Q8537199","Q8537223","Q8537302","Q8537335","Q8537337","Q8537338","Q8537342","Q8537353","Q8537379","Q8537394","Q8537420","Q8537453","Q8537491","Q8537537","Q8537540","Q8537547","Q8537579","Q8537592","Q8537619","Q8537648","Q8537685","Q8537706","Q8537720","Q8537721","Q8537732","Q8537737","Q8537756","Q8537758","Q8537787","Q8537815","Q8537821","Q8537835","Q8537866","Q8537881","Q8537895","Q8537917","Q8537943","Q8537961","Q8537962","Q8537985","Q8537986","Q8538019","Q8538020","Q8538024","Q8538041","Q8538042","Q8538067","Q8538076","Q8538084","Q8538109","Q8538125","Q8538128","Q8538139","Q8538140","Q8538143","Q8538156","Q8538167","Q8538187","Q8538194","Q8538201","Q8538232","Q8538335","Q8538337","Q8538344","Q8538356","Q8538363","Q8538383","Q8538408","Q8538437","Q8538446","Q8538503","Q8538512","Q8538523","Q8538556","Q8538576","Q8538585","Q8538586","Q8538588","Q8538589","Q8538591","Q8538594","Q8538597","Q8538598","Q8538628","Q8538643","Q8538644","Q8538656","Q8538662","Q8538698","Q8538707","Q8538711","Q8538716","Q8538747","Q8538766","Q8538768","Q8538769","Q8538780","Q8538826","Q8538903","Q8538911","Q8538949","Q8538950","Q8538976","Q8539019","Q8539044","Q8539102","Q8539103","Q8539120","Q8539129","Q8539138","Q8539154","Q8539158","Q8539179","Q8539206","Q8539217","Q8539269","Q8539295","Q8539321","Q8539361","Q8539379","Q8539387","Q8539388","Q8539390","Q8539396","Q8539411","Q8539443","Q8539466","Q8539467","Q8539521","Q8539522","Q8540744","Q8540746","Q8540763","Q8540775","Q8540788","Q8540790","Q8540793","Q8540795","Q8540810","Q8540818","Q8540839","Q8540854","Q8540855","Q8540859","Q8540861","Q8540891","Q8540902","Q8540995","Q8540996","Q8541032","Q8541082","Q8541084","Q8541088","Q8541089","Q8541093","Q8541096","Q8541100","Q8541101","Q8541104","Q8541108","Q8541114","Q8541122","Q8541124","Q8541129","Q8541139","Q8541149","Q8541152","Q8541160","Q8541164","Q8541172","Q8541173","Q8541189","Q8541192","Q8541193","Q8541198","Q8541207","Q8541216","Q8541238","Q8541248","Q8541249","Q8541252","Q8541274","Q8541281","Q8541282","Q8541285","Q8541318","Q8541325","Q8541328","Q8541329","Q8541333","Q8541337","Q8541345","Q8541346","Q8541357","Q8541358","Q8541364","Q8541380","Q8541381","Q8541382","Q8541383","Q8541384","Q8541385","Q8541395","Q8541409","Q8541416","Q8541434","Q8541442","Q8541449","Q8541453","Q8541469","Q8541470","Q8541479","Q8541481","Q8541489","Q8541496","Q8541497","Q8541507","Q8541510","Q8541514","Q8541521","Q8541522","Q8541548","Q8541550","Q8541566","Q8541583","Q8541584","Q8541587","Q8541598","Q8541606","Q8541609","Q8541629","Q8541679","Q8541692","Q8541708","Q8541709","Q8541717","Q8541723","Q8541727","Q8541734","Q8541735","Q8541747","Q8541757","Q8541761","Q8541763","Q8541766","Q8541767","Q8541832","Q8541844","Q8541851","Q8541852","Q8541862","Q8541865","Q8541866","Q8541867","Q8541868","Q8541872","Q8541883","Q8541904","Q8541907","Q8541908","Q8541911","Q8541912","Q8541913","Q8541922","Q8541927","Q8541945","Q8541958","Q8541971","Q8541976","Q8541977","Q8541994","Q8542001","Q8542006","Q8542008","Q8542015","Q8542060","Q8542062","Q8542063","Q8542065","Q8542067","Q8542070","Q8542081","Q8542114","Q8542128","Q8542138","Q8542140","Q8542145","Q8542187","Q8542220","Q8542231","Q8542275","Q8542299","Q8542321","Q8542367","Q8542370","Q8542373","Q8542377","Q8542383","Q8542406","Q8542408","Q8542425","Q8542435","Q8542467","Q8542475","Q8542476","Q8542478","Q8542497","Q8542533","Q8542534","Q8542542","Q8542556","Q8542583","Q8542610","Q8542612","Q8542691","Q8542705","Q8542706","Q8542707","Q8542711","Q8542719","Q8542759","Q8542760","Q8542761","Q8542762","Q8542765","Q8542766","Q8542777")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q10229991","Q15263695","Q15263845","Q15263857","Q15263876","Q16811477","Q32786719","Q32800665","Q32801931","Q32803102","Q32804124","Q32994497","Q8533816","Q8533825","Q8533874","Q8533875","Q8533882","Q8533890","Q8533915","Q8533930","Q8533951","Q8533959","Q8533960","Q8533962","Q8533963","Q8533965","Q8533968","Q8533970","Q8533971","Q8533972","Q8533999","Q8534014","Q8534015","Q8534033","Q8534039","Q8534056","Q8534064","Q8534072","Q8534076","Q8534081","Q8534092","Q8534108","Q8534109","Q8534128","Q8534129","Q8534140","Q8534177","Q8534186","Q8534241","Q8534260","Q8534268","Q8534288","Q8534307","Q8534308","Q8534334","Q8534345","Q8534374","Q8534398","Q8534421","Q8534450","Q8534460","Q8534461","Q8534479","Q8534500","Q8534515","Q8534516","Q8534518","Q8534519","Q8534567","Q8534569","Q8534577","Q8534627","Q8534629","Q8534654","Q8534721","Q8534739","Q8534748","Q8534749","Q8534751","Q8534758","Q8534765","Q8534772","Q8534791","Q8534792","Q8534793","Q8534823","Q8534882","Q8534883","Q8534889","Q8534934","Q8534935","Q8534936","Q8534943","Q8535001","Q8535090","Q8535091","Q8535113","Q8535141","Q8535155","Q8535193","Q8535208","Q8535209","Q8535216","Q8535247","Q8535293","Q8535301","Q8535309","Q8535310","Q8535327","Q8535330","Q8535336","Q8535337","Q8535346","Q8535347","Q8535360","Q8535366","Q8535370","Q8535375","Q8535378","Q8535392","Q8535393","Q8535414","Q8535455","Q8535490","Q8535535","Q8535589","Q8535616","Q8535617","Q8535620","Q8535627","Q8535642","Q8535698","Q8535733","Q8535770","Q8535800","Q8535859","Q8535866","Q8535878","Q8535900","Q8535903","Q8535912","Q8535964","Q8535975","Q8535976","Q8535977","Q8536025","Q8536027","Q8536037","Q8536083","Q8536126","Q8536135","Q8536171","Q8536191","Q8536213","Q8536245","Q8536262","Q8536266","Q8536272","Q8536273","Q8536282","Q8536283","Q8536309","Q8536327","Q8536328","Q8536342","Q8536348","Q8536387","Q8536403","Q8536408","Q8536447","Q8536502","Q8536534","Q8536543","Q8536568","Q8536570","Q8536572","Q8536575","Q8536580","Q8536612","Q8536615","Q8536617","Q8536623","Q8536640","Q8536676","Q8536679","Q8536744","Q8536752","Q8536759","Q8536764","Q8536767","Q8536795","Q8536821","Q8536822","Q8536823","Q8536825","Q8536869","Q8536885","Q8536916","Q8536921","Q8536922","Q8536924","Q8536965","Q8536970","Q8536971","Q8537000","Q8537064","Q8537087","Q8537171","Q8537187","Q8537192","Q8537199","Q8537223","Q8537302","Q8537335","Q8537337","Q8537338","Q8537342","Q8537353","Q8537379","Q8537394","Q8537420","Q8537453","Q8537491","Q8537537","Q8537540","Q8537547","Q8537579","Q8537592","Q8537619","Q8537648","Q8537685","Q8537706","Q8537720","Q8537721","Q8537732","Q8537737","Q8537756","Q8537758","Q8537787","Q8537815","Q8537821","Q8537835","Q8537866","Q8537881","Q8537895","Q8537917","Q8537943","Q8537961","Q8537962","Q8537985","Q8537986","Q8538019","Q8538020","Q8538024","Q8538041","Q8538042","Q8538067","Q8538076","Q8538084","Q8538109","Q8538125","Q8538128","Q8538139","Q8538140","Q8538143","Q8538156","Q8538167","Q8538187","Q8538194","Q8538201","Q8538232","Q8538335","Q8538337","Q8538344","Q8538356","Q8538363","Q8538383","Q8538408","Q8538437","Q8538446","Q8538503","Q8538512","Q8538523","Q8538556","Q8538576","Q8538585","Q8538586","Q8538588","Q8538589","Q8538591","Q8538594","Q8538597","Q8538598","Q8538628","Q8538643","Q8538644","Q8538656","Q8538662","Q8538698","Q8538707","Q8538711","Q8538716","Q8538747","Q8538766","Q8538768","Q8538769","Q8538780","Q8538826","Q8538903","Q8538911","Q8538949","Q8538950","Q8538976","Q8539019","Q8539044","Q8539102","Q8539103","Q8539120","Q8539129","Q8539138","Q8539154","Q8539158","Q8539179","Q8539206","Q8539217","Q8539269","Q8539295","Q8539321","Q8539361","Q8539379","Q8539387","Q8539388","Q8539390","Q8539396","Q8539411","Q8539443","Q8539466","Q8539467","Q8539521","Q8539522","Q8540744","Q8540746","Q8540763","Q8540775","Q8540788","Q8540790","Q8540793","Q8540795","Q8540810","Q8540818","Q8540839","Q8540854","Q8540855","Q8540859","Q8540861","Q8540891","Q8540902","Q8540995","Q8540996","Q8541032","Q8541082","Q8541084","Q8541088","Q8541089","Q8541093","Q8541096","Q8541100","Q8541101","Q8541104","Q8541108","Q8541114","Q8541122","Q8541124","Q8541129","Q8541139","Q8541149","Q8541152","Q8541160","Q8541164","Q8541172","Q8541173","Q8541189","Q8541192","Q8541193","Q8541198","Q8541207","Q8541216","Q8541238","Q8541248","Q8541249","Q8541252","Q8541274","Q8541281","Q8541282","Q8541285","Q8541318","Q8541325","Q8541328","Q8541329","Q8541333","Q8541337","Q8541345","Q8541346","Q8541357","Q8541358","Q8541364","Q8541380","Q8541381","Q8541382","Q8541383","Q8541384","Q8541385","Q8541395","Q8541409","Q8541416","Q8541434","Q8541442","Q8541449","Q8541453","Q8541469","Q8541470","Q8541479","Q8541481","Q8541489","Q8541496","Q8541497","Q8541507","Q8541510","Q8541514","Q8541521","Q8541522","Q8541548","Q8541550","Q8541566","Q8541583","Q8541584","Q8541587","Q8541598","Q8541606","Q8541609","Q8541629","Q8541679","Q8541692","Q8541708","Q8541709","Q8541717","Q8541723","Q8541727","Q8541734","Q8541735","Q8541747","Q8541757","Q8541761","Q8541763","Q8541766","Q8541767","Q8541832","Q8541844","Q8541851","Q8541852","Q8541862","Q8541865","Q8541866","Q8541867","Q8541868","Q8541872","Q8541883","Q8541904","Q8541907","Q8541908","Q8541911","Q8541912","Q8541913","Q8541922","Q8541927","Q8541945","Q8541958","Q8541971","Q8541976","Q8541977","Q8541994","Q8542001","Q8542006","Q8542008","Q8542015","Q8542060","Q8542062","Q8542063","Q8542065","Q8542067","Q8542070","Q8542081","Q8542114","Q8542128","Q8542138","Q8542140","Q8542145","Q8542187","Q8542220","Q8542231","Q8542275","Q8542299","Q8542321","Q8542367","Q8542370","Q8542373","Q8542377","Q8542383","Q8542406","Q8542408","Q8542425","Q8542435","Q8542467","Q8542475","Q8542476","Q8542478","Q8542497","Q8542533","Q8542534","Q8542542","Q8542556","Q8542583","Q8542610","Q8542612","Q8542691","Q8542705","Q8542706","Q8542707","Q8542711","Q8542719","Q8542759","Q8542760","Q8542761","Q8542762","Q8542765","Q8542766","Q8542777")
    )
#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...
