MySQL server version: 5.5.8
collapsArch options:
Array
(
[title] => archive
[noTitle] =>
[inExcludeCat] => exclude
[inExcludeCats] =>
[inExcludeYear] =>
[inExcludeYears] =>
[showPages] =>
[sort] => DESC
[linkToArch] =>
[showYearCount] => 1
[expandCurrentYear] => 1
[expandMonths] => 1
[expandYears] => 1
[expandCurrentMonth] => 1
[showMonthCount] => 1
[showPostTitle] => 1
[expand] => 0
[showPostDate] => 1
[debug] => 1
[postDateFormat] =>
[postDateAppend] => after
[accordion] => 0
[useCookies] => 1
[post_type] => post
[taxoncmy] => category
[postTitleLength] =>
[showPostCount] => 1
[archSortOrder] => DESC
[showPosts] =>
[customExpand] =>
[customCollapse] =>
[animate] => 1
[number] => 3
)
POST QUERY:
SELECT wp_terms.slug, wp_posts.ID,
wp_posts.post_name, wp_posts.post_title, wp_posts.post_author,
wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
MONTH(wp_posts.post_date) AS 'month' ,
wp_posts.post_type
FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
wp_term_relationships.object_id
LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
wp_term_relationships.term_taxonomy_id
LEFT JOIN wp_terms ON wp_terms.term_id =
wp_term_taxonomy.term_id
WHERE post_status='publish' AND wp_posts.post_type='post'
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
POST QUERY RESULTS
Array
(
[0] => stdClass Object
(
[slug] => uncategorized
[ID] => 540
[post_name] => theaster-gates-at-the-cincinnati-art-museum
[post_title] => Theaster Gates at the Cincinnati Art Museum
[post_author] => 1
[post_date] => 2013-05-07 04:47:53
[year] => 2013
[month] => 5
[post_type] => post
)
[1] => stdClass Object
(
[slug] => uncategorized
[ID] => 536
[post_name] => video-articulate-lecture-series-casey-riordan-millard
[post_title] => VIDEO – ARTiculate Lecture Series, Casey Riordan Millard
[post_author] => 1
[post_date] => 2013-04-03 22:00:26
[year] => 2013
[month] => 4
[post_type] => post
)
[2] => stdClass Object
(
[slug] => uncategorized
[ID] => 516
[post_name] => doug-and-mike-starn-gravity-of-light
[post_title] => Doug and Mike Starn: Gravity of Light
[post_author] => 1
[post_date] => 2012-10-05 06:24:29
[year] => 2012
[month] => 10
[post_type] => post
)
[3] => stdClass Object
(
[slug] => uncategorized
[ID] => 506
[post_name] => hello-art-lovers
[post_title] => Hello Art Lovers
[post_author] => 1
[post_date] => 2012-08-24 19:24:03
[year] => 2012
[month] => 8
[post_type] => post
)
[4] => stdClass Object
(
[slug] => uncategorized
[ID] => 495
[post_name] => one-bite-at-a-time-is-fine
[post_title] => One Bite At A Time Is Fine
[post_author] => 1
[post_date] => 2012-06-18 18:34:27
[year] => 2012
[month] => 6
[post_type] => post
)
[5] => stdClass Object
(
[slug] => uncategorized
[ID] => 490
[post_name] => words-from-the-director
[post_title] => Words From the Director
[post_author] => 1
[post_date] => 2012-06-18 15:13:41
[year] => 2012
[month] => 6
[post_type] => post
)
[6] => stdClass Object
(
[slug] => uncategorized
[ID] => 479
[post_name] => school-is-out-summer-is-here
[post_title] => School is Out & Summer is Here
[post_author] => 1
[post_date] => 2012-06-14 02:58:19
[year] => 2012
[month] => 6
[post_type] => post
)
[7] => stdClass Object
(
[slug] => uncategorized
[ID] => 469
[post_name] => how-many-pieces-of-glass
[post_title] => How Many Pieces of Glass?
[post_author] => 1
[post_date] => 2012-05-02 13:07:29
[year] => 2012
[month] => 5
[post_type] => post
)
[8] => stdClass Object
(
[slug] => uncategorized
[ID] => 454
[post_name] => conservation-eternal-summer-the-art-of-edward-henry-potthast
[post_title] => Conservation - Eternal Summer
[post_author] => 1
[post_date] => 2012-04-19 12:38:51
[year] => 2012
[month] => 4
[post_type] => post
)
[9] => stdClass Object
(
[slug] => uncategorized
[ID] => 447
[post_name] => how-do-you-show-art
[post_title] => How Do You Show Art?
[post_author] => 1
[post_date] => 2011-12-22 03:23:48
[year] => 2011
[month] => 12
[post_type] => post
)
[10] => stdClass Object
(
[slug] => uncategorized
[ID] => 425
[post_name] => cincinnati-art-museum%e2%80%93family-blog
[post_title] => Cincinnati Art Museum–Family Blog
[post_author] => 1
[post_date] => 2011-12-19 15:07:31
[year] => 2011
[month] => 12
[post_type] => post
)
[11] => stdClass Object
(
[slug] => uncategorized
[ID] => 403
[post_name] => schmidlapp-gallery
[post_title] => Schmidlapp Gallery
[post_author] => 1
[post_date] => 2011-11-15 06:35:01
[year] => 2011
[month] => 11
[post_type] => post
)
[12] => stdClass Object
(
[slug] => uncategorized
[ID] => 360
[post_name] => art-museum-of-the-22nd-century
[post_title] => Art Museum of the 22nd Century
[post_author] => 1
[post_date] => 2011-11-02 21:20:43
[year] => 2011
[month] => 11
[post_type] => post
)
[13] => stdClass Object
(
[slug] => uncategorized
[ID] => 307
[post_name] => welcome
[post_title] => Welcome
[post_author] => 1
[post_date] => 2011-10-13 14:21:01
[year] => 2011
[month] => 10
[post_type] => post
)
)
May 12, 2012 four Tiffany Studios stained glass windows will go on permanent display at the Cincinnati Art Museum. A recent acquisition, the windows have been undergoing conservation for the last year. Tiffany developed a technique called plating where numerous …
May 21, 2013
Museum Shop : 11 am - 5 pm
Terrace Café : 11 am - 3 pm
Library : 12 pm - 4:45 pm
53 Eden Park Drive
Cincinnati, Ohio 45202
Tickets: (513) 721-ARTS (2787)
Toll Free: 1 (877) 472-4226
© 2011 Cincinnati Art Museum