select card.* from card, ranking, sort where card.crid in (0,1000000128,1000000080,1000000129,1000000187,1000000131,1000000181,1000000082,1000000165,1000000137,1000000184,1000000083) and ranking.crid = card.crid and sort.crid = card.crid order by desc ranking.total

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'desc ranking.total' at line 1