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, | ||
name, | name, | ||
| - | xmlelement(name a, xmlattributes('http://fridav-data.ljudmila.net/data/'||frida.vehicle_macaddr(vehicle_id)||'/'||date||'/' as href),files) as files, | + | xmlelement(name a, xmlattributes('http://fridav-data.ljudmila.net/data/'||px.preg_replace(':','',frida.vehicle_macaddr(vehicle_id))||'/'||date||'/' as href),files) as 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 | ||
