select * from bland_slides_info where ((province like '%BC%') OR (province like '%AB%') OR (province like '%SK%') OR (province like '%MB%') OR (province like '%ON%') OR (province like '%QC%') OR (province like '%NB%') OR (province like '%NS%') OR (province like '%PEI%') OR (province like '%NF%')) AND (type like '%View%') AND bland_slides_date >= 0 and end_date <= 9999 order by title