SELECT IF (
(@cblnk := (
ifnull(
`tab_callback`.`cb_type` = 'local'
) - ifnull(
`view_adoffer_remain_cap`.`sum(day_cap)`,
0
)
)) = - (1.1),
'不限',
@remain
) AS `OFFER_REMAIN_CAP`,
`tab_callback`.`ADOFFER_ID` AS `ADOFFER_ID`
FROM
(
`tab_callback`
LEFT JOIN `view_adoffer_remain_cap` ON (
(
`tab_callback`.`ADOFFER_ID` = `view_adoffer_remain_cap`.`ADOFFER_ID`
)
)
)
