Pagination with sorting

[eluser]dmorin[/eluser]
No, in a previous post I said: "This also doesn’t pull back a single review so you’ll have to keep that part of your code", meaning the point of this was only to get the pagination to work correctly by getting all of your sorting into this query. Therefore, the goal of the join is to join on every review that matches the criteria and then count the number per account record.

Then you can still get your single record the way you were previously, or you can do another join just for the single record. i would go with the first and keep it easy until you get the pagination working.