[golography]

[9:47:42] Ekaterina: case when c.merchant_id=1 then 'debit SB'

when pn.partner_id in (43,108) and c.tariff_id<>8 then 'debit ITB'

when pn.partner_id not in (43,108) and c.tariff not in (5,6,8,13,17,18,20,27,28) then concat('debit ',(select p.name_short from iqcardtestdb.partner p where p.id=pn.partner_id))

when pn.partner_id not in (43,108) and c.tariff in (5,6,8,13,17,18,20,27,28) then concat('credit ',(select p.name_short from iqcardtestdb.partner p where p.id=pn.partner_id))

[9:47:44] Ekaterina: я сдaлась

[9:47:49] Ekaterina: : D

[9:47:52] Яшин Николай: : DDDDD

[9:48:00] Яшин Николай: : DDDDDDD

Понимание с полуслова! <3