Skip to content

Instantly share code, notes, and snippets.

@roomkey

roomkey/gist:724239

Created December 1, 2010 21:13
Show Gist options
  • Save roomkey/724239 to your computer and use it in GitHub Desktop.
Save roomkey/724239 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment