SELECT
    ->   `us`.`id`              AS `user`,
    ->   `curr`.`code`          AS `currency`,
    ->   `o`.`status`           AS `orderStatus`,
    ->   SUM(o.income_user_aff) AS `amount`
    -> FROM `user_source` `us` LEFT JOIN `user` `u` ON u.user_source_id = us.id
    ->   LEFT JOIN `click` `c` ON c.user_id = u.id
    ->   LEFT JOIN `order` `o` ON o.click_id = c.id
    ->   LEFT JOIN `currency` `curr` ON curr.id = o.income_currency_id
    -> WHERE o.id IS NOT NULL
    -> GROUP BY `o`.`status`, `us`.`id`, `curr`.`code`;
+-------+----------+---------------+----------+
| user  | currency | orderStatus   | amount   |
+-------+----------+---------------+----------+
|    11 | RUR      | NEW           |    29.66 |
|    11 | USD      | NEW           |     0.25 |
|    16 | RUR      | NEW           |   381.71 |
|    16 | USD      | NEW           |     2.55 |
|   832 | RUR      | NEW           |     3.00 |
|  4658 | USD      | NEW           |     0.25 |
|  5596 | USD      | NEW           |     0.42 |
|  5962 | BRL      | NEW           |     5.40 |
|  8898 | USD      | NEW           |     0.44 |
| 13250 | USD      | NEW           |     0.03 |
| 13768 | RUR      | NEW           |  1529.66 |
| 13768 | USD      | NEW           |     0.81 |
| 15274 | USD      | NEW           |     0.12 |
| 15289 | USD      | NEW           |     9.82 |
| 15739 | RUR      | NEW           |     1.73 |
| 17254 | USD      | NEW           |     0.30 |
| 24217 | USD      | NEW           |     0.04 |
| 27904 | USD      | NEW           |     0.12 |
| 28516 | USD      | NEW           |     0.12 |
| 29228 | USD      | NEW           |     0.01 |
|     3 | RUR      | PURCHASED     |     4.16 |
|    11 | RUR      | PURCHASED     |   196.23 |
|    11 | USD      | PURCHASED     |     2.40 |
|    16 | RUR      | PURCHASED     |  2989.51 |
|    16 | USD      | PURCHASED     |    35.25 |
|    19 | USD      | PURCHASED     |     0.02 |
|    41 | RUR      | PURCHASED     |   149.72 |
|    41 | USD      | PURCHASED     |     2.16 |
|  3338 | RUR      | PURCHASED     |    43.35 |
|  3598 | BRL      | PURCHASED     |     2.05 |
|  3691 | USD      | PURCHASED     |     0.07 |
|  4301 | BRL      | PURCHASED     |     4.67 |
|  4658 | USD      | PURCHASED     |     0.31 |
|  5962 | BRL      | PURCHASED     |    10.04 |
|  8898 | RUR      | PURCHASED     |   252.55 |
|  8898 | USD      | PURCHASED     |     2.24 |
|  8899 | USD      | PURCHASED     |     1.41 |
| 10535 | BRL      | PURCHASED     |     4.27 |
| 13614 | RUR      | PURCHASED     |     1.62 |
| 13614 | USD      | PURCHASED     |     0.96 |
| 13768 | USD      | PURCHASED     |     1.07 |
| 15274 | USD      | PURCHASED     |     0.28 |
| 15289 | RUR      | PURCHASED     |   101.71 |
| 15400 | USD      | PURCHASED     |     0.19 |
| 17254 | USD      | PURCHASED     |     0.32 |
| 23850 | RUR      | PURCHASED     |    58.32 |
| 24217 | USD      | PURCHASED     |     0.25 |
| 26241 | USD      | PURCHASED     |     0.01 |
| 27904 | USD      | PURCHASED     |     0.14 |
|     3 | RUR      | NOT_PURCHASED |   100.51 |
|     3 | USD      | NOT_PURCHASED |     0.01 |
|    11 | RUR      | NOT_PURCHASED |   621.40 |
|    16 | EUR      | NOT_PURCHASED |     1.35 |
|    16 | RUR      | NOT_PURCHASED | 19680.32 |
|    16 | USD      | NOT_PURCHASED |     1.21 |
|    41 | RUR      | NOT_PURCHASED |   132.37 |
|  2399 | USD      | NOT_PURCHASED |     0.09 |
|  3338 | RUR      | NOT_PURCHASED |   656.52 |
|  3474 | BRL      | NOT_PURCHASED |     1.93 |
|  3598 | BRL      | NOT_PURCHASED |    71.07 |
|  4301 | BRL      | NOT_PURCHASED |   305.65 |
|  4301 | USD      | NOT_PURCHASED |     0.22 |
|  4593 | RUR      | NOT_PURCHASED |    12.64 |
|  5223 | RUR      | NOT_PURCHASED |    15.67 |
|  8899 | RUR      | NOT_PURCHASED |     4.44 |
|  8944 | RUR      | NOT_PURCHASED |   108.64 |
| 13148 | BRL      | NOT_PURCHASED |   230.51 |
| 13250 | RUR      | NOT_PURCHASED |    40.38 |
| 13250 | USD      | NOT_PURCHASED |     0.22 |
| 13614 | RUR      | NOT_PURCHASED |     2.90 |
| 13614 | USD      | NOT_PURCHASED |     0.61 |
| 13768 | RUR      | NOT_PURCHASED |   316.43 |
| 13768 | USD      | NOT_PURCHASED |     0.01 |
| 13885 | RUR      | NOT_PURCHASED |    19.37 |
| 15274 | USD      | NOT_PURCHASED |     0.01 |
| 20073 | USD      | NOT_PURCHASED |     0.02 |
+-------+----------+---------------+----------+
76 rows in set (0.03 sec)