View source

 SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date,
               name,
            xmlelement(name a, xmlattributes(frida.data_url(date,vehicle_id) as href),files) as files,
               pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, 
               xmlelement(name a, xmlattributes(city_url as href),px.basename(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