USE trwiki_p;

SET @kacgun = -100;

SELECT  up_value, COUNT(*), SUM(user_editcount), SUM(user_editcount)/COUNT(*) as ort_edit

#SELECT up_value, user_name, user_editcount

 FROM user

 JOIN user_properties ON up_user = user_id

 WHERE up_property ='gender'

 AND user_editcount > 0

 AND user_name NOT LIKE '%Bot'

# AND user_registration > date_add(now(), INTERVAL @kacgun DAY)

 GROUP BY up_value ;

# ORDER BY up_value ASC, user_editcount DESC;

​