SELECT restaurant.restaurantID, chefname, restaurantname, restaurantdesc, thumb, type, caption FROM restaurant LEFT JOIN images ON restaurant.restaurantID = images.restaurantID WHERE restaurant.restaurantID = 43 ORDER by restaurantname, images.placement
LXR Resorts / The Blackstone Group El Conquistador Resort
