flagged - Quarry

SQL

USE trwiki_p;
SELECT user_name, up_property, up_value
 FROM user
 JOIN user_properties ON up_user = user_id
 WHERE up_property = 'gender';
 

#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...
