Untitled query #86461

SQL

SELECT 
	t1.day, t1.editors, t1.edits, 
	all_editors, all_edits
FROM 
(
  select 
floor(rev_timestamp/1000000) as day,
sum(1) as edits,
count(distinct(rev_actor)) as editors
from revision 
where 
  rev_id > 880491260
  AND rev_timestamp>20240601000000
  group by day) as t2
  LEFT JOIN
(
select 
	floor(rev_timestamp/1000000) as day, 
    sum(1) as all_edits, 
    count(distinct(rev_actor)) as all_editors  
from 
	change_tag_def, 
    change_tag, 
    revision_userindex 
where 
	ct_tag_id = ctd_id 
    and ctd_name='Cat-a-lot' 
    and rev_id > 880491260 
    and ct_rev_id = rev_id 
group by day
) AS t1 ON t1.day=t2.day
ORDER BY day
SQL

Checking query status...
