MediaWiki:Query:MediaThumbnails

SELECT xmlelement(name a, xmlattributes(url as href),

        xmlelement(name img, xmlattributes(frida.icon_from_url(url) as src, 'wdbi-thumbnail' as class))  

      ) as thumbnail

  FROM frida.media

ORDER BY rectime desc

LIMIT 400