Media

From FridaV

Jump to: navigation, search

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!

Personal tools
maps, graphs & data