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
    [animate] => 1
    [postTitleLength] => 
    [showPostCount] => 1
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [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' 
    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_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND 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] => 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
        )

    [1] => 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
        )

    [2] => 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
        )

    [3] => 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
        )

    [4] => 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
        )

)

• • December, 2011 (2) ▶
  • November, 2011 (2) ▶
  • October, 2011 (1) ▶