Untitled query #73327

SQL

SELECT 
   count(ar_id) as ac, 
  tt.*
FROM
(
SELECT 
   count(rev_id) as rc, 
   t.* FROM (
SELECT 
    log_timestamp,
    user_registration,
    user_editcount,
    log_id,
    ct_rev_id,
    actor_name,
    actor_id
FROM 
	change_tag_def,
    change_tag,
    actor_logging,
    user,
    logging 
WHERE 
	ctd_name IN ("contenttranslation", "contenttranslation-v2")
    AND ct_tag_id=ctd_id
    AND log_id=ct_log_id
    AND log_namespace=0    
    AND log_actor=actor_id 
    AND actor_user=user_id
GROUP BY log_id
) as t
    LEFT JOIN revision ON actor_id=rev_actor AND rev_timestamp<log_timestamp
GROUP BY log_id
) as tt
    LEFT JOIN archive ON actor_id=ar_actor AND ar_timestamp<log_timestamp
GROUP BY log_id
SQL

Checking query status...
