zhwiki: cross ns redirects

SQL

SELECT rd_from,  page_namespace, page_title, rd_namespace, rd_title
FROM redirect
LEFT JOIN page ON rd_from = page_id
WHERE page_namespace NOT IN (2, 3)
	AND page_namespace != rd_namespace
    AND NOT (page_namespace = 4 AND rd_namespace = 102)
    AND NOT (page_namespace = 0 AND (
      page_title LIKE "MOS:%"
      OR page_title LIKE "LTA:%"
      OR page_title LIKE "NT:%"
    ))
    AND NOT (page_namespace = 10 AND rd_namespace = 828 AND page_title LIKE "CGroup/%")
    AND NOT (page_namespace = 11 AND rd_namespace = 829 AND page_title LIKE "CGroup/%")
SQL

Checking query status...
