use hewiki_p;

select el_to as adress, replace(page_title, "_", " ") as page from externallinks inner join page

on el_from = page_id

and page_namespace = 0

and (substr(el_to, 1,locate('/',el_to, 9)) like '%/m.%/%'

or substr(el_to, 1,locate('/',el_to, 9)) like '%.m.%/%'

or substr(el_to, 1,locate('/',el_to, 9)) like '%/mobile.%/%' 

or substr(el_to, 1,locate('/',el_to, 9)) like '%.mobile.%/%')

and not locate(".maariv.", el_to ,1)