Untitled query #64023

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

SELECT DISTINCT pl_title#, COUNT(*)
FROM pagelinks
LEFT JOIN page ON 
	pl_title = page_title 
	AND pl_namespace = page_namespace
WHERE
	pl_from_namespace IN (0, 120, 146)
	AND pl_namespace IN (0, 120, 146)
	AND pl_title in ("Q86331100","Q9049552","Q15207464","Q9049619","Q9049641","Q86332513","Q60928439","Q25213860","Q9049789","Q9049832","Q9049852","Q32091314","Q97407078","Q102749558","Q15961060","Q9051007","Q49750521","Q25214964","Q9050124","Q28791860","Q15207575","Q97407080","Q32083231","Q15920999","Q9050319","Q32068983","Q9050394","Q9050406","Q9050416","Q60918808","Q86301663","Q97407081","Q9050580","Q15929554","Q9050627","Q9050704","Q97407083","Q9050723","Q9050733","Q9052138","Q21423038","Q9050911","Q32081168","Q60910785","Q66660259","Q9051057","Q97407086","Q9051128","Q18046017","Q86312479","Q60901449","Q60900962","Q15205917","Q97407088","Q9051383","Q8647706","Q32225180","Q9051477","Q9051513","Q60905093","Q86328660","Q9051652","Q9051704","Q9051751","Q9051755","Q9052274","Q60914872","Q86329516","Q60903424","Q32086295","Q8862495","Q32087884","Q86331194","Q15149694","Q9052504","Q9052371","Q15960588","Q9053331","Q8289863","Q97407092","Q65618260","Q97407094","Q97407096","Q97407097","Q86270667","Q8234662","Q105723742","Q86288659","Q97407098","Q32086052","Q97407102","Q19691024","Q9053671","Q9053687","Q97407106","Q9053747","Q97407109","Q32068823","Q97407111","Q32103252","Q97407115","Q9053912","Q97407117","Q97407121","Q97407123","Q86288658","Q32046226","Q9053961","Q65751478","Q20644401","Q86325566","Q32087823","Q9054081","Q15210909","Q97407126","Q97407128","Q60900797","Q60910396","Q60900848","Q9054231","Q55758177","Q9054267","Q97407135","Q112144519","Q86328027","Q9054331","Q65751671","Q9054445","Q65618091","Q65751553","Q60896210","Q86308707","Q60912008","Q97407138","Q66625210","Q86292897","Q97407140","Q18819858","Q60927607","Q32088980","Q97407142","Q62697131","Q9054768","Q97407148","Q65751476","Q86304096","Q65618090","Q15961066","Q86330679","Q9054904","Q97407158","Q65619226","Q65752124","Q86325893","Q9055000","Q86332466","Q86328286","Q32218025","Q86294731","Q61744837","Q18819831","Q86270665","Q97407160","Q60934172","Q97407162","Q97407164","Q86327957","Q97407167","Q60931571","Q18819852","Q86331147","Q97407170","Q97407172","Q97407174","Q9055372","Q97407176","Q9055395","Q86299374","Q9055411","Q9055476","Q32086685","Q32318145","Q9055496","Q97407178","Q9055541","Q9055578","Q9054394","Q15213771","Q9055694","Q15210684","Q32088047","Q60931120","Q97407182","Q18965658","Q97407184","Q9055996","Q86327770","Q15213950","Q15213985","Q60896979","Q9056110","Q86314147","Q65752415","Q60897582","Q97407188","Q86327791","Q97407190","Q86270610","Q32083224","Q9056329","Q9056343","Q9056395","Q9056400","Q9056403","Q97407193","Q86293195","Q32070931","Q9056443","Q97407196","Q9056579","Q9056598","Q97407200","Q32069873","Q60930369","Q23712199","Q65751480","Q97407202","Q65752307","Q86288294","Q97407205","Q32092558","Q9056852","Q9056865","Q9056934","Q60904082","Q60902302","Q9057071","Q86304135","Q9057093","Q86288092","Q9057098","Q65751825","Q86288384","Q20971682","Q86327894","Q97407208","Q9057293","Q97407211","Q20972813","Q60902130","Q20972864","Q9057394","Q97407212","Q19853506","Q86326896","Q9057524","Q9057533","Q65752413","Q97407215","Q9057735","Q97407221","Q97407229","Q86299375","Q9057984","Q86327893","Q15214791","Q9058041","Q9058374","Q9058089","Q9058124","Q97407240","Q60928719","Q86304132","Q60896200","Q65752136","Q86308925","Q60930920","Q9052060","Q9058503","Q86296487","Q86326940","Q86323252","Q97407245","Q97407247","Q97407249","Q15633481","Q97407251","Q86308782","Q9058818")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q86331100","Q9049552","Q15207464","Q9049619","Q9049641","Q86332513","Q60928439","Q25213860","Q9049789","Q9049832","Q9049852","Q32091314","Q97407078","Q102749558","Q15961060","Q9051007","Q49750521","Q25214964","Q9050124","Q28791860","Q15207575","Q97407080","Q32083231","Q15920999","Q9050319","Q32068983","Q9050394","Q9050406","Q9050416","Q60918808","Q86301663","Q97407081","Q9050580","Q15929554","Q9050627","Q9050704","Q97407083","Q9050723","Q9050733","Q9052138","Q21423038","Q9050911","Q32081168","Q60910785","Q66660259","Q9051057","Q97407086","Q9051128","Q18046017","Q86312479","Q60901449","Q60900962","Q15205917","Q97407088","Q9051383","Q8647706","Q32225180","Q9051477","Q9051513","Q60905093","Q86328660","Q9051652","Q9051704","Q9051751","Q9051755","Q9052274","Q60914872","Q86329516","Q60903424","Q32086295","Q8862495","Q32087884","Q86331194","Q15149694","Q9052504","Q9052371","Q15960588","Q9053331","Q8289863","Q97407092","Q65618260","Q97407094","Q97407096","Q97407097","Q86270667","Q8234662","Q105723742","Q86288659","Q97407098","Q32086052","Q97407102","Q19691024","Q9053671","Q9053687","Q97407106","Q9053747","Q97407109","Q32068823","Q97407111","Q32103252","Q97407115","Q9053912","Q97407117","Q97407121","Q97407123","Q86288658","Q32046226","Q9053961","Q65751478","Q20644401","Q86325566","Q32087823","Q9054081","Q15210909","Q97407126","Q97407128","Q60900797","Q60910396","Q60900848","Q9054231","Q55758177","Q9054267","Q97407135","Q112144519","Q86328027","Q9054331","Q65751671","Q9054445","Q65618091","Q65751553","Q60896210","Q86308707","Q60912008","Q97407138","Q66625210","Q86292897","Q97407140","Q18819858","Q60927607","Q32088980","Q97407142","Q62697131","Q9054768","Q97407148","Q65751476","Q86304096","Q65618090","Q15961066","Q86330679","Q9054904","Q97407158","Q65619226","Q65752124","Q86325893","Q9055000","Q86332466","Q86328286","Q32218025","Q86294731","Q61744837","Q18819831","Q86270665","Q97407160","Q60934172","Q97407162","Q97407164","Q86327957","Q97407167","Q60931571","Q18819852","Q86331147","Q97407170","Q97407172","Q97407174","Q9055372","Q97407176","Q9055395","Q86299374","Q9055411","Q9055476","Q32086685","Q32318145","Q9055496","Q97407178","Q9055541","Q9055578","Q9054394","Q15213771","Q9055694","Q15210684","Q32088047","Q60931120","Q97407182","Q18965658","Q97407184","Q9055996","Q86327770","Q15213950","Q15213985","Q60896979","Q9056110","Q86314147","Q65752415","Q60897582","Q97407188","Q86327791","Q97407190","Q86270610","Q32083224","Q9056329","Q9056343","Q9056395","Q9056400","Q9056403","Q97407193","Q86293195","Q32070931","Q9056443","Q97407196","Q9056579","Q9056598","Q97407200","Q32069873","Q60930369","Q23712199","Q65751480","Q97407202","Q65752307","Q86288294","Q97407205","Q32092558","Q9056852","Q9056865","Q9056934","Q60904082","Q60902302","Q9057071","Q86304135","Q9057093","Q86288092","Q9057098","Q65751825","Q86288384","Q20971682","Q86327894","Q97407208","Q9057293","Q97407211","Q20972813","Q60902130","Q20972864","Q9057394","Q97407212","Q19853506","Q86326896","Q9057524","Q9057533","Q65752413","Q97407215","Q9057735","Q97407221","Q97407229","Q86299375","Q9057984","Q86327893","Q15214791","Q9058041","Q9058374","Q9058089","Q9058124","Q97407240","Q60928719","Q86304132","Q60896200","Q65752136","Q86308925","Q60930920","Q9052060","Q9058503","Q86296487","Q86326940","Q86323252","Q97407245","Q97407247","Q97407249","Q15633481","Q97407251","Q86308782","Q9058818")
    )
#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...
