MediaWiki:Query:MediaThumbnails
From FridaV
SELECT xmlelement(name a, xmlattributes(url as href), | SELECT xmlelement(name a, xmlattributes(url as href), | ||
| - | xmlelement(name img, xmlattributes(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 rectime desc | ORDER BY rectime desc | ||
LIMIT 40 | LIMIT 40 | ||
