unknowndevQwQ
diff --git a/‎coderd/database/queries.sql.go
+2-2 b/‎coderd/database/queries.sql.go
+2-2
diff --git a/‎coderd/database/queries/workspaces.sql
+2-2 b/‎coderd/database/queries/workspaces.sql
+2-2
@@ -109,15 +109,15 @@ WHERE
 	-- Filter by owner_name
 	AND CASE
 		WHEN @owner_username :: text != '' THEN
-			owner_id = (SELECT id FROM users WHERE lower(username) = lower(@owner_username))
+			owner_id = (SELECT id FROM users WHERE lower(username) = lower(@owner_username) AND deleted = false)
 		ELSE true
 	END
 	-- Filter by template_name
 	-- There can be more than 1 template with the same name across organizations.
 	-- Use the organization filter to restrict to 1 org if needed.
 	AND CASE
 		WHEN @template_name :: text != '' THEN
-			template_id = ANY(SELECT id FROM templates WHERE lower(name) = lower(@template_name))
+			template_id = ANY(SELECT id FROM templates WHERE lower(name) = lower(@template_name)  AND deleted = false)
 		ELSE true
 	END
 	-- Filter by template_ids