Id ^ v | Jid ^ v | Description ^ v | Tags ^ v | Members ^ v | LastUpdate before x days ^ v | MAM ^ v | options |
---|---|---|---|---|---|---|---|
19 | securemessenger@conference.trashserver.net | Diskussion über die Sicherheit von Messenger Apps | chat messenger app | 20 | 2716 | modify | |
17 | jdev@conference.jabber.org | Jabber/XMPP development RFCs and Extensions | XMPP development | 36 | 2716 | modify | |
13 | prosody@conference.prosody.im | Support zum Prosŏdy IM Server | XMPP | 115 | 2716 | modify | |
15 | operators@muc.xmpp.org | XMPP Operators Room | XMPP | 30 | 2716 | modify |
search: %s
query: SELECT * FROM Rooms WHERE (Description LIKE "%%s%" OR Tags LIKE "%%s%" OR Jid LIKE "%%s%") ORDER BY LastUpdate DESC LIMIT 10 OFFSET 30;