KeFe által létrehozott lapok

SQL

USE huwiki_p;
SELECT page2.page_id, actor_name, ug_group
      	FROM page as page2
        INNER JOIN revision AS revision2 ON page2.page_id = revision2.rev_page
        INNER JOIN flaggedpage_pending AS flaggedpage_pending2 ON page2.page_id = flaggedpage_pending2.fpp_page_id
        INNER JOIN actor AS actor2 ON revision2.rev_actor = actor2.actor_id
        INNER JOIN user AS user2 ON revision2.rev_actor = user2.user_id
        LEFT OUTER JOIN user_groups AS user_groups2 ON ug_user = actor_user
      	WHERE 50428 = page2.page_id
      		AND revision2.rev_timestamp >= flaggedpage_pending2.fpp_pending_since
      		#AND ug_group NOT IN ('editor','trusted','sysop')
SQL

Checking query status...
