archive

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
        )

)

• ▼2013 (2)
  • ▼May (1)
    • Theaster Gates at the Cincinnati Art Museum
  • ►April (1)
• ►2012 (7)
  • ►October (1)
  • ►August (1)
  • ►June (3)
  • ►May (1)
  • ►April (1)
• ►2011 (5)
  • ►December (2)
  • ►November (2)
  • ►October (1)