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 (
"Q6421901","Q7014618","Q7029267","Q7029270","Q7042504","Q7778743","Q8386000","Q8654860","Q8680462","Q8789506","Q8828920","Q8922377","Q9072994","Q9099848","Q9226822","Q9542017","Q9580508","Q9612240","Q9673117","Q9732092","Q9758745","Q9837038","Q9889074","Q9892309","Q9948996",
"Q9991174","Q10054740","Q10074885","Q10087510","Q10096309","Q10104853","Q10106244","Q10183831","Q10189575","Q10832241","Q13281535","Q13305188","Q13356167","Q16789451","Q18758821","Q21102839","Q21292663","Q22351229","Q22584702","Q24048156","Q24875973","Q25079439","Q25087710","Q25243839","Q25937096",
"Q25974262","Q26209878","Q26979442","Q26979483","Q27216775","Q27602716","Q27880763","Q27880775","Q27880781","Q27892069","Q27950708","Q28152887","Q28599289","Q28863841","Q28863863","Q28863864","Q28863865","Q28863867","Q30640118","Q30675447","Q30713491","Q30785292","Q30791903","Q31052183","Q31074435",
"Q31872609","Q31881938","Q32152145","Q32152586","Q32153081","Q32153566","Q32153733","Q32360349","Q32359814","Q32478257","Q32484386","Q32485339","Q32599106","Q32655880","Q32695682","Q32695718","Q32691985","Q32692733","Q32698976","Q32699468","Q32699587","Q32696748","Q32697005","Q32701366","Q32700287",
"Q32700717","Q32705735","Q32703174","Q32703384","Q32703441","Q32703659","Q32716349","Q32721307","Q32721309","Q32722001","Q32722547","Q32723114","Q32723115","Q32723535","Q32723596","Q32736765","Q32782799","Q32817872","Q32817874","Q32929341","Q32991953","Q32992284","Q32992354","Q33036623",
"Q33036630","Q33096062","Q33127686","Q33248105","Q33661221","Q33299180","Q33300459","Q33309708","Q33669717","Q34369722","Q34445092","Q35453747","Q35614158","Q37667800","Q46386053","Q47209025","Q49884551","Q51916211","Q51918129","Q51918146","Q51918582","Q51918988","Q51919905","Q51920921","Q52740608",
"Q52740977","Q52742288","Q52694883","Q52695607","Q52695797","Q52696318","Q52696386","Q52748963","Q52756590","Q52757712","Q55299090","Q55299319","Q55297362","Q55305710","Q55308414","Q55307265","Q55325835","Q55327582","Q60339398","Q60772367","Q60887598","Q60939541","Q61241722","Q61248136","Q61248142",
"Q61248145","Q61248148","Q61248153","Q61248157","Q61244497","Q61244512","Q61245576","Q61246802","Q61247188","Q61247191","Q61247198","Q61247202","Q61247208","Q61247393","Q61255556","Q61255566","Q61256766","Q61402951","Q61402955","Q61402958","Q61402964","Q61404363","Q61427209","Q61430803","Q64332845",
"Q65646520","Q65650643","Q65764772","Q65796589","Q67906785","Q68202422","Q80345070","Q84252495","Q84255561","Q86124931","Q86125849","Q97386587","Q99233927","Q105098681","Q105259346","Q105570536","Q105598300","Q105602031","Q105602443","Q105716188","Q105803812","Q106135480","Q106241661","Q106814437","Q107042265",
"Q108788259","Q108788264","Q109527092","Q109617650","Q110381813","Q110819624","Q111248164","Q111248226","Q111248230","Q111248236","Q111248238","Q111248244","Q111248251","Q111248256","Q111548678","Q111698052","Q111793476","Q112247694","Q112275759","Q112302410","Q112302985","Q112303230","Q112323608","Q112323884","Q112660385",
"Q112660387","Q112660389","Q112660552","Q112667151","Q112741627","Q112741720","Q112741742","Q112741748","Q112741765","Q112741785","Q112741803","Q112741876","Q112741942","Q112739010","Q112739027","Q112739144","Q112739188","Q112739190","Q112739217","Q112739219","Q112739442","Q112739463","Q112739465","Q112739704","Q112739710",
"Q112739834","Q112739871","Q112739973","Q112740001","Q112740025","Q112740062","Q112740068","Q112740388","Q112740395","Q112740406","Q112740441","Q112740443","Q112740447","Q112740511","Q112740536","Q112740558","Q112740648","Q112740655","Q112740731","Q112740733","Q112740769","Q112740798","Q112740800","Q112740813","Q112740814",
"Q112740816","Q112740873","Q112740881","Q112740887","Q112740890","Q112740892","Q112740895","Q112740968","Q112740970","Q112740988","Q112741074","Q112741076","Q112741094","Q112741222","Q112741229","Q112741343","Q112741344","Q112737695","Q112737764","Q112737766","Q112737821","Q112737867","Q112738236","Q112738239","Q112738243",
"Q112738247","Q112738250","Q112738259","Q112738387","Q112738390","Q112738399","Q112738434","Q112738436","Q112738485","Q112738493","Q112738506","Q112738697","Q112742048","Q112742055","Q112742195","Q112742307","Q112742515","Q112742764","Q112742885","Q112742896","Q112742898","Q112742902","Q112742909","Q112742921","Q112742986",
"Q112743009","Q112743013","Q112743231","Q112743434","Q112743572","Q112743573","Q112743586","Q112743615","Q112743792","Q112743844","Q112743848","Q112743868","Q112743871","Q112743879","Q112743880","Q112743921","Q112744018","Q112744100","Q112744101","Q112744126","Q112744128","Q112744250","Q112744296","Q112704235","Q112746394",
"Q112746400","Q112746409","Q112746414","Q112746416","Q112746466","Q112746470","Q112746600","Q112746603","Q112746608","Q112746620","Q112746825","Q112746924","Q112746944","Q112746948","Q112746962","Q112746969","Q112746971","Q112746972","Q112747001","Q112744371","Q112744501","Q112744593","Q112744704","Q112744801","Q112744904",
"Q112744966","Q112745006","Q112745008","Q112745062","Q112745110","Q112745111","Q112745115","Q112745116","Q112745117","Q112745118","Q112745119","Q112745197","Q112745319","Q112745376","Q112745589","Q112745592","Q112745605","Q112745624","Q112745627","Q112745705","Q112745776","Q112745865","Q112745880","Q112745955","Q112745977",
"Q112745978","Q112745990","Q112746117","Q112746174","Q112746272","Q112746278","Q112746327","Q112746377","Q112747094","Q112747122","Q112747124","Q112747270","Q112747312","Q112747314","Q112747332","Q112747400","Q112747416","Q112747418","Q112747424","Q112747425","Q112747427","Q112747428","Q112747451","Q112747455","Q112747509",
"Q112747548","Q112747550","Q112747608","Q112747677","Q112747713","Q112892885","Q112919135","Q112919389","Q113152317","Q113329583","Q113458735","Q113443653","Q113443655","Q113495598","Q113563895","Q113625564","Q113990384","Q113990385","Q113956562","Q114438874","Q115090434","Q115119530","Q115206482","Q115325054","Q115325055",
"Q115624712","Q115682163","Q115682170","Q115682194","Q115693335","Q115754387","Q115796682","Q116190885","Q116190886","Q116190889","Q116441686","Q116441697","Q116441715","Q116441717","Q116778654","Q116824108","Q116824111","Q116824117","Q116824123","Q116824127","Q116824129","Q116848555","Q116848601","Q116848634","Q116849045",
"Q116849050","Q116849236","Q116849238","Q116876361","Q116876404","Q116876424","Q116876428","Q116876449","Q116876484","Q116876485","Q116876487","Q116876488","Q116876489","Q116876490","Q116876491","Q116876492","Q116876493","Q116876494","Q116876495","Q116876497","Q116876498","Q116876499","Q116876501","Q116876503","Q116876505",
"Q116876506","Q116849482","Q116849501","Q116849515","Q116850069","Q116850105","Q116850106","Q116850107","Q116850108","Q116850738","Q116850739","Q116876336","Q116850797","Q116850798","Q116850799","Q116850800","Q116924691","Q116924692","Q116924693","Q116926599","Q116926602","Q116942628","Q116942641","Q116942670","Q116942685",
"Q116942686","Q116942691","Q116942700","Q116942705","Q116942717","Q116948458","Q116948541","Q116948612","Q116948621","Q116948628","Q116948635","Q116948664","Q116948701","Q116948703","Q116948704","Q116948705","Q116948706","Q116948708","Q116948710","Q116948711","Q116948712","Q116948713","Q116948714","Q116948716","Q116948717",
"Q116948719","Q116948720","Q116948722","Q116948723","Q116948725","Q116948726","Q116948727","Q116948728","Q116948729","Q116948731","Q116948732","Q116948733","Q116948736","Q116948737","Q116948738","Q116948739","Q116948741","Q116948742","Q116948743","Q116948744","Q116948745","Q116948747","Q116948749","Q116948751","Q116948752",
"Q116948755","Q116948757","Q116948759","Q116948761","Q116948762","Q116948763","Q116948764","Q116948765","Q116948767","Q116948769","Q116948770","Q116948771","Q116948773","Q116948774","Q116948775","Q116948776","Q116942553","Q116942603","Q116942617","Q116942619","Q117077100","Q117089035","Q117307373","Q117848119","Q117867189",
"Q117881494","Q117881508","Q117882708","Q118591988","Q118591989","Q118533674","Q118945227","Q118945244","Q119252408","Q119252532","Q119252709","Q119252713","Q119252714","Q119252729","Q119252731","Q119252735","Q119252738","Q119252744","Q119252751","Q119252759","Q119254493","Q119820394","Q119985436","Q119985438","Q119985439",
"Q120761849","Q120736201","Q120785731","Q120785749","Q120886718","Q120886721","Q121026668","Q121026797","Q121363442","Q121363443","Q121494499","Q122143204","Q122690163","Q122690654","Q122692116","Q122692160","Q122692632","Q122692867","Q122693563","Q122716883","Q122717482","Q122720413","Q122500376","Q122500447","Q122500535",
"Q122719684","Q122720648","Q122720924","Q122721142","Q122802987","Q123236230","Q123236239","Q123236241","Q123236242","Q123236243","Q123236244","Q123236247","Q123236248","Q123236249","Q123236251","Q123236252","Q123236253","Q123236256","Q123296215","Q123398735","Q123399773","Q123399779","Q123399780","Q123399781",
"Q123523809","Q123594695","Q123836089","Q123836143","Q123836153","Q123836158","Q123836198","Q123836217","Q123836352","Q123836357","Q123836362","Q123836366","Q123836372","Q123836377","Q123836382","Q123836387","Q123836393","Q123836398","Q123836403","Q123836408","Q123836412","Q123836418","Q124076105","Q124094273","Q124315809",
"Q124367304","Q124367325","Q124367350","Q124367356","Q124367371","Q124367373","Q124367374","Q124367375","Q124367376","Q124367377","Q124367397","Q124367410","Q124367411","Q124367412","Q124367413","Q124367480","Q124367482","Q124367483","Q124367497","Q124367517","Q124367547","Q124367593","Q124367629","Q124367633","Q124367637"
    )
    AND pl_from NOT IN (
      select page_id from page where page_title in (
"Q6421901","Q7014618","Q7029267","Q7029270","Q7042504","Q7778743","Q8386000","Q8654860","Q8680462","Q8789506","Q8828920","Q8922377","Q9072994","Q9099848","Q9226822","Q9542017","Q9580508","Q9612240","Q9673117","Q9732092","Q9758745","Q9837038","Q9889074","Q9892309","Q9948996",
"Q9991174","Q10054740","Q10074885","Q10087510","Q10096309","Q10104853","Q10106244","Q10183831","Q10189575","Q10832241","Q13281535","Q13305188","Q13356167","Q16789451","Q18758821","Q21102839","Q21292663","Q22351229","Q22584702","Q24048156","Q24875973","Q25079439","Q25087710","Q25243839","Q25937096",
"Q25974262","Q26209878","Q26979442","Q26979483","Q27216775","Q27602716","Q27880763","Q27880775","Q27880781","Q27892069","Q27950708","Q28152887","Q28599289","Q28863841","Q28863863","Q28863864","Q28863865","Q28863867","Q30640118","Q30675447","Q30713491","Q30785292","Q30791903","Q31052183","Q31074435",
"Q31872609","Q31881938","Q32152145","Q32152586","Q32153081","Q32153566","Q32153733","Q32360349","Q32359814","Q32478257","Q32484386","Q32485339","Q32599106","Q32655880","Q32695682","Q32695718","Q32691985","Q32692733","Q32698976","Q32699468","Q32699587","Q32696748","Q32697005","Q32701366","Q32700287",
"Q32700717","Q32705735","Q32703174","Q32703384","Q32703441","Q32703659","Q32716349","Q32721307","Q32721309","Q32722001","Q32722547","Q32723114","Q32723115","Q32723535","Q32723596","Q32736765","Q32782799","Q32817872","Q32817874","Q32929341","Q32991953","Q32992284","Q32992354","Q33036623",
"Q33036630","Q33096062","Q33127686","Q33248105","Q33661221","Q33299180","Q33300459","Q33309708","Q33669717","Q34369722","Q34445092","Q35453747","Q35614158","Q37667800","Q46386053","Q47209025","Q49884551","Q51916211","Q51918129","Q51918146","Q51918582","Q51918988","Q51919905","Q51920921","Q52740608",
"Q52740977","Q52742288","Q52694883","Q52695607","Q52695797","Q52696318","Q52696386","Q52748963","Q52756590","Q52757712","Q55299090","Q55299319","Q55297362","Q55305710","Q55308414","Q55307265","Q55325835","Q55327582","Q60339398","Q60772367","Q60887598","Q60939541","Q61241722","Q61248136","Q61248142",
"Q61248145","Q61248148","Q61248153","Q61248157","Q61244497","Q61244512","Q61245576","Q61246802","Q61247188","Q61247191","Q61247198","Q61247202","Q61247208","Q61247393","Q61255556","Q61255566","Q61256766","Q61402951","Q61402955","Q61402958","Q61402964","Q61404363","Q61427209","Q61430803","Q64332845",
"Q65646520","Q65650643","Q65764772","Q65796589","Q67906785","Q68202422","Q80345070","Q84252495","Q84255561","Q86124931","Q86125849","Q97386587","Q99233927","Q105098681","Q105259346","Q105570536","Q105598300","Q105602031","Q105602443","Q105716188","Q105803812","Q106135480","Q106241661","Q106814437","Q107042265",
"Q108788259","Q108788264","Q109527092","Q109617650","Q110381813","Q110819624","Q111248164","Q111248226","Q111248230","Q111248236","Q111248238","Q111248244","Q111248251","Q111248256","Q111548678","Q111698052","Q111793476","Q112247694","Q112275759","Q112302410","Q112302985","Q112303230","Q112323608","Q112323884","Q112660385",
"Q112660387","Q112660389","Q112660552","Q112667151","Q112741627","Q112741720","Q112741742","Q112741748","Q112741765","Q112741785","Q112741803","Q112741876","Q112741942","Q112739010","Q112739027","Q112739144","Q112739188","Q112739190","Q112739217","Q112739219","Q112739442","Q112739463","Q112739465","Q112739704","Q112739710",
"Q112739834","Q112739871","Q112739973","Q112740001","Q112740025","Q112740062","Q112740068","Q112740388","Q112740395","Q112740406","Q112740441","Q112740443","Q112740447","Q112740511","Q112740536","Q112740558","Q112740648","Q112740655","Q112740731","Q112740733","Q112740769","Q112740798","Q112740800","Q112740813","Q112740814",
"Q112740816","Q112740873","Q112740881","Q112740887","Q112740890","Q112740892","Q112740895","Q112740968","Q112740970","Q112740988","Q112741074","Q112741076","Q112741094","Q112741222","Q112741229","Q112741343","Q112741344","Q112737695","Q112737764","Q112737766","Q112737821","Q112737867","Q112738236","Q112738239","Q112738243",
"Q112738247","Q112738250","Q112738259","Q112738387","Q112738390","Q112738399","Q112738434","Q112738436","Q112738485","Q112738493","Q112738506","Q112738697","Q112742048","Q112742055","Q112742195","Q112742307","Q112742515","Q112742764","Q112742885","Q112742896","Q112742898","Q112742902","Q112742909","Q112742921","Q112742986",
"Q112743009","Q112743013","Q112743231","Q112743434","Q112743572","Q112743573","Q112743586","Q112743615","Q112743792","Q112743844","Q112743848","Q112743868","Q112743871","Q112743879","Q112743880","Q112743921","Q112744018","Q112744100","Q112744101","Q112744126","Q112744128","Q112744250","Q112744296","Q112704235","Q112746394",
"Q112746400","Q112746409","Q112746414","Q112746416","Q112746466","Q112746470","Q112746600","Q112746603","Q112746608","Q112746620","Q112746825","Q112746924","Q112746944","Q112746948","Q112746962","Q112746969","Q112746971","Q112746972","Q112747001","Q112744371","Q112744501","Q112744593","Q112744704","Q112744801","Q112744904",
"Q112744966","Q112745006","Q112745008","Q112745062","Q112745110","Q112745111","Q112745115","Q112745116","Q112745117","Q112745118","Q112745119","Q112745197","Q112745319","Q112745376","Q112745589","Q112745592","Q112745605","Q112745624","Q112745627","Q112745705","Q112745776","Q112745865","Q112745880","Q112745955","Q112745977",
"Q112745978","Q112745990","Q112746117","Q112746174","Q112746272","Q112746278","Q112746327","Q112746377","Q112747094","Q112747122","Q112747124","Q112747270","Q112747312","Q112747314","Q112747332","Q112747400","Q112747416","Q112747418","Q112747424","Q112747425","Q112747427","Q112747428","Q112747451","Q112747455","Q112747509",
"Q112747548","Q112747550","Q112747608","Q112747677","Q112747713","Q112892885","Q112919135","Q112919389","Q113152317","Q113329583","Q113458735","Q113443653","Q113443655","Q113495598","Q113563895","Q113625564","Q113990384","Q113990385","Q113956562","Q114438874","Q115090434","Q115119530","Q115206482","Q115325054","Q115325055",
"Q115624712","Q115682163","Q115682170","Q115682194","Q115693335","Q115754387","Q115796682","Q116190885","Q116190886","Q116190889","Q116441686","Q116441697","Q116441715","Q116441717","Q116778654","Q116824108","Q116824111","Q116824117","Q116824123","Q116824127","Q116824129","Q116848555","Q116848601","Q116848634","Q116849045",
"Q116849050","Q116849236","Q116849238","Q116876361","Q116876404","Q116876424","Q116876428","Q116876449","Q116876484","Q116876485","Q116876487","Q116876488","Q116876489","Q116876490","Q116876491","Q116876492","Q116876493","Q116876494","Q116876495","Q116876497","Q116876498","Q116876499","Q116876501","Q116876503","Q116876505",
"Q116876506","Q116849482","Q116849501","Q116849515","Q116850069","Q116850105","Q116850106","Q116850107","Q116850108","Q116850738","Q116850739","Q116876336","Q116850797","Q116850798","Q116850799","Q116850800","Q116924691","Q116924692","Q116924693","Q116926599","Q116926602","Q116942628","Q116942641","Q116942670","Q116942685",
"Q116942686","Q116942691","Q116942700","Q116942705","Q116942717","Q116948458","Q116948541","Q116948612","Q116948621","Q116948628","Q116948635","Q116948664","Q116948701","Q116948703","Q116948704","Q116948705","Q116948706","Q116948708","Q116948710","Q116948711","Q116948712","Q116948713","Q116948714","Q116948716","Q116948717",
"Q116948719","Q116948720","Q116948722","Q116948723","Q116948725","Q116948726","Q116948727","Q116948728","Q116948729","Q116948731","Q116948732","Q116948733","Q116948736","Q116948737","Q116948738","Q116948739","Q116948741","Q116948742","Q116948743","Q116948744","Q116948745","Q116948747","Q116948749","Q116948751","Q116948752",
"Q116948755","Q116948757","Q116948759","Q116948761","Q116948762","Q116948763","Q116948764","Q116948765","Q116948767","Q116948769","Q116948770","Q116948771","Q116948773","Q116948774","Q116948775","Q116948776","Q116942553","Q116942603","Q116942617","Q116942619","Q117077100","Q117089035","Q117307373","Q117848119","Q117867189",
"Q117881494","Q117881508","Q117882708","Q118591988","Q118591989","Q118533674","Q118945227","Q118945244","Q119252408","Q119252532","Q119252709","Q119252713","Q119252714","Q119252729","Q119252731","Q119252735","Q119252738","Q119252744","Q119252751","Q119252759","Q119254493","Q119820394","Q119985436","Q119985438","Q119985439",
"Q120761849","Q120736201","Q120785731","Q120785749","Q120886718","Q120886721","Q121026668","Q121026797","Q121363442","Q121363443","Q121494499","Q122143204","Q122690163","Q122690654","Q122692116","Q122692160","Q122692632","Q122692867","Q122693563","Q122716883","Q122717482","Q122720413","Q122500376","Q122500447","Q122500535",
"Q122719684","Q122720648","Q122720924","Q122721142","Q122802987","Q123236230","Q123236239","Q123236241","Q123236242","Q123236243","Q123236244","Q123236247","Q123236248","Q123236249","Q123236251","Q123236252","Q123236253","Q123236256","Q123296215","Q123398735","Q123399773","Q123399779","Q123399780","Q123399781",
"Q123523809","Q123594695","Q123836089","Q123836143","Q123836153","Q123836158","Q123836198","Q123836217","Q123836352","Q123836357","Q123836362","Q123836366","Q123836372","Q123836377","Q123836382","Q123836387","Q123836393","Q123836398","Q123836403","Q123836408","Q123836412","Q123836418","Q124076105","Q124094273","Q124315809",
"Q124367304","Q124367325","Q124367350","Q124367356","Q124367371","Q124367373","Q124367374","Q124367375","Q124367376","Q124367377","Q124367397","Q124367410","Q124367411","Q124367412","Q124367413","Q124367480","Q124367482","Q124367483","Q124367497","Q124367517","Q124367547","Q124367593","Q124367629","Q124367633","Q124367637"
      )
    )
#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...
