Untitled query #64023

This query is marked as a draft This query has been published by Mahir256.
SQL

SELECT DISTINCT lt_title#, COUNT(*)
FROM pagelinks
LEFT JOIN linktarget ON pl_target_id = lt_id
WHERE
	pl_from_namespace IN (0, 120, 146)
	AND lt_namespace IN (0, 120, 146)
	AND lt_title in ("Q127502251","Q127437675","Q127427646","Q127387218","Q127385601","Q127346896","Q127328707","Q127325071","Q127255804","Q127244520","Q127166858","Q127166596","Q127166144","Q127163579","Q127029047","Q127001803","Q126973163","Q126956639","Q126910968","Q126737774","Q126436997","Q126430524","Q126375349","Q126375313","Q126375301",
"Q126375240","Q126375182","Q126375165","Q126375142","Q126375121","Q126375101","Q126375098","Q126375082","Q126372568","Q126091263","Q126088034","Q125965044","Q125928519","Q125867729","Q125867719","Q125867139","Q125867132","Q125448267","Q125448246","Q125439251","Q125434162","Q125434120","Q125228960","Q125086068","Q125086067",
"Q125086066","Q125086063","Q125062128","Q124982337","Q124901682","Q124901681","Q124901669","Q124901665","Q124901664","Q124892832","Q124892829","Q124892826","Q124892822","Q124892793","Q124798888","Q124650422","Q123385242","Q122719383","Q122715290","Q122692710","Q122692404","Q122692342","Q122691129","Q122690691","Q122690100",
"Q122689784","Q122689520","Q122195966","Q121767526","Q121762580","Q121599259","Q120828169","Q120762754","Q120762579","Q120092825","Q120092583","Q118868863","Q118868744","Q118235198","Q118210266","Q118210247","Q118162180","Q118162179","Q117260907","Q117229311","Q117025197","Q116764508","Q116693533","Q114369509","Q113119465",
"Q113005611","Q111985664","Q111837319","Q111540684","Q111540667","Q110264969","Q109617650","Q109527092","Q109369866","Q109369864","Q109369863","Q109369862","Q109369860","Q109369801","Q109369789","Q109369788","Q109369786","Q109369784","Q108377297","Q108133759","Q106698171","Q105942866","Q105836027","Q105836008","Q105686354",
"Q105686352","Q105686351","Q105686350","Q105686349","Q105529679","Q105529677","Q105529673","Q105529670","Q105529661","Q105529657","Q105529651","Q105529650","Q105529647","Q105529645","Q105529553","Q105502379","Q105498203","Q105497338","Q105490102","Q105483313","Q105474462","Q105474279","Q105453428","Q105450336","Q105448156",
"Q105445881","Q105445496","Q105445477","Q105445453","Q105444745","Q105444446","Q105443783","Q105442546","Q105440749","Q105440564","Q105439887","Q105439169","Q105438161","Q105437977","Q105437166","Q105435996","Q105434195","Q105433199","Q105432210","Q105431356","Q105430803","Q105428098","Q105427539","Q105423633","Q105421700",
"Q105419923","Q105410482","Q105387412","Q105364953","Q105339126","Q105334536","Q105333445","Q105326205","Q105324314","Q105319167","Q105319020","Q105316871","Q105316211","Q105305946","Q105294747","Q105291401","Q105286229","Q105285816","Q105252498","Q105250537","Q105208171","Q104632150","Q104587497","Q104551498","Q100326418",
"Q97405802","Q95612343","Q95177060","Q86804868","Q86780179","Q86777800","Q86229573","Q83639781","Q80345070","Q79878540","Q77436895","Q73018099","Q65787679","Q65671358","Q65650904","Q65636510","Q61267270","Q61263065","Q61263064","Q61263062","Q61263060","Q61263057","Q61263056","Q61263054","Q61263053",
"Q61263050","Q61263048","Q61263047","Q61263044","Q61263043","Q61263042","Q61263039","Q61263038","Q61263037","Q61263034","Q61263032","Q61263030","Q61263029","Q61263026","Q61263025","Q61263023","Q61263021","Q61263019","Q61263018","Q61263016","Q61263012","Q61263011","Q61263007","Q61263005","Q61263003",
"Q61263001","Q61262999","Q61262997","Q61262996","Q61262994","Q61262991","Q61262989","Q61262987","Q61262985","Q61262766","Q61262751","Q61234082","Q61211095","Q61198655","Q61198652","Q61012482","Q61005447","Q60909149","Q60772656","Q60588777","Q55976212","Q55928197","Q55928196","Q55326496","Q55248724",
"Q52703793","Q49882403","Q49878648","Q49766060","Q49659786","Q46395073","Q45291660","Q37674993","Q37666271","Q37657259","Q37652902","Q37646405","Q33014528","Q32951079","Q32949849","Q32889918","Q32878083","Q32872062","Q32734577","Q32721275","Q32702430","Q32667723","Q32611576","Q32435761","Q32393344",
"Q32359814","Q32347151","Q32344704","Q32153733","Q32153566","Q32153081","Q32152145","Q32102217","Q32088445","Q32084654","Q32083215","Q32083211","Q32083207","Q32083052","Q32083049","Q32083044","Q32082773","Q32082770","Q32082641","Q32082638","Q32082461","Q30825962","Q30822858","Q30735443","Q30677069",
"Q30677025","Q30676960","Q30676785","Q30676403","Q30675934","Q30674674","Q29351763","Q29108900","Q29108899","Q28046020","Q27978404","Q27901351","Q27901171","Q27899715","Q27672197","Q27599451","Q26465682","Q25972207","Q25972055","Q25867044","Q25867005","Q25865897","Q25814449","Q25814394","Q25814322",
"Q25814318","Q25337900","Q25337848","Q25331012","Q25330984","Q25330815","Q25330731","Q25330711","Q25330404","Q25330052","Q25310835","Q25216399","Q25203090","Q25200767","Q25088093","Q25077521","Q25073293","Q25065079","Q25065073","Q25065070","Q25065049","Q25065041","Q25065038","Q25065037","Q25065030",
"Q25065029","Q25065028","Q25044189","Q25044185","Q25044182","Q25044180","Q25044176","Q25044175","Q25032494","Q25025975","Q25007850","Q24994369","Q24973643","Q24875973","Q24544719","Q23983645","Q22166265","Q21292663","Q18754997","Q17336864","Q16005100","Q15958784","Q15205730","Q15147121","Q15131292",
"Q13306335","Q13278359","Q10244208","Q10231756","Q10151964","Q10141736","Q10106244","Q10058405","Q10035945","Q9951611","Q9831044","Q9819379","Q9660555","Q9495718","Q9432764","Q9235311","Q9235310","Q9235307","Q9235306","Q9235304","Q9235298","Q9235296","Q9235295","Q9235294","Q9235203",
"Q9235202","Q9235199","Q9235198","Q9235196","Q9235189","Q9235188","Q9221841","Q9170063","Q9147819","Q9100545","Q9100254","Q9099447","Q9010915","Q9010268","Q9009523","Q9007627","Q9005684","Q8993082","Q8947052","Q8925737","Q8915276","Q8915273","Q8893171","Q8885397","Q8858758",
"Q8838668","Q8819774","Q8810828","Q8795784","Q8784464","Q8759194","Q8722226","Q8722111","Q8722072","Q8690620","Q8689234","Q8678142","Q8672283","Q8658563","Q8656163","Q8625616","Q8603788","Q8592001","Q8562131","Q8561203","Q8516031","Q8516030","Q8509516","Q8476641","Q8467319",
"Q8449520","Q8438437","Q8432935","Q8389495","Q8377864","Q8347548","Q8331387","Q8306902","Q8297862","Q8282337","Q8276856","Q8276078","Q8250583","Q8250580","Q8214455","Q8070243","Q7886298","Q7473119","Q7473115","Q7471095","Q7469790","Q7466553","Q7466550","Q7466549","Q7458575",
"Q7006079","Q6586767","Q6232557"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q127502251","Q127437675","Q127427646","Q127387218","Q127385601","Q127346896","Q127328707","Q127325071","Q127255804","Q127244520","Q127166858","Q127166596","Q127166144","Q127163579","Q127029047","Q127001803","Q126973163","Q126956639","Q126910968","Q126737774","Q126436997","Q126430524","Q126375349","Q126375313","Q126375301",
"Q126375240","Q126375182","Q126375165","Q126375142","Q126375121","Q126375101","Q126375098","Q126375082","Q126372568","Q126091263","Q126088034","Q125965044","Q125928519","Q125867729","Q125867719","Q125867139","Q125867132","Q125448267","Q125448246","Q125439251","Q125434162","Q125434120","Q125228960","Q125086068","Q125086067",
"Q125086066","Q125086063","Q125062128","Q124982337","Q124901682","Q124901681","Q124901669","Q124901665","Q124901664","Q124892832","Q124892829","Q124892826","Q124892822","Q124892793","Q124798888","Q124650422","Q123385242","Q122719383","Q122715290","Q122692710","Q122692404","Q122692342","Q122691129","Q122690691","Q122690100",
"Q122689784","Q122689520","Q122195966","Q121767526","Q121762580","Q121599259","Q120828169","Q120762754","Q120762579","Q120092825","Q120092583","Q118868863","Q118868744","Q118235198","Q118210266","Q118210247","Q118162180","Q118162179","Q117260907","Q117229311","Q117025197","Q116764508","Q116693533","Q114369509","Q113119465",
"Q113005611","Q111985664","Q111837319","Q111540684","Q111540667","Q110264969","Q109617650","Q109527092","Q109369866","Q109369864","Q109369863","Q109369862","Q109369860","Q109369801","Q109369789","Q109369788","Q109369786","Q109369784","Q108377297","Q108133759","Q106698171","Q105942866","Q105836027","Q105836008","Q105686354",
"Q105686352","Q105686351","Q105686350","Q105686349","Q105529679","Q105529677","Q105529673","Q105529670","Q105529661","Q105529657","Q105529651","Q105529650","Q105529647","Q105529645","Q105529553","Q105502379","Q105498203","Q105497338","Q105490102","Q105483313","Q105474462","Q105474279","Q105453428","Q105450336","Q105448156",
"Q105445881","Q105445496","Q105445477","Q105445453","Q105444745","Q105444446","Q105443783","Q105442546","Q105440749","Q105440564","Q105439887","Q105439169","Q105438161","Q105437977","Q105437166","Q105435996","Q105434195","Q105433199","Q105432210","Q105431356","Q105430803","Q105428098","Q105427539","Q105423633","Q105421700",
"Q105419923","Q105410482","Q105387412","Q105364953","Q105339126","Q105334536","Q105333445","Q105326205","Q105324314","Q105319167","Q105319020","Q105316871","Q105316211","Q105305946","Q105294747","Q105291401","Q105286229","Q105285816","Q105252498","Q105250537","Q105208171","Q104632150","Q104587497","Q104551498","Q100326418",
"Q97405802","Q95612343","Q95177060","Q86804868","Q86780179","Q86777800","Q86229573","Q83639781","Q80345070","Q79878540","Q77436895","Q73018099","Q65787679","Q65671358","Q65650904","Q65636510","Q61267270","Q61263065","Q61263064","Q61263062","Q61263060","Q61263057","Q61263056","Q61263054","Q61263053",
"Q61263050","Q61263048","Q61263047","Q61263044","Q61263043","Q61263042","Q61263039","Q61263038","Q61263037","Q61263034","Q61263032","Q61263030","Q61263029","Q61263026","Q61263025","Q61263023","Q61263021","Q61263019","Q61263018","Q61263016","Q61263012","Q61263011","Q61263007","Q61263005","Q61263003",
"Q61263001","Q61262999","Q61262997","Q61262996","Q61262994","Q61262991","Q61262989","Q61262987","Q61262985","Q61262766","Q61262751","Q61234082","Q61211095","Q61198655","Q61198652","Q61012482","Q61005447","Q60909149","Q60772656","Q60588777","Q55976212","Q55928197","Q55928196","Q55326496","Q55248724",
"Q52703793","Q49882403","Q49878648","Q49766060","Q49659786","Q46395073","Q45291660","Q37674993","Q37666271","Q37657259","Q37652902","Q37646405","Q33014528","Q32951079","Q32949849","Q32889918","Q32878083","Q32872062","Q32734577","Q32721275","Q32702430","Q32667723","Q32611576","Q32435761","Q32393344",
"Q32359814","Q32347151","Q32344704","Q32153733","Q32153566","Q32153081","Q32152145","Q32102217","Q32088445","Q32084654","Q32083215","Q32083211","Q32083207","Q32083052","Q32083049","Q32083044","Q32082773","Q32082770","Q32082641","Q32082638","Q32082461","Q30825962","Q30822858","Q30735443","Q30677069",
"Q30677025","Q30676960","Q30676785","Q30676403","Q30675934","Q30674674","Q29351763","Q29108900","Q29108899","Q28046020","Q27978404","Q27901351","Q27901171","Q27899715","Q27672197","Q27599451","Q26465682","Q25972207","Q25972055","Q25867044","Q25867005","Q25865897","Q25814449","Q25814394","Q25814322",
"Q25814318","Q25337900","Q25337848","Q25331012","Q25330984","Q25330815","Q25330731","Q25330711","Q25330404","Q25330052","Q25310835","Q25216399","Q25203090","Q25200767","Q25088093","Q25077521","Q25073293","Q25065079","Q25065073","Q25065070","Q25065049","Q25065041","Q25065038","Q25065037","Q25065030",
"Q25065029","Q25065028","Q25044189","Q25044185","Q25044182","Q25044180","Q25044176","Q25044175","Q25032494","Q25025975","Q25007850","Q24994369","Q24973643","Q24875973","Q24544719","Q23983645","Q22166265","Q21292663","Q18754997","Q17336864","Q16005100","Q15958784","Q15205730","Q15147121","Q15131292",
"Q13306335","Q13278359","Q10244208","Q10231756","Q10151964","Q10141736","Q10106244","Q10058405","Q10035945","Q9951611","Q9831044","Q9819379","Q9660555","Q9495718","Q9432764","Q9235311","Q9235310","Q9235307","Q9235306","Q9235304","Q9235298","Q9235296","Q9235295","Q9235294","Q9235203",
"Q9235202","Q9235199","Q9235198","Q9235196","Q9235189","Q9235188","Q9221841","Q9170063","Q9147819","Q9100545","Q9100254","Q9099447","Q9010915","Q9010268","Q9009523","Q9007627","Q9005684","Q8993082","Q8947052","Q8925737","Q8915276","Q8915273","Q8893171","Q8885397","Q8858758",
"Q8838668","Q8819774","Q8810828","Q8795784","Q8784464","Q8759194","Q8722226","Q8722111","Q8722072","Q8690620","Q8689234","Q8678142","Q8672283","Q8658563","Q8656163","Q8625616","Q8603788","Q8592001","Q8562131","Q8561203","Q8516031","Q8516030","Q8509516","Q8476641","Q8467319",
"Q8449520","Q8438437","Q8432935","Q8389495","Q8377864","Q8347548","Q8331387","Q8306902","Q8297862","Q8282337","Q8276856","Q8276078","Q8250583","Q8250580","Q8214455","Q8070243","Q7886298","Q7473119","Q7473115","Q7471095","Q7469790","Q7466553","Q7466550","Q7466549","Q7458575",
"Q7006079","Q6586767","Q6232557"
)
    )
#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...
