MediaWiki:Query:Overview
From FridaV
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 |
| + | AND date >= date'2004-01-01' | ||
