I'd like to sort my products listing, for certain categories only, by new and most popular. So first it would show the new products in the last 60 days, along with some kind of "NEW" badge, and then list the most popular in descending order. The popular count might be by orders or views, but assume I already have the data in another table.

Is this possible?

I think i would use a couple ORDER BY clauses in the SQL command. What file should I be changing?