Media

From FridaV

Latest

 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 108

Random

 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 random()
  LIMIT 36

re-randomize!