flagged - Quarry

SQL

USE trwiki_p;
SET @kacgun = -10;
SELECT  user_name, up_value, user_editcount, user_registration
 FROM user
 LEFT JOIN user_properties ON up_user = user_id
 WHERE up_value IS NOT NULL
 AND up_property ='gender'
 AND user_editcount > 0
 AND user_registration > date_add(now(), INTERVAL @kacgun DAY)
 ORDER BY up_value ASC, user_editcount DESC
 GROUP BY up_value;

 

#SET @bas = now();
#SELECT @bas as zaman;
#set @sure = 100;
#SELECT * 
#FROM (SELECT rev_user, COUNT(rev_timestamp) AS saysay, MAX(rev_timestamp) AS last_edit FROM revision WHERE rev_user > 0 AND rev_timestamp > DATE_ADD(NOW(), 
#              INTERVAL -@sure SECOND) GROUP BY rev_user) AS latest
#limit 2;
#SElect datediff(now(),@bas) as fark, timediff(now(),@bas) as farks;
SQL

Checking query status...
