SELECT restaurant.restaurantID, chefname, restaurantname, restaurantdesc, thumb, type, caption FROM restaurant LEFT JOIN images ON restaurant.restaurantID = images.restaurantID WHERE restaurant.restaurantID = 47 ORDER by restaurantname, images.placement
