Untitled query #20240

SQL

USE wikidatawiki_p;/*
# Number of items merged
SELECT COUNT(rev.rev_id) AS 'Number of merges'
	FROM (SELECT * FROM revision WHERE rev_user_text in ('GZWDer', 'GZWDer (flood)')) AS rev
WHERE rev.rev_comment LIKE '%wbmergeitems-from%'     
GROUP BY rev.rev_user_text;*/
# Latest merges
SELECT rev_id, rev_timestamp as timestamp, rev_comment AS summary
	FROM revision
WHERE rev_comment LIKE '%wbmergeitems-from%' and rev_user_text = 'GZWDer (flood)'#in ('GZWDer', 'GZWDer (flood)')
ORDER BY rev_timestamp DESC
LIMIT 500;
SQL

Checking query status...
