MySQL - Error 1046

CREATE PROCEDURE sp(param1 int(11))

 SELECT f.title AS Titulo,a.last_name AS  Apellido, a.first_name AS Nombre FROM sakila.film f JOIN sakila.film_actor f_a ON f.id_film=f_a.id_film JOIN sakila.actor a ON f_a.id_actor=a.id_actor ORDER BY f.title,a.last_name,a.first_name LIMIT @param1;