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 ("Q42","Q8662436","Q8869532","Q8912548","Q9100118","Q10813441","Q13313174","Q14630220","Q15253018","Q15373519","Q15404150","Q15727279","Q17276994","Q19853461","Q22267838","Q22575672","Q23876664","Q24460896","Q25015027","Q25030305","Q25221025","Q25243602","Q25304443","Q25335452","Q25710804","Q27883812","Q28435256","Q28438662","Q28439339","Q28459615","Q30733099","Q30792175","Q30792266","Q30793041","Q30998537","Q31000767","Q31000770","Q31001304","Q31014637","Q32212676","Q32254973","Q32282067","Q32289906","Q32298448","Q32313232","Q32353246","Q32358486","Q32367594","Q32370297","Q32370343","Q32370346","Q32370349","Q32375901","Q32384149","Q32390133","Q32392947","Q32393804","Q32394118","Q32399078","Q32405084","Q32407472","Q32407843","Q32412165","Q32417032","Q32436611","Q32453105","Q32453415","Q32453506","Q32454853","Q32462618","Q32470875","Q32473390","Q32481804","Q32492778","Q32493009","Q32494534","Q32494977","Q32500823","Q32511452","Q32527353","Q32543049","Q32550288","Q32587830","Q32599348","Q32606281","Q32606729","Q32643516","Q32645517","Q32723121","Q32725285","Q32732931","Q32739506","Q32756604","Q32776039","Q32780051","Q32791458","Q32802518","Q32956088","Q32994683","Q33017814","Q33069746","Q34524685","Q35457512","Q36052851","Q36054213","Q36055179","Q47737099","Q49666627","Q49667966","Q49674769","Q49747785","Q49751035","Q49751040","Q49804342","Q49867871","Q49883274","Q50406859","Q51142586","Q53844019","Q54483716","Q54483848","Q54483871","Q54484299","Q54484313","Q54484408","Q54484709","Q54519218","Q54519234","Q54519305","Q54528055","Q54614444","Q54654845","Q54657338","Q54657590","Q54658740","Q54659086","Q54663260","Q54663285","Q54663300","Q54663446","Q54663546","Q54663800","Q54666057","Q55242507","Q55243053","Q55243170","Q55245699","Q55247034","Q55248403","Q55248686","Q55249112","Q55252396","Q55267618","Q55268623","Q55272089","Q55277114","Q55288787","Q55289497","Q55289649","Q55292277","Q55297368","Q55301803","Q55303593","Q55303863","Q55304013","Q55323783","Q55328219","Q55328708","Q55329045","Q55329694","Q55331560","Q55342458","Q55827225","Q55917799","Q55928527","Q55929561","Q55986520","Q55995398","Q58504633","Q60616930","Q60803888","Q60803891","Q60803902","Q60803903","Q60803907","Q60803908","Q60806474","Q60812455","Q60812982","Q60878560","Q60893125","Q60896167","Q61025231","Q61171608","Q61172993","Q61193544","Q61404424","Q61723517","Q61985070","Q63368700","Q63677177","Q64748929","Q64821334","Q65278659","Q65608032","Q65614460","Q65614522","Q65690803","Q65757119","Q68936991","Q69998625","Q72946519","Q72947262","Q74844177","Q75103577","Q75886965","Q76465788","Q76658718","Q76756190","Q77584351","Q80101076","Q80101632","Q80191607","Q81655323","Q82068579","Q83798797","Q83890106","Q83895268","Q83902493","Q83903022","Q83903036","Q84114771","Q84255171","Q84260977","Q84262719","Q84357658","Q84612571","Q86801271","Q87536288","Q87880291","Q90726642","Q95432680","Q95607904","Q95608300","Q95609411","Q95934006","Q95949344","Q95998877","Q96030493","Q96048108","Q96143024","Q96143232","Q97179695","Q97425324","Q97434422","Q97621036","Q97767306","Q97800311","Q98968184","Q100276480","Q100893972","Q101069485","Q101204772","Q101920005","Q103818218","Q103818965","Q104054042","Q104373996","Q104439905","Q104672073","Q105203814","Q105214755","Q105292153","Q105411616","Q105412665","Q105412981","Q105420802","Q105503642","Q105540587","Q105540590","Q105540653","Q105540732","Q105541618","Q105766023","Q105799271","Q105825940","Q105958902","Q106395112","Q106419712","Q106639930","Q106643192","Q106643206","Q106650371","Q106697741","Q106703383","Q106756489","Q106902470","Q107400289","Q107463135","Q107627615","Q119212037","Q119224839","Q119239044","Q119518794","Q119626929","Q119730001","Q119950051","Q119973528","Q120450769","Q120491819","Q108105664","Q108668980","Q108774602","Q108803299","Q108904664","Q108938386","Q109466698","Q109466702","Q109548562","Q109626728","Q109626741","Q109626747","Q109631621","Q109631628","Q109631632","Q109631638","Q110165693","Q110295467","Q110306024","Q110322879","Q110343041","Q110472374","Q110583186","Q110617295","Q110731927","Q110753367","Q110753388","Q110753872","Q110823954","Q110950333","Q111314074","Q111377824","Q111377834","Q111377844","Q111377950","Q111436860","Q111511042","Q111540649","Q111593493","Q111826222","Q111838988","Q111881353","Q111903513","Q111969171","Q112157280","Q112168123","Q112208902","Q112299948","Q112526120","Q112845636","Q112941771","Q113086905","Q113112369","Q113117664","Q113172302","Q113261797","Q113512159","Q113572607","Q113586514","Q113955313","Q114041181","Q114222378","Q114333087","Q114497991","Q114591693","Q115012425","Q115140076","Q115152769","Q115283933","Q115429604","Q115522048","Q115682991","Q115780569","Q115858786","Q115934462","Q115996220","Q116205449","Q116262309","Q116311903","Q116414590","Q116688127","Q116745758","Q116751684","Q116786091","Q116811666","Q116907590","Q116951792","Q116959700","Q116973606","Q117070534","Q117794412","Q117861575","Q118410942","Q118867509","Q118895683","Q118903764","Q118915697","Q119021574","Q119139983","Q119198742")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q8015573","Q8662436","Q8869532","Q8912548","Q9100118","Q10813441","Q13313174","Q14630220","Q15253018","Q15373519","Q15404150","Q15727279","Q17276994","Q19853461","Q22267838","Q22575672","Q23876664","Q24460896","Q25015027","Q25030305","Q25221025","Q25243602","Q25304443","Q25335452","Q25710804","Q27883812","Q28435256","Q28438662","Q28439339","Q28459615","Q30733099","Q30792175","Q30792266","Q30793041","Q30998537","Q31000767","Q31000770","Q31001304","Q31014637","Q32212676","Q32254973","Q32282067","Q32289906","Q32298448","Q32313232","Q32353246","Q32358486","Q32367594","Q32370297","Q32370343","Q32370346","Q32370349","Q32375901","Q32384149","Q32390133","Q32392947","Q32393804","Q32394118","Q32399078","Q32405084","Q32407472","Q32407843","Q32412165","Q32417032","Q32436611","Q32453105","Q32453415","Q32453506","Q32454853","Q32462618","Q32470875","Q32473390","Q32481804","Q32492778","Q32493009","Q32494534","Q32494977","Q32500823","Q32511452","Q32527353","Q32543049","Q32550288","Q32587830","Q32599348","Q32606281","Q32606729","Q32643516","Q32645517","Q32723121","Q32725285","Q32732931","Q32739506","Q32756604","Q32776039","Q32780051","Q32791458","Q32802518","Q32956088","Q32994683","Q33017814","Q33069746","Q34524685","Q35457512","Q36052851","Q36054213","Q36055179","Q47737099","Q49666627","Q49667966","Q49674769","Q49747785","Q49751035","Q49751040","Q49804342","Q49867871","Q49883274","Q50406859","Q51142586","Q53844019","Q54483716","Q54483848","Q54483871","Q54484299","Q54484313","Q54484408","Q54484709","Q54519218","Q54519234","Q54519305","Q54528055","Q54614444","Q54654845","Q54657338","Q54657590","Q54658740","Q54659086","Q54663260","Q54663285","Q54663300","Q54663446","Q54663546","Q54663800","Q54666057","Q55242507","Q55243053","Q55243170","Q55245699","Q55247034","Q55248403","Q55248686","Q55249112","Q55252396","Q55267618","Q55268623","Q55272089","Q55277114","Q55288787","Q55289497","Q55289649","Q55292277","Q55297368","Q55301803","Q55303593","Q55303863","Q55304013","Q55323783","Q55328219","Q55328708","Q55329045","Q55329694","Q55331560","Q55342458","Q55827225","Q55917799","Q55928527","Q55929561","Q55986520","Q55995398","Q58504633","Q60616930","Q60803888","Q60803891","Q60803902","Q60803903","Q60803907","Q60803908","Q60806474","Q60812455","Q60812982","Q60878560","Q60893125","Q60896167","Q61025231","Q61171608","Q61172993","Q61193544","Q61404424","Q61723517","Q61985070","Q63368700","Q63677177","Q64748929","Q64821334","Q65278659","Q65608032","Q65614460","Q65614522","Q65690803","Q65757119","Q68936991","Q69998625","Q72946519","Q72947262","Q74844177","Q75103577","Q75886965","Q76465788","Q76658718","Q76756190","Q77584351","Q80101076","Q80101632","Q80191607","Q81655323","Q82068579","Q83798797","Q83890106","Q83895268","Q83902493","Q83903022","Q83903036","Q84114771","Q84255171","Q84260977","Q84262719","Q84357658","Q84612571","Q86801271","Q87536288","Q87880291","Q90726642","Q95432680","Q95607904","Q95608300","Q95609411","Q95934006","Q95949344","Q95998877","Q96030493","Q96048108","Q96143024","Q96143232","Q97179695","Q97425324","Q97434422","Q97621036","Q97767306","Q97800311","Q98968184","Q100276480","Q100893972","Q101069485","Q101204772","Q101920005","Q103818218","Q103818965","Q104054042","Q104373996","Q104439905","Q104672073","Q105203814","Q105214755","Q105292153","Q105411616","Q105412665","Q105412981","Q105420802","Q105503642","Q105540587","Q105540590","Q105540653","Q105540732","Q105541618","Q105766023","Q105799271","Q105825940","Q105958902","Q106395112","Q106419712","Q106639930","Q106643192","Q106643206","Q106650371","Q106697741","Q106703383","Q106756489","Q106902470","Q107400289","Q107463135","Q107627615","Q119212037","Q119224839","Q119239044","Q119518794","Q119626929","Q119730001","Q119950051","Q119973528","Q120450769","Q120491819","Q108105664","Q108668980","Q108774602","Q108803299","Q108904664","Q108938386","Q109466698","Q109466702","Q109548562","Q109626728","Q109626741","Q109626747","Q109631621","Q109631628","Q109631632","Q109631638","Q110165693","Q110295467","Q110306024","Q110322879","Q110343041","Q110472374","Q110583186","Q110617295","Q110731927","Q110753367","Q110753388","Q110753872","Q110823954","Q110950333","Q111314074","Q111377824","Q111377834","Q111377844","Q111377950","Q111436860","Q111511042","Q111540649","Q111593493","Q111826222","Q111838988","Q111881353","Q111903513","Q111969171","Q112157280","Q112168123","Q112208902","Q112299948","Q112526120","Q112845636","Q112941771","Q113086905","Q113112369","Q113117664","Q113172302","Q113261797","Q113512159","Q113572607","Q113586514","Q113955313","Q114041181","Q114222378","Q114333087","Q114497991","Q114591693","Q115012425","Q115140076","Q115152769","Q115283933","Q115429604","Q115522048","Q115682991","Q115780569","Q115858786","Q115934462","Q115996220","Q116205449","Q116262309","Q116311903","Q116414590","Q116688127","Q116745758","Q116751684","Q116786091","Q116811666","Q116907590","Q116951792","Q116959700","Q116973606","Q117070534","Q117794412","Q117861575","Q118410942","Q118867509","Q118895683","Q118903764","Q118915697","Q119021574","Q119139983","Q119198742")
    )
#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...
