Select dep.ShortName, wpln.ShortName, ccItem.StartDate, ccItem.EndDate,

	wcrl.MondayCapacity, wcrl.TuesdayCapacity, wcrl.WednesdayCapacity, wcrl.ThursdayCapacity, wcrl.FridayCapacity, wcrl.SaturdayCapacity, wcrl.SundayCapacity from dbo.ResourcePlanItem rpi
INNER JOIN ResourceLink rlnk on rpi.ResourceLink_Id = rlnk.Id
INNER JOIN WorkPlan wpln on rpi.WorkPlan_Id = wpln.Id
INNER JOIN Department dep on rlnk.Department_Id = dep.Id
INNER JOIN Calendar cal on rpi.Calendar_Id = cal.Id
INNER JOIN CalculatedCalendar ccal on cal.Id = ccal.Id
INNER JOIN CalculatedCalendarItem ccItem on ccal.Id = ccItem.CalculatedCalendar_Id
INNER JOIN BaseCalendarRule bcrl on bcrl.Id = ccItem.CalendarRule_Id
INNER JOIN WeekCalendarRule wcrl on wcrl.Id = bcrl.Id
INNER JOIN EachDayCalendarRule ecrl on ecrl.Id = ccItem.CalendarRule_Id
where rlnk.InventoryType_Id is NULL AND rlnk.EmployeeSpeciality_Id is NULL;