This shows you the differences between two versions of the page.
| Both sides previous revision
Previous revision
|
Next revision
Both sides next revision
|
en:public_servers [2021/09/23 12:47]
jomat |
en:public_servers [2021/09/23 12:47]
jomat |
| <searchtable> | <searchtable> |
| <sortable> | <sortable> |
| <sql db="pgsql://matrixservers:jnhEfk3zSPiT4BkaC6xOja9Omq77Bu@172.23.216.251/matrixservers" display="block" wikitext="disable"> select domain as "Name", c2s as "Server", daemon as "Software", daemonver as "Version", to_timestamp(lastupdate) as "Last Check" from servers where reg=1 and federation=1 and domain like '%2air%' and (domain, lastupdate) in (select domain, max(lastupdate) from servers group by domain) ORDER BY RANDOM(); </sql> | <sql db="pgsql://matrixservers:jnhEfk3zSPiT4BkaC6xOja9Omq77Bu@172.23.216.251/matrixservers" display="block" wikitext="disable"> select domain as "Name", c2s as "Server", daemon as "Software", daemonver as "Version", to_timestamp(lastupdate) as "Last Check" from servers where reg=1 and federation=1 and (domain, lastupdate) in (select domain, max(lastupdate) from servers group by domain) ORDER BY RANDOM(); </sql> |
| </sortable> | </sortable> |
| </searchtable> | </searchtable> |