Partial Hebrew Revisions

SQL

SELECT rev_page, rev_id, start_time-rev_6.timestamp as diff FROM
  (SELECT rev_page, rev_parent_id, start_time FROM 
    (SELECT rev_page, rev_user_text, time, start_time FROM
      (SELECT rev1.rev_page as rev_page, rev1.rev_user_text as rev_user_text, rev_timestamp as start_time FROM hewiki_p.revision
        WHERE rev_deleted = 0
        AND LCASE(rev_user) NOT LIKE '%bot%'
        AND rev_parent_id = 0) as rev1
      INNER JOIN 
        (SELECT rev_page, rev_user_text, MIN(rev_timestamp) as time FROM hewiki_p.revision
         WHERE rev_deleted = 0
         AND LCASE(rev_user) NOT LIKE '%bot%'
        GROUP BY rev_page, rev_user_text) as rev2
      ON rev1.rev_page = rev2.rev_page
      AND rev1.rev_user_text != rev2.rev_user_text) as rev3
  INNER JOIN 
    (SELECT rev_page, rev_parent_id, rev_timestamp FROM hewiki_p.revision) as rev4
  ON rev3.rev_page = rev4.rev_page
  AND rev3.time = rev4.rev_timestamp) rev5
INNER JOIN
	(SELECT rev_page, rev_id, rev_timestamp FROM hewiki_p.revision) as rev6
ON rev5.rev_parent_id = rev6.rev_id
LIMIT 100;
SQL

Checking query status...
