select a.mb_name, b.mb_id, c.mb_id, count(*) as cnt , sum(b.wr_31) as totb, sum(c.wr_31) as totc
          from g5_member a
                   left join g5_write_csorder b on a.mb_id = b.mb_id
                   left join g5_write_cscenter c on a.mb_id = c.mb_id
         where b.wr_29 between '{$stx1}' and '{$stx2}' and b.wr_50 like '%{$stx7}%' and NOT b.wr_54 IN ('exchange') and NOT b.wr_7 IN ('4') and
         c.wr_29 between '{$stx1}' and '{$stx2}' and c.wr_50 like '%{$stx7}%'
         group by a.mb_name, b.mb_id ORDER BY totb DESC

        select a.mb_name, b.mb_id,count(*) as cnt , sum(b.wr_31) as totb
          from g5_member a
                   left join g5_write_cscenter b on a.mb_id = b.mb_id
         where b.wr_29 between '{$stx1}' and '{$stx2}' and b.wr_50 like '%{$stx7}%'
         group by a.mb_name, b.mb_id ORDER BY totb DESC

        select a.mb_name, b.mb_id,count(*) as cnt , sum(b.wr_31) as totb
          from g5_member a
                   left join g5_write_csorder b on a.mb_id = b.mb_id
         where b.wr_29 between '{$stx1}' and '{$stx2}' and b.wr_50 like '%{$stx7}%' and NOT b.wr_54 IN ('exchange') and NOT b.wr_7 IN ('4')
         group by a.mb_name, b.mb_id ORDER BY totb DESC