View source

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