SELECT *
FROM `Tabla`
WHERE `Campo1` = ’1′
ORDER BY Campo2 DESC, Campo3 DESC
LIMIT 0 , 10