MediaWiki:Query:MediaThumbnails

-SELECT xmlelement(name a, xmlattributes(url as href),
+ SELECT xmlelement(name a, xmlattributes('/srv/photo/'||media_id||'/' 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.interesting_media
+   FROM frida.media
- ORDER BY random()
+  ORDER BY media_id desc
- LIMIT 50
+  LIMIT 108

Current revision as of 20:27, 5 June 2009