nds_nlwiki Use of redirect categorylinks

SQL

USE nds_nlwiki_p;
/*SELECT page_title, cl_from
  FROM page, categorylinks
  WHERE 
      page_namespace=14 AND
      page_is_redirect=1 AND
      cl_to=page_title;*/
/*SELECT pf.page_namespace, pf.page_title, t.page_title
FROM page pf, (
  SELECT page_title, cl_from
  FROM page, categorylinks
  WHERE 
      page_namespace=14 AND
      page_is_redirect=1 AND
      cl_to=page_title
	) t
WHERE t.cl_from=pf.page_id;*/
SELECT pf.page_namespace AS from_ns, pf.page_title AS from_title, pt.page_title AS to_title
FROM page pf, page pt, categorylinks
WHERE 
	page_namespace=14 AND
    page_is_redirect=1 AND
    cl_to=page_title
WHERE pt.cl_from=pf.page_id;
SQL

Checking query status...
