select sum((select `price` from `item` where `item`.`id` = `order`.`item_id` )*`order`.`qty`-(select sum(`payment`.`amount`) `amount` from `payment` where `payment`.`order_id` = `order`.`id` )) `due` from `order` where `order`.`user_id` in (select `id` from `user` where `user`.`is_client` = 1 and `user`.`is_vip` = 1 ) [:a_2, :a]
40.00