Messages count(*) wrong when applying content_workflow.state filter

I am building a content dashboard which should give an overview of content workflow states across different blogs and TKBs. But I get the wrong message count back. Let me talk you through it: Here's...