MediaWiki:Query:Overview

-SELECT date, pings, positions, bssids, waypoints, tracks, itracks, media, pmedia,
+ SELECT xmlelement(name a, xmlattibutes('/map/'||date||'/' as href) as date,
-       xmlelement(name a, xmlattributes(city_url as href),city_url) as city
+               pings, positions, bssids, waypoints, tracks, itracks, media, pmedia,
-  FROM frida.overview;
+               xmlelement(name a, xmlattributes(city_url as href),city_url) as city
+   FROM frida.overview;

Revision as of 22:37, 27 May 2009