MediaWiki:Query:Overview
From FridaV
| - | SELECT date, pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, | + | SELECT xmlelement(name a, xmlattributes('/srv/map/'||date||'/' as href),to_char(date,'YYYY-MM-DD Dy')) as date, |
| - | + | name, | |
| - | + | xmlelement(name a, xmlattributes(frida.data_url(date,vehicle_id) as href),files) as files, | |
| + | pings, positions, bssids, waypoints, tracks, itracks, media, pmedia, | ||
| + | xmlelement(name a, xmlattributes(city_url as href),px.basename(city_url)) as city | ||
| + | FROM frida.overview_date_vehicle | ||
| + | WHERE date IS NOT NULL | ||
| + | AND date >= date'2004-01-01' | ||
| + | ORDER BY to_char(date,'YYYY-MM-DD Dy') DESC | ||
