Bland information request result

select * from bland_slides_info where (province like '%NB%') AND (type like '%view%') AND bland_slides_date >= 0 and end_date <= 9999 order by title

Number of matched records: 7

Charlotte Street Saint John NB View	Duke Street Saint John NB View	Germain Street Saint John NB View	Market Square Saint John NB Commercial and View
North Wharf Saint John NB View	View of Dock Street Saint John NB View	View of Mount Pleasant Saint John NB circa 1920s View


Building Canada	C.A. 101	Pop Quiz	Overview	Glossary	General search