SELECT M_TITLE.id, M_TITLE.m_title, M_TITLE.bdisplay, M_TITLE.t_type
FROM M_TITLE
WHERE M_TITLE.id REGEXP '[[:<:]]WAUUcostumehist'
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.0012588500976562
Afternoon and evening dresses, 1827
|
Afternoon dress, 1913
|
Afternoon dress, 1913
|
Afternoon dress, 1914
|
Autumn hats, 1912
|
Ball and opera dresses, 1827
|
Ball dress, 1809
|
Ball dress, 1818
|
Ball dresses, ca. 1865
|
Ball gowns, 1865
|
Bathing costume, 1912
|
Bathing suit, 1913
|
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 |
|
|
