Replicas browser and optimizer
This query is marked as a draft
This query has been published
use enwiki_p; select page_title, count(l2.ll_title) as CNT from page join langlinks l2 on l2.ll_from = page_id left join langlinks l1 on l1.ll_from = page_id and l1.ll_lang = 'fa' where l1.ll_from is null and page_namespace = 0 group by l2.ll_from order by CNT desc limit 100;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in