Anything wrong with this SQL?

[eluser]whiteae[/eluser]
I think it has to do with the pagination. I thought codeigniter handled the offset if you put your SQL within active records. Because they don't have an offset number for the first page, its not getting that value.