Untitled query #76813

SQL

-- get list of redirect categories
set @rcat_titles = (
  select GROUP_CONCAT(page_title)
  from categorylinks
  inner join page on page_id = cl_from
  where cl_to = "All_redirect_categories"
);

select page_namespace, page_name from (
  -- this subquery get ids of matching redirect pages
  -- (and gets rid of duplicates)
  select distinct rd_from
  from redirect
  inner join categorylinks on rd_from = cl_from
  where FIND_IN_SET(cl_to, @rcat_titles) > 0
  -- order by page_id asc
  limit 10
) as subq
inner join page on rd_from = page_id;
SQL

Checking query status...
