Anonymous users on plwiki by edit counter

SQL

USE plwiki_p;
/*SELECT CONCAT('# [[', page_title ,']]') AS page_title
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND el_to RLIKE 'https?:\/\/.+\.(facebook\.|fb\.|twitter\.|naszaklasa\.|nk\.|plus\.google\.)+.{2,3}\/.+'
GROUP BY page_title
ORDER BY page_title;*/
SELECT el_to, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE page_namespace = 0
AND el_to RLIKE 'https?:\/((\/|.*\.)facebook\.|(\/|.*\.)fb\.|(\/|.*\.)twitter\.|(\/|.*\.)naszaklasa\.|(\/|.*\.)nk\.|(\/|.*\.)plus\.google\.).{2,3}\/.+'
GROUP BY el_to
ORDER BY counting DESC, el_to;

SQL

Checking query status...