How to reset active record database query?

[eluser]CroNiX[/eluser]
The query doesn't get reset until you db::get() the data. Until that point it is compiling all of the AR statements into a single query. So if you don't have a get() in your loop, you are just continually building upon the existing query until get() gets executed outside of the loop.