summaryrefslogtreecommitdiffstats
path: root/sql/server_delete_get_qa_clients.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/server_delete_get_qa_clients.sql')
-rw-r--r--sql/server_delete_get_qa_clients.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/server_delete_get_qa_clients.sql b/sql/server_delete_get_qa_clients.sql
new file mode 100644
index 0000000..bc7b983
--- /dev/null
+++ b/sql/server_delete_get_qa_clients.sql
@@ -0,0 +1 @@
+SELECT clients.client_id FROM group_server_to_client, clients WHERE group_server_to_client.id1 = clients.client_id and clients.server_id=:server_id: and group_server_to_client.server_id=0; \ No newline at end of file