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 ) )