SQL: Need someone else to look at this, please

[eluser]coding_hero[/eluser]
[quote author="pistolPete" date="1235774552"]A general advice: Use the profiler to see which queries were actually generated.

Code:

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

[/quote]

Aha! Thanks, I was looking for something like that. I eventually started stepping into the ActiveRecords class to see what SQL it was generating mere minutes before you posted.

I suggest using the plain SQL statement instead:

Code:

$this->db->query('SELECT DISTINCT collection.id, collection.name ...');

Yah, that's the conclusion I came to also. Glad to know it wasn't me doing something stupid. I can blame the class for this one

Thanks for the help!