db_select returns empty array, BUT the raw query returns records...?
It's impossible to troubleshoot such a query without access to your environment.

The Devel module has a query inspection tool (Display query log in the Devel settings). that can assist you in determining what query was sent to your database. Use that to determine the exact query sent to your DB and  how it differs from the query you're sending to your SQL client.