0, finslip.itempay_amt, finslip.itempay_amt)) as bthai, DATE_FORMAT(DATE_ADD( operate_date, INTERVAL 543 YEAR), '%d/%m/%Y') as date_thai ,coop_name,concat( CMCOOPMASTER.ADDR_NO,' หมู่ ',CMCOOPMASTER.ADDR_MOO,' ถ.',CMCOOPMASTER.ADDR_ROAD ,' ต.',CMCOOPMASTER.ADDR_TAMBOL,' อ.',CMCOOPMASTER.ADDR_AMPHUR ,' จ.',CMCOOPMASTER.ADDR_PROVINCE,' ',CMCOOPMASTER.ADDR_POSTCODE,' โทร ', CMCOOPMASTER.ADDR_PHONE) AS COOP_ADDR ,concat(address_no,' ต.',subdistrict,' อ.',district_desc,' จ.',province_desc,' ',fincontackmaster.postcode) as addr3 from finslipdet ,finslip left join mbmembmaster on finslip.member_no = mbmembmaster.member_no left join mbucfprename on mbmembmaster.prename_code = mbucfprename.prename_code left join cmcoopmaster on finslip.coop_id= cmcoopmaster.coop_id left join fincontackmaster on fincontackmaster.contack_no =finslip.member_no left join mbucfdistrict on fincontackmaster.district =mbucfdistrict.district_code left join mbucfprovince on mbucfprovince.province_code =fincontackmaster.province left join amsecusers on finslip.entry_id = amsecusers.user_name where finslip.slip_no = finslipdet.slip_no and finslip.coop_id = $P{coop_id} and (finslip.ref_slipno=$P{slippayin_no} or finslip.slip_no = $P{slippayin_no} or payslip_no =$P{slippayin_no} ) order by finslipdet.seq_no]]> 0 ? $F{item_payamt} : $F{item_payamt} )]]>