Untitled query #73327

SQL

SELECT 
   count(rev_id) as rc, 
   page_id,
   t.* FROM (
SELECT 
    log_timestamp,
    user_registration,
    user_editcount,
    log_id,
    log_page,
    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
    LEFT JOIN page ON page_namespace=0 AND log_page=page_id
WHERE
    rc<100
GROUP BY log_id
SQL

Checking query status...
