SELECT
rgc.any_code
,rgc.customer_group
,rgc.customer_code
,max(c.customer_name1)
,max(c.customer_name2)
,rg.create_time
,max(c.customer_group)
FROM
reading_group_customer rgc
LEFT OUTER JOIN reading_group rg ON
rgc.any_code = rg.any_code
and rgc.customer_group = rg.customer_group
LEFT OUTER JOIN customer c ON
rgc.customer_code = c.customer_code
LEFT OUTER JOIN member m ON
rgc.any_code = m.any_code
AND m.sts = 30
WHERE
c.status <> -1
AND (rgc.customer_code LIKE '%03040000%'
OR rgc.customer_group LIKE '%03040000%'
OR rgc.any_code LIKE '%03040000%'
OR rg.group_name LIKE '%03040000%'
OR m.name LIKE '%03040000%'
OR m.department_name LIKE '%03040000%'
OR m.tel LIKE '%03040000%'
OR m.email LIKE '%03040000%'
OR c.customer_name1 LIKE '%03040000%'
OR c.customer_name2 LIKE '%03040000%'
)
GROUP BY
rgc.any_code, rgc.customer_group, rgc.customer_code, rg.create_time
ORDER BY rg.create_time DESC, rgc.any_code, max(c.customer_group), rgc.customer_code