Pagination Category Issue

[Rich]

I just gave what you wrote up a whirl, but it spits out a database error asking me to check the syntax near "group by". I then dropped the initial category id and tried that, no avail. Also dropped the comma, no avail. lol

I have never used the group by command, so I am not certain of the proper syntax. I tried running a search on google for the syntax, but I found more people asking the same question than I did anything else.

I appreciate the assistance.