Utilizatori cu cele mai multe editări într-o perioadă

SQL

USE rowiki_p;
SELECT user_name, user_editcount, COUNT(rev_id) AS year_count
	FROM user
 LEFT JOIN revision ON revision.rev_user = user.user_id
 WHERE (user_name LIKE 'Accipiter Q. Gentilis' OR 
        user_name LIKE 'Gikü' OR 
        user_name LIKE 'Boldeanu Daniel' OR 
        user_name LIKE 'Asmoraahu' OR 
        user_name LIKE 'Maxdsl' OR 
        user_name LIKE 'Nicoleta Rotaru' OR 
        user_name LIKE 'Luluță Popândău' OR 
        user_name LIKE 'Telcean Marius Andrei' OR 
        user_name LIKE 'Dan Mihai Pitea' OR 
        user_name LIKE 'Titoiu gicu' OR 
        user_name LIKE 'Florin35' OR 
        user_name LIKE 'Robertgombos' OR 
        user_name LIKE 'Razvan1986' OR 
        user_name LIKE 'Atastelin' OR 
        user_name LIKE 'Naturista2018' OR 
        user_name LIKE 'Octavix' OR 
        user_name LIKE 'Gh. Pitran' OR 
        user_name LIKE 'Lenutaa_mirceaa' OR 
        user_name LIKE 'Nnnnnn' OR 
        user_name LIKE 'Dosz' OR 
        user_name LIKE 'Cratau Mihai ADRIAN' OR 
        user_name LIKE 'Maria Cratau' OR 
        user_name LIKE 'Puterealibertatii' OR 
        user_name LIKE 'Portasa.ionel' OR 
        user_name LIKE 'Kfsof' OR 
        user_name LIKE 'Photos.moldova' OR 
        user_name LIKE 'Maraal01') AND rev_timestamp >= '20170725000000'
GROUP BY user_name
ORDER BY year_count DESC, user_name LIMIT 500;
SQL

Checking query status...
