edit spike - Quarry

SQL

use ukwiki_p;

select A.rev_user_text, A.num_edits, coalesce(D.pre_thank_edits, 0) as pre_thnx_edits, coalesce(E.post_thank_edits, 0) as post_thnx_edits

from (select rev_user_text, count(rev_user_text) as num_edits
	from revision
    where (
      rev_timestamp < timestamp('2017-11-01')
      and rev_timestamp >= timestamp('2017-08-01')
      and rev_user != 0)
     group by rev_user_text
     order by num_edits) as A
    
join (select log_title
    from logging_userindex
    where (
        log_action = 'thank' and log_type='thanks'
        and log_timestamp < timestamp('2017-11-09') 
        and log_timestamp >= timestamp('2017-11-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('2017-11-08')
              and log_timestamp >= timestamp('2017-11-01'))
      	  group by log_title) as C 

on A.rev_user_text = C.log_title

left join (select rev_user_text, count(rev_user_text) as pre_thank_edits
    from revision
    where (
        rev_timestamp < timestamp('2017-11-08') 
        and rev_timestamp >= timestamp('2017-11-07'))
    group by rev_user_text) as D

on A.rev_user_text = D.rev_user_text

left join (select rev_user_text, count(rev_user_text) as post_thank_edits
    from revision
    where (
        rev_timestamp < timestamp('2017-11-10') 
        and rev_timestamp >= timestamp('2017-11-09'))
    group by rev_user_text) as E

on A.rev_user_text = E.rev_user_text

where (C.log_title is null);
SQL

Checking query status...
