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 (
"Q116848188","Q116848554","Q116848687","Q116849232","Q116850082","Q116850081","Q116850095","Q116850099","Q116850103","Q116850100","Q116850736","Q116850741","Q116850745","Q116850759","Q116850762","Q116850772","Q116850787","Q116850784","Q116850790","Q116875633","Q116876299","Q116876321","Q116876325","Q116876339","Q116876360",
"Q116876380","Q116876390","Q116876389","Q116876394","Q116876405","Q116876422","Q116876451","Q116897086","Q116897084","Q116897085","Q116897088","Q116922600","Q116924690","Q116924695","Q116942584","Q116942597","Q116942611","Q116942661","Q116942684","Q116942689","Q116942694","Q116942716","Q116942722","Q116942734","Q116948457",
"Q116948463","Q116948503","Q116948544","Q116948551","Q116948587","Q116948584","Q116948615","Q116948620","Q116948629","Q116948655","Q116948662","Q116948663","Q116948670","Q116948730","Q116948748","Q116948766","Q116948768","Q116968482","Q116969118","Q117021889","Q117076350","Q117077877","Q117088070","Q117088838","Q117196693",
"Q117257124","Q117289957","Q117297772","Q117298846","Q117304033","Q117310724","Q117310784","Q117311173","Q117314458","Q117314471","Q117314473","Q117314476","Q117314732","Q117316110","Q117452137","Q117505917","Q117506901","Q117507646","Q117536194","Q117708497","Q118235588","Q118328452","Q118363112","Q118533636","Q119252500",
"Q119252525","Q119252629","Q119252705","Q119608488","Q120829691","Q121026667","Q121026796","Q121624345","Q122154275","Q122689817","Q122692005","Q122714809","Q122715348","Q122716342","Q122716366","Q122716716","Q122716850","Q122717002","Q122717920","Q122718037","Q122718622","Q122718627","Q122719037","Q122719068","Q122719097",
"Q122719185","Q122719312","Q122719538","Q122719612","Q122720336","Q122721365","Q122721405","Q122721536","Q122721567","Q123163409","Q123163413","Q123236211","Q123236229","Q123266502","Q123523253","Q123663087","Q123835906","Q123835916","Q123836125","Q123836213","Q123836248","Q123836262","Q123836347","Q124313461","Q124367291",
"Q124367319","Q124367390","Q124367451","Q124367449","Q124367462","Q124367466","Q124367472","Q124367479","Q124367580","Q124367592","Q124367636","Q124367666","Q124367674","Q124367802","Q124367835","Q124367863","Q124367873","Q124396360","Q124396369","Q124396429","Q124396443","Q124396440","Q124396475","Q124396529","Q124396542",
"Q124396551","Q124396564","Q124396575","Q124396583","Q124396588","Q124396589","Q124396605","Q124396629","Q124396640","Q124396688","Q124396694","Q124396706","Q124396708","Q124417242","Q124417259","Q124417290","Q124417295","Q124417296","Q124417309","Q124417329","Q124417349","Q124417360","Q124417386","Q124417482","Q124417499",
"Q124417497","Q124417507","Q124417517","Q124417526","Q124417562","Q124417573","Q124417598","Q124417603","Q124417661","Q124417692","Q124417710","Q124417722","Q124417724","Q124417766","Q124417782","Q124417794","Q124417830","Q124417843","Q124417848","Q124417857","Q124417888","Q124470844","Q124470938","Q124470956","Q124470995",
"Q124471027","Q124471031","Q124471066","Q124471127","Q124471233","Q124471460","Q124471483","Q124471519","Q124471618","Q124471647","Q124541607","Q124541610","Q124541611","Q124541614","Q124541640","Q124541650","Q124541664","Q124541674","Q124541724","Q124541760","Q124541799","Q124541822","Q124541850","Q124541892","Q124541899",
"Q124631284","Q124631333","Q124631346","Q124631344","Q124631349","Q124631374","Q124631440","Q124631446","Q124631464","Q124631491","Q124631530","Q124631558","Q124631610","Q124631611","Q124631632","Q124631685","Q124631689","Q124798888","Q124903118","Q124904012","Q124923505","Q124924467","Q125018561","Q125061137","Q125303902",
"Q125389931","Q125389934","Q125441124","Q125798489","Q125798508","Q125798548","Q125863580","Q125863591","Q125863656","Q125863794","Q125863845","Q125863935","Q125864050","Q125864124","Q125864151","Q125864201","Q125864245","Q125864285","Q125864332","Q125864443","Q125866421","Q125866484","Q125866605","Q125876452","Q125876474",
"Q125876546","Q125876578","Q125876605","Q125876630","Q125876650","Q125876791","Q125876809","Q125876867","Q125876963","Q125877014","Q125883797","Q125892410","Q125908399","Q125908440","Q125908480","Q125908508","Q125912625","Q126080976","Q126361540","Q126361546","Q126448042","Q126455184","Q126455463","Q126625706","Q126625762",
"Q126628141","Q126628179","Q126628624","Q126629207","Q126632149","Q126632388","Q126633084","Q126633177","Q126633630","Q126633793","Q126633819","Q126633835","Q126633974","Q126634181","Q126634279","Q126634587","Q126634698","Q126634801","Q126635505","Q126635542","Q126636231","Q126636843","Q126636899","Q126636918","Q126636992",
"Q126637006","Q126637114","Q126637174","Q126637331","Q126637384","Q126637396","Q126637431","Q126637557","Q126637584","Q126637743","Q126637740","Q126637768","Q126637856","Q126637865","Q126637971","Q126638012","Q126638055","Q126638134","Q126638154","Q126638187","Q126638195","Q126638258","Q126638272","Q126638355","Q126638398",
"Q126638397","Q126638405","Q126638415","Q126638526","Q126638569","Q126638981","Q126639472","Q126643340","Q126643715","Q126643724","Q126643743","Q126679668","Q126679681","Q126679684","Q126679694","Q126679693","Q126679815","Q126679831","Q126679859","Q126679866","Q126679884","Q126729427","Q126730613","Q126730625","Q126730649",
"Q126730676","Q126730715","Q126730831","Q126730835","Q126730873","Q126730880","Q126731022","Q126731028","Q126731139","Q126731145","Q126731189","Q126731311","Q126731361","Q126731376","Q126731377","Q126731384","Q126731408","Q126731446","Q126731461","Q126731495","Q126731492","Q126731533","Q126731536","Q126731537","Q126731541",
"Q126731604","Q126731610","Q126731697","Q126731798","Q126731824","Q126731844","Q126731893","Q126731906","Q126731908","Q126731938","Q126731948","Q126731959","Q126731979","Q126732084","Q126732116","Q126732131","Q126732129","Q126732228","Q126732245","Q126732345","Q126732366","Q126732370","Q126732380","Q126732389","Q126732425",
"Q126732429","Q126732519","Q126732546","Q126732630","Q126732660","Q126732987","Q126737762","Q126737933","Q126738025","Q126738092","Q126738107","Q126738159","Q126738234","Q126738264","Q126738284","Q126738342","Q126738427","Q126738446","Q126738482","Q126738534","Q126738555","Q126738604","Q126738696","Q126738814","Q126738902",
"Q126738910","Q126738959","Q126738974","Q126738973","Q126738999","Q126739072","Q126739114","Q126739341","Q126739566","Q126740232","Q126740253","Q126740294","Q126740310","Q126741703","Q126742080","Q126742081","Q126742084","Q126742089","Q126742096","Q126742110","Q126742118","Q126742117","Q126742352","Q126742361","Q126742435",
"Q126742438","Q126742454","Q126742478","Q126742477","Q126742544","Q126742618","Q126742706","Q126742711","Q126742722","Q126742743","Q126742746","Q126742751","Q126742787","Q126742861","Q126742874","Q126742878","Q126742876","Q126742894","Q126743005","Q126743033","Q126743158","Q126743261","Q126743332","Q126743544","Q126743713",
"Q126743880","Q126743916","Q126743972","Q126744098","Q126744141","Q126744150","Q126744158","Q126744201","Q126744220","Q126744266","Q126744273","Q126744423","Q126744617","Q126744621","Q126744711","Q126744708","Q126744739","Q126744895","Q126744922","Q126744947","Q126744954","Q126744972","Q126745005","Q126745030","Q126745034",
"Q126745183","Q126745260","Q126745277","Q126745282","Q126745312","Q126745411","Q126745416","Q126745427","Q126745546","Q126745752","Q126746322","Q126746946","Q126747266","Q126747367","Q126747967","Q126749143","Q126751278","Q126751372","Q126751379","Q126752247","Q126752515","Q126752533","Q126752584","Q126752665","Q126752712",
"Q126753388","Q126753879","Q126753888","Q126754708","Q126754922","Q126754960","Q126755084","Q126755211","Q126755624","Q126756297","Q126756602","Q126757249","Q126757455","Q126757613","Q126765580","Q126765654","Q126765652","Q126766274","Q126768334","Q126769704","Q126769725","Q126775431","Q126955537","Q126955591","Q126955779",
"Q128354641","Q128787831","Q129110517","Q129110665","Q129121051","Q129167196","Q129170322","Q129170410","Q129170425","Q129170479","Q129170490","Q129170504","Q129170521","Q129170558","Q129170566","Q129170567","Q129170583","Q129170621","Q129170668","Q129170699","Q129170705","Q129170721","Q129170726","Q129170764","Q129170784",
"Q129170801","Q129170813","Q129170818","Q129170891","Q129170909","Q129170918","Q129170979","Q129170984","Q129170993","Q129171002","Q129171009","Q129171024","Q129171063","Q129171151","Q129171172","Q129171179","Q129171238","Q129171241","Q129171248","Q129171256","Q129171264","Q129171295","Q129171298","Q129171356","Q129171381",
"Q129171414","Q129171430","Q129171468","Q129171503","Q129171510","Q129171631","Q129171692","Q129171752","Q129171784","Q129171798","Q129171837","Q129171847","Q129171845","Q129171874","Q129171903","Q130350563","Q130351266","Q130351430","Q130355459","Q130360181","Q130637485","Q130901300","Q130901564","Q130901569","Q130901574",
"Q130901581","Q131095669","Q131150419","Q131295134","Q131295138","Q131295140","Q131335471","Q131406539","Q131419223","Q131446624","Q131468203","Q131478133","Q131501037","Q131502410","Q131511572","Q131598599","Q131694428","Q131736463","Q131738639","Q131767358","Q131781780","Q131781811","Q131813708","Q131832719","Q131867731",
"Q131873534","Q131878558","Q131878557","Q131937223","Q132146006","Q132147475","Q132174324","Q132177851"
    )
    AND pl_from NOT IN (
      select page_id from page where page_title in (
"Q116848188","Q116848554","Q116848687","Q116849232","Q116850082","Q116850081","Q116850095","Q116850099","Q116850103","Q116850100","Q116850736","Q116850741","Q116850745","Q116850759","Q116850762","Q116850772","Q116850787","Q116850784","Q116850790","Q116875633","Q116876299","Q116876321","Q116876325","Q116876339","Q116876360",
"Q116876380","Q116876390","Q116876389","Q116876394","Q116876405","Q116876422","Q116876451","Q116897086","Q116897084","Q116897085","Q116897088","Q116922600","Q116924690","Q116924695","Q116942584","Q116942597","Q116942611","Q116942661","Q116942684","Q116942689","Q116942694","Q116942716","Q116942722","Q116942734","Q116948457",
"Q116948463","Q116948503","Q116948544","Q116948551","Q116948587","Q116948584","Q116948615","Q116948620","Q116948629","Q116948655","Q116948662","Q116948663","Q116948670","Q116948730","Q116948748","Q116948766","Q116948768","Q116968482","Q116969118","Q117021889","Q117076350","Q117077877","Q117088070","Q117088838","Q117196693",
"Q117257124","Q117289957","Q117297772","Q117298846","Q117304033","Q117310724","Q117310784","Q117311173","Q117314458","Q117314471","Q117314473","Q117314476","Q117314732","Q117316110","Q117452137","Q117505917","Q117506901","Q117507646","Q117536194","Q117708497","Q118235588","Q118328452","Q118363112","Q118533636","Q119252500",
"Q119252525","Q119252629","Q119252705","Q119608488","Q120829691","Q121026667","Q121026796","Q121624345","Q122154275","Q122689817","Q122692005","Q122714809","Q122715348","Q122716342","Q122716366","Q122716716","Q122716850","Q122717002","Q122717920","Q122718037","Q122718622","Q122718627","Q122719037","Q122719068","Q122719097",
"Q122719185","Q122719312","Q122719538","Q122719612","Q122720336","Q122721365","Q122721405","Q122721536","Q122721567","Q123163409","Q123163413","Q123236211","Q123236229","Q123266502","Q123523253","Q123663087","Q123835906","Q123835916","Q123836125","Q123836213","Q123836248","Q123836262","Q123836347","Q124313461","Q124367291",
"Q124367319","Q124367390","Q124367451","Q124367449","Q124367462","Q124367466","Q124367472","Q124367479","Q124367580","Q124367592","Q124367636","Q124367666","Q124367674","Q124367802","Q124367835","Q124367863","Q124367873","Q124396360","Q124396369","Q124396429","Q124396443","Q124396440","Q124396475","Q124396529","Q124396542",
"Q124396551","Q124396564","Q124396575","Q124396583","Q124396588","Q124396589","Q124396605","Q124396629","Q124396640","Q124396688","Q124396694","Q124396706","Q124396708","Q124417242","Q124417259","Q124417290","Q124417295","Q124417296","Q124417309","Q124417329","Q124417349","Q124417360","Q124417386","Q124417482","Q124417499",
"Q124417497","Q124417507","Q124417517","Q124417526","Q124417562","Q124417573","Q124417598","Q124417603","Q124417661","Q124417692","Q124417710","Q124417722","Q124417724","Q124417766","Q124417782","Q124417794","Q124417830","Q124417843","Q124417848","Q124417857","Q124417888","Q124470844","Q124470938","Q124470956","Q124470995",
"Q124471027","Q124471031","Q124471066","Q124471127","Q124471233","Q124471460","Q124471483","Q124471519","Q124471618","Q124471647","Q124541607","Q124541610","Q124541611","Q124541614","Q124541640","Q124541650","Q124541664","Q124541674","Q124541724","Q124541760","Q124541799","Q124541822","Q124541850","Q124541892","Q124541899",
"Q124631284","Q124631333","Q124631346","Q124631344","Q124631349","Q124631374","Q124631440","Q124631446","Q124631464","Q124631491","Q124631530","Q124631558","Q124631610","Q124631611","Q124631632","Q124631685","Q124631689","Q124798888","Q124903118","Q124904012","Q124923505","Q124924467","Q125018561","Q125061137","Q125303902",
"Q125389931","Q125389934","Q125441124","Q125798489","Q125798508","Q125798548","Q125863580","Q125863591","Q125863656","Q125863794","Q125863845","Q125863935","Q125864050","Q125864124","Q125864151","Q125864201","Q125864245","Q125864285","Q125864332","Q125864443","Q125866421","Q125866484","Q125866605","Q125876452","Q125876474",
"Q125876546","Q125876578","Q125876605","Q125876630","Q125876650","Q125876791","Q125876809","Q125876867","Q125876963","Q125877014","Q125883797","Q125892410","Q125908399","Q125908440","Q125908480","Q125908508","Q125912625","Q126080976","Q126361540","Q126361546","Q126448042","Q126455184","Q126455463","Q126625706","Q126625762",
"Q126628141","Q126628179","Q126628624","Q126629207","Q126632149","Q126632388","Q126633084","Q126633177","Q126633630","Q126633793","Q126633819","Q126633835","Q126633974","Q126634181","Q126634279","Q126634587","Q126634698","Q126634801","Q126635505","Q126635542","Q126636231","Q126636843","Q126636899","Q126636918","Q126636992",
"Q126637006","Q126637114","Q126637174","Q126637331","Q126637384","Q126637396","Q126637431","Q126637557","Q126637584","Q126637743","Q126637740","Q126637768","Q126637856","Q126637865","Q126637971","Q126638012","Q126638055","Q126638134","Q126638154","Q126638187","Q126638195","Q126638258","Q126638272","Q126638355","Q126638398",
"Q126638397","Q126638405","Q126638415","Q126638526","Q126638569","Q126638981","Q126639472","Q126643340","Q126643715","Q126643724","Q126643743","Q126679668","Q126679681","Q126679684","Q126679694","Q126679693","Q126679815","Q126679831","Q126679859","Q126679866","Q126679884","Q126729427","Q126730613","Q126730625","Q126730649",
"Q126730676","Q126730715","Q126730831","Q126730835","Q126730873","Q126730880","Q126731022","Q126731028","Q126731139","Q126731145","Q126731189","Q126731311","Q126731361","Q126731376","Q126731377","Q126731384","Q126731408","Q126731446","Q126731461","Q126731495","Q126731492","Q126731533","Q126731536","Q126731537","Q126731541",
"Q126731604","Q126731610","Q126731697","Q126731798","Q126731824","Q126731844","Q126731893","Q126731906","Q126731908","Q126731938","Q126731948","Q126731959","Q126731979","Q126732084","Q126732116","Q126732131","Q126732129","Q126732228","Q126732245","Q126732345","Q126732366","Q126732370","Q126732380","Q126732389","Q126732425",
"Q126732429","Q126732519","Q126732546","Q126732630","Q126732660","Q126732987","Q126737762","Q126737933","Q126738025","Q126738092","Q126738107","Q126738159","Q126738234","Q126738264","Q126738284","Q126738342","Q126738427","Q126738446","Q126738482","Q126738534","Q126738555","Q126738604","Q126738696","Q126738814","Q126738902",
"Q126738910","Q126738959","Q126738974","Q126738973","Q126738999","Q126739072","Q126739114","Q126739341","Q126739566","Q126740232","Q126740253","Q126740294","Q126740310","Q126741703","Q126742080","Q126742081","Q126742084","Q126742089","Q126742096","Q126742110","Q126742118","Q126742117","Q126742352","Q126742361","Q126742435",
"Q126742438","Q126742454","Q126742478","Q126742477","Q126742544","Q126742618","Q126742706","Q126742711","Q126742722","Q126742743","Q126742746","Q126742751","Q126742787","Q126742861","Q126742874","Q126742878","Q126742876","Q126742894","Q126743005","Q126743033","Q126743158","Q126743261","Q126743332","Q126743544","Q126743713",
"Q126743880","Q126743916","Q126743972","Q126744098","Q126744141","Q126744150","Q126744158","Q126744201","Q126744220","Q126744266","Q126744273","Q126744423","Q126744617","Q126744621","Q126744711","Q126744708","Q126744739","Q126744895","Q126744922","Q126744947","Q126744954","Q126744972","Q126745005","Q126745030","Q126745034",
"Q126745183","Q126745260","Q126745277","Q126745282","Q126745312","Q126745411","Q126745416","Q126745427","Q126745546","Q126745752","Q126746322","Q126746946","Q126747266","Q126747367","Q126747967","Q126749143","Q126751278","Q126751372","Q126751379","Q126752247","Q126752515","Q126752533","Q126752584","Q126752665","Q126752712",
"Q126753388","Q126753879","Q126753888","Q126754708","Q126754922","Q126754960","Q126755084","Q126755211","Q126755624","Q126756297","Q126756602","Q126757249","Q126757455","Q126757613","Q126765580","Q126765654","Q126765652","Q126766274","Q126768334","Q126769704","Q126769725","Q126775431","Q126955537","Q126955591","Q126955779",
"Q128354641","Q128787831","Q129110517","Q129110665","Q129121051","Q129167196","Q129170322","Q129170410","Q129170425","Q129170479","Q129170490","Q129170504","Q129170521","Q129170558","Q129170566","Q129170567","Q129170583","Q129170621","Q129170668","Q129170699","Q129170705","Q129170721","Q129170726","Q129170764","Q129170784",
"Q129170801","Q129170813","Q129170818","Q129170891","Q129170909","Q129170918","Q129170979","Q129170984","Q129170993","Q129171002","Q129171009","Q129171024","Q129171063","Q129171151","Q129171172","Q129171179","Q129171238","Q129171241","Q129171248","Q129171256","Q129171264","Q129171295","Q129171298","Q129171356","Q129171381",
"Q129171414","Q129171430","Q129171468","Q129171503","Q129171510","Q129171631","Q129171692","Q129171752","Q129171784","Q129171798","Q129171837","Q129171847","Q129171845","Q129171874","Q129171903","Q130350563","Q130351266","Q130351430","Q130355459","Q130360181","Q130637485","Q130901300","Q130901564","Q130901569","Q130901574",
"Q130901581","Q131095669","Q131150419","Q131295134","Q131295138","Q131295140","Q131335471","Q131406539","Q131419223","Q131446624","Q131468203","Q131478133","Q131501037","Q131502410","Q131511572","Q131598599","Q131694428","Q131736463","Q131738639","Q131767358","Q131781780","Q131781811","Q131813708","Q131832719","Q131867731",
"Q131873534","Q131878558","Q131878557","Q131937223","Q132146006","Q132147475","Q132174324","Q132177851"
      )
    )
#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...
