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)

    AND page_namespace != rd_namespace

    AND NOT (page_namespace = 4 AND rd_namespace = 102)

    AND NOT (page_namespace = 5 AND rd_namespace = 103)

    AND NOT (page_namespace = 0 AND (

      page_title LIKE "MOS:%"

      OR page_title LIKE "LTA:%"

      OR page_title LIKE "NC:%"

      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/%")

    AND rd_namespace = 0 AND page_namespace = 10