sql - Query working days from calendar in CRM 2015 -

i have created calendar (working days) resource (e.g. facility). how can list or @ least ranges of working days directly database?

all have found far calendar , calendarrule views. problem calendarrule rule written pattern

"freq=weekly;interval=1;byday=mo,tu,we,th,fr" 

i can not find way use in sql query.

assuming working days mon fri , calendar table linked resources table calendar.workingdays = resources.daysworked, if not adjust them suit.

select extract(dow timestamp (to_timestamp(c.workingdays), "yyyy-mm-dd")), r.facility calendar c left join resources r on c.workingdays = r.daysworked extract(dow timestamp (to_timestamp(c.workingdays, "yyyy-mm-dd")) not in (0,6)