名前空間をまたぐリダイレクト

SQL

SELECT
P.page_title,
R.rd_namespace,
R.rd_title
FROM redirect R
INNER JOIN page P ON R.rd_from = P.page_id
WHERE R.rd_namespace != 0
AND P.page_namespace = 0
AND P.page_title NOT LIKE 'WT:%'
AND P.page_title NOT LIKE 'H:%'
AND P.page_title NOT LIKE 'CAT:%'
AND P.page_title NOT LIKE 'P:%'
AND P.page_title NOT LIKE 'PJ:%'
AND P.page_title NOT LIKE 'PJT:%'
AND P.page_title NOT LIKE 'LTA:%'
AND P.page_title NOT LIKE 'ANB:%'
AND P.page_title NOT LIKE 'ANT:%'
AND P.page_title NOT LIKE 'MOS:%'
AND R.rd_title NOT LIKE '漫画家/日本の漫画家%'
ORDER BY R.rd_namespace ASC, R.rd_title ASC;

SQL

Checking query status...