SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUboydBraas'
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.31157088279724
Aftermath of Seattle fire of June 6, 1889, looking west from 2nd Ave. and Cherry St., Seattle, Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking west from between Columbia St. and Cherry St. Washington.
|
Aftermath of the fire of June 6, 1889, showing the ruins of the Occidental Hotel, corner of James St. and Yesler Way, Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, looking north on 1st Ave. S. at Yesler toward the ruins of the Yesler-Leary Building, Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, looking northwest showing the ruins of the Occidental Hotel, corner of James St. and Yesler Way, Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, looking west on Main St., Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, showing the ruins of buildings along 1st Ave. from Columbia to Yesler, Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, showing the ruins of Frye's Opera House, Seattle, Washington.
|
Aftermath of the fire of June 6, 1889, showing view from the waterfront, Seattle, Washington.
|
Angeline, daughter of Chief Seattle, probably Seattle, Washington, ca. 1890
|
Butler Block, 2nd Ave. northwest corner of James St., Seattle, Washington, ca. 1891.
|
Fire fighters battling the fire at the Schwabacher Brothers' building, Seattle, Washington, June 27, 1892.
|
1 |2 |3 |4 |
|
|
