Test view and sub-query with ORDER BY and LIMIT.