SQL
x
USE trwiki_p;
SET @kacgun = -10;
SELECT up_value, COUNT(*), SUM(user_editcount), SUM(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)
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.