Untitled query #30150 - Quarry

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

SQL

USE enwiki_p;

SELECT 
	count(*) ll_count,
	page_title title_en
  FROM 
  	page, langlinks
  WHERE 
  	ll_from = page_id and
	(select count(*) from langlinks where ll_from = page_id) >= 20 and
	page_id not in (select ll_from from langlinks where ll_lang = 'nl') and
	page_namespace = 0
  GROUP BY 
	page_id
  ORDER BY 
  	ll_count desc, page_title
  LIMIT 500

​x
 
USE enwiki_p;​SELECT     count(*) ll_count,    page_title title_en  FROM     page, langlinks  WHERE     ll_from = page_id and    (select count(*) from langlinks where ll_from = page_id) >= 20 and    page_id not in (select ll_from from langlinks where ll_lang = 'nl') and    page_namespace = 0  GROUP BY     page_id  ORDER BY     ll_count desc, page_title  LIMIT 500

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.

Checking query status...