Apollo String Quartet Glasgow

News Archives

MySQL server version: 5.0.77

collapsArch options:
Array
(
    [title] => News Archives
    [noTitle] => 
    [inExcludeCat] => include
    [inExcludeCats] => string-quartet-latest-news
    [inExcludeYear] => 
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 4
    [showPostDate] => 
    [useCookies] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [animate] => 1
    [postTitleLength] => 
    [MTversion] => 12
    [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'  AND wp_terms.slug IN ('string-quartet-latest-news') 
	GROUP BY wp_posts.ID 
	ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => string-quartet-latest-news
            [ID] => 600
            [post_name] => were-going-wedding-show-tastic-this-february
            [post_title] => We're going Wedding Show-tastic this February
            [post_author] => 1
            [post_date] => 2012-01-28 10:04:12
            [year] => 2012
            [month] => 1
        )

    [1] => stdClass Object
        (
            [slug] => string-quartet-latest-news
            [ID] => 593
            [post_name] => brilliant-day-at-the-gg-wedding-fayre
            [post_title] => We had a Brilliant day at the Glasgow Girls Wedding Fayre
            [post_author] => 2
            [post_date] => 2012-01-24 15:14:54
            [year] => 2012
            [month] => 1
        )

    [2] => stdClass Object
        (
            [slug] => string-quartet-latest-news
            [ID] => 251
            [post_name] => we-have-a-shiny-new-website
            [post_title] => Yay! We have a shiny new website!
            [post_author] => 1
            [post_date] => 2012-01-18 22:33:07
            [year] => 2012
            [month] => 1
        )

    [3] => stdClass Object
        (
            [slug] => string-quartet-latest-news
            [ID] => 256
            [post_name] => glasgow-girls-wedding-fayre
            [post_title] => We'll be at The Glasgow Girls Wedding Fayre
            [post_author] => 1
            [post_date] => 2012-01-17 16:50:45
            [year] => 2012
            [month] => 1
        )

)

• 2012 (4)
• • January (4)
  • • We're going Wedding Show-tastic this February
    • We had a Brilliant day at the Glasgow Girls Wedding Fayre
    • Yay! We have a shiny new website!
    • We'll be at The Glasgow Girls Wedding Fayre