Untitled query #16118

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 (OR (el_to LIKE 'http://www.fifa.com/worldcup/archive/%'; el_to LIKE 'http://www.fifa.com/tournaments/archive/%';))
GROUP BY page_title
ORDER BY page_title;
SELECT CONCAT('# ',el_to) as el_to#, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND (OR (el_to LIKE 'http://www.fifa.com/worldcup/archive/%'; el_to LIKE 'http://www.fifa.com/tournaments/archive/%';))
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;
SQL

Checking query status...
