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 ("Q114965636","Q114965767","Q114965883","Q114965908","Q114976150","Q115056109","Q115102939","Q115112507","Q115112634","Q115116117","Q115116522","Q115119845","Q115120148","Q115125356","Q115128603","Q115128601","Q115128638","Q115128741","Q115142142","Q115142158","Q115142263","Q115142318","Q115144207","Q115144783","Q115145334",
"Q115164833","Q115164920","Q115164939","Q115164965","Q115175601","Q115208610","Q115208628","Q115210924","Q115214439","Q115214487","Q115214505","Q115214525","Q115214757","Q115214902","Q115214911","Q115214914","Q115214915","Q115214912","Q115214913","Q115216239","Q115234346","Q115235262","Q115235755","Q115245503","Q115269260",
"Q115270469","Q115298065","Q115307437","Q115325155","Q115325184","Q115325642","Q115327046","Q115366293","Q115377613","Q115378389","Q115398085","Q115473530","Q115473595","Q115473606","Q115491780","Q115491792","Q115492237","Q115492580","Q115493272","Q115493935","Q115493940","Q115493967","Q115493964","Q115493973","Q115494105",
"Q115494940","Q115501702","Q115517985","Q115518079","Q115534259","Q115537118","Q115560788","Q115560818","Q115577767","Q115578263","Q115578359","Q115578442","Q115578559","Q115579087","Q115579495","Q115579682","Q115589950","Q115590036","Q115593679","Q115593697","Q115593800","Q115594324","Q115596838","Q115608567","Q115627237",
"Q115627441","Q115629896","Q115630412","Q115645091","Q115645088","Q115645101","Q115646204","Q115648120","Q115648338","Q115659572","Q115661331","Q115664635","Q115682513","Q115687218","Q115701338","Q115701339","Q115737278","Q115740007","Q115740066","Q115753520","Q115777515","Q115791443","Q115794600","Q115807380","Q115808018",
"Q115808395","Q115809341","Q115809654","Q115810139","Q115810855","Q115812062","Q115812293","Q115812419","Q115812989","Q115813834","Q115814385","Q115814631","Q115814802","Q115814917","Q115815073","Q115815196","Q115815305","Q115815413","Q115815497","Q115815904","Q115816069","Q115816202","Q115816433","Q115816984","Q115817496",
"Q115817623","Q115817773","Q115817873","Q115817986","Q115818454","Q115818894","Q115819015","Q115819422","Q115932182","Q115932304","Q115932339","Q115940895","Q115940963","Q115942527","Q115973179","Q116031891","Q116031892","Q116051227","Q116051450","Q116051460","Q116051467","Q116051499","Q116051552","Q116051560","Q116051568",
"Q116051575","Q116051894","Q116051910","Q116051926","Q116051936","Q116051976","Q116051995","Q116052076","Q116052084","Q116052102","Q116052118","Q116052129","Q116052140","Q116052148","Q116052158","Q116052170","Q116052196","Q116052220","Q116052232","Q116052263","Q116052279","Q116052326","Q116052337","Q116052348","Q116052513",
"Q116052592","Q116052610","Q116052641","Q116052668","Q116052679","Q116052693","Q116052707","Q116171397","Q116198166","Q116198164","Q116205807","Q116206167","Q116263157","Q116263187","Q116263221","Q116263242","Q116263265","Q116263287","Q116263302","Q116263327","Q116283028","Q116347776","Q116374287","Q116441614","Q116441648",
"Q116442011","Q116457267","Q116457301","Q116485942","Q116486255","Q116749858","Q116749963","Q116750008","Q116824154","Q116846020","Q116846980","Q116847003","Q116856106","Q116856104","Q116856105","Q116864274","Q116874336","Q116875425","Q116875432","Q116875872","Q116884219","Q116896587","Q116896600","Q116902298","Q116903662",
"Q116903769","Q116969089","Q116970442","Q116975958","Q116975963","Q116975961","Q116975964","Q116975965","Q117006108","Q117006210","Q117006320","Q117042113","Q117048654","Q117048681","Q117076240","Q117077115","Q117077132","Q117078686","Q117078774","Q117089076","Q117089161","Q117089278","Q117089366","Q117089427","Q117089483",
"Q117089573","Q117089659","Q117089672","Q117089683","Q117089729","Q117101834","Q117135458","Q117135462","Q117232116","Q117314863","Q117321883","Q117324720","Q117353049","Q117369621","Q117383866","Q117475291","Q117477235","Q117477250","Q117477248","Q117477254","Q117477252","Q117477258","Q117477256","Q117477262","Q117477263",
"Q117477260","Q117477266","Q117477265","Q117477274","Q117477275","Q117477273","Q117477278","Q117477279","Q117477276","Q117477277","Q117477283","Q117477281","Q117536333","Q117707504","Q117709009","Q117774688","Q117774689","Q117774698","Q117774699","Q117774701","Q117774709","Q117774719","Q117774716","Q117774717","Q117774723",
"Q117774720","Q117774727","Q117774724","Q117774725","Q117774730","Q117774731","Q117774734","Q117774732","Q117774733","Q117774738","Q117774739","Q117774736","Q117774737","Q117774742","Q117774743","Q117774741","Q117774746","Q117774747","Q117774744","Q117774750","Q117774751","Q117774748","Q117774749","Q117774755","Q117774752",
"Q117826476","Q117867405","Q118105218","Q118154723","Q118156254","Q118162770","Q118162782","Q118162799","Q118162796","Q118162803","Q118162801","Q118162807","Q118162805","Q118162817","Q118162872","Q118162879","Q118162890","Q118162901","Q118162912","Q118162939","Q118162942","Q118162940","Q118162947","Q118162944","Q118162955",
"Q118162966","Q118163002","Q118163011","Q118163015","Q118163013","Q118163021","Q118163066","Q118163079","Q118163343","Q118163367","Q118163435","Q118163438","Q118163437","Q118163441","Q118163447","Q118163448","Q118163455","Q118163453","Q118163458","Q118163459","Q118163461","Q118163466","Q118163467","Q118163464","Q118163470",
"Q118163471","Q118163468","Q118186460","Q118235051","Q118236081","Q118287208","Q118324163","Q118325310","Q118381966","Q118396999","Q118779730","Q118779731","Q118779728","Q118779729","Q118779734","Q118779732","Q118779733","Q118779738","Q118779736","Q118779737","Q118779740","Q118779831","Q118779980","Q118780206","Q118780489",
"Q118780535","Q118780795","Q119254641","Q119266257","Q119349329","Q119360322","Q119397714","Q119405060","Q119560139","Q119718786","Q119803209","Q119941144","Q119949737","Q119950295","Q119950322","Q119998172","Q120038833","Q120345693","Q120345710","Q120348078","Q120349680","Q120349774","Q120379260","Q120441536","Q120534037",
"Q120629534","Q120629605","Q120634681","Q120689127","Q120731607","Q120731611","Q120731609","Q120749773","Q120761381","Q120762325","Q120785468","Q120844914","Q120966359","Q120966673","Q121001451","Q121067750","Q121085687","Q121085848","Q121184792","Q121314493","Q121359836","Q121360528","Q121674635","Q121815374","Q121865361",
"Q122030897","Q122030945","Q122149266","Q122202476","Q122205888","Q122205902","Q122609515","Q122657805","Q122658095","Q122689446","Q122689537","Q122689844","Q122689863","Q122689994","Q122690049","Q122690064","Q122690437","Q122690662","Q122690949","Q122691026","Q122691230","Q122691313","Q122691435","Q122691913","Q122693523",
"Q122693855","Q122694005","Q122717492","Q122719488","Q122719957","Q122720151","Q122720161","Q122749639","Q122780768","Q122811466","Q122811558","Q122811615","Q122812063","Q122813044","Q122841277","Q122919505","Q122919568","Q122919733","Q122919819","Q122937871","Q122937926","Q122938044","Q122938083","Q122938176","Q122938425",
"Q122938449","Q122938490","Q123125439","Q123236505","Q123236714","Q123315819","Q123456883","Q123466615","Q123503597","Q123563599","Q123573004","Q123597049","Q123600205","Q123600533","Q123601056","Q123694194","Q123750862","Q123750863","Q123750892","Q123756299","Q123772606","Q123774384","Q123860477","Q123914669","Q123995430",
"Q124005273","Q124049160","Q124059395","Q124085948","Q124213859","Q124293067","Q124349999","Q124370205","Q124393318","Q124419586","Q124433142","Q124454324","Q124459629","Q124459881","Q124461275","Q124541477","Q124635037","Q124635571","Q124636101","Q124637203","Q124736413","Q124743685","Q124744499","Q124749284","Q124773058",
"Q124798888","Q124799181","Q124822754","Q124891232","Q124892284","Q124914211","Q124914212","Q124914567","Q124914572","Q124914614","Q124914615","Q124914613","Q124924042","Q124924051","Q124924059","Q124924068","Q124924083","Q124924093","Q124924100","Q124924106","Q124924111","Q124924121","Q124924128","Q124924135","Q124924143",
"Q124924152","Q124924157","Q124924161","Q124924169","Q124924173","Q124924184","Q124924190","Q124924195","Q124924247","Q124969735","Q125001468","Q125012891","Q125012895","Q125012896","Q125059010","Q125060963","Q125063644","Q125065776","Q125068787","Q125074353","Q125084381","Q125090291","Q125096785","Q125108138","Q125108864",
"Q125109611","Q125111648","Q125117059","Q125122673","Q125134981","Q125145375","Q125188427","Q125188602","Q125210515","Q125220131","Q125224236","Q125251353","Q125294686","Q125358314","Q125386558","Q125398998","Q125402702","Q125402885","Q125405740","Q125420701","Q125426425","Q125429163","Q125429471","Q125429474","Q125429472",
"Q125429473","Q125429494","Q125429492","Q125429499","Q125429496","Q125429502","Q125429501","Q125429506","Q125429504","Q125429508","Q125429513","Q125429524","Q125429528","Q125435837","Q125436039","Q125436040","Q125444431","Q125445118","Q125445164","Q125453391","Q125465823","Q125547251","Q125550164","Q125552808","Q125601263",
"Q125624153","Q125687668","Q125687687","Q125687697","Q125705748","Q125741245","Q125741311","Q125741446","Q125741967","Q125745932","Q125747071","Q125747938","Q125747959","Q125748359","Q125750578","Q125759936","Q125767705","Q125797418","Q125798641","Q125798903","Q125798924","Q125799434","Q125801315","Q125802077","Q125802103",
"Q126736685","Q126736766","Q126888519","Q126890768","Q125802202","Q125810294","Q125810622","Q125810699","Q125833933","Q125835376","Q125838387","Q125862813","Q125863007","Q125863042","Q125863064","Q125882380","Q125882430","Q125882567","Q125883498","Q125887523","Q125889175","Q125889172","Q125889187","Q125889229","Q125889318",
"Q125889316","Q125906518","Q125910079","Q125910755","Q125913149","Q125915423","Q125915510","Q125923046","Q125923054","Q125923062","Q125923066","Q125923069","Q125925072","Q125926200","Q125926240","Q125931405","Q125931436","Q125933675","Q125933921","Q125933954","Q125933975","Q125934106","Q125934165","Q125938302","Q125941813",
"Q125942176","Q125942214","Q125942399","Q125942502","Q125942585","Q125947514","Q125947740","Q125952314","Q125952347","Q125963042","Q125963045","Q125988522","Q125988757","Q126050406","Q126068416","Q126068456","Q126080726","Q126081481","Q126107618","Q126110609","Q126117343","Q126130520","Q126165450","Q126169663","Q126192721",
"Q126197152","Q126197841","Q126197910","Q126197956","Q126198005","Q126198170","Q126198182","Q126198268","Q126198276","Q126198301","Q126198339","Q126198376","Q126198497","Q126253309","Q126283004","Q126320123","Q126320218","Q126320269","Q126320327","Q126320744","Q126320778","Q126321297","Q126366688","Q126438786","Q126551793",
"Q126599023","Q126717772","Q126717797","Q126725315"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q114965636","Q114965767","Q114965883","Q114965908","Q114976150","Q115056109","Q115102939","Q115112507","Q115112634","Q115116117","Q115116522","Q115119845","Q115120148","Q115125356","Q115128603","Q115128601","Q115128638","Q115128741","Q115142142","Q115142158","Q115142263","Q115142318","Q115144207","Q115144783","Q115145334",
"Q115164833","Q115164920","Q115164939","Q115164965","Q115175601","Q115208610","Q115208628","Q115210924","Q115214439","Q115214487","Q115214505","Q115214525","Q115214757","Q115214902","Q115214911","Q115214914","Q115214915","Q115214912","Q115214913","Q115216239","Q115234346","Q115235262","Q115235755","Q115245503","Q115269260",
"Q115270469","Q115298065","Q115307437","Q115325155","Q115325184","Q115325642","Q115327046","Q115366293","Q115377613","Q115378389","Q115398085","Q115473530","Q115473595","Q115473606","Q115491780","Q115491792","Q115492237","Q115492580","Q115493272","Q115493935","Q115493940","Q115493967","Q115493964","Q115493973","Q115494105",
"Q115494940","Q115501702","Q115517985","Q115518079","Q115534259","Q115537118","Q115560788","Q115560818","Q115577767","Q115578263","Q115578359","Q115578442","Q115578559","Q115579087","Q115579495","Q115579682","Q115589950","Q115590036","Q115593679","Q115593697","Q115593800","Q115594324","Q115596838","Q115608567","Q115627237",
"Q115627441","Q115629896","Q115630412","Q115645091","Q115645088","Q115645101","Q115646204","Q115648120","Q115648338","Q115659572","Q115661331","Q115664635","Q115682513","Q115687218","Q115701338","Q115701339","Q115737278","Q115740007","Q115740066","Q115753520","Q115777515","Q115791443","Q115794600","Q115807380","Q115808018",
"Q115808395","Q115809341","Q115809654","Q115810139","Q115810855","Q115812062","Q115812293","Q115812419","Q115812989","Q115813834","Q115814385","Q115814631","Q115814802","Q115814917","Q115815073","Q115815196","Q115815305","Q115815413","Q115815497","Q115815904","Q115816069","Q115816202","Q115816433","Q115816984","Q115817496",
"Q115817623","Q115817773","Q115817873","Q115817986","Q115818454","Q115818894","Q115819015","Q115819422","Q115932182","Q115932304","Q115932339","Q115940895","Q115940963","Q115942527","Q115973179","Q116031891","Q116031892","Q116051227","Q116051450","Q116051460","Q116051467","Q116051499","Q116051552","Q116051560","Q116051568",
"Q116051575","Q116051894","Q116051910","Q116051926","Q116051936","Q116051976","Q116051995","Q116052076","Q116052084","Q116052102","Q116052118","Q116052129","Q116052140","Q116052148","Q116052158","Q116052170","Q116052196","Q116052220","Q116052232","Q116052263","Q116052279","Q116052326","Q116052337","Q116052348","Q116052513",
"Q116052592","Q116052610","Q116052641","Q116052668","Q116052679","Q116052693","Q116052707","Q116171397","Q116198166","Q116198164","Q116205807","Q116206167","Q116263157","Q116263187","Q116263221","Q116263242","Q116263265","Q116263287","Q116263302","Q116263327","Q116283028","Q116347776","Q116374287","Q116441614","Q116441648",
"Q116442011","Q116457267","Q116457301","Q116485942","Q116486255","Q116749858","Q116749963","Q116750008","Q116824154","Q116846020","Q116846980","Q116847003","Q116856106","Q116856104","Q116856105","Q116864274","Q116874336","Q116875425","Q116875432","Q116875872","Q116884219","Q116896587","Q116896600","Q116902298","Q116903662",
"Q116903769","Q116969089","Q116970442","Q116975958","Q116975963","Q116975961","Q116975964","Q116975965","Q117006108","Q117006210","Q117006320","Q117042113","Q117048654","Q117048681","Q117076240","Q117077115","Q117077132","Q117078686","Q117078774","Q117089076","Q117089161","Q117089278","Q117089366","Q117089427","Q117089483",
"Q117089573","Q117089659","Q117089672","Q117089683","Q117089729","Q117101834","Q117135458","Q117135462","Q117232116","Q117314863","Q117321883","Q117324720","Q117353049","Q117369621","Q117383866","Q117475291","Q117477235","Q117477250","Q117477248","Q117477254","Q117477252","Q117477258","Q117477256","Q117477262","Q117477263",
"Q117477260","Q117477266","Q117477265","Q117477274","Q117477275","Q117477273","Q117477278","Q117477279","Q117477276","Q117477277","Q117477283","Q117477281","Q117536333","Q117707504","Q117709009","Q117774688","Q117774689","Q117774698","Q117774699","Q117774701","Q117774709","Q117774719","Q117774716","Q117774717","Q117774723",
"Q117774720","Q117774727","Q117774724","Q117774725","Q117774730","Q117774731","Q117774734","Q117774732","Q117774733","Q117774738","Q117774739","Q117774736","Q117774737","Q117774742","Q117774743","Q117774741","Q117774746","Q117774747","Q117774744","Q117774750","Q117774751","Q117774748","Q117774749","Q117774755","Q117774752",
"Q117826476","Q117867405","Q118105218","Q118154723","Q118156254","Q118162770","Q118162782","Q118162799","Q118162796","Q118162803","Q118162801","Q118162807","Q118162805","Q118162817","Q118162872","Q118162879","Q118162890","Q118162901","Q118162912","Q118162939","Q118162942","Q118162940","Q118162947","Q118162944","Q118162955",
"Q118162966","Q118163002","Q118163011","Q118163015","Q118163013","Q118163021","Q118163066","Q118163079","Q118163343","Q118163367","Q118163435","Q118163438","Q118163437","Q118163441","Q118163447","Q118163448","Q118163455","Q118163453","Q118163458","Q118163459","Q118163461","Q118163466","Q118163467","Q118163464","Q118163470",
"Q118163471","Q118163468","Q118186460","Q118235051","Q118236081","Q118287208","Q118324163","Q118325310","Q118381966","Q118396999","Q118779730","Q118779731","Q118779728","Q118779729","Q118779734","Q118779732","Q118779733","Q118779738","Q118779736","Q118779737","Q118779740","Q118779831","Q118779980","Q118780206","Q118780489",
"Q118780535","Q118780795","Q119254641","Q119266257","Q119349329","Q119360322","Q119397714","Q119405060","Q119560139","Q119718786","Q119803209","Q119941144","Q119949737","Q119950295","Q119950322","Q119998172","Q120038833","Q120345693","Q120345710","Q120348078","Q120349680","Q120349774","Q120379260","Q120441536","Q120534037",
"Q120629534","Q120629605","Q120634681","Q120689127","Q120731607","Q120731611","Q120731609","Q120749773","Q120761381","Q120762325","Q120785468","Q120844914","Q120966359","Q120966673","Q121001451","Q121067750","Q121085687","Q121085848","Q121184792","Q121314493","Q121359836","Q121360528","Q121674635","Q121815374","Q121865361",
"Q122030897","Q122030945","Q122149266","Q122202476","Q122205888","Q122205902","Q122609515","Q122657805","Q122658095","Q122689446","Q122689537","Q122689844","Q122689863","Q122689994","Q122690049","Q122690064","Q122690437","Q122690662","Q122690949","Q122691026","Q122691230","Q122691313","Q122691435","Q122691913","Q122693523",
"Q122693855","Q122694005","Q122717492","Q122719488","Q122719957","Q122720151","Q122720161","Q122749639","Q122780768","Q122811466","Q122811558","Q122811615","Q122812063","Q122813044","Q122841277","Q122919505","Q122919568","Q122919733","Q122919819","Q122937871","Q122937926","Q122938044","Q122938083","Q122938176","Q122938425",
"Q122938449","Q122938490","Q123125439","Q123236505","Q123236714","Q123315819","Q123456883","Q123466615","Q123503597","Q123563599","Q123573004","Q123597049","Q123600205","Q123600533","Q123601056","Q123694194","Q123750862","Q123750863","Q123750892","Q123756299","Q123772606","Q123774384","Q123860477","Q123914669","Q123995430",
"Q124005273","Q124049160","Q124059395","Q124085948","Q124213859","Q124293067","Q124349999","Q124370205","Q124393318","Q124419586","Q124433142","Q124454324","Q124459629","Q124459881","Q124461275","Q124541477","Q124635037","Q124635571","Q124636101","Q124637203","Q124736413","Q124743685","Q124744499","Q124749284","Q124773058",
"Q124798888","Q124799181","Q124822754","Q124891232","Q124892284","Q124914211","Q124914212","Q124914567","Q124914572","Q124914614","Q124914615","Q124914613","Q124924042","Q124924051","Q124924059","Q124924068","Q124924083","Q124924093","Q124924100","Q124924106","Q124924111","Q124924121","Q124924128","Q124924135","Q124924143",
"Q124924152","Q124924157","Q124924161","Q124924169","Q124924173","Q124924184","Q124924190","Q124924195","Q124924247","Q124969735","Q125001468","Q125012891","Q125012895","Q125012896","Q125059010","Q125060963","Q125063644","Q125065776","Q125068787","Q125074353","Q125084381","Q125090291","Q125096785","Q125108138","Q125108864",
"Q125109611","Q125111648","Q125117059","Q125122673","Q125134981","Q125145375","Q125188427","Q125188602","Q125210515","Q125220131","Q125224236","Q125251353","Q125294686","Q125358314","Q125386558","Q125398998","Q125402702","Q125402885","Q125405740","Q125420701","Q125426425","Q125429163","Q125429471","Q125429474","Q125429472",
"Q125429473","Q125429494","Q125429492","Q125429499","Q125429496","Q125429502","Q125429501","Q125429506","Q125429504","Q125429508","Q125429513","Q125429524","Q125429528","Q125435837","Q125436039","Q125436040","Q125444431","Q125445118","Q125445164","Q125453391","Q125465823","Q125547251","Q125550164","Q125552808","Q125601263",
"Q125624153","Q125687668","Q125687687","Q125687697","Q125705748","Q125741245","Q125741311","Q125741446","Q125741967","Q125745932","Q125747071","Q125747938","Q125747959","Q125748359","Q125750578","Q125759936","Q125767705","Q125797418","Q125798641","Q125798903","Q125798924","Q125799434","Q125801315","Q125802077","Q125802103",
"Q126736685","Q126736766","Q126888519","Q126890768","Q125802202","Q125810294","Q125810622","Q125810699","Q125833933","Q125835376","Q125838387","Q125862813","Q125863007","Q125863042","Q125863064","Q125882380","Q125882430","Q125882567","Q125883498","Q125887523","Q125889175","Q125889172","Q125889187","Q125889229","Q125889318",
"Q125889316","Q125906518","Q125910079","Q125910755","Q125913149","Q125915423","Q125915510","Q125923046","Q125923054","Q125923062","Q125923066","Q125923069","Q125925072","Q125926200","Q125926240","Q125931405","Q125931436","Q125933675","Q125933921","Q125933954","Q125933975","Q125934106","Q125934165","Q125938302","Q125941813",
"Q125942176","Q125942214","Q125942399","Q125942502","Q125942585","Q125947514","Q125947740","Q125952314","Q125952347","Q125963042","Q125963045","Q125988522","Q125988757","Q126050406","Q126068416","Q126068456","Q126080726","Q126081481","Q126107618","Q126110609","Q126117343","Q126130520","Q126165450","Q126169663","Q126192721",
"Q126197152","Q126197841","Q126197910","Q126197956","Q126198005","Q126198170","Q126198182","Q126198268","Q126198276","Q126198301","Q126198339","Q126198376","Q126198497","Q126253309","Q126283004","Q126320123","Q126320218","Q126320269","Q126320327","Q126320744","Q126320778","Q126321297","Q126366688","Q126438786","Q126551793",
"Q126599023","Q126717772","Q126717797","Q126725315"
)
    )
#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...
