# Problem mit Gladys Plus

**URL:** <https://community.gladysassistant.com/t/probleme-gladys-plus/8986>\
**Category:** Configuration\
**Created:** [24. Juni 2024 um 21:48 UTC](https://community.gladysassistant.com/t/probleme-gladys-plus/8986 "2024-06-24T21:48:59Z")\
**Posts on this page:** 1\
**Showing post:** 56

<div class="post-metadata">

**Author:** ![pierre-gilles](https://gladys-assistant-community.b-cdn.net/user_avatar/community.gladysassistant.com/pierre-gilles/32/5886_2.png) [@pierre-gilles](https://community.gladysassistant.com/u/pierre-gilles)\
**Post date:** [18. Juli 2024 um 17:36 UTC](https://community.gladysassistant.com/t/probleme-gladys-plus/8986/56 "2024-07-18T17:36:48Z")

</div>

> [@Hilfe! Problem mit der Aggregation?](https://community.gladysassistant.com/t/help-probleme-avec-lagregation/6630/56?u=pierre-gilles):
>
> @lmilcent Hop c’est cadeau: SELECT COUNT(t\_device\_feature\_state.id), device\_feature\_id, t\_device\_feature.name as feature\_name, t\_device.name as device\_name FROM t\_device\_feature\_state JOIN t\_device\_feature ON t\_device\_feature.id = device\_feature\_id JOIN t\_device ON t\_device.id = t\_device\_feature.device\_id GROUP BY device\_feature\_id ORDER BY COUNT(t\_device\_feature\_state.id) DESC;

---

_[View the full topic](https://community.gladysassistant.com/t/probleme-gladys-plus/8986)._