Untitled query #39392

SQL

USE ruwiki_p;
SELECT DISTINCT fr_flags FROM flaggedrevs
LIMIT 100;
# 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 fr_rev_timestamp > 20190000000000
#   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...
