Mandatory information about my setup:

Have I searched the tickets before posting? Yes
Have I searched the forum before posting? Yes
Have I read the documentation before posting (which pages?)? Yes
Joomla! version: 3.2.2
PHP version: 5.3.13
MySQL version: 5.5.24
Hotspots version: 3.5.5 pro
Direct link to the page that shows the issue: (unknown)


Description of my issue:

Hi,
I am creating a custom list of hotspots directly from the database.
http://www.orthodox.net.au/ch/en/list-of-churches
I need to build a HREF link to individual hotspot from the database.
I've noticed the individual hotspot URL is excellent for SEF but quite complex to generate from the database, example
http://www.orthodox.net.au/ch/en/map/3-greek-church/4-cathedral-of-the-annunciation-of-our-lady-s

You have both category name and spot name, with special characters stripped or substituted, and length capped at 45 chars...
Can you please help? Perhaps there is an easier way to generate a link just by using the ID?

PS so far my SQL query:
SELECT j0385_hotspots_marker.name as Name, cat_name as Type, CASE left(plz,1) WHEN '0' THEN 'Northern Territory' WHEN '2' THEN 'New South Wales' WHEN '3' THEN 'Victoria' WHEN '4' THEN ' Queensland ' WHEN '5' THEN ' South Australia' WHEN '6' THEN 'Unknown' WHEN '7' THEN 'Tasmania' ELSE 'Unknown' END as State , town as Suburb, plz as Postcode, street as Address FROM j0385_hotspots_marker, j0385_hotspots_categorie where j0385_hotspots_categorie.id = catid