Untitled query #63572

SQL

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=',page1.page_latest) AS 'Ellenőriz'
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 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;

DESCRIBE revision;
DESCRIBE rev_comment;

/*
SELECT
	page1.page_title AS 'Cím',
	CONCAT(actor1.actor_name, IF(COUNT(DISTINCT actor2.actor_name)>1, CONCAT(' + ', COUNT(DISTINCT actor2.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=',page1.page_latest) AS 'Ellenőriz'
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 rev_comment ON rev_comment.rev_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 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;
*/
SQL

Checking query status...
