Unreviewed main namespace redirects on plwiktionary

SQL

USE plwiktionary_p;

SELECT
	page_title
FROM
	page RIGHT JOIN redirect ON
        	rd_from = page_id
WHERE
	rd_namespace = 0 AND
    NOT EXISTS (SELECT NULL FROM flaggedpages WHERE fp_page_id = page_id)
;

SELECT
	source.page_title
FROM
	redirect
    	LEFT JOIN page source ON
        	rd_from = source.page_id
		INNER JOIN page target ON
        	rd_title = target.page_title
WHERE
	rd_namespace = 0 AND
    target.page_title LIKE "%_się" AND
    NOT EXISTS (SELECT NULL FROM flaggedpages WHERE fp_page_id = source.page_id)
;

SELECT
	source.page_title,
    "",
    source.page_latest
FROM
	redirect
    	LEFT JOIN page source ON
        	rd_from = source.page_id
		INNER JOIN page target ON
        	rd_title = target.page_title
WHERE
	rd_namespace = 0 AND
    source.page_title LIKE "%_się" AND
    #target.page_title = SUBSTRING(source.page_title, 0, -4) AND
    source.page_title = CONCAT(target.page_title, "_się") AND
    NOT EXISTS (SELECT NULL FROM flaggedpages WHERE fp_page_id = source.page_id)
;
SQL

Checking query status...
