Well: Is "unanswered" the same as "unsolved"? Not sure, maybe keithkelly could clarify?
In my view "unanswered" is a topic that hasn't received any replies where a topic can have replies but none of these replies were marked as a solution, e.g. is "unsolved" (which would be what the query above would return).
To get back topics with no replies you'd want to use replies.count(*) = 0, e.g. something like this:
SELECT count(*) FROM messages WHERE depth = 0 AND replies.count(*) = 0
Yes, I'm referring to topics where replies = 0. Or, "response-less" topics.
But rather than asking "How many topics - posted in January - don't have a response?" I'd like to ask "On January 1, how many topics on the Policy board were responseless?"
