MediaWiki:Query:Overview
From FridaV
| - | SELECT xmlelement(name a, | + | SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href)) as date, |
pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, | pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, | ||
xmlelement(name a, xmlattributes(city_url as href),city_url) as city | xmlelement(name a, xmlattributes(city_url as href),city_url) as city | ||
FROM frida.overview | FROM frida.overview | ||
WHERE date IS NOT NULL | WHERE date IS NOT NULL | ||
