SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUlaroche'
AND M_TITLE.m_title != '
'
AND M_TITLE.bsearch=0
AND M_TITLE.bdisplay=0
GROUP BY M_TITLE.id
ORDER BY M_TITLE.m_title limit 0,12
elapsed time: 0.30576992034912
1st Ave. from James St., Seattle, Washington, ca. 1891.
|
1st Ave. from James St., Seattle, Washington, ca. 1892.
|
2nd Ave. from Yesler Way, Seattle, Washington, ca. 1891.
|
2nd Ave. from Yesler Way, Seattle, Washington, ca.1891.
|
2nd Avenue from Cherry Street after the fire of June 6, 1889, Seattle, Washington, and two years later.
|
Actresses fording Dyea River on the Chilkoot Trail, Alaska, 1897.
|
Actresses on the Chilkoot Trail at Happy Camp, British Columbia, 1897
|
Angeline, daughter of Chief Seattle, ca. 1893.
|
Angeline, daughter of Chief Seattle, ca. 1893.
|
Arthur A. Denny cabin in ruins at Alki Point, West Seattle, n.d.
|
Bailey Block, southwest corner of 2nd Ave. and Cherry St., Seattle, Washington, ca. 1891.
|
Baranov Castle, Sitka, Alaska, ca. 1897.
|
1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |
|
|
