Uziel draft 1 - Quarry

SQL

use hewiki_p;
select substr(el_to, 1,locate('/',el_to, 9)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to, 9)) like '%/m.%/%' 
group by substr(el_to, 1,locate('/',el_to, 9));
select substr(el_to, 1,locate('/',el_to, 9)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to, 9)) like '%.m.%/%'
group by substr(el_to, 1,locate('/',el_to, 9));
select substr(el_to, 1,locate('/',el_to, 9)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to, 9)) like '%/mobile.%/%' 
group by substr(el_to, 1,locate('/',el_to, 9));
select substr(el_to, 1,locate('/',el_to, 9)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to, 9)) like '%.mobile.%/%'
group by substr(el_to, 1,locate('/',el_to, 9));
SQL

Checking query status...
