SELECT    ca.card_code,
          b.org_id_from,
          Count(b.id)           AS count_buy,
          Max(b.date)           AS last_date,
          Sum(b.discount_price) AS all_price,
          u.NAME                AS name,
          u.last_name           AS surname,
          ca.user_id,
          Sum(b.org_bonus)      AS bonus,
          Sum(b.org_bonus_down) AS bonus_down,
          Sum(b.POINTS_DOWN)    AS POINTS_DOWN,
          cb.bonus              AS card_bonus,
          uts.uf_yamap_x        AS map_x,
          uts.uf_yamap_y        AS map_y
FROM      b_org_buy_list b
LEFT JOIN b_user_cards ca
ON        ca.ID = b.card_id
LEFT JOIN b_uts_user uts
ON        uts.uf_card_code = ca.card_code
LEFT JOIN b_user u
ON        u.id = uts.value_id
LEFT JOIN b_card_bonus cb
ON        cb.card_id = ca.ID
AND       cb.org_id='137'
WHERE b.ORG_ID ='137'
GROUP BY  b.card_id
ORDER BY  last_date desc limit 10 offset 0