SELECT
rgc.any_code
,rgc.customer_group
,rgc.customer_code
,max(c.customer_name1)
,max(c.customer_name2)
,rg.create_time
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
GROUP BY
rgc.any_code, rgc.customer_group, rgc.customer_code, rg.create_time
ORDER BY rg.create_time DESC, rgc.any_code, rgc.customer_code