SQL
AخA
/*
select
actor_name as name,
COUNT(*) as score
from
logging
INNER JOIN actor ON log_actor = actor.actor_id
where
#and ucase(actor_name) not like ucase("%BOT") COLLATE utf8_general_ci
#and actor_name not like "%بوت%" collate utf8_general_ci
#and actor_name Not IN (SELECT user_name
# FROM user_groups
# INNER JOIN user ON user_id = ug_user
# WHERE ug_group = "bot")
#and
#log_action = "patrol"
log_action = "approve-i"
#and log_namespace = 0
group by actor_name
having COUNT(*) > 1
ORDER BY score DESC,name
LIMIT 10;
*/
select distinct(log_action) from logging
where log_type = "review"
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.