Fiwiki edit analysis 2

SQL

SELECT ip_timestamp, page_title, ip, (user_timestamp<ip_timestamp) as abc10_edited_first, COALESCE(creator_name, r4.rev_user_text) as article_creator_name
FROM (
SELECT page_id, page_title, ip_timestamp, ip, user, user_timestamp, creator_name, min(r3.rev_timestamp) as min_ts
FROM (
SELECT 
    p.page_id,
	p.page_title,
    min(r1.rev_timestamp) as ip_timestamp,
    r1.rev_user_text as ip,
    r2.rev_user_text as user,
    min(r2.rev_timestamp) as user_timestamp,
    l.log_user_text as creator_name
FROM 
    page as p,
	revision_compat AS r1
    LEFT JOIN revision_compat as r2 
    	ON r1.rev_page=r2.rev_page 
        AND r2.rev_user_text="Abc10" 
        AND r2.rev_id<r1.rev_id 
        AND r2.rev_id>17811428
    LEFT JOIN logging_compat as l
        ON log_page=r1.rev_page
        AND log_namespace=0
        AND log_type="create"
        AND log_action="create"
        AND log_user_text="Abc10"
        AND log_id>10573200        
WHERE 
    p.page_namespace=0
    AND p.page_id = r1.rev_page
	AND r1.rev_id>18630374
    AND r1.rev_id < 19457868
    AND r1.rev_user=0
    AND r1.rev_user_text IN (
      "95.175.104.197", 
      "95.175.104.138", 
      "95.175.104.166", 
      "95.175.104.26", 
      "95.175.104.119", 
      "95.175.104.145", 
      "95.175.104.162" 
    )
GROUP BY p.page_id
) as t,
   revision_compat as r3
WHERE 
  r3.rev_page=page_id
GROUP BY page_id
) as tt,
  revision_compat as r4
WHERE
  r4.rev_page=page_id
  AND r4.rev_timestamp=tt.min_ts
GROUP BY page_id
ORDER BY ip
SQL

Checking query status...
