salix/db/routines/vn/procedures/itemShelving_get.sql

DELIMITER $$
CREATE OR REPLACE DEFINER=`vn`@`localhost` PROCEDURE `vn`.`itemShelving_get`(
	vShelvingCode VARCHAR(10)
)
BEGIN
/**
* Lista artículos de itemShelving.
*
* @param vShelvingCode Matrícula del carro
**/
	SELECT ish.itemFk item, 
			i.name, 
			i.longName,
			i.size, 
			ish.visible,
			ish.packing,
			ish.grouping,
			p.code,
			ish.id,
			s.priority,
			ish.isChecked,
			ic.url,
			ish.available,
			ish.buyFk,
			ish.shelvingFk
		FROM itemShelving ish
			JOIN item i ON i.id = ish.itemFk
			JOIN shelving s ON s.id = ish.shelvingFk
			LEFT JOIN parking p ON p.id = s.parkingFk
			JOIN hedera.imageConfig ic
		WHERE s.code COLLATE utf8_unicode_ci = vShelvingCode;
END$$
DELIMITER ;