PHP:
скопировать код в буфер обмена
скопировать код в буфер обмена
- SUM(IF(method=1,amount,0)) AS am_met_1,
- SUM(IF(method=1,bonus,0)) AS bonus_met_1,
- SUM(IF(method=2,amount,0)) AS am_met_2,
- SUM(IF(method=2,bonus,0)) AS bonus_met_2,
- SUM(IF(method=3,amount,0)) AS am_met_3,
- SUM(IF(method=3,bonus,0)) AS bonus_met_3,
- SUM(IF(method=4,amount,0)) AS am_met_4,
- SUM(IF(method=4,bonus,0)) AS bonus_met_4,
- SUM(amount) AS total_am,
- SUM(bonus) AS total_bon
- FROM fn.fn_balance_in
- WHERE TO_DAYS('2010-07-01') - TO_DAYS(dtime) <= 30