Unflagged import on plwiktionary

Resultset 1: count of unflagged (FlaggedRevs) pages within the categories "importSV", "importIA", "jidyszbot" and "importCStematyczny" in the main namespace.
Resultset 2: same as above, but it doesn't take into account pages with non-bot edits in history.
Resultset 3: list of pages to work on from resultset 2.

SQL

USE plwiktionary_p;

SELECT
	cl_to AS category,
	COUNT(page_title) AS unflagged
FROM
	page RIGHT JOIN categorylinks ON
		cl_from = page_id AND
		cl_to IN ("importSV", "importIA", "jidyszbot")
WHERE
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	NOT EXISTS (SELECT fp_page_id FROM flaggedpages WHERE fp_page_id = page_id)
GROUP BY
	cl_to
ORDER BY
	unflagged DESC;

SELECT
	cl_to AS category,
	COUNT(DISTINCT page_title) AS unflagged
FROM
	page
		JOIN categorylinks ON
			cl_from = page_id AND
			cl_to IN ("importSV", "importIA", "jidyszbot")
		JOIN revision ON
			rev_page = page_id
		LEFT JOIN user_groups ON
			ug_user = rev_user AND
			ug_group = "bot"
WHERE
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	NOT EXISTS (SELECT fp_page_id FROM flaggedpages WHERE fp_page_id = page_id) AND
	ug_group IS NOT NULL
GROUP BY
	cl_to
/*HAVING
	MAX(ug_group IS NULL) = 0*/
ORDER BY
	unflagged DESC;

SQL

Checking query status...