SQL Statement is: SELECT DISTINCT daMASTER.OBJECT_KEY, daMASTER.OBJECT_ID, clicker.clicks, THUMBNAIL_FILE, COLLECTION, DIMENSIONS, DEPARTMENT, ARTIST, TITLE, DATES, TYPE, MEDIUM, CREDIT_LINE, MANUFACTURER, MANUFACTURERDATES, ARTISTDATES, COUNTRY, OBJECT_COUNT, IF (search1 = exterm, .1, IF (search2 = exterm, .2, IF (search3 = exterm, .3, IF (search4 = exterm, .4, IF (search5 = exterm, .5, IF (search1 like daterm,1, IF (search2 like daterm, 2, IF (search3 like daterm,3, IF (search4 like daterm,4, IF (search5 like daterm,5, 10)))))))))) as rank, IF (ISNULL(DATE_MIN), DATE_MIN1, DATE_MIN) as MIN, IF (ISNULL(DATE_MAX), DATE_MAX1, DATE_MAX) as MAX, OBJDESCR From daMASTER, clicker, audiofile LEFT JOIN manufacturer ON daMASTER.OBJECT_KEY = manufacturer.OBJECT_KEY LEFT JOIN superfields ON daMASTER.OBJECT_KEY = superfields.OBJECT_KEY WHERE (TYPE like '%OVERVIEW%') AND ((OBJECT_COUNT >0) or OBJECT_COUNT IS NULL) AND clicker.objectID = daMASTER.OBJECT_ID AND clicks > 21
Search Parameters are:
The Chrysler Museum of Art - Web Gallery
| Top 20 Most Viewed Objects |
 More Details
|
Bonifazio de' Pitati Italian (1487-1553)
Lot and His Daughters
,
ca. 1545
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 71.622
|
 More Details
|
Marx Reichlich German (active ca. 1485-1520)
Last Judgment
,
ca. 1490
Tempura | Oil on panel
Gift of Walter P. Chrysler, Jr.
Object ID: 71.3098
|
 More Details
|
Thomas Cole American | English (1801-1848)
The Angel Appearing to the Shepherds
,
1833-1834
Oil on canvas
Gift of Walter P. Chrysler, Jr. in memory of Edgar...more
Object ID: 80.30
|
 More Details
|
Paul Gauguin French (1848-1903)
The Loss of Virginity
,
1890-1891
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 71.510
|
 More Details
|
Pierre Auguste Renoir French (1841-1919)
The Daughters of Durand-Ruel
,
1882
Oil on canvas
Gift of Walter P. Chrysler, Jr. in memory of Thelm...more
Object ID: 71.518
|
 More Details
|
Franz Kline American (1910-1962)
Hot Jazz (Bleecker Street Tavern Mural)
,
1940
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 71.1077
|
 More Details
|
Edward Hopper American (1882-1967)
New York Pavements
,
1924 or 1925
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 83.591
|
 More Details
|
Edward Hicks American (1780-1849)
The Declaration of Independence
,
ca. 1840-45
Oil on canvas
Gift of Edgar William and Bernice Chrysler Garbisc...more
Object ID: 76.53.1
|
 More Details
|
Mary Cassatt American (1844-1926)
The Family
,
1893
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 71.498
|
 More Details
|
Frederick Childe Hassam American (1859-1935)
At the Florist
,
1889
Oil on canvas
Gift of Walter P. Chrysler, Jr. This work of art ...more
Object ID: 71.500
|
 More Details
|
Tom Wesselmann American (1931-2004)
Bedroom Painting #15
,
1968-70
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 77.420
|
 More Details
|
Asher B. Durand American (1796-1886)
God's Judgment Upon Gog
,
ca. 1851-1852
Oil on canvas
Gift of Walter P. Chrysler, Jr.
Object ID: 71.499
|
 More Details
|
Thomas Hart Benton American (1889-1975)
The Arts of Life in America: Unemployment, Radical Protest, Speed
,
1932
Tempera on board
Gift of Walter P. Chrysler, Jr.
Object ID: 71.2011
|
 More Details
|
Charles Willson Peale American (1741-1827)
Mrs. John O'Donnell (Sarah Chew Elliott)
,
1787
Oil on canvas
Gift of Mrs. Frank Batten
Object ID: 62.94.1
|
 More Details
|
Giovanni Francesco Barbieri, called Guercino Italian (1591-1666)
Samson Bringing Honey To His Parents
,
ca. 1625-1626
Oil on canvas
Gift of Walter P. Chrysler, Jr., in honor of the B...more
Object ID: 71.521
|
 More Details
|
Tiffany Studios
Portrait of a Woman in a Pergola with Wisteria
,
ca. 1915
Stained glass | Leaded glass
Gift of Walter P. Chrysler, Jr.
Object ID: 78.477
|
 More Details
|
Jan Gossaert | Mabuse Flemish (1478-1532)
Madonna and Child
,
ca. 1525-1530
Oil on panel
Gift of Walter P. Chrysler, Jr.
Object ID: 71.491
|
 More Details
|
William Merritt Chase American (1849-1916)
An Italian Garden
,
ca. 1909
Oil on canvas
Gift of Edward J. Brickhouse
Object ID: 59.79.1
|
 More Details
|
Hale Aspacio Woodruff American (1900-1980)
Battle of Lake Erie
,
ca. 1934
Tempera | Masonite
Gift of Mr. A. Ailon
Object ID: 83.593
|
 More Details
|
Daniel Chester French American (1850-1931)
The Spirit of Life
,
modeled 1914
Bronze
Gift of The Imperial Recreation Club for Men of th...more
Object ID: 26.4.1
|
| | | | | | |
|