--
-- Liste des layers d'une map
--
select 
m.id as "map.id",
m.name as "map.name",
c.id as "category.id",
c.name as "category.name",
c.iconurl "category.iconurl",
c.checked as "category.checked"
from map m
left join Category c on c.map_id = m.id

--
-- Liste des markers d'une map et d'un layer
--
select 
m.id as "map.id",
m.name as "map.name",
c.name as "category.name",
c.iconurl "category.iconurl",
c.checked as "category.checked",
k.name as "marker.name",
k.description as "marker.description",
k.lat as "marker.lat",
k.lon as "marker.lon",
k.alt as "marker.alt",
k.iconurl as "marker.iconurl",
k.photoprefix as "marker.photoprefix",
k.datemaj as "marker.datemaj",
r.name as "propertyref.name",
r.description as "propertyref.description",
v.value as "Propertyval.value"
from map m
left join Category c on c.map_id = m.id
left join Propertyref r on r.category_id = c.id
left join Marker k on k.category_id = c.id
left join propertyval v on v.propertyref_id = r.id and v.marker_id = k.id
where 
	m.id = 1 
and c.id = 1
and k.type = 1
order by c.id, k.id, r.id