MediaWiki:Query:MediaThumbnails
From FridaV
(Created page with 'SELECT xmlelement(name img, xmlattributes(url as src, 'wdbi-thumbnail' as class)) ) as thumbnail FROM frida.media LIMIT 100') |
|||
| - | SELECT xmlelement(name img, xmlattributes(url as src, 'wdbi-thumbnail' as class)) | + | 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 | ||
