Active record and date in where statement

[eluser]WanWizard[/eluser]
The profiler doesn't make errors, it simply lists the queries as they were executed by the database library.

If you see an extra where clause, check your code to see where it is defined. The database class only resets it's internal arrays after executing a query, so a $this->db->where() in your code is remembered by the database class until you execute the query.

I find it hard to believe that the exact same query produces different results when run from PHPMyAdmin. As mentioned before, output $this->db1->last_query() directly after you run the query, to make sure you're looking at the same query.