=$P{adtm_sdate} OR "MBMEMBMASTER"."RESIGN_DATE" is null OR to_char( mbmembmaster.resign_date,'dd/mm/yyyy') = '01/01/1900' ) AND MBMEMBMASTER.MEMBER_DATE <= $P{adtm_edate} ) GROUP BY "MBMEMBMASTER"."MEMBER_NO", "MBMEMBMASTER"."MEMB_NAME", "MBMEMBMASTER"."MEMB_SURNAME", "MBMEMBMASTER"."MEMBGROUP_CODE", "MBUCFMEMBGROUP"."MEMBGROUP_DESC", "MBUCFPRENAME"."PRENAME_DESC", "CMCOOPMASTER"."COOP_NAME", "MBMEMBMASTER"."MEMBER_DATE", "MBMEMBMASTER"."SEX","MBMEMBMASTER"."RESIGN_STATUS" order by "MBMEMBMASTER"."MEMBGROUP_CODE","MBMEMBMASTER"."MEMBER_NO","MBUCFMEMBGROUP"."MEMBGROUP_DESC"]]>