SELECT COUNT(DISTINCT el_from),

       actor_name

FROM externallinks

JOIN page ON page_id = el_from

LEFT JOIN revision ON rev_page = el_from AND rev_parent_id = 0

LEFT JOIN actor_revision ON actor_id = rev_actor

WHERE (el_index LIKE 'http://net.koyumuz%'

       OR el_index LIKE 'https://net.koyumuz%')

  AND el_index RLIKE '^https?://net\\.koyumuz([./]|$)'

  AND page_namespace = 0

GROUP BY actor_name;