Dies ist eine alte Version des Dokuments!
SELECT izwei.name_ AS ClientName, COUNT(ieins.name_) AS "User in Benutzung" FROM loom_identity ieins INNER JOIN loom_identity izwei ON ieins.client_id_ = izwei.id_ WHERE ieins.blocked=FALSE AND ieins.archiv_=FALSE GROUP BY izwei.name_