test (revues.org)

SQL

USE frwiki_p;
SELECT site, COUNT(*) AS LINKS
FROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to_domain_index, LOCATE('://', el_to_domain_index) + 3), '/', 1) AS site
      FROM page tp
      JOIN page mp ON mp.page_namespace = 0 AND mp.page_title = tp.page_title
      JOIN externallinks ON el_from = mp.page_id
      AND tp.page_namespace = 0) sq
    where site LIKE "org.revues"

GROUP BY site
HAVING COUNT(*) > 1000
ORDER BY LINKS DESC

​x
 
USE frwiki_p;SELECT site, COUNT(*) AS LINKSFROM (SELECT SUBSTRING_INDEX(SUBSTRING(el_to_domain_index, LOCATE('://', el_to_domain_index) + 3), '/', 1) AS site      FROM page tp      JOIN page mp ON mp.page_namespace = 0 AND mp.page_title = tp.page_title      JOIN externallinks ON el_from = mp.page_id      AND tp.page_namespace = 0) sq    where site LIKE "org.revues"​GROUP BY siteHAVING COUNT(*) > 1000ORDER BY LINKS DESC

SQL

Checking query status...