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 JOIN categorylinks ON cl_from = page_id
WHERE
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	cl_to IN ("importSV", "importIA", "jidyszbot") AND
	page_id NOT IN (SELECT fp_page_id FROM flaggedpages)
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
		JOIN revision ON rev_page = page_id
WHERE
	page_namespace = 0 AND
	page_is_redirect = 0 AND
	cl_to IN ("importSV", "importIA", "jidyszbot") AND
	page_id NOT IN (SELECT fp_page_id FROM flaggedpages) AND
	rev_user != 0 AND
	/* rev_user IN (SELECT ug_user FROM user_groups WHERE ug_group = "bot") AND
	page_id IN (SELECT rev_page FROM revision WHERE rev_page = page_id) */
	NOT EXISTS (
      SELECT
      	*
      FROM
      	user 
      WHERE
      	user_id = rev_user AND
      	user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = "bot")
    )
GROUP BY
	cl_to
ORDER BY
	unflagged DESC;

SQL

Checking query status...