Skip to content

Instantly share code, notes, and snippets.

@raedatoui

raedatoui/gist:2161387

Created March 22, 2012 18:33
Show Gist options
  • Save raedatoui/2161387 to your computer and use it in GitHub Desktop.
Save raedatoui/2161387 to your computer and use it in GitHub Desktop.
Download ZIP
mysql select concat links
Raw
gistfile1.sql
SELECT CONCAT('http://naturevalleytrailview.com/',parks.slug,'/',trails.slug,'#panorama-',interest_points.slug)
FROM `interest_points`
LEFT JOIN trails ON trails.id = interest_points.trail_id
LEFT JOIN parks ON parks.id = trails.park_id
WHERE `poi_type_id` = 1 ORDER BY parks.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment