Hello,

What's the best way to get a count from some keys / values pairs existing in $items ?
(where the value is a boolean and the key is a string)

Create a new custom SQL query in prepareQuery().
The only thing to add is to set the state var to switch the query. Follow the way the VIEW is doing it to choose its correct layout query.