Untitled query #3676

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", "importAZ", "importKA", " importCStematyczny") 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", "importAZ", "importKA", " importCStematyczny") AND
	page_id NOT IN (SELECT fp_page_id FROM flaggedpages) AND
	rev_user != 0 AND
	NOT EXISTS (
      SELECT
      	user_id
      FROM
      	user
      WHERE
      	user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = "bot") AND
      	user_id = rev_user
    )
GROUP BY
	cl_to
ORDER BY
	unflagged DESC;
SQL

Checking query status...
