Untitled query #63572

SQL

DESCRIBE flaggedpage_pending;

SELECT
	page1.page_title AS 'Cím',
	CONCAT(af.afl_user_text, IF(COUNT(DISTINCT actor.actor_name)>1, CONCAT(' + ', COUNT(DISTINCT actor.actor_name)-1,' további'), '') ) AS 'Szerkesztő',
	CONCAT('https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&oldid=',flaggedpage_pending1.fpp_rev_id,'&diff=curr') AS 'Ellenőriz',
	comment1.comment_text
FROM
	page as page1
	INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page
	INNER JOIN flaggedpage_pending AS flaggedpage_pending1 ON page1.page_id = flaggedpage_pending1.fpp_page_id
	INNER JOIN abuse_filter_log AS af ON af.afl_rev_id = revision1.rev_id
	INNER JOIN `comment` AS comment1 ON comment1.comment_id = revision1.rev_comment_id
	INNER JOIN revision AS revision2 ON page1.page_id = revision2.rev_page
	INNER JOIN actor ON actor.actor_id = revision2.rev_actor
WHERE
	revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
	AND af.afl_filter_id = 64
	AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
	AND page1.page_namespace = 0
GROUP BY
	page1.page_title
ORDER BY
	revision1.rev_timestamp DESC;

SELECT
	page1.page_title,
	actor1.actor_name AS renamer,
	COUNT(DISTINCT actor2.actor_name) AS pending_users,
	flaggedpage_pending1.fpp_rev_id AS pending_oldid
FROM
	page as page1
	INNER JOIN revision AS revision1 ON page1.page_id = revision1.rev_page
	INNER JOIN flaggedpage_pending AS flaggedpage_pending1 ON page1.page_id = flaggedpage_pending1.fpp_page_id
	INNER JOIN actor AS actor1 ON actor1.actor_id = revision1.rev_actor
	INNER JOIN `comment` AS comment1 ON comment1.comment_id = revision1.rev_comment_id
	INNER JOIN revision AS revision2 ON page1.page_id = revision2.rev_page
	INNER JOIN actor AS actor2 ON actor2.actor_id = revision2.rev_actor
WHERE
	revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
	AND (comment1.comment_text RLIKE '^\\(\\[\\[c\\:GR\\|GR\\]\\]\\)' OR comment1.comment_text RLIKE '[G|g]lobal[R|r]eplace')
	AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
	AND page1.page_namespace = 0
GROUP BY
	page1.page_title
ORDER BY
	revision1.rev_timestamp DESC;
SQL

Checking query status...
