creations by evc/acc

SQL

select log_timestamp, log_user_text creator, log_title created, log_comment from logging l
  inner join (
    select ug_user from user_groups where ug_group = 'eventcoordinator'
    union
    select ufg_user from user_former_groups where ufg_group = 'accountcreator'
  ) ug on l.log_user = ug.ug_user
where l.log_type = 'newusers'
  and l.log_action not in ('autocreate', 'create', 'byemail')
  and l.log_user_text is not null
  and l.log_title is not null
  and l.log_timestamp > '20140101000000'
  and (
    l.log_comment like '%A+F%'
    or l.log_comment like '%fem%'
    or l.log_comment like '%art%'
;
SQL

Checking query status...
