Uziel draft 1 - Quarry

SQL

use hewiki_p;
select substr(el_to, 1,locate('/',el_to)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to)) like '%/m.%/%' 
group by substr(el_to, 1,locate('/',el_to));
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));

AخA
 
use hewiki_p;select substr(el_to, 1,locate('/',el_to)), count(*) from externallinks where substr(el_to, 1,locate('/',el_to)) like '%/m.%/%' group by substr(el_to, 1,locate('/',el_to));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...