"r_id"|"total_days"|"s_date_start"|"s_date_end"|"r_date_from"|"r_date_last"
"1"|"1"|"2007-01-01"|"2007-07-31"|"2007-07-30"|"2007-08-03"
"1"|"2"|"2007-08-01"|"2007-12-31"|"2007-07-30"|"2007-08-03"

So first season:
1 day   : 2007-07-30 / 2007-07-31  -
                                    |- this night is not counted (night from 31/7 - 01/8
2 days  : 2007-08-01 / 2007-08-03  -