Advanced Card Search Combos Artists Rules Sets Trivia Random Card

SELECT * FROM combos where locate("abu018",combo) && clone_types not in ("fake", "notworking", "fun") order by (clone_types="fake"),(clone_types="notworking"),(clone_types="classic"),(clone_types="fun"), (clone_types=""),(clone_types="normal"),(clone_types="synergy"),(clone_types="lock"), (clone_types="threat"),(clone_types="infinite"),(clone_refs<>""), inf_win desc, inf_active desc, mt8_decks desc,date desc limit 20,20