Are there any differences between MariaDb and Mysql?

Question

MySQL

There is a small request
for mysql 5.6 It fulfills the norms, sorting does not work in maria 5.6.
Does anyone know what could be the problem?
UPD: I found a solution, but it's very strange, I can't understand why maria Requires Limit
ORDER BY products.count DESC, product_images.order_sort ASC
LIMIT 9999999999 <----- This is how it works

Answer 1

Sorting that can and works, but in a subquery.
Sort the result.