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/11/09 20:43] jomat |
en:public_servers [2021/11/10 13:29] 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 != 'kescher.at' 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 != 'kescher.at' and domain != 'llit.eu' and (domain, lastupdate) in (select domain, max(lastupdate) from servers group by domain) ORDER BY RANDOM(); </sql> |
</sortable> | </sortable> |
</searchtable> | </searchtable> |