Untitled query #11527

SQL

use arwiki_p;
select user_name,rev_timestamp
 	,DATE_FORMAT(user_registration, "%Y-%m-%d") AS registration
	,user_editcount
    ,ug_group
    ,concat('{{#time:H:i, F j, Y|',rev_timestamp,'}}') as "Last edit"
from 
	user,
   user_groups
where ug_group = "bot"
and user_name like "%bot"
and ug_group not like "bot"
and user_id not in (select user_name from user_groups where ug_group like "bot" and ug_user=user_id)
and user_editcount > 100
AND rev_timestamp = (SELECT
                       MAX(rev_timestamp)
                     FROM revision
                     WHERE rev_user = user_id)
order by user_editcount
limit 10;
SQL

Checking query status...
