MySQL server version: 5.5.31-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] => 4857
            [post_name] => spring-delivers-greater-balance-to-greater-vancouver-housing-market
            [post_title] => Spring delivers greater balance to Greater Vancouver housing market
            [post_author] => 1
            [post_date] => 2013-05-12 23:34:42
            [year] => 2013
            [month] => 5
        )

    [1] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4854
            [post_name] => saying-good-bye-to-nasty-neighbours-new-community-safety-act-takes-aim-at-problem-properties
            [post_title] => Saying Good-bye to Nasty Neighbours—New Community Safety Act  takes aim at problem properties
            [post_author] => 1
            [post_date] => 2013-05-12 23:25:20
            [year] => 2013
            [month] => 5
        )

    [2] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4825
            [post_name] => the-2-bc-transition-tax-on-new-homes-is-coming-april-1-2013
            [post_title] => The 2% BC Transition Tax on new homes is coming April 1, 2013
            [post_author] => 1
            [post_date] => 2013-04-16 22:37:03
            [year] => 2013
            [month] => 4
        )

    [3] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4819
            [post_name] => home-sale-activity-improves-but-remains-below-historical-averages
            [post_title] => Home sale activity improves but remains below historical averages
            [post_author] => 1
            [post_date] => 2013-04-11 20:48:37
            [year] => 2013
            [month] => 4
        )

    [4] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4747
            [post_name] => home-sales-continue-at-below-average-pace
            [post_title] => Home sales continue at below average pace
            [post_author] => 1
            [post_date] => 2013-03-05 22:18:51
            [year] => 2013
            [month] => 3
        )

    [5] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4461
            [post_name] => whats-a-property-worth-property-assessment-notices-are-here
            [post_title] => What’s a property worth? Property assessment notices are here
            [post_author] => 1
            [post_date] => 2013-02-08 12:19:08
            [year] => 2013
            [month] => 2
        )

    [6] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 4160
            [post_name] => prices-hold-firm-as-home-buyers-and-sellers-conclude-2012-from-the-sidelines
            [post_title] => Prices hold firm as home buyers and sellers conclude 2012 from the sidelines
            [post_author] => 1
            [post_date] => 2013-01-14 15:50:57
            [year] => 2013
            [month] => 1
        )

    [7] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3684
            [post_name] => greater-vancouver-residential-property-sale-and-listing-activity-below-10-year-averages-in-november
            [post_title] => Greater Vancouver residential property sale and listing activity below 10-year averages in November 
            [post_author] => 1
            [post_date] => 2012-12-06 10:55:58
            [year] => 2012
            [month] => 12
        )

    [8] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3598
            [post_name] => information-about-the-hstpst-new-housing-transitional-rules
            [post_title] => Information about the HST/PST new housing transitional rules
            [post_author] => 1
            [post_date] => 2012-12-05 15:12:27
            [year] => 2012
            [month] => 12
        )

    [9] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3569
            [post_name] => home-truths-the-door-is-closing-on-home-buyers
            [post_title] => Home Truths: The Door is closing on Home Buyers
            [post_author] => 1
            [post_date] => 2012-12-04 11:30:48
            [year] => 2012
            [month] => 12
        )

    [10] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3196
            [post_name] => interesting-mortgage-statistics
            [post_title] => Interesting Mortgage Statistics
            [post_author] => 1
            [post_date] => 2012-11-21 15:03:54
            [year] => 2012
            [month] => 11
        )

    [11] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3171
            [post_name] => pre-sale-purchase-law-protects-buyers-and-developers
            [post_title] => Pre-Sale Purchase Law protects buyers and developers
            [post_author] => 1
            [post_date] => 2012-11-14 14:27:47
            [year] => 2012
            [month] => 11
        )

    [12] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3136
            [post_name] => housing-market-sees-slight-changes-in-october
            [post_title] => Housing market sees slight changes in October  
            [post_author] => 1
            [post_date] => 2012-11-08 15:24:08
            [year] => 2012
            [month] => 11
        )

    [13] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 3045
            [post_name] => some-fast-facts-about-richmond
            [post_title] => Some Fast Facts About Richmond
            [post_author] => 1
            [post_date] => 2012-10-24 16:11:43
            [year] => 2012
            [month] => 10
        )

    [14] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3033
            [post_name] => bank-of-canada-interest-rate-announcement-october-23-2012
            [post_title] => Bank of Canada Interest Rate Announcement - October 23, 2012
            [post_author] => 1
            [post_date] => 2012-10-23 11:22:06
            [year] => 2012
            [month] => 10
        )

    [15] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3026
            [post_name] => grant-for-new-secondary-or-recreational-homes-available
            [post_title] => Grant for new secondary or recreational homes available 
            [post_author] => 1
            [post_date] => 2012-10-05 10:58:35
            [year] => 2012
            [month] => 10
        )

    [16] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 3022
            [post_name] => alternative-dispute-resolution-for-stratas-coming
            [post_title] => Alternative dispute resolution for stratas coming
            [post_author] => 1
            [post_date] => 2012-10-03 15:11:55
            [year] => 2012
            [month] => 10
        )

    [17] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2947
            [post_name] => what-you-need-to-know-about-non-residents-tax-laws
            [post_title] => What you need to know about Non-Residents Tax Laws
            [post_author] => 1
            [post_date] => 2012-08-19 21:45:09
            [year] => 2012
            [month] => 8
        )

    [18] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2932
            [post_name] => new-legislation-will-open-doors-to-development-on-first-nations-lands
            [post_title] => New Legislation will open doors to Development on First Nations Lands	 
            [post_author] => 1
            [post_date] => 2012-08-07 12:36:32
            [year] => 2012
            [month] => 8
        )

    [19] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2929
            [post_name] => greater-vancouver-housing-market-hits-summer-lull
            [post_title] => Greater Vancouver housing market hits summer lull
            [post_author] => 1
            [post_date] => 2012-08-07 12:29:38
            [year] => 2012
            [month] => 8
        )

    [20] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2823
            [post_name] => ottawa-caps-cmhc-mortgages-at-25-years
            [post_title] => Ottawa caps CMHC mortgages at 25 years
            [post_author] => 1
            [post_date] => 2012-07-10 14:46:55
            [year] => 2012
            [month] => 7
        )

    [21] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2805
            [post_name] => greater-vancouver-and-richmond-housing-market-favoured-buyers-in-june
            [post_title] => Greater Vancouver and Richmond housing market favoured buyers in June
            [post_author] => 1
            [post_date] => 2012-07-09 16:04:53
            [year] => 2012
            [month] => 7
        )

    [22] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2679
            [post_name] => spring-activity-balanced-in-the-greater-vancouver-falling-in-the-richmond-real-estate-market
            [post_title] => Spring Activity Balanced in the Greater Vancouver / Falling in the Richmond Real Estate Market
            [post_author] => 1
            [post_date] => 2012-06-07 12:01:46
            [year] => 2012
            [month] => 6
        )

    [23] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2544
            [post_name] => greater-vancouver-housing-market-maintains-a-steady-spring-pace
            [post_title] => Greater Vancouver Housing Market Maintains a Steady Spring Pace
            [post_author] => 1
            [post_date] => 2012-05-08 16:43:46
            [year] => 2012
            [month] => 5
        )

    [24] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 2320
            [post_name] => increased-selection-helps-maintain-balance-in-greater-vancouver-housing-market
            [post_title] => Increased selection helps maintain balance in Greater Vancouver housing market
            [post_author] => 1
            [post_date] => 2012-04-04 16:34:01
            [year] => 2012
            [month] => 4
        )

    [25] => stdClass Object
        (
            [slug] => real-estate
            [ID] => 2269
            [post_name] => greater-vancouver-housing-market-trends-near-long-term-averages-as-spring-market-approaches
            [post_title] => Greater Vancouver housing market trends near long-term averages as spring market approaches
            [post_author] => 1
            [post_date] => 2012-03-14 16:31:09
            [year] => 2012
            [month] => 3
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

)