'00000000') as c_mem_all,(select count(distinct mem_full) from stscales_slip where slip_date between $P{adtm_sdate} and $P{adtm_edate} and slip_status=1 and stscales_slip.coop_id = $P{coop_id} and stproductmaster.producttype_code like '%$P!{adtm_producttype}%' and stscales_slip.product_no between $P{adtm_sproductno} and $P{adtm_eproductno} and member_no = '00000000') as c_orther_all from stscales_slip inner join stproductmaster on stscales_slip.product_no = stproductmaster.product_no inner join cmcoopmaster on cmcoopmaster.coop_id = stscales_slip.coop_id where slip_date between $P{adtm_sdate} and $P{adtm_edate} and slip_status=1 and stscales_slip.coop_id = $P{coop_id} and stproductmaster.producttype_code like '%$P!{adtm_producttype}%' and stscales_slip.product_no between $P{adtm_sproductno} and $P{adtm_eproductno} order by stscales_slip.product_no,slip_no asc]]>