salix/db/routines/floranet/procedures/sliders_get.sql

DROP PROCEDURE IF EXISTS floranet.sliders_get;

DELIMITER $$
$$
CREATE DEFINER=`root`@`localhost` PROCEDURE floranet.sliders_get()
READS SQL DATA
BEGIN
/**
 * Returns list of url for sliders.
 */
	SELECT 
		CONCAT('https://cdn.verdnatura.es/image/catalog/1600x900/', i.image) url,
		i.longName
	FROM vn.item i
		JOIN vn.itemType it ON it.id = i.typeFk
	WHERE it.code IN ('FNR','FNP')
	LIMIT 3;
END$$
DELIMITER ;