2018-07-10 SARU_LRUID去重

select DISTINCT details.SARU_LRUID, saleru.SARU_PHONE, details.BCCON_AREGDATE, details.BCCON_ORDERNUM, details.BCCON_MARK, COUNT(DISTINCT details.SARU_LRUID) from r_w_bankcardconsumerdetils as details LEFT JOIN r_b_saleru as saleru on details.SARU_LRUID = saleru.SARU_LRUID where BCCON_AREGDATE > '2018-07-10 00:00:00' and BCCON_MARK = 'FD,找不到商户号' GROUP BY details.SARU_LRUID