why wont this query return any results

[eluser]cideveloper[/eluser]
set

Code:

$this->output->enable_profiler(TRUE);

and see what query is being generated. Then try that query directly in you database and see if you get a result.