test - Quarry

SQL

USE arwiki_p;
SELECT page_title
FROM page
INNER JOIN templatelinks t ON page.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title NOT IN ('معلومات_ممثل')
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to LIKE '%.imdb.com/name/%'
AND page_namespace = 0
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 '%.imdb.com/name/%'
AND page_namespace = 0
GROUP BY el_to
ORDER BY counting DESC, el_to;
SQL

Checking query status...
