MediaWiki:Query:Overview
From FridaV
SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date, | SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date, | ||
| + | files, | ||
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. | + | FROM frida.overview_date_vehicle |
WHERE date IS NOT NULL | WHERE date IS NOT NULL | ||
AND date >= date'2004-01-01' | AND date >= date'2004-01-01' | ||
ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC | ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC | ||
