SELECT SUM(d.roaylties) AS suma, COUNT(d.roaylties) AS sk
                        FROM band b INNER JOIN deal d ON b.id = fk_bandid
                        AND b.genre=IFNULL(?gen, b.genre)