CivilServant thanker study candidates

Arabic, German, Farsi, and Polish wiki definitions for users that could receive invites to participate in CivilServant study.

SQL

SET @DE_EDITS_ENOUGH = 500;
SET @DE_DAYS_ENOUGH = 60;
SET @FA_EDITS_ENOUGH = 500
SET @FA_DAYS_ENOUGH = 365;

use dewiki_p;

select user_id, ug_group, user_name, user_editcount, user_registration from (
    select user_id, ug_group, user_name, user_editcount, coalesce(user_registration, 20010101000000) as user_registration
          from (select * from user_groups where ug_group = 'autoreview') ug
join user u on  ug.ug_user = u.user_id) coal
	where user_editcount >= @DE_EDITS_ENOUGH and user_registration <= DATE_FORMAT(DATE_SUB(NOW(), INTERVAL @DE_DAYS_ENOUGH DAY), '%Y%m%d%H%M%S');

SQL

Checking query status...