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 (
"Q6167027","Q6177071","Q6180172","Q6194651","Q6206424","Q6273555","Q6294314","Q6316948","Q7025491","Q7840432","Q7937258","Q8152702","Q8153866","Q8154420","Q8156208","Q8158030","Q8158699","Q8159292","Q8159936","Q8160522","Q8161185","Q8161857","Q8162503","Q8163164","Q8164649",
"Q8166624","Q8168056","Q8168767","Q8169468","Q8170398","Q8171150","Q8172732","Q8173516","Q8174370","Q8175163","Q8177019","Q8178043","Q8178924","Q8179895","Q8189497","Q8190958","Q8243071","Q8282258","Q8319261","Q8334281","Q8377882","Q8377883","Q8377880","Q8377881","Q8377886",
"Q8377885","Q8432975","Q8438468","Q8441550","Q8441554","Q8441552","Q8441553","Q8441558","Q8441556","Q8449534","Q8449535","Q8449539","Q8449536","Q8449537","Q8449540","Q8476671","Q8533510","Q8557790","Q8575498","Q8586649","Q8676979","Q8680820","Q8784478","Q8784482","Q8784480",
"Q8795802","Q8795800","Q8795806","Q8819809","Q8838703","Q8838706","Q8838710","Q8838708","Q8838714","Q8838717","Q8918475","Q8971737","Q8973746","Q8973747","Q8977254","Q8989851","Q9090378","Q9093507","Q9102023","Q9112456","Q9125319","Q9129052","Q9146069","Q9416968","Q9422233",
"Q9454142","Q9490121","Q9506388","Q9522646","Q9525751","Q9538206","Q9601149","Q9607015","Q9630471","Q9630500","Q9630645","Q9630660","Q9697867","Q9697970","Q9697968","Q9697972","Q9699073","Q9714259","Q9716984","Q9730405","Q9731396","Q9734788","Q9739414","Q9743299","Q9752948",
"Q9783670","Q9788018","Q9809994","Q9810056","Q9810109","Q9817556","Q9842531","Q9842845","Q9844240","Q9845107","Q9865306","Q9869185","Q9872160","Q9888168","Q9897677","Q9982153","Q9991653","Q10005653","Q10005689","Q10013566","Q10022193","Q10034093","Q10054008","Q10073471","Q10078738",
"Q10106244","Q10136197","Q10141172","Q10144809","Q10159667","Q10159886","Q10161624","Q10170798","Q10179387","Q10190818","Q10253745","Q10259904","Q10738413","Q10811274","Q10832241","Q13276608","Q13287727","Q13287728","Q13288925","Q13334781","Q13338048","Q13338106","Q13338107","Q13338104","Q13338119",
"Q13338116","Q13338120","Q13348863","Q15252778","Q15257270","Q15264390","Q15295317","Q15296655","Q15296658","Q15358011","Q15950308","Q15955624","Q15960728","Q16500883","Q16809067","Q17162860","Q17162935","Q17163012","Q17273534","Q17303777","Q17391430","Q17391434","Q17391433","Q17391442","Q17391447",
"Q17391451","Q17391449","Q18012997","Q18328687","Q18328685","Q18328688","Q18328693","Q18328720","Q18727929","Q18744141","Q19331728","Q19593290","Q20643587","Q20654345","Q20705447","Q20878320","Q20947421","Q20965118","Q21175995","Q21292663","Q22266811","Q22685756","Q23927670","Q23927668","Q24870058",
"Q24872347","Q24875707","Q24875973","Q24917097","Q25142022","Q25333150","Q25336005","Q25341470","Q25349619","Q25362191","Q25937094","Q25937108","Q25937109","Q25938274","Q25938273","Q25972405","Q25974254","Q26467691","Q26833224","Q26925981","Q27069925","Q27218112","Q27311046","Q27311045","Q27311048",
"Q27311077","Q27311082","Q27311132","Q27311138","Q27311136","Q27311151","Q27311148","Q27493160","Q27819693","Q27886228","Q28697367","Q28814334","Q29790297","Q30070913","Q30628856","Q30690341","Q30718011","Q30738907","Q30767866","Q30817338","Q30994303","Q31014039","Q31058319","Q31070014","Q31089168",
"Q31101133","Q31168728","Q31883453","Q31934170","Q31934171","Q31934169","Q31934174","Q31952145","Q31987083","Q31987084","Q31992241","Q31992271","Q31993706","Q32018642","Q32032598","Q32032603","Q32032601","Q32032615","Q32032612","Q32032613","Q32032616","Q32032624","Q32032625","Q32032638","Q32032639",
"Q32032640","Q32039305","Q32040421","Q32040442","Q32040448","Q32040454","Q32040548","Q32040549","Q32040616","Q32040635","Q32040648","Q32040649","Q32040654","Q32042647","Q32082527","Q32084796","Q32085064","Q32085092","Q32105858","Q32131357","Q32152145","Q32153081","Q32153566","Q32153733","Q32225661",
"Q32238960","Q32242776","Q32249198","Q32336829","Q32339496","Q32339502","Q32339505","Q32339511","Q32341597","Q32348059","Q32359814","Q32363476","Q32366400","Q32438519","Q32438523","Q32442790","Q32458229","Q32464568","Q32472756","Q32472778","Q32499985","Q32512912","Q32534992","Q32568586","Q32572719",
"Q32572949","Q32590049","Q32590056","Q32590062","Q32590107","Q32590126","Q32590133","Q32590158","Q32590201","Q32590224","Q32590244","Q32590282","Q32590308","Q32590326","Q32590424","Q32590458","Q32598341","Q32609484","Q32638018","Q32651997","Q32660718","Q32671189","Q32682242","Q32688199","Q32700756",
"Q32700783","Q32701883","Q32709377","Q32717180","Q32719754","Q32809481","Q32821711","Q32876411","Q32890532","Q32890543","Q32904505","Q32914024","Q32914873","Q32929555","Q32962571","Q32962624","Q33016358","Q33016486","Q33019776","Q33030762","Q33037170","Q33037215","Q33037218","Q33037216","Q33037234",
"Q33037287","Q33046500","Q33062493","Q33062667","Q33090329","Q33090388","Q33117699","Q33117719","Q33119616","Q33127688","Q33133059","Q33133060","Q33670887","Q33676041","Q34202865","Q34221450","Q34222664","Q34222684","Q34519295","Q34531380","Q34585783","Q35453736","Q35466421","Q35469036","Q35469088",
"Q35632715","Q35632712","Q36050029","Q36051481","Q36116695","Q36116692","Q36151731","Q36775445","Q37650498","Q37654285","Q37654715","Q37654861","Q37654935","Q37655010","Q37655039","Q37656073","Q37656976","Q37658382","Q37664501","Q37664994","Q37665003","Q37665377","Q37666878","Q37667496","Q37668204",
"Q37673999","Q39417742","Q41539642","Q44618126","Q44619018","Q44731708","Q47014562","Q47212162","Q47483653","Q48479401","Q49661014","Q49678927","Q49780370","Q49931872","Q50312206","Q52232939","Q55246700","Q55277067","Q55921402","Q55921400","Q55921405","Q55921411","Q55921409","Q55976589","Q56034312",
"Q60772367","Q60810809","Q60906083","Q60973625","Q60981084","Q60981412","Q60981413","Q61030486","Q61167085","Q61172693","Q61187480","Q61232006","Q61382883","Q61393245","Q61424399","Q63532984","Q65625120","Q65702643","Q65713656","Q65718833","Q65736714","Q65755495","Q65790071","Q65790086","Q65790087",
"Q65790084","Q65790085","Q65790119","Q74880895","Q80345070","Q84473663","Q86108517","Q86224692","Q86232976","Q86281546","Q86378945","Q86769017","Q86778231","Q86778228","Q86791591","Q86791968","Q93953721","Q96288781","Q97433654","Q97443838","Q99632832","Q101108861","Q101108880","Q105167764","Q105209531",
"Q105312295","Q105405599","Q105412542","Q105424332","Q105449071","Q105491979","Q105509082","Q105570784","Q105798399","Q106136248","Q106314340","Q106393263","Q106627685","Q106691926","Q106757406","Q106775108","Q106942162","Q106942632","Q106949344","Q106949397","Q107136417","Q107212825","Q107212839","Q107212874","Q107633970",
"Q108266846","Q108539205","Q108793760","Q108905211","Q108905216","Q109527092","Q109617650","Q109858835","Q109859066","Q110050759","Q110050767","Q110482647","Q110482679","Q110482702","Q110482713","Q110482721","Q110482730","Q110482764","Q110482803","Q110482835","Q110482853","Q110482937","Q110483008","Q110483039","Q110483059",
"Q110483225","Q110483251","Q110483309","Q110483382","Q110483444","Q110483485","Q110483550","Q110483965","Q110483988","Q110484381","Q110484397","Q110484411","Q110484420","Q110484429","Q110484435","Q110484440","Q110484450","Q110484461","Q110484472","Q110484483","Q110484491","Q110484496","Q110484726","Q110819898","Q110854789",
"Q111313970","Q111314017","Q111818471","Q111818472","Q111818556","Q111818581","Q111818819","Q111819331","Q111819505","Q111819525","Q111819547","Q111819663","Q111819757","Q111819825","Q111819849","Q111819897","Q111820107","Q111820158","Q111820166","Q111820211","Q111820262","Q111820287","Q111820336","Q111884045","Q111949927",
"Q111953766","Q111953768","Q111957708","Q112062772","Q112184753","Q112400751","Q112738244","Q112740323","Q112740939","Q112742200","Q112743809","Q112744915","Q112745157","Q112745379","Q112745958","Q112746094","Q112746188","Q112746380","Q112747285","Q112747616","Q112747710","Q113303458","Q113303475","Q113303517","Q113584232",
"Q113666769","Q113712122","Q113834333","Q114723285","Q114742418","Q114742427","Q114742537","Q114742556","Q114742649","Q114802208","Q114975310","Q115197327","Q115197835","Q115205427","Q115205428","Q115208595","Q115208762","Q115268995","Q115269235","Q115269232","Q115269233","Q115269237","Q115269242","Q115269240","Q115269246",
"Q115269244","Q115269251","Q115269248","Q115269255","Q115269253","Q115269258","Q115269262","Q115269266","Q115269270","Q115269275","Q115269272","Q115269273","Q115269279","Q115269286","Q115269285","Q115269289","Q115269297","Q115269304","Q115269311","Q115269308","Q115269313","Q115297748","Q115297786","Q115322293","Q115322298",
"Q115428682","Q115428975","Q115517807","Q115561372","Q115567129","Q115577698","Q115577699","Q115577700","Q115577706","Q115577707","Q115577705","Q115682262","Q115682266","Q115748392","Q115775210","Q115902282","Q116313759","Q116313795","Q116313796","Q116678694","Q116778652","Q116823014","Q116838248","Q116838259","Q116848105"
    )
    AND pl_from NOT IN (
      select page_id from page where page_title in (
"Q6167027","Q6177071","Q6180172","Q6194651","Q6206424","Q6273555","Q6294314","Q6316948","Q7025491","Q7840432","Q7937258","Q8152702","Q8153866","Q8154420","Q8156208","Q8158030","Q8158699","Q8159292","Q8159936","Q8160522","Q8161185","Q8161857","Q8162503","Q8163164","Q8164649",
"Q8166624","Q8168056","Q8168767","Q8169468","Q8170398","Q8171150","Q8172732","Q8173516","Q8174370","Q8175163","Q8177019","Q8178043","Q8178924","Q8179895","Q8189497","Q8190958","Q8243071","Q8282258","Q8319261","Q8334281","Q8377882","Q8377883","Q8377880","Q8377881","Q8377886",
"Q8377885","Q8432975","Q8438468","Q8441550","Q8441554","Q8441552","Q8441553","Q8441558","Q8441556","Q8449534","Q8449535","Q8449539","Q8449536","Q8449537","Q8449540","Q8476671","Q8533510","Q8557790","Q8575498","Q8586649","Q8676979","Q8680820","Q8784478","Q8784482","Q8784480",
"Q8795802","Q8795800","Q8795806","Q8819809","Q8838703","Q8838706","Q8838710","Q8838708","Q8838714","Q8838717","Q8918475","Q8971737","Q8973746","Q8973747","Q8977254","Q8989851","Q9090378","Q9093507","Q9102023","Q9112456","Q9125319","Q9129052","Q9146069","Q9416968","Q9422233",
"Q9454142","Q9490121","Q9506388","Q9522646","Q9525751","Q9538206","Q9601149","Q9607015","Q9630471","Q9630500","Q9630645","Q9630660","Q9697867","Q9697970","Q9697968","Q9697972","Q9699073","Q9714259","Q9716984","Q9730405","Q9731396","Q9734788","Q9739414","Q9743299","Q9752948",
"Q9783670","Q9788018","Q9809994","Q9810056","Q9810109","Q9817556","Q9842531","Q9842845","Q9844240","Q9845107","Q9865306","Q9869185","Q9872160","Q9888168","Q9897677","Q9982153","Q9991653","Q10005653","Q10005689","Q10013566","Q10022193","Q10034093","Q10054008","Q10073471","Q10078738",
"Q10106244","Q10136197","Q10141172","Q10144809","Q10159667","Q10159886","Q10161624","Q10170798","Q10179387","Q10190818","Q10253745","Q10259904","Q10738413","Q10811274","Q10832241","Q13276608","Q13287727","Q13287728","Q13288925","Q13334781","Q13338048","Q13338106","Q13338107","Q13338104","Q13338119",
"Q13338116","Q13338120","Q13348863","Q15252778","Q15257270","Q15264390","Q15295317","Q15296655","Q15296658","Q15358011","Q15950308","Q15955624","Q15960728","Q16500883","Q16809067","Q17162860","Q17162935","Q17163012","Q17273534","Q17303777","Q17391430","Q17391434","Q17391433","Q17391442","Q17391447",
"Q17391451","Q17391449","Q18012997","Q18328687","Q18328685","Q18328688","Q18328693","Q18328720","Q18727929","Q18744141","Q19331728","Q19593290","Q20643587","Q20654345","Q20705447","Q20878320","Q20947421","Q20965118","Q21175995","Q21292663","Q22266811","Q22685756","Q23927670","Q23927668","Q24870058",
"Q24872347","Q24875707","Q24875973","Q24917097","Q25142022","Q25333150","Q25336005","Q25341470","Q25349619","Q25362191","Q25937094","Q25937108","Q25937109","Q25938274","Q25938273","Q25972405","Q25974254","Q26467691","Q26833224","Q26925981","Q27069925","Q27218112","Q27311046","Q27311045","Q27311048",
"Q27311077","Q27311082","Q27311132","Q27311138","Q27311136","Q27311151","Q27311148","Q27493160","Q27819693","Q27886228","Q28697367","Q28814334","Q29790297","Q30070913","Q30628856","Q30690341","Q30718011","Q30738907","Q30767866","Q30817338","Q30994303","Q31014039","Q31058319","Q31070014","Q31089168",
"Q31101133","Q31168728","Q31883453","Q31934170","Q31934171","Q31934169","Q31934174","Q31952145","Q31987083","Q31987084","Q31992241","Q31992271","Q31993706","Q32018642","Q32032598","Q32032603","Q32032601","Q32032615","Q32032612","Q32032613","Q32032616","Q32032624","Q32032625","Q32032638","Q32032639",
"Q32032640","Q32039305","Q32040421","Q32040442","Q32040448","Q32040454","Q32040548","Q32040549","Q32040616","Q32040635","Q32040648","Q32040649","Q32040654","Q32042647","Q32082527","Q32084796","Q32085064","Q32085092","Q32105858","Q32131357","Q32152145","Q32153081","Q32153566","Q32153733","Q32225661",
"Q32238960","Q32242776","Q32249198","Q32336829","Q32339496","Q32339502","Q32339505","Q32339511","Q32341597","Q32348059","Q32359814","Q32363476","Q32366400","Q32438519","Q32438523","Q32442790","Q32458229","Q32464568","Q32472756","Q32472778","Q32499985","Q32512912","Q32534992","Q32568586","Q32572719",
"Q32572949","Q32590049","Q32590056","Q32590062","Q32590107","Q32590126","Q32590133","Q32590158","Q32590201","Q32590224","Q32590244","Q32590282","Q32590308","Q32590326","Q32590424","Q32590458","Q32598341","Q32609484","Q32638018","Q32651997","Q32660718","Q32671189","Q32682242","Q32688199","Q32700756",
"Q32700783","Q32701883","Q32709377","Q32717180","Q32719754","Q32809481","Q32821711","Q32876411","Q32890532","Q32890543","Q32904505","Q32914024","Q32914873","Q32929555","Q32962571","Q32962624","Q33016358","Q33016486","Q33019776","Q33030762","Q33037170","Q33037215","Q33037218","Q33037216","Q33037234",
"Q33037287","Q33046500","Q33062493","Q33062667","Q33090329","Q33090388","Q33117699","Q33117719","Q33119616","Q33127688","Q33133059","Q33133060","Q33670887","Q33676041","Q34202865","Q34221450","Q34222664","Q34222684","Q34519295","Q34531380","Q34585783","Q35453736","Q35466421","Q35469036","Q35469088",
"Q35632715","Q35632712","Q36050029","Q36051481","Q36116695","Q36116692","Q36151731","Q36775445","Q37650498","Q37654285","Q37654715","Q37654861","Q37654935","Q37655010","Q37655039","Q37656073","Q37656976","Q37658382","Q37664501","Q37664994","Q37665003","Q37665377","Q37666878","Q37667496","Q37668204",
"Q37673999","Q39417742","Q41539642","Q44618126","Q44619018","Q44731708","Q47014562","Q47212162","Q47483653","Q48479401","Q49661014","Q49678927","Q49780370","Q49931872","Q50312206","Q52232939","Q55246700","Q55277067","Q55921402","Q55921400","Q55921405","Q55921411","Q55921409","Q55976589","Q56034312",
"Q60772367","Q60810809","Q60906083","Q60973625","Q60981084","Q60981412","Q60981413","Q61030486","Q61167085","Q61172693","Q61187480","Q61232006","Q61382883","Q61393245","Q61424399","Q63532984","Q65625120","Q65702643","Q65713656","Q65718833","Q65736714","Q65755495","Q65790071","Q65790086","Q65790087",
"Q65790084","Q65790085","Q65790119","Q74880895","Q80345070","Q84473663","Q86108517","Q86224692","Q86232976","Q86281546","Q86378945","Q86769017","Q86778231","Q86778228","Q86791591","Q86791968","Q93953721","Q96288781","Q97433654","Q97443838","Q99632832","Q101108861","Q101108880","Q105167764","Q105209531",
"Q105312295","Q105405599","Q105412542","Q105424332","Q105449071","Q105491979","Q105509082","Q105570784","Q105798399","Q106136248","Q106314340","Q106393263","Q106627685","Q106691926","Q106757406","Q106775108","Q106942162","Q106942632","Q106949344","Q106949397","Q107136417","Q107212825","Q107212839","Q107212874","Q107633970",
"Q108266846","Q108539205","Q108793760","Q108905211","Q108905216","Q109527092","Q109617650","Q109858835","Q109859066","Q110050759","Q110050767","Q110482647","Q110482679","Q110482702","Q110482713","Q110482721","Q110482730","Q110482764","Q110482803","Q110482835","Q110482853","Q110482937","Q110483008","Q110483039","Q110483059",
"Q110483225","Q110483251","Q110483309","Q110483382","Q110483444","Q110483485","Q110483550","Q110483965","Q110483988","Q110484381","Q110484397","Q110484411","Q110484420","Q110484429","Q110484435","Q110484440","Q110484450","Q110484461","Q110484472","Q110484483","Q110484491","Q110484496","Q110484726","Q110819898","Q110854789",
"Q111313970","Q111314017","Q111818471","Q111818472","Q111818556","Q111818581","Q111818819","Q111819331","Q111819505","Q111819525","Q111819547","Q111819663","Q111819757","Q111819825","Q111819849","Q111819897","Q111820107","Q111820158","Q111820166","Q111820211","Q111820262","Q111820287","Q111820336","Q111884045","Q111949927",
"Q111953766","Q111953768","Q111957708","Q112062772","Q112184753","Q112400751","Q112738244","Q112740323","Q112740939","Q112742200","Q112743809","Q112744915","Q112745157","Q112745379","Q112745958","Q112746094","Q112746188","Q112746380","Q112747285","Q112747616","Q112747710","Q113303458","Q113303475","Q113303517","Q113584232",
"Q113666769","Q113712122","Q113834333","Q114723285","Q114742418","Q114742427","Q114742537","Q114742556","Q114742649","Q114802208","Q114975310","Q115197327","Q115197835","Q115205427","Q115205428","Q115208595","Q115208762","Q115268995","Q115269235","Q115269232","Q115269233","Q115269237","Q115269242","Q115269240","Q115269246",
"Q115269244","Q115269251","Q115269248","Q115269255","Q115269253","Q115269258","Q115269262","Q115269266","Q115269270","Q115269275","Q115269272","Q115269273","Q115269279","Q115269286","Q115269285","Q115269289","Q115269297","Q115269304","Q115269311","Q115269308","Q115269313","Q115297748","Q115297786","Q115322293","Q115322298",
"Q115428682","Q115428975","Q115517807","Q115561372","Q115567129","Q115577698","Q115577699","Q115577700","Q115577706","Q115577707","Q115577705","Q115682262","Q115682266","Q115748392","Q115775210","Q115902282","Q116313759","Q116313795","Q116313796","Q116678694","Q116778652","Q116823014","Q116838248","Q116838259","Q116848105"
      )
    )
#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...
