It should be about right. {$user} is resolved to the userid.
You should put your site to debug to see what kind of query it produces, and then try running this with phpMyAdmin to see why it does not return results.
I subscribed to this topic. It seems the forum post you'd made did not come properly with the email. {user} was missing in it. I will try it again with the proper query.