select * from bland_slides_info where (province like '%SK%') AND (type like '%commercial%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Number of matched records: 2
Birk's Building
Saskatoon SK
Percy Nobbs
1929
commercial
Canadian Bank of Commerce
Regina SK
Darling and Pearson
1900
commercial
New Search
Building Canada
C.A. 101
Pop Quiz
Overview
Glossary
General search