Complex SQL -> converting to active records

[eluser]jedd[/eluser]
[quote author="JamesTaylor" date="1260480656"]
I would like to add some pagination to the results so am wanting to convert the above sql into a CI active records statement.

I'm not sure but does the CI pagination only work with active records?
[/quote]

No - you can easily just put your LIMIT and offset values in to your usual (non-AR) queries.

What you may want to do is use binding or manually escape your variables in your queries, at least.