Daily
From FridaV
SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date,
pings, positions, bssids, waypoints, tracks, itracks, media, pmedia,
xmlelement(name a, xmlattributes(city_url as href),city_url) as city
FROM frida.overview
WHERE date IS NOT NULL
AND date >= date'2004-01-01'
ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC
