MediaWiki:Query:Overview
From FridaV
m |
|||
| - | SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,' | + | SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) 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 | ||
