edit spike - Quarry

SQL

use ukwiki_p;

select count(A.user_id)

from (select rev_user_text, count(rev_user_text)
	from revision
    where (
      rev_timestamp < timestamp('2018-03-01')
      and rev_timestamp >= timestamp('2017-12-01')
      and rev_user != 0)
     group by rev_user_text
     order by count(rev_user_text)) as A
    
join (select log_title
    from logging_userindex
    where (
        log_action = 'thank' and log_type='thanks'
        and log_timestamp < timestamp('2018-03-09') 
        and log_timestamp >= timestamp('2018-03-08'))
    group by log_title) as B

on A.rev_user_text = B.log_title

left join (select log_title
          from logging_userindex
      	  where (
      		  log_action = 'thank' and log_type='thanks'
		      and log_timestamp < timestamp('2018-03-08')
              and log_timestamp >= timestamp('2018-03-01'))
      	  group by log_title) as C 

on A.rev_user_text = C.log_title

#join (select rev_user
#    from revision
#    where (
#        rev_timestamp < timestamp('2017-08-01') 
#        and rev_timestamp >= timestamp('2017-05-01') 
#        and rev_user != 0)
#    group by rev_user) as D

#on A.user_id = D.rev_user
where (C.log_title is null);
SQL

Checking query status...
