summaryrefslogblamecommitdiffstats
path: root/sql/client_delete_prune.sql
blob: 81ae6da3f6c54637c509907efe3e1bf68526fd15 (plain) (tree)
1
                                                                                                                                                                                
select * from clients where not exists (select id1 from group_server_to_client where id1= clients.client_id) and client_lastconnected < :timestamp: and server_id != 0 limit 100;