SQL
AخA
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%';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.