SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUcurtis'
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.30216383934021

"C.K. Hamilton taking the machine out for a flight at The Meadows, Seattle, March 11, 1910."
|

"Disappointed gold seekers selling their outfits along the Dawson waterfront," Yukon Territory.
|

"Dome" roadhouse, Yukon Territory.
|

"Mucking thawed ground in a drift on 16 Eldorado," underground mining shaft in Yukon Territory.
|

"Nugget Express," Dawson, Yukon Territory.
|

"Oldest house in the state," Thurston County.
|

"Seeing Seattle" streetcar of Seattle Electric Co., Woodland Park, Seattle.
|

"World Flyers" at Sand Point Naval Air Station, being congratulated by Major Frederick L. Martin on the completion of the first successful flight around the world.
|

10-foot section of Douglas fir log, completely fossilized. at Ginkgo State Park near Vantage.
|

1st Ave. from Cherry St., Seattle, 1874.
|

1st Ave. from Columbia St. after Seattle fire of June 6, 1889.
|

1st Ave. from Columbia St., Seattle.
|
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 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96 |97 |98 |99 |100 |101 |102 |103 |104 |105 |106 |107 |108 |109 |110 |111 |112 |113 |114 |115 |116 |117 |118 |119 |120 |121 |122 |123 |124 |125 |126 |127 |128 |129 |130 |131 |132 |133 |134 |135 |136 |137 |138 |139 |140 |141 |142 |
|
|