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 'assassin' AND b.id = bt.game_id AND b.published = 1 GROUP BY b.id' at line 4