select * from bland_slides_info where (province like '%NB%') AND (type like '%commercial%') AND bland_slides_date >= 0 and end_date <= 9999 order by title
Nombre de dossiers trouvés: 5
Log Barn
King's Landing NB
commercial
MacDonald Farm
Bartibog NB
Alexander Macdonald
1815 - 1820
Commercial
Market Square
Saint John NB
Commercial and View
Mill
King's Landing NB
Commercial
Royal Hotel
Saint John NB
Commercial
Nouvelle recherche
Édifices Canada
A.C. 101
Quiz
Vue d'ensemble
Glossaire
Recherche générale