try

SELECT COUNT(C.clientId) as RowNr


instead of

SELECT COUNT(*) as RowNr


since count(*) counts even null rows

How does COUNT behave when cross joins are involved in mysql?
I would like to have a OSD notification display briefly everytime the CAPS, Num, or Scroll Lock state toggles.

Is there a way to do this?
