This query is marked as a draft This query has been published by Nemo bis.

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.

Checking query status...