Articles linking to a given external link on plwiki

SQL

USE plwiki_p;
SELECT page_title
FROM page
INNER JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 10
AND el_to LIKE 'http%://%.facebook.%/%'
OR el_to LIKE 'http%://facebook.%/%'
OR el_to LIKE 'http%://fb.%/%'
OR el_to LIKE 'http%://%.fb.%/%'
OR el_to LIKE 'http%://twitter.%/%'
OR el_to LIKE 'http%://%.twitter.%/%'
OR el_to LIKE 'http%://naszaklasa.%/%'
OR el_to LIKE 'http%://%.naszaklasa.%/%'
OR el_to LIKE 'http%://nk.%/%'
OR el_to LIKE 'http%://%.nk.%/%'
OR el_to LIKE 'http%://plus.google.%/%'
OR el_to LIKE 'http%://%.plus.google.%/%'
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 el_to LIKE 'http%://facebook.%/%'
OR el_to LIKE 'http%://%.facebook.%/%'
OR el_to LIKE 'http%://fb.%/%'
OR el_to LIKE 'http%://%.fb.%/%'
OR el_to LIKE 'http%://twitter.%/%'
OR el_to LIKE 'http%://%.twitter.%/%'
OR el_to LIKE 'http%://naszaklasa.%/%'
OR el_to LIKE 'http%://%.naszaklasa.%/%'
OR el_to LIKE 'http%://nk.%/%'
OR el_to LIKE 'http%://%.nk.%/%'
OR el_to LIKE 'http%://plus.google.%/%'
OR el_to LIKE 'http%://%.plus.google.%/%'
AND page_namespace = 10
GROUP BY el_to
ORDER BY counting DESC, el_to;
SQL

Checking query status...
