select		@start := r_date_from
			,@end := r_date_last
			,SUM(  (TO_DAYS(LEAST(s_date_end, @end)) - TO_DAYS(GREATEST(@start, s_date_start)) ) * sp_price) as total_house_price
from		reservations
inner join	reservation_items
		on	ri_reservationsid = ri_id
inner join	products
		on	ri_productsid = p_id
inner join 	product_groups
on			if (p_type = "house", p_house_public_productgroupsid, p_productgroupsid) = pg_id
inner join 	season_prices
		on 	sp_productgroupsid = pg_id
inner join	seasons
		on	s_id = sp_seasonsid
		and	@start < s_date_end
		and	@end > s_date_start
where		(ri_parentid = 0 or ri_parentid is null)
			and ri_id = 1
group by 	ri_id;