Well, yes it does, thanks! But now this shows up at the top:
SELECT a.*, b.* FROM wp_church_admin_calendar_date a,wp_church_admin_calendar_category b WHERE a.cat_id=b.cat_id AND a.start_date BETWEEN CAST(“2017-10-03” AS DATE) AND CAST(“2017-11-02” AS DATE) AND (a.cat_id=1) ORDER BY a.start_date,a.start_time
http://dev.teknoziz.com:8888/ncbc2/