mysql> select * from daily_hours order by day desc limit 10;
+-------+------------+---------+--------------+---------+
| id    | day        | user_id | type         | seconds |
+-------+------------+---------+--------------+---------+
| 10708 | 2008-04-15 |     512 | gross        |       0 |
| 10709 | 2008-04-15 |     512 | paid_break   |       0 |
| 10710 | 2008-04-15 |     512 | unpaid_break |       0 |
| 10711 | 2008-04-15 |     512 | vacation     |       0 |
| 10712 | 2008-04-15 |     512 | net          |       0 |
| 10713 | 2008-04-15 |    4153 | gross        |   37730 |
| 10714 | 2008-04-15 |    4153 | paid_break   |       0 |
| 10715 | 2008-04-15 |    4153 | unpaid_break |    4800 |
| 10716 | 2008-04-15 |    4153 | vacation     |       0 |
| 10717 | 2008-04-15 |    4153 | net          |   32930 |
+-------+------------+---------+--------------+---------+


mysql> select date_format(day,'%V %X'),
       user_id,
       type,
      sum(if(date_format(day,'%W')='Monday',seconds,0)) as monday,    sum(if(date_format(day,'%W')='Tuesday',seconds,0)) as tuesday
from daily_hours group by date_format(day,'%X %V'),user_id,type
order by day desc
limit 5;
+--------------------------+---------+--------------+--------+---------+
| date_format(day,'%V %X') | user_id | type         | monday | tuesday |
+--------------------------+---------+--------------+--------+---------+
| 15 2008                  |     512 | paid_break   |      0 |       0 |
| 15 2008                  |    5627 | unpaid_break |   2280 |    3420 |
| 15 2008                  |    5693 | vacation     |      0 |       0 |
| 15 2008                  |    5705 | net          |  28167 |   29132 |
| 15 2008                  |    5793 | gross        |      0 |       0 |
+--------------------------+---------+--------------+--------+---------+
5 rows in set (0.00 sec)