MediaWiki:Query:Overview
From FridaV
| - | SELECT xmlelement(name a, xmlattibutes('/srv/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 | ||
| - | WHERE date IS NOT NULL | + | WHERE date IS NOT NULL |
