Help with this query, joining three tables in mysql
Order resulting table in the reverse chronological order and limit result to single row:

SELECT c.old_id,c.old_text 
  FROM text     AS c 
  JOIN revision AS b ON c.old_id=b.rev_text_id 
  JOIN page     AS a ON a.page_id=b.rev_page 
 WHERE a.page_id=3
 ORDER BY b.rev_text_id DESC
 LIMIT 1
;