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 ("Q25346566","Q25347224","Q25347842","Q25347861","Q25348650","Q25348812","Q25349516","Q25361920","Q25361921","Q25361956","Q25361957","Q25361972","Q25361976","Q25362058","Q25362087","Q25363449","Q25363450","Q25363453","Q25363454","Q25363455","Q25363459","Q25363469","Q25363477","Q25364117","Q25364118",
"Q25364120","Q25364121","Q25364122","Q25364377","Q25365171","Q25365297","Q25365565","Q25365567","Q25365568","Q25365569","Q25365570","Q25365571","Q25365573","Q25365574","Q25365628","Q25365722","Q25365724","Q25365725","Q25365727","Q25365729","Q25365731","Q25365732","Q25365735","Q25365737","Q25370797",
"Q25370799","Q25370800","Q25370815","Q25370816","Q25370818","Q25370821","Q25370824","Q25370825","Q25370826","Q25370829","Q25370836","Q25370847","Q25371009","Q25371011","Q25371012","Q25371014","Q25371015","Q25371016","Q25371017","Q26195816","Q26728030","Q26728032","Q26763232","Q26764216","Q27216817",
"Q27493051","Q27782201","Q27994647","Q28023973","Q28427744","Q28430110","Q28458804","Q28653726","Q28693601","Q29351682","Q29601941","Q29899448","Q30008194","Q30008195","Q30008197","Q30008198","Q30008199","Q30008200","Q30008213","Q30008214","Q30008215","Q30008216","Q30008217","Q30008218","Q30008220",
"Q30008221","Q30599996","Q30635370","Q30727303","Q30742872","Q30742877","Q30779936","Q30779937","Q30779939","Q30779943","Q30779946","Q30779947","Q30779951","Q30779952","Q30780894","Q30783343","Q30783346","Q30784871","Q30784931","Q30784958","Q30785302","Q30785303","Q30785305","Q30785310","Q30785311",
"Q30785321","Q30785409","Q30785642","Q30785815","Q30785816","Q30785818","Q30785825","Q30785826","Q30785827","Q30786163","Q30786564","Q30786565","Q30786567","Q30786570","Q30786575","Q30786577","Q30786801","Q30787356","Q30787357","Q30787359","Q30787364","Q30787370","Q30788108","Q30788109","Q30788110",
"Q30788111","Q30788112","Q30788115","Q30788118","Q30788119","Q30788120","Q30788267","Q30788302","Q30788383","Q30788405","Q30788407","Q30788409","Q30788411","Q30788412","Q30788415","Q30788416","Q30788417","Q30788418","Q30788421","Q30788422","Q30788423","Q30788830","Q30788832","Q30788939","Q30788942",
"Q30788945","Q30788954","Q30789179","Q30789217","Q30789221","Q30789225","Q30789226","Q30789228","Q30789234","Q30789235","Q30789301","Q30789303","Q30789308","Q30789364","Q30789408","Q30789431","Q30789437","Q30789444","Q30789457","Q30789492","Q30790458","Q30790810","Q30791644","Q30793282","Q30793769",
"Q30793933","Q30794850","Q30796352","Q30796838","Q30797082","Q30820512","Q30849959","Q30863228","Q30875198","Q30876402","Q31003216","Q31024233","Q31068904","Q31083058","Q31089613","Q31090805","Q31127379","Q31127536","Q31128496","Q31129146","Q31952940","Q31956413","Q32043868","Q32082316","Q32108439",
"Q32184066","Q32191421","Q32217695","Q32220313","Q32225044","Q32229009","Q32232275","Q32238365","Q32238370","Q32249399","Q32313196","Q32314689","Q32316090","Q32321272","Q32321273","Q32321274","Q32325707")
    AND pl_from NOT IN (
      select page_id from page where page_title in ("Q25346566","Q25347224","Q25347842","Q25347861","Q25348650","Q25348812","Q25349516","Q25361920","Q25361921","Q25361956","Q25361957","Q25361972","Q25361976","Q25362058","Q25362087","Q25363449","Q25363450","Q25363453","Q25363454","Q25363455","Q25363459","Q25363469","Q25363477","Q25364117","Q25364118",
"Q25364120","Q25364121","Q25364122","Q25364377","Q25365171","Q25365297","Q25365565","Q25365567","Q25365568","Q25365569","Q25365570","Q25365571","Q25365573","Q25365574","Q25365628","Q25365722","Q25365724","Q25365725","Q25365727","Q25365729","Q25365731","Q25365732","Q25365735","Q25365737","Q25370797",
"Q25370799","Q25370800","Q25370815","Q25370816","Q25370818","Q25370821","Q25370824","Q25370825","Q25370826","Q25370829","Q25370836","Q25370847","Q25371009","Q25371011","Q25371012","Q25371014","Q25371015","Q25371016","Q25371017","Q26195816","Q26728030","Q26728032","Q26763232","Q26764216","Q27216817",
"Q27493051","Q27782201","Q27994647","Q28023973","Q28427744","Q28430110","Q28458804","Q28653726","Q28693601","Q29351682","Q29601941","Q29899448","Q30008194","Q30008195","Q30008197","Q30008198","Q30008199","Q30008200","Q30008213","Q30008214","Q30008215","Q30008216","Q30008217","Q30008218","Q30008220",
"Q30008221","Q30599996","Q30635370","Q30727303","Q30742872","Q30742877","Q30779936","Q30779937","Q30779939","Q30779943","Q30779946","Q30779947","Q30779951","Q30779952","Q30780894","Q30783343","Q30783346","Q30784871","Q30784931","Q30784958","Q30785302","Q30785303","Q30785305","Q30785310","Q30785311",
"Q30785321","Q30785409","Q30785642","Q30785815","Q30785816","Q30785818","Q30785825","Q30785826","Q30785827","Q30786163","Q30786564","Q30786565","Q30786567","Q30786570","Q30786575","Q30786577","Q30786801","Q30787356","Q30787357","Q30787359","Q30787364","Q30787370","Q30788108","Q30788109","Q30788110",
"Q30788111","Q30788112","Q30788115","Q30788118","Q30788119","Q30788120","Q30788267","Q30788302","Q30788383","Q30788405","Q30788407","Q30788409","Q30788411","Q30788412","Q30788415","Q30788416","Q30788417","Q30788418","Q30788421","Q30788422","Q30788423","Q30788830","Q30788832","Q30788939","Q30788942",
"Q30788945","Q30788954","Q30789179","Q30789217","Q30789221","Q30789225","Q30789226","Q30789228","Q30789234","Q30789235","Q30789301","Q30789303","Q30789308","Q30789364","Q30789408","Q30789431","Q30789437","Q30789444","Q30789457","Q30789492","Q30790458","Q30790810","Q30791644","Q30793282","Q30793769",
"Q30793933","Q30794850","Q30796352","Q30796838","Q30797082","Q30820512","Q30849959","Q30863228","Q30875198","Q30876402","Q31003216","Q31024233","Q31068904","Q31083058","Q31089613","Q31090805","Q31127379","Q31127536","Q31128496","Q31129146","Q31952940","Q31956413","Q32043868","Q32082316","Q32108439",
"Q32184066","Q32191421","Q32217695","Q32220313","Q32225044","Q32229009","Q32232275","Q32238365","Q32238370","Q32249399","Q32313196","Q32314689","Q32316090","Q32321272","Q32321273","Q32321274","Q32325707")
    )
#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...
