Bugfix: Fix clauses for user listing query.

1 files changed, 4 insertions, 4 deletions

diff --git a/gn_auth/auth/authorisation/users/models.py b/gn_auth/auth/authorisation/users/models.py
index 956f239..1b7d8e0 100644
--- a/gn_auth/auth/authorisation/users/models.py
+++ b/gn_auth/auth/authorisation/users/models.py
@@ -54,18 +54,18 @@ def __list_user_clauses_and_params__(**kwargs) -> tuple[str, dict[str, Union[int
         clauses = "email LIKE :email"
         params["email"] = f'%{kwargs["email"].strip()}%'
     elif bool(kwargs.get("name", "").strip()):
-        clauses = clauses + ["name LIKE :name"]
+        clauses = "name LIKE :name"
         params["name"] = f'%{kwargs["name"].strip()}%'
     else:
         clauses = ""
 
     if bool(kwargs.get("verified", "").strip()):
-        clauses = clauses + " AND verified=:verified"
-        params["verified"] = 1 if kwargs["verified"].strip() == "yes" else 0
+        clauses = clauses + (" AND " if len(clauses) > 0 else "") + "verified=:verified"
+        params["verified"] = "1" if kwargs["verified"].strip() == "yes" else "0"
 
     if bool(kwargs.get("age", "").strip()):
         _clause, _param = __process_age_clause__(kwargs["age"].strip())
-        clauses = clauses + f" AND {_clause}"
+        clauses = clauses + (" AND " if len(clauses) > 0 else "") + _clause
         params["created"] = _param
 
     return clauses, params