USE frwiki_p;

SELECT p.page_id, page_title, rd_namespace FROM page p

JOIN redirect r ON r.rd_from = p.page_id

WHERE p.page_namespace = 0

AND r.rd_namespace NOT IN (0, #Article

                           #14, # Category

                           #10, # Template

                           #4, # Wikipedia

                           #5, # Wikipedia talk

                           #12, # Help

                           #100, # Portal

                           104) # Reference

AND page_title not like 'P:%'

AND page_title not like 'DP:%'

AND page_title not like 'CAT:%'