External links (backlinks) - multiple wikis

SQL

SELECT 'enwiki_p' as dbname, COUNT(*) as rc_count FROM enwiki_p.externallinks
WHERE el_index LIKE 'http://org.mediawiki%' OR el_index LIKE 'https://org.mediawiki%'

UNION ALL
SELECT 'metawiki_p' as dbname, COUNT(*) as rc_count FROM metawiki_p.externallinks
WHERE el_index LIKE 'http://org.mediawiki%' OR el_index LIKE 'https://org.mediawiki%'

UNION ALL
SELECT 'commonswiki_p' as dbname, COUNT(*) as rc_count FROM commonswiki_p.externallinks
WHERE el_index LIKE 'http://org.mediawiki%' OR el_index LIKE 'https://org.mediawiki%'

UNION ALL
SELECT 'mediawikiwiki_p' as dbname, COUNT(*) as rc_count FROM mediawikiwiki_p.externallinks
WHERE el_index LIKE 'http://org.mediawiki%' OR el_index LIKE 'https://org.mediawiki%'

ORDER BY rc_count DESC;
SQL

Checking query status...
