H - Quarry

SQL

USE enwiki_p;
SELECT concat('[[',REPLACE(page_title,'_',' '),']]'), COUNT(ll_from)
FROM page JOIN langlinks ON page_id = ll_from
WHERE page_namespace=0
AND page_is_redirect = 0
AND NOT EXISTS (
  SELECT null
  FROM langlinks
  WHERE ll_from = page_id
  AND ll_lang = 'fa'
)
/*#----------- DAB -----------------------
AND page_id IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)
#----------- DAB -----------------------
*/
GROUP BY ll_from HAVING COUNT(ll_from) > 30
ORDER BY COUNT(ll_from) DESC;
SQL

Checking query status...
