I don't know much about Mysql and can't figure how I would achieve the following. I want to select the 50 most expensive products, and I want to order them alphabetically. The following orders them by prize, but I don't know how to grab those results and order them by something else (alphabetically).
SELECT * FROM `products` ORDER BY `prize` DESC LIMIT 50;