بوت: توزيع أوسمة

SQL

#select user_id,actor_id from user inner join actor on actor.actor_user = user.user_id where user_name in ("لوقا");


#select * from revision where rev_actor in (2901068) and rev_timestamp <=  limit 10;
#select count(*) from revision where rev_actor in (2901068);

SELECT actor_name,
       (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id AND rev_timestamp < DATE_SUB(NOW(), INTERVAL 1 DAY)) AS revisions_until_yesterday,
       (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id) AS total_edits
FROM actor
where revisions_until_yesterday < 500 and total_edits >= 500
limit 10
SQL

Checking query status...
