CREATE  PROCEDURE `DSC_GetListOfLiveEstByCityID`(IN `CityID` INT)
	LANGUAGE SQL
	NOT DETERMINISTIC
	CONTAINS SQL
	SQL SECURITY DEFINER
	COMMENT ''
BEGIN
SELECT EST.id, EST.name, EST.latitude, EST.longitude, EST.landmark FROM establishment EST WHERE EST.city_id=CityID and EST.`status`=1;
END