Date to be checked against = 2022-03-14 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-14' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-14 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-14' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-30 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-30' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-03-31 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-03-31' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-04 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-04' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-05 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-05' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-06 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-06' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-07 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-07' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-08 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-08' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-11 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-11' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-12 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-12' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-13 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-13' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-14 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-14' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 1 Date to be checked against = 2022-04-18 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-18' AND (branch = 'All' OR branch = 'ZA-DW') Value = 1 Date to be checked against = 2022-04-19 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-19' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-20 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-20' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-21 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-21' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-22 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-22' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-25 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-25' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-26 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-26' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-27 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-27' AND (branch = 'All' OR branch = 'ZA-DW') Value = 1 Date to be checked against = 2022-04-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-04-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-04-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 1 Date to be checked against = 2022-05-03 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-03' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-04 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-04' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-05 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-05' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-06 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-06' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-09 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-09' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-10 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-10' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-11 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-11' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-12 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-12' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-13 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-13' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-16 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-16' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-17 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-17' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-18 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-18' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-19 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-19' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-20 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-20' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-23 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-23' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-24 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-24' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-25 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-25' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-26 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-26' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-27 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-27' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-30 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-30' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-05-31 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-05-31' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-06 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-06' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-07 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-07' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-09 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-09' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-10 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-10' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-04 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-04' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-04 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-04' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-04 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-04' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-05 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-05' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-06 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-06' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-07 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-07' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-08 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-08' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-11 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-11' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-12 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-12' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-13 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-13' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-14 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-14' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-18 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-18' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-19 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-19' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-20 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-20' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-21 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-21' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-22 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-22' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-25 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-25' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-26 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-26' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-27 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-27' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-28 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-28' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-07-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-07-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-01 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-01' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-02 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-02' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-13 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-13' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-14 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-14' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-29 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-29' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-23 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-23' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-24 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-24' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-17 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-17' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-06-24 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-06-24' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-15 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-15' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-16 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-16' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-17 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-17' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-10 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-10' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-11 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-11' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-18 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-18' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-05 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-05' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-19 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-19' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-12 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-12' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-26 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-26' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0 Date to be checked against = 2022-08-24 the SQL is SELECT COUNT(olid) FROM OLBlockedDates WHERE blockedDate = '2022-08-24' AND (branch = 'All' OR branch = 'ZA-DW') Value = 0