MediaWiki:Query:MediaThumbnails
From FridaV
| - | SELECT xmlelement(name a, xmlattributes( | + | 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)) | xmlelement(name img, xmlattributes(frida.icon_from_url(url) as src, 'wdbi-thumbnail' as class)) | ||
) as thumbnail | ) as thumbnail | ||
FROM frida.media | FROM frida.media | ||
| - | ORDER BY | + | ORDER BY media_id desc |
| - | LIMIT | + | LIMIT 108 |
