SELECT rental_listings.*, rental_images.Name as ImageName, rental_managers.Name as managerName FROM rental_listings LEFT JOIN rental_images ON (rental_images.RentalID = rental_listings.RentalID AND rental_images.Name LIKE '%e1%') LEFT JOIN rental_managers ON (rental_managers.ManagerID = rental_listings.CompanyID) INNER JOIN locations ON (rental_listings.LocID = locations.LocID) WHERE rental_listings.Status = 1 AND locations.DestinationID =28815 GROUP BY rental_listings.RentalID ORDER BY rental_listings.City

© 2016, Inc. Conditions of Use. Please read before using this site.