View source

 SELECT xmlelement(name a, xmlattributes('/srv/photo/'||media_id||'/' as href),
        xmlelement(name img, xmlattributes(frida.icon_from_url(url) as src, 'wdbi-thumbnail' as class)) 
        ) as thumbnail
   FROM frida.media
  ORDER BY media_id desc
  LIMIT 72