MediaWiki:Query:Overview

From FridaV

Jump to: navigation, search
-
  SELECT xmlelement(name a, xmlattibutes('/map/'||date||'/' as href) as date,
+
  SELECT xmlelement(name a, xmlattibutes('/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;

Revision as of 22:37, 27 May 2009

Personal tools
maps, graphs & data