CREATE 
    ALGORITHM = UNDEFINED 
    DEFINER = `root`@`localhost` 
    SQL SECURITY DEFINER
VIEW `recent_films` AS
    SELECT 
        `films`.`id` AS `id`,
        `films`.`name` AS `name`,
        `films`.`synopsis` AS `synopsis`,
        `films`.`user_id` AS `user_id`,
        `films`.`type_` AS `type_`,
        `films`.`time_` AS `time_`,
        `films`.`creation_date` AS `creation_date`,
        DROOLS(`films`.`id`, `films`.`type_`) AS `drools`,
        BTS(`films`.`id`, `films`.`type_`) AS `bites`
    FROM
        `films`
    ORDER BY `films`.`time_` DESC
    LIMIT 4