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 ("Q35641794","Q35652439","Q35823007","Q35987974","Q35988690","Q36004849","Q36025822","Q36025828","Q36049474","Q36049656","Q36050409","Q36050416","Q36051553","Q36051558","Q36051663","Q36051667","Q36051850","Q36051978","Q36051985","Q36051990","Q36051996","Q36052000","Q36052004","Q36052087","Q36052091",
"Q36052097","Q36052101","Q36052107","Q36052113","Q36052117","Q36123885","Q36134800","Q36143689","Q36172825","Q37651898","Q37655967","Q38398696","Q38981394","Q41537967","Q41537968","Q41538037","Q41538039","Q44831625","Q47010907","Q47520747","Q47520760","Q49105936","Q49105985","Q49106141","Q49106146",
"Q49106198","Q49150479","Q49150491","Q49176441","Q49176461","Q49176488","Q49237212","Q49237241","Q49237247","Q49656255","Q49696107","Q49718082","Q49747978","Q49751846","Q49783298","Q49842349","Q49877343","Q52686426","Q52896624","Q53129059","Q53129069","Q53129079","Q53129087","Q53331737","Q54663857",
"Q55247812","Q55273284","Q55275511","Q55291023","Q55306157","Q55308365","Q55325818","Q55328750","Q55751153","Q55921641","Q55925355","Q55927544","Q55929809","Q55942256","Q55945464","Q56034138","Q56034348","Q56034349","Q56034357","Q58808240","Q60061537","Q60648164","Q60796960","Q60799329","Q60799340",
"Q60803516","Q60822922","Q60864221","Q61023017","Q61139304","Q61167041","Q61175664","Q61175717","Q61176067","Q61176079","Q61176590","Q61176705","Q61185450","Q61188275","Q61216105","Q61227305","Q61236991","Q61430140","Q62600329","Q63130684","Q63225278","Q63436360","Q64825514","Q65632857","Q65633414",
"Q65637334","Q65638412","Q65639971","Q65649940","Q65661749","Q65663218","Q65664310","Q65664591","Q65664602","Q65664687","Q65689606","Q65696075","Q65698411","Q65700941","Q65702527","Q65710528","Q65710529","Q65710573","Q65710575","Q65710576","Q65710627","Q65710629","Q65711889","Q65712098","Q65712099",
"Q65712100","Q65712102","Q65712103","Q65712527","Q65712531","Q65712533","Q65712628","Q65712633","Q65712637","Q65712680","Q65712699","Q65746499","Q65751612","Q65751616","Q65751618","Q65751620","Q65751761","Q65751763","Q65751766","Q65751767","Q65751769","Q65751771","Q65751773","Q65751775","Q65751777",
"Q65751779","Q65751781","Q65751783","Q65751785","Q65751787","Q65751789","Q65751791","Q65751793","Q65751795","Q65751797","Q65751802","Q65751804","Q65751806","Q65751816","Q65751840","Q65751842","Q65751844","Q65751845","Q65751847","Q65751854","Q65795519","Q65795522","Q65795524","Q65795525","Q65795529",
"Q65939801","Q66011003","Q67614892","Q75117464","Q83371024","Q84020256","Q84089532","Q84252598","Q84632717","Q85696422","Q86129389","Q86129401","Q86129413","Q86162221","Q86162265","Q86224360","Q86240371","Q86273967","Q86332306","Q86335517","Q86338680","Q86338682","Q86343830","Q86763536","Q86783749",
"Q86788741","Q86808179","Q87832121","Q90911695","Q92794644","Q93977028","Q96626940","Q97023645","Q97416783","Q97773766","Q97947467","Q97947498","Q97948091","Q97949276","Q97961516","Q97961744","Q97961752","Q97961766","Q97967432","Q97985174","Q99364945","Q99569604","Q100593708","Q100979349","Q100979478"
)
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q35641794","Q35652439","Q35823007","Q35987974","Q35988690","Q36004849","Q36025822","Q36025828","Q36049474","Q36049656","Q36050409","Q36050416","Q36051553","Q36051558","Q36051663","Q36051667","Q36051850","Q36051978","Q36051985","Q36051990","Q36051996","Q36052000","Q36052004","Q36052087","Q36052091",
"Q36052097","Q36052101","Q36052107","Q36052113","Q36052117","Q36123885","Q36134800","Q36143689","Q36172825","Q37651898","Q37655967","Q38398696","Q38981394","Q41537967","Q41537968","Q41538037","Q41538039","Q44831625","Q47010907","Q47520747","Q47520760","Q49105936","Q49105985","Q49106141","Q49106146",
"Q49106198","Q49150479","Q49150491","Q49176441","Q49176461","Q49176488","Q49237212","Q49237241","Q49237247","Q49656255","Q49696107","Q49718082","Q49747978","Q49751846","Q49783298","Q49842349","Q49877343","Q52686426","Q52896624","Q53129059","Q53129069","Q53129079","Q53129087","Q53331737","Q54663857",
"Q55247812","Q55273284","Q55275511","Q55291023","Q55306157","Q55308365","Q55325818","Q55328750","Q55751153","Q55921641","Q55925355","Q55927544","Q55929809","Q55942256","Q55945464","Q56034138","Q56034348","Q56034349","Q56034357","Q58808240","Q60061537","Q60648164","Q60796960","Q60799329","Q60799340",
"Q60803516","Q60822922","Q60864221","Q61023017","Q61139304","Q61167041","Q61175664","Q61175717","Q61176067","Q61176079","Q61176590","Q61176705","Q61185450","Q61188275","Q61216105","Q61227305","Q61236991","Q61430140","Q62600329","Q63130684","Q63225278","Q63436360","Q64825514","Q65632857","Q65633414",
"Q65637334","Q65638412","Q65639971","Q65649940","Q65661749","Q65663218","Q65664310","Q65664591","Q65664602","Q65664687","Q65689606","Q65696075","Q65698411","Q65700941","Q65702527","Q65710528","Q65710529","Q65710573","Q65710575","Q65710576","Q65710627","Q65710629","Q65711889","Q65712098","Q65712099",
"Q65712100","Q65712102","Q65712103","Q65712527","Q65712531","Q65712533","Q65712628","Q65712633","Q65712637","Q65712680","Q65712699","Q65746499","Q65751612","Q65751616","Q65751618","Q65751620","Q65751761","Q65751763","Q65751766","Q65751767","Q65751769","Q65751771","Q65751773","Q65751775","Q65751777",
"Q65751779","Q65751781","Q65751783","Q65751785","Q65751787","Q65751789","Q65751791","Q65751793","Q65751795","Q65751797","Q65751802","Q65751804","Q65751806","Q65751816","Q65751840","Q65751842","Q65751844","Q65751845","Q65751847","Q65751854","Q65795519","Q65795522","Q65795524","Q65795525","Q65795529",
"Q65939801","Q66011003","Q67614892","Q75117464","Q83371024","Q84020256","Q84089532","Q84252598","Q84632717","Q85696422","Q86129389","Q86129401","Q86129413","Q86162221","Q86162265","Q86224360","Q86240371","Q86273967","Q86332306","Q86335517","Q86338680","Q86338682","Q86343830","Q86763536","Q86783749",
"Q86788741","Q86808179","Q87832121","Q90911695","Q92794644","Q93977028","Q96626940","Q97023645","Q97416783","Q97773766","Q97947467","Q97947498","Q97948091","Q97949276","Q97961516","Q97961744","Q97961752","Q97961766","Q97967432","Q97985174","Q99364945","Q99569604","Q100593708","Q100979349","Q100979478"
)
    )
#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...
