| |
|
|
| | Задача тривиальная - посчитать реферальский бонус.
Вот только запрос получается очень длинный. Подскажите, как его сократить.
SELECT (
SELECT SUM( `amount1` )
FROM `qp_transactions`
WHERE `login2` = ANY(
SELECT id
FROM qp_users
WHERE ref =1
)
AND `ban_num1` =0
AND `is_ext1` =0
) + (
SELECT SUM( `amount2` )
FROM `qp_transactions`
WHERE `login1` = ANY(
SELECT id
FROM qp_users
WHERE ref =1
)
AND `ban_num2` =0
AND `is_ext2` =0 ) - (
SELECT SUM( `amount2` )
FROM `qp_transactions`
WHERE `login2` = ANY(
SELECT id
FROM qp_users
WHERE ref =1
)
AND `ban_num2` =0
AND `is_ext2` =0 ) - (
SELECT SUM( `amount1` )
FROM `qp_transactions`
WHERE `login1` = ANY(
SELECT id
FROM qp_users
WHERE ref =1
)
AND `ban_num1` =0
AND `is_ext1` =0 ) AS `result`
|
| |
| |
|
