BEIC.it linked documents count by Wikipedia language

SQL

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

SQL

Checking query status...