SELECT id, partner_id, partner_hotel_identifier, name, CONCAT(COALESCE(address1, ''), ' ', COALESCE(address2, '')) AS 'address', city, state, zip, phone, lat, lng, stars, pet_policy, url FROM partner_hotels WHERE deleted <> 1 AND city='Aspen' AND state='CO' AND country_code='US' ORDER BY name, address;