Untitled query #22716

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

SQL

USE urwiki_p; 

SELECT p.page_title, COUNT(l.ll_lang)
FROM langlinks l
JOIN page p ON p.page_id=l.ll_from
WHERE EXISTS (
  SELECT * FROM pagelinks pl						
  JOIN page p ON p.page_title=pl.pl_title 
  AND pl.pl_namespace=p.page_namespace						
  WHERE p.page_id=l.ll_from 
  AND pl.pl_from=22819068 
  AND pl.pl_namespace=0)

AND p.page_namespace=0 
AND NOT EXISTS (
  SELECT * FROM langlinks m 
  WHERE l.ll_from=m.ll_from 
  AND m.ll_lang = 'ur') 

GROUP BY l.ll_from
ORDER BY COUNT(l.ll_lang) DESC;

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...