>
> Would there be a performance penalty?
> Because, for each row SELECT for COUNT will be executed?
>

There is no performance penaly (as long as you are aware that count(*) is
slow) because that's uncorelated subquery and it get's executed only once
(someone correct me if I'm wrong on this)

Nevertheless, as others have said already it's not the same query as already
posted.

Sasha