UPDATE account.account INNER JOIN (
    SELECT id, login, coins+mince as nove FROM (
        SELECT id, login, coins, mince FROM account.account RIGHT JOIN (
            SELECT uid, ROUND(m*0.9) as mince FROM (
                SELECT uid, sum(mince) as m FROM (
                    SELECT uid, am*c as mince FROM (
                            SELECT uid, type, count(*) as c , gopay.ammount as am FROM `gopay_log` LEFT JOIN gopay ON type=gopay.id WHERE state = 'PAID' GROUP BY uid, type
                        ) as s1
                ) as s2
            GROUP BY uid
            ORDER BY m DESC
            ) as s3
        ) as s4 ON account.id=s4.uid
    ) as s5
) as s6 ON account.id=s6.id SET coins = nove;