SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUboyd'
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.3243088722229
Aftermath of Seattle fire of June 6, 1889, looking north at the ruins of the Seattle Lake Shore and Eastern Railway Company tracks, Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking south showing ruins in the vicinity of the waterfront area, Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking south showing the ruins of the downtown area, Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking southwest toward the harbor, Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking west from 1st Ave. between Columbia and Cherry Streets, Washington.
|
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 2nd Ave. and Columbia St., Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking west from between Columbia St. and Cherry St. Washington.
|
Aftermath of Seattle fire of June 6, 1889, looking west on Yesler Way, Washington.
|
Aftermath of Seattle fire of June 6, 1889, showing bread line at the tent of the Tacoma Relief Bureau in vicinity of 3rd Ave. near Union St., Washington.
|
Aftermath of Seattle fire of June 6, 1889, showing bread line leading to tent of Tacoma Relief Bureau in vicinity of 3rd Ave. near Union St., Seattle, Washington.
|
Aftermath of Seattle fire of June 6, 1889, showing devastated section of the city, Washington.
|
1 |2 |3 |4 |5 |6 |7 |8 |
|
|
