USE nlwiki_p;

# XXX Quarry bug with column names

SELECT page_title AS 'page_title', rd_namespace AS 'rd_namespace', rd_title AS 'rd_title', rd_namespace AS 'rd_namespace', rd_interwiki AS 'rd_interwiki'

FROM (

  SELECT page_id, page_title

  FROM page

  WHERE

      page_namespace=0 AND

      page_is_redirect=1 AND

      page_title REGEXP '_\\(hoofdbetekenis\\)$'    

  LIMIT 10) p INNER JOIN redirect ON page_id=rd_from