MediaWiki:Query:Media

From FridaV

Revision as of 22:02, 21 March 2009 (view source) Root (Talk | contribs) (Created page with 'SELECT * FROM frida.media') ← Older edit		Current revision as of 23:26, 21 March 2009 (view source) Root (Talk | contribs)
-	SELECT *	+	SELECT rectime,type,icon,
-	FROM frida.media	+	xmlelement(name a, xmlattributes(url as href), url) as link
		+	FROM frida.media
		+	order by rectime desc

---

Current revision as of 23:26, 21 March 2009