Untitled query #27826

SQL

USE fiwiki_p;
SET @rev_id=17393631;
SELECT 
  SUM(1) AS c, 
  r.rev_id, 
  newer.rev_id, 
  older.rev_id 
FROM 
  revision AS r, 
  revision AS older, 
  revision AS newer, 
  revision AS delta 
WHERE 
 r.rev_id=@rev_id 
 AND r.rev_page=older.rev_page 
 AND older.rev_timestamp < r.rev_timestamp 
 AND r.rev_page=newer.rev_page 
 AND newer.rev_timestamp > r.rev_timestamp 
 AND older.rev_sha1=newer.rev_sha1 
 AND delta.rev_page=r.rev_page 
 AND delta.rev_timestamp > older.rev_timestamp 
 AND delta.rev_timestamp < newer.rev_timestamp 
GROUP BY r.rev_id, older.rev_id, newer.rev_id;
SQL

Checking query status...
