SELECT date, 
case when categoria = 10 then suma else 0 end as Zarplata1,
case when categoria = 11 then suma else 0 end as Avans1,
case when categoria = 12 then suma else 0 end as Bonus1,
case when categoria = 13 then suma else 0 end as Zarplata2,
case when categoria = 14 then suma else 0 end as Avans2,
case when categoria = 15 then suma else 0 end as Bonus2
FROM `prixod` 
WHERE date >= '2013-10-10' 
and date <= '2013-10-31'

SELECT categoria, 
sum(case day(date) when  1 then suma else 0 end) as day_01,
sum(case day(date) when  2 then suma else 0 end) as day_02,
sum(case day(date) when  3 then suma else 0 end) as day_03,
sum(case day(date) when  4 then suma else 0 end) as day_04,
sum(case day(date) when  5 then suma else 0 end) as day_05,
sum(case day(date) when  6 then suma else 0 end) as day_06,
sum(case day(date) when  7 then suma else 0 end) as day_07,
sum(case day(date) when  8 then suma else 0 end) as day_08,
sum(case day(date) when  9 then suma else 0 end) as day_09,
sum(case day(date) when  10 then suma else 0 end) as day_10,
sum(case day(date) when  11 then suma else 0 end) as day_11,
sum(case day(date) when  12 then suma else 0 end) as day_12,
sum(case day(date) when  13 then suma else 0 end) as day_13,
sum(case day(date) when  14 then suma else 0 end) as day_14,
sum(case day(date) when  15 then suma else 0 end) as day_15,
sum(case day(date) when  16 then suma else 0 end) as day_16,
sum(case day(date) when  17 then suma else 0 end) as day_17,
sum(case day(date) when  18 then suma else 0 end) as day_18,
sum(case day(date) when  19 then suma else 0 end) as day_19,
sum(case day(date) when  20 then suma else 0 end) as day_20,
sum(case day(date) when  21 then suma else 0 end) as day_21,
sum(case day(date) when  22 then suma else 0 end) as day_22,
sum(case day(date) when  23 then suma else 0 end) as day_23,
sum(case day(date) when  24 then suma else 0 end) as day_24,
sum(case day(date) when  25 then suma else 0 end) as day_25,
sum(case day(date) when  26 then suma else 0 end) as day_26,
sum(case day(date) when  27 then suma else 0 end) as day_27,
sum(case day(date) when  28 then suma else 0 end) as day_28,
sum(case day(date) when  29 then suma else 0 end) as day_29,
sum(case day(date) when  30 then suma else 0 end) as day_30,
sum(case day(date) when  31 then suma else 0 end) as day_31
FROM `prixod` 
WHERE date >= '2013-10-01' 
and date < '2013-11-01'
group by categoria