SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUhester'
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.0013108253479004
2nd Ave. from the corner of Kester Ave., Nome, Alaska, ca.1900.
|
Bathing room in the five-masted schooner H.K. HALL, Puget Sound, Washington, ca. 1904.
|
Battleship USS IOWA on drydock, Puget Sound port, Washington, ca. 1904.
|
Billiard Room at the Pleasant Beach Hotel, Bainbridge Island, Washington, ca. 1898.
|
Boats, men and supplies on the beach at Port Clarence, Alaska, ca. 1900.
|
Bowling alley at the Pleasant Beach Hotel, Bainbridge Island, ca. 1898.
|
British four-masted bark SAMARITAN at anchor, Commencement Bay, Washington, ca. 1904.
|
Buildings, tents, and boats along the Snake River, Nome, Alaska, ca. 1900.
|
Cabin aboard the four-masted British bark LYNTON, Puget Sound, Washington, ca. 1904.
|
Cabin on the bark BALMORAL, Washington, ca. 1904.
|
Capt. Alex Teschner beside the wheel of the three-masted German bark PERA, Port Blakely, Washington, 1901.
|
Capt. C.H. Jensen and his dog on the deck of the sailing vessel ALSTERKAMP, Puget Sound port, Washington, ca. 1904.
|
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 |
|
|
