SQL error: 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 ')' at line 5

Original query: select k.*, w.name as weapon_name, vjc.team as v_team, vjc.class as v_class, kjc.team as k_team, kjc.class as k_class from kills k join join_classes vjc on k.victim_join_class_id = vjc.join_classes_id join join_classes kjc on k.player_join_class_id = kjc.join_classes_id join weapons w on k.weapon = w.weapon_id where player_join_class_id in (8587552,8587544) and victim_join_class_id in ()