MySQL server version: 5.1.60-community-log

collapsArch options:
Array
(
    [title] => Blog Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => 
    [inExcludeYears] => 2011, 2010, 2009
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 
    [expandCurrentYear] => 1
    [expandMonths] => 
    [expandYears] => 1
    [expandCurrentMonth] => 
    [showMonthCount] => 
    [showPostTitle] => 1
    [expand] => 0
    [showPostDate] => 
    [useCookies] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [animate] => 0
    [postTitleLength] => 
    [MTversion] => 12
    [showPostCount] => 
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 0
    [customCollapse] => 0
    [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] => real-estate
            [ID] => 2125
            [post_name] => government-announces-new-hstpst-housing-transitional-rules
            [post_title] => Government announces new HST/PST housing transitional rules
            [post_author] => 1
            [post_date] => 2012-02-21 10:10:20
            [year] => 2012
            [month] => 2
        )

    [1] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2052
            [post_name] => the-home-owner-grant-threshold-keeps-pace-with-assessments
            [post_title] => The Home Owner Grant threshold keeps pace with assessments
            [post_author] => 1
            [post_date] => 2012-02-10 11:00:23
            [year] => 2012
            [month] => 2
        )

    [2] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2047
            [post_name] => selection-broadens-and-demand-eases-to-kick-off-2012-in-the-greater-vancouver-housing-market
            [post_title] => Selection broadens and demand eases to kick off 2012 in the Greater Vancouver housing market 
            [post_author] => 1
            [post_date] => 2012-02-09 11:55:40
            [year] => 2012
            [month] => 2
        )

    [3] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1989
            [post_name] => top-26-grants-and-rebates-for-property-buyers-and-owners
            [post_title] => Top 26 Grants and Rebates for Property Buyers and Owners
            [post_author] => 1
            [post_date] => 2012-02-02 10:54:51
            [year] => 2012
            [month] => 2
        )

    [4] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1967
            [post_name] => assessment-notices-%e2%80%93-a-wake-up-call-for-property-owners
            [post_title] => Assessment notices – a wake-up call for property owners
            [post_author] => 1
            [post_date] => 2012-01-31 09:42:37
            [year] => 2012
            [month] => 1
        )

    [5] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1954
            [post_name] => what-is-the-property-transfer-tax
            [post_title] => What is the Property Transfer Tax?
            [post_author] => 1
            [post_date] => 2012-01-26 15:27:10
            [year] => 2012
            [month] => 1
        )

    [6] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1949
            [post_name] => richmond-outlook
            [post_title] => Richmond Outlook
            [post_author] => 1
            [post_date] => 2012-01-23 17:05:53
            [year] => 2012
            [month] => 1
        )

    [7] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1906
            [post_name] => balanced-real-estate-market-prevailed-through-much-of-2011
            [post_title] => Balanced real estate market prevailed through much of 2011
            [post_author] => 1
            [post_date] => 2012-01-04 16:30:28
            [year] => 2012
            [month] => 1
        )

    [8] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1891
            [post_name] => richmond-apartment-for-sale-%e2%80%93-south-arm1-bedroom-apartment-for-sale-richmond-bc-real-estate
            [post_title] => Richmond Apartment for Sale – South Arm1 Bedroom Apartment for Sale - Richmond BC Real Estate
            [post_author] => 1
            [post_date] => 2011-12-22 10:54:17
            [year] => 2011
            [month] => 12
        )

    [9] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1877
            [post_name] => richmond-condos-for-sale-%e2%80%93-steveston-1-bedroom-condo-for-sale-%e2%80%93-richmond-bc-real-estate
            [post_title] => Richmond Condos for Sale – Steveston 1 Bedroom Condo for Sale in Richmond BC
            [post_author] => 1
            [post_date] => 2011-12-21 10:31:23
            [year] => 2011
            [month] => 12
        )

    [10] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1874
            [post_name] => richmond-condos-for-sale-%e2%80%93-brighouse-1-bedroom-condos-for-sale-richmond-bc-real-estate
            [post_title] => Richmond Condos for Sale – Brighouse 1 Bedroom Condos for Sale in Richmond BC
            [post_author] => 1
            [post_date] => 2011-12-20 13:48:03
            [year] => 2011
            [month] => 12
        )

    [11] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1822
            [post_name] => richmond-bc-house-for-sale
            [post_title] => Richmond BC House for Sale - Westwind 4 Bedroom House for Sale in Richmond BC
            [post_author] => 1
            [post_date] => 2011-12-15 10:10:37
            [year] => 2011
            [month] => 12
        )

    [12] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1799
            [post_name] => richmond-bc-condos-for-sale
            [post_title] => Richmond BC Condos for Sale - Central 2 Bedroom Condos for Sale in Richmond BC
            [post_author] => 1
            [post_date] => 2011-12-13 15:32:26
            [year] => 2011
            [month] => 12
        )

    [13] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1792
            [post_name] => richmond-bc-townhouse-for-sale
            [post_title] => Richmond BC Townhouse for Sale - Steveston 3 Bedroom Townhouse for Sale in Richmond BC
            [post_author] => 1
            [post_date] => 2011-12-13 15:10:07
            [year] => 2011
            [month] => 12
        )

    [14] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1767
            [post_name] => historically-normal-activity-keeps-the-greater-vancouver-housing-market-in-a-balanced-state
            [post_title] => Historically normal activity keeps the Greater Vancouver housing market in a balanced state 
            [post_author] => 1
            [post_date] => 2011-12-05 16:46:09
            [year] => 2011
            [month] => 12
        )

    [15] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1746
            [post_name] => free-movie-day
            [post_title] => FREE MOVIE DAY
            [post_author] => 1
            [post_date] => 2011-11-21 09:53:02
            [year] => 2011
            [month] => 11
        )

    [16] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1660
            [post_name] => renewing-and-refinancing-mortgages-is-saving-canadians
            [post_title] => Renewing and refinancing mortgages is saving Canadians
            [post_author] => 1
            [post_date] => 2011-11-14 11:40:52
            [year] => 2011
            [month] => 11
        )

    [17] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1632
            [post_name] => greater-vancouver-at-lower-end-of-balanced-housing-market
            [post_title] => Greater Vancouver at lower end of balanced housing market 
            [post_author] => 1
            [post_date] => 2011-11-07 10:04:34
            [year] => 2011
            [month] => 11
        )

    [18] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 1580
            [post_name] => bank-of-canada-interest-rate
            [post_title] => Bank of Canada Interest Rate 
            [post_author] => 1
            [post_date] => 2011-10-25 14:25:28
            [year] => 2011
            [month] => 10
        )

    [19] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1546
            [post_name] => home-listings-continue-to-rise-in-the-greater-vancouver-housing-market
            [post_title] => Home listings continue to rise in the Greater Vancouver housing market 
            [post_author] => 1
            [post_date] => 2011-10-05 14:21:02
            [year] => 2011
            [month] => 10
        )

    [20] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1469
            [post_name] => 1469
            [post_title] => Greater Vancouver home sales trend toward buyers’ market over summer 
            [post_author] => 1
            [post_date] => 2011-09-13 13:52:12
            [year] => 2011
            [month] => 9
        )

    [21] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1318
            [post_name] => greater-selection-in-the-vancouver-housing-market
            [post_title] => Greater selection in the Vancouver housing market 
            [post_author] => 1
            [post_date] => 2011-08-04 12:12:07
            [year] => 2011
            [month] => 8
        )

    [22] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1321
            [post_name] => housing-market-trends-toward-balance
            [post_title] => Housing market trends toward balance
            [post_author] => 1
            [post_date] => 2011-07-04 12:15:01
            [year] => 2011
            [month] => 7
        )

    [23] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1219
            [post_name] => greater-vancouver-housing-market-holds-steady
            [post_title] => Greater Vancouver Market Holds Steady
            [post_author] => 1
            [post_date] => 2011-06-14 11:07:00
            [year] => 2011
            [month] => 6
        )

    [24] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 1144
            [post_name] => greater-vancouver-housing-market-sees-typical-spring-activity-in-april
            [post_title] => Market Sees Typical Spring Activity
            [post_author] => 1
            [post_date] => 2011-05-03 23:06:30
            [year] => 2011
            [month] => 5
        )

    [25] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 915
            [post_name] => market-at-near-record-pace-in-march
            [post_title] => Market at Near Record Pace in March
            [post_author] => 1
            [post_date] => 2011-04-05 10:48:23
            [year] => 2011
            [month] => 4
        )

    [26] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 848
            [post_name] => real-estate-board-of-greater-vancouver-reports-increased-housing-demand-in-february
            [post_title] => Increased Housing Demand in February
            [post_author] => 1
            [post_date] => 2011-03-20 21:37:23
            [year] => 2011
            [month] => 3
        )

    [27] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 760
            [post_name] => stability-and-regional-%e2%80%98hot-spots%e2%80%99-characterize-january-housing-market
            [post_title] => Stability & Regional ‘Hot Spots’ 
            [post_author] => 1
            [post_date] => 2011-02-08 12:47:30
            [year] => 2011
            [month] => 2
        )

    [28] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 746
            [post_name] => real-estate-market-stable-at-year-end
            [post_title] => Real Estate Market Stable 
            [post_author] => 1
            [post_date] => 2011-01-13 21:40:56
            [year] => 2011
            [month] => 1
        )

    [29] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 736
            [post_name] => mls%c2%ae-stats-show-more-sales-fewer-property-listings-in-november
            [post_title] => MLS® Stats in November
            [post_author] => 1
            [post_date] => 2010-12-06 15:52:32
            [year] => 2010
            [month] => 12
        )

    [30] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 673
            [post_name] => home-sales-remain-steady-in-greater-vancouver
            [post_title] => Home Sales Remain Steady
            [post_author] => 1
            [post_date] => 2010-11-07 17:52:14
            [year] => 2010
            [month] => 11
        )

    [31] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 586
            [post_name] => hello-world-2
            [post_title] => Housing Market Factors
            [post_author] => 2
            [post_date] => 2010-10-04 01:59:56
            [year] => 2010
            [month] => 10
        )

    [32] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 166
            [post_name] => buyer%e2%80%99s-market-conditions
            [post_title] => Buyer’s Market Conditions
            [post_author] => 2
            [post_date] => 2010-09-08 01:49:36
            [year] => 2010
            [month] => 9
        )

    [33] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 361
            [post_name] => buyers-sellers-less-active
            [post_title] => Buyers & Sellers Less Active
            [post_author] => 2
            [post_date] => 2010-08-10 23:02:09
            [year] => 2010
            [month] => 8
        )

    [34] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 364
            [post_name] => bc-market
            [post_title] => BC Real Estate Market
            [post_author] => 2
            [post_date] => 2010-08-02 20:49:27
            [year] => 2010
            [month] => 8
        )

    [35] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 368
            [post_name] => 368
            [post_title] => Activity Steady
            [post_author] => 2
            [post_date] => 2010-07-06 20:16:47
            [year] => 2010
            [month] => 7
        )

    [36] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 377
            [post_name] => 377
            [post_title] => Forget Market Timing
            [post_author] => 2
            [post_date] => 2010-06-09 08:33:44
            [year] => 2010
            [month] => 6
        )

    [37] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 375
            [post_name] => may-market
            [post_title] => May Market
            [post_author] => 2
            [post_date] => 2010-06-09 08:12:26
            [year] => 2010
            [month] => 6
        )

    [38] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 381
            [post_name] => busy-spring-market
            [post_title] => Busy Spring Market
            [post_author] => 2
            [post_date] => 2010-05-12 12:54:40
            [year] => 2010
            [month] => 5
        )

    [39] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 386
            [post_name] => home-listings-rise
            [post_title] => Home Listings Rise
            [post_author] => 2
            [post_date] => 2010-04-07 13:12:45
            [year] => 2010
            [month] => 4
        )

    [40] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 384
            [post_name] => home-sales-activity
            [post_title] => Home Sales Activity
            [post_author] => 2
            [post_date] => 2010-04-07 13:08:18
            [year] => 2010
            [month] => 4
        )

    [41] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 391
            [post_name] => 391
            [post_title] => Feds Change Borrowing Requirements
            [post_author] => 2
            [post_date] => 2010-02-17 20:25:00
            [year] => 2010
            [month] => 2
        )

    [42] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 388
            [post_name] => housing-supply-demand
            [post_title] => Housing Supply & Demand
            [post_author] => 2
            [post_date] => 2010-02-05 21:48:31
            [year] => 2010
            [month] => 2
        )

    [43] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 402
            [post_name] => some-facts-about-richmond
            [post_title] => Some Facts About Richmond
            [post_author] => 2
            [post_date] => 2010-01-17 14:52:13
            [year] => 2010
            [month] => 1
        )

    [44] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 399
            [post_name] => 399
            [post_title] => Richmond Private Dwellings
            [post_author] => 2
            [post_date] => 2010-01-16 20:11:38
            [year] => 2010
            [month] => 1
        )

    [45] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 396
            [post_name] => 396
            [post_title] => Slow Start, Strong Finish
            [post_author] => 2
            [post_date] => 2010-01-05 16:41:19
            [year] => 2010
            [month] => 1
        )

    [46] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 412
            [post_name] => 2009-archives
            [post_title] => Richmond Market Overview
            [post_author] => 2
            [post_date] => 2009-12-31 12:30:26
            [year] => 2009
            [month] => 12
        )

)