timestamps for some edits

SQL

USE wikidatawiki_p;
SELECT MIN(rev_timestamp), rev_id, rev_user_text AS user_name/*
	COUNT(rev1.rev_id) AS number, SUM(rev1.rev_len) - SUM(rev2.rev_len) AS data_amount,
	(SUM(rev1.rev_len) - SUM(rev2.rev_len)) / COUNT(rev1.rev_id) AS ratio
	FROM (SELECT * FROM revision WHERE rev_comment LIKE '%wbmergeitems-from%') AS rev1
    */
	FROM revision #AS rev2 ON rev2.rev_id = rev1.rev_parent_id
	#LEFT JOIN user_groups ON rev1.rev_user IS NOT NULL AND ug_user = rev1.rev_user
WHERE left(rev_timestamp,10) in ("2013010100")
Limit 10
SQL

Checking query status...
