SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUindocc'
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.30358910560608
A.L. Clark Paving Co. on muddy road, location unknown, n.d.
|
Agricultural workers in flax field, Whatcom County, Washington, 1893
|
Alaska Packers Association hatchery interior, Karluk, Alaska, ca. 1920
|
Alcan Aluminum Corporation plant interior, Kemano, British Columbia, n.d.
|
Alcoa aluminum plant, Wenatchee, Washington, n.d.
|
Aloha Lumber Co. mill, Aloha, Washington, ca. 1916
|
Aloha Lumber Co. shingle mill interior, Aloha, Washington, n.d.
|
Alpine Lumber Co. mill and workers, Alpine, Washington, 1925
|
Automobile garage interior, unidentified location, n.d.
|
Barge unloading oyster shells in Oyster Bay, Washington, n.d.
|
Beaver pelts, Tsimshian fur trader camp, British Columbia, n.d.
|
Beaver skin on stretcher, Tsimshian fur trader camp, British Columbia, n.d.
|
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 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |
|
|
