BEIC.it link count by Wikipedia language

SQL

USE itwiki_p;
select count(distinct(el_from)) as itwiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE enwiki_p;
select count(distinct(el_from)) as enwiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE dewiki_p;
select count(distinct(el_from)) as dewiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE frwiki_p;
select count(distinct(el_from)) as frwiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE eswiki_p;
select count(distinct(el_from)) as eswiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE ptwiki_p;
select count(distinct(el_from)) as ptwiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
USE ruwiki_p;
select count(distinct(el_from)) as ruwiki FROM externallinks WHERE el_to LIKE '%.beic.it%';
SQL

Checking query status...
