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

SQL

/*
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 (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id AND rev_timestamp < DATE_SUB(NOW(), INTERVAL 1 DAY)) < 500
AND (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id) >= 500
limit 10



*/


select pl_title from pagelinks where  pl_from = 7519882

#select * from actor where actor_name in (select pl_title from pagelinks where  pl_from = 7519882)
SQL

Checking query status...
