0AD Alpha 24 - Names with X

SQL

-- Links from civ articles to elsewhere
-- 
SELECT pl_title as _title
FROM pagelinks
WHERE pl_from IN (
   SELECT page_id
   FROM page
   WHERE page_namespace = 0
   AND page_title IN ('Ptolemaic_Kingdom', 'Achaemenid_Empire', 'Celtic_Britons', 'Gaul', 'Iberians', 'Maurya_Empire')
)
AND pl_title LIKE '%X'
UNION
-- 
-- Links from elsewhere to civ articles
-- 
SELECT page_title as _title
FROM page
WHERE page_id IN (
  SELECT pl_from
  FROM pagelinks
  WHERE pl_namespace = 0
  AND pl_title IN ('Ptolemaic_Kingdom', 'Achaemenid_Empire', 'Celtic_Britons', 'Gaul', 'Iberians', 'Maurya_Empire')
)
AND page_title LIKE 'X%';
SQL

Checking query status...
