Untitled query #39392

SQL

USE ruwiki_p;
SELECT * FROM flaggedrevs LIMIT 1;
# SELECT * FROM revision LIMIT 1;
# SELECT * FROM actor LIMIT 1;

SELECT page_title FROM flaggedrevs
JOIN revision ON rev_id = fr_rev_id
JOIN actor ON rev_actor = actor_id
JOIN page ON page_id = fr_page_id
WHERE fr_user = (SELECT user_id FROM user WHERE user_name = "Facenapalm")
  AND actor_user IN (SELECT ug_user FROM user_groups WHERE ug_group = "editor")
  AND page_namespace = 10
LIMIT 10;

# SELECT * FROM logging
# WHERE log_type = "review"
#   AND log_action = "approve"
#   AND log_actor = 1625
#   AND log_namespace = 10
#   AND log_timestamp > 20190000000000
# LIMIT 10;
SQL

Checking query status...
