Unreviewed changes by trusted users

This query is marked as a draft This query has been published by FoBe.
SQL

# USE huwiki_p; -- deprecated
SELECT 
	CONCAT('[[',page1.page_title,']]') AS 'Cím',
    page1.page_latest
	#CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&action=history történet]') AS 'Történet', 
    #CONCAT('[https://hu.wikipedia.org/w/index.php?title=',page1.page_title,'&oldid=',flaggedpage_pending1.fpp_rev_id,'&diff=',page1.page_latest,' ellenőriz]') AS 'Ellenőriz', 
    #GROUP_CONCAT(DISTINCT actor1.actor_name SEPARATOR ', ') AS 'Szerkesztők',
    #CONCAT(FLOOR(lastrevision.rev_timestamp/10000000000),'-',
    #       FLOOR(lastrevision.rev_timestamp/100000000)-FLOOR(lastrevision.rev_timestamp/10000000000)*100,'-',
    #       FLOOR(lastrevision.rev_timestamp/1000000)-FLOOR(lastrevision.rev_timestamp/100000000)*100,' ',
    #       FLOOR(lastrevision.rev_timestamp/10000)-FLOOR(lastrevision.rev_timestamp/1000000)*100,':',
    #       FLOOR(lastrevision.rev_timestamp/100)-FLOOR(lastrevision.rev_timestamp/10000)*100,':',
    #       FLOOR(lastrevision.rev_timestamp/1)-FLOOR(lastrevision.rev_timestamp/100)*100
    #      ) AS 'Utolsó módosítás'
    #, flaggedpage_pending1.fpp_pending_since #, GROUP_CONCAT(user_groups.ug_group) AS 'jogok'
FROM page as page1
INNER JOIN revision AS lastrevision ON page1.page_latest = lastrevision.rev_id -- used for outputting timestamp of last edit, not used in rest of query
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 revision1.rev_actor = actor1.actor_id
INNER JOIN user AS user1 ON actor1.actor_user = user1.user_id
LEFT OUTER JOIN user_groups AS user_groups1 ON ug_user = actor_user
WHERE page1.page_namespace = 0
    AND revision1.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
    AND user_groups1.ug_group IN ('editor','trusted','sysop','bot')
    AND page1.page_id NOT IN ( # exclude edits by anons
    	SELECT page2.page_id
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
     	INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
      	WHERE page1.page_id = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
      		AND actor2.actor_user IS NULL
    	)
     AND page1.page_id NOT IN ( # exclude edits by non-trusted users
        SELECT page2.page_id
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
     	INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
        INNER JOIN user AS user2 ON actor2.actor_user = user2.user_id
      	WHERE page1.page_id = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending1.fpp_pending_since
            AND NOT EXISTS (SELECT user_groups2.ug_user FROM user_groups AS user_groups2 WHERE user_groups2.ug_user = user2.user_id AND user_groups2.ug_group IN ('editor','trusted','sysop','bot'))
    	)
GROUP BY page1.page_title
#ORDER BY page1.page_title ASC;
ORDER BY revision1.rev_timestamp DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
