Miscellany

Documentation 
CREATE VIEW current_wiki AS (
  SELECT a.* 
  FROM wiki AS a
  INNER JOIN (
    SELECT wiki_key, MAX( id ) AS max_id
    FROM wiki
    GROUP BY wiki_key
  ) 
  AS b ON a.wiki_key = b.wiki_key
  AND a.id = b.max_id
  WHERE body <> ''
) 

MySQL said: Documentation 
 #1349 - View's SELECT contains a subquery in the FROM clause