Okay, I think I solve the question, our admin configured something really differently, since with an another fresh installation its working.
When I run the query outside the WP its working perfectly, I querying user defined tables, but according the codex it should work, and work as well if I not tighten up the query
