alexi@www1-staging:~$ cat test.sql && mysql -t  < test.sql
SELECT
    distinct(u.email),
    u.id,
    u.nickname,
    u.balance,
    (
        SELECT
            SUM(tn.amount)
        FROM
            transactions tn
        WHERE
            tn.payer = u.id
    ) AS payer_amount,
    t.settlement_time,
    CURDATE() AS now
FROM
    system_settings s,
    transactions t
INNER JOIN
    users u ON t.recipient = u.id
WHERE
    s.key = 'grant_expiration_period' AND
    t.description = 'It all starts with C$20...' AND
    t.settlement_time BETWEEN "2011-07-01" AND "2011-08-02";
+-----------------------------+------+----------------+---------+--------------+---------------------+------------+
| email                       | id   | nickname       | balance | payer_amount | settlement_time     | now        |
+-----------------------------+------+----------------+---------+--------------+---------------------+------------+
| janet.vrasic@gmail.com      | 2449 | JanetDev       |      20 |         NULL | 2011-07-01 15:26:42 | 2011-08-09 |
| jlvrasic@excite.com         | 2999 | JanetDev2      |      20 |         NULL | 2011-07-01 23:05:30 | 2011-08-09 |
| tjdeluna@mac.com            |    7 | TJ             | 3105.64 |      3323.79 | 2011-07-02 12:38:11 | 2011-08-09 |
| deluna@mac.com              |   53 | T-Tester       |  993.83 |       332.00 | 2011-07-02 12:54:01 | 2011-08-09 |
| test+005@lovemachineinc.com |   82 | Wallace        |  110.59 |       105.12 | 2011-07-03 20:27:21 | 2011-08-09 |
| roshun.gautam@gmail.com     | 3122 | RoshanG        |      62 |        50.00 | 2011-07-16 04:26:23 | 2011-08-09 |
| qsdsqd@sdsq.sdsd            | 3126 | azaz           |       0 |         NULL | 2011-07-16 18:27:35 | 2011-08-09 |
| zezeze@sdsd.eze             | 3128 | ezezezez       |    3325 |         5.00 | 2011-07-17 03:49:32 | 2011-08-09 |
| spmmak7+16@gmail.com        | 3129 | spmmak7 16     |       0 |         NULL | 2011-07-17 11:48:52 | 2011-08-09 |
| spmmak7+16@gmail.com        | 3129 | spmmak7 16     |       0 |         NULL | 2011-07-17 11:51:48 | 2011-08-09 |
| zezeze@sdsd.eze             | 3128 | ezezezez       |    3325 |         5.00 | 2011-07-18 02:11:37 | 2011-08-09 |
| zezeze@sdsd.eze             | 3128 | ezezezez       |    3325 |         5.00 | 2011-07-18 02:13:24 | 2011-08-09 |
| zezeze@sdsd.eze             | 3128 | ezezezez       |    3325 |         5.00 | 2011-07-18 15:24:25 | 2011-08-09 |
| AdamHamot@gmail.com         | 3140 | zamn           |       0 |         NULL | 2011-07-18 15:53:42 | 2011-08-09 |
| ryan+2@coffeeandpower.com   | 3144 | Zoggie         |      20 |         NULL | 2011-07-18 16:10:42 | 2011-08-09 |
| dsasasa@dsa.ds              | 3154 | fds            |       0 |         NULL | 2011-07-19 00:54:30 | 2011-08-09 |
| dsadsa@hgs.lk               | 3158 | qwe            |       0 |         NULL | 2011-07-19 00:57:34 | 2011-08-09 |
| dsadsadsa@dsa.ds            | 3159 | wer            |      20 |         NULL | 2011-07-19 01:07:21 | 2011-08-09 |
| hjkhjk@dsa.sk               | 3160 | ert            |      20 |         NULL | 2011-07-19 01:10:17 | 2011-08-09 |
| saSa@sda.lk                 | 3161 | yxc            |      20 |         NULL | 2011-07-19 01:13:27 | 2011-08-09 |
| dsadsa@dsa.ds               | 3135 | dsa            |      20 |         NULL | 2011-07-19 21:15:51 | 2011-08-09 |
| matevz.mihalic@gmail.com    | 1909 | matevz         |       9 |        12.00 | 2011-07-13 19:14:24 | 2011-08-09 |
| dsadsaas@dsad.sl            | 3180 | fewewgvrew     |      20 |         NULL | 2011-07-14 21:20:31 | 2011-08-09 |
| dsa@dsadsa.si               | 3147 | dsadsa         |      20 |         NULL | 2011-07-15 21:23:23 | 2011-08-09 |
| test@test.si                | 3010 | test1235432    |      20 |         NULL | 2011-07-26 09:33:18 | 2011-08-09 |
| tretre@dsa.lk               | 3190 | iop            |      20 |         NULL | 2011-07-17 21:27:19 | 2011-08-09 |
| dasasd@dsadsa.lk            | 3151 | dsasdfds       |      20 |         NULL | 2011-07-18 21:42:48 | 2011-08-09 |
| freg@dsa.sl                 | 3181 | qwdwq          |      20 |         NULL | 2011-07-19 21:44:10 | 2011-08-09 |
| fefewfew@dsa.lk             | 3197 | gfdgfdgfd      |      20 |         NULL | 2011-07-20 15:34:59 | 2011-08-09 |
| tzu@dsa.ls                  | 3207 | poiut          |      20 |         NULL | 2011-07-20 15:36:54 | 2011-08-09 |
| 32refd@fds.lk               | 3208 | 34gref         |      20 |         NULL | 2011-07-26 15:39:26 | 2011-08-09 |
| werfhgn@dsa.sl              | 3209 | ztr            |      20 |         NULL | 2011-07-25 15:43:42 | 2011-08-09 |
| efwgrg@dsa.ls               | 3210 | wgrfe          |      20 |         NULL | 2011-07-24 15:47:03 | 2011-08-09 |
| 32tfgrf@dsa.sl              | 3211 | efw            |      20 |         NULL | 2011-07-23 15:52:57 | 2011-08-09 |
| lm7@jciapps.com             | 3220 | jotestme       |      20 |         NULL | 2011-07-21 01:24:59 | 2011-08-09 |
| alexi@lovemachineinc.com    |  268 | Alexi          | 134.194 |       370.75 | 2011-07-21 23:24:19 | 2011-08-09 |
| test@tes.dd                 | 3232 | tictac         |       0 |        20.00 | 2011-07-22 11:34:45 | 2011-08-09 |
| alexi+348759043@below92.com | 3470 | Alexi_Test9829 |      15 |         5.00 | 2011-07-30 18:07:03 | 2011-08-09 |
+-----------------------------+------+----------------+---------+--------------+---------------------+------------+