select card.* from card, ranking, sort where card.crid in (0,1000000159,1000000026,1000000209) 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