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
Nombre de dossiers trouvés: 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
Nouvelle recherche
Édifices Canada
A.C. 101
Quiz
Vue d'ensemble
Glossaire
Recherche générale