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...