Monthly Archives: July 2011

Here Comes the Sun!

It’s that time of the year when our attention turns to holidays, relaxation and in our case the question arises as to what we can do with our three children for 8 weeks. The long established tradition of re-locating the

Posted in Financial News

Archives

    MySQL server version: 
    
    collapsArch options:
    Array
    (
        [title] => Archives
        [noTitle] => 
        [inExcludeCat] => exclude
        [inExcludeCats] => 
        [inExcludeYear] => include
        [inExcludeYears] => 
        [showPages] => 
        [sort] => DESC
        [linkToArch] => 
        [showYearCount] => 
        [expandCurrentYear] => 1
        [expandMonths] => 
        [expandYears] => 1
        [expandCurrentMonth] => 1
        [showMonthCount] => 1
        [showPostTitle] => 
        [expand] => 0
        [showPostDate] => 
        [debug] => 1
        [postDateFormat] => m/d
        [postDateAppend] => after
        [accordion] => 0
        [useCookies] => 1
        [post_type] => post
        [taxoncmy] => category
        [postTitleLength] => 
        [showPostCount] => 1
        [style] => kubrick
        [archSortOrder] => DESC
        [showPosts] => 
        [customExpand] => 
        [customCollapse] => v
        [taxonomy] => both
        [number] => 2
    )
    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] => financial-news
                [ID] => 199
                [post_name] => sparkling-golden-shorts
                [post_title] => Sparkling Golden Shorts  
                [post_author] => 1
                [post_date] => 2011-11-15 18:07:03
                [year] => 2011
                [month] => 11
                [post_type] => post
            )
    
        [1] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 202
                [post_name] => are-the-banks-diversifying-too-much
                [post_title] => Are the Banks Diversifying Too Much?
                [post_author] => 1
                [post_date] => 2011-09-19 15:09:30
                [year] => 2011
                [month] => 9
                [post_type] => post
            )
    
        [2] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 187
                [post_name] => can-investing-in-cash-damage-your-health
                [post_title] => Can Investing in Cash Damage Your Health?
                [post_author] => 1
                [post_date] => 2011-09-05 17:29:32
                [year] => 2011
                [month] => 9
                [post_type] => post
            )
    
        [3] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 192
                [post_name] => the-future-genuinely-looks-grim
                [post_title] => The Future Genuinely Looks Grim!
                [post_author] => 1
                [post_date] => 2011-08-08 16:37:59
                [year] => 2011
                [month] => 8
                [post_type] => post
            )
    
        [4] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 194
                [post_name] => here-comes-the-sun
                [post_title] => Here Comes the Sun!
                [post_author] => 1
                [post_date] => 2011-07-12 17:40:19
                [year] => 2011
                [month] => 7
                [post_type] => post
            )
    
        [5] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 182
                [post_name] => dont-mention-the-cfor-charges-word
                [post_title] => Don’t Mention the ‘C’ for charges Word!
                [post_author] => 1
                [post_date] => 2011-06-21 12:34:08
                [year] => 2011
                [month] => 6
                [post_type] => post
            )
    
        [6] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 166
                [post_name] => is-there-a-parallel-between-riding-a-bike-over-rough-terrain-and-investing-in-our-current-turbulent-times
                [post_title] => Is there a parallel between riding a bike over rough terrain and investing in our current turbulent times?  
                [post_author] => 1
                [post_date] => 2011-06-13 13:40:57
                [year] => 2011
                [month] => 6
                [post_type] => post
            )
    
        [7] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 158
                [post_name] => bruises-baths-bonds
                [post_title] => Bruises, Baths & Bonds
                [post_author] => 1
                [post_date] => 2010-12-01 10:32:43
                [year] => 2010
                [month] => 12
                [post_type] => post
            )
    
        [8] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 155
                [post_name] => investing-and-perhaps-drinking-to-forget
                [post_title] => Investing and Perhaps Drinking to Forget
                [post_author] => 1
                [post_date] => 2010-11-23 12:32:35
                [year] => 2010
                [month] => 11
                [post_type] => post
            )
    
        [9] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 153
                [post_name] => easing-back-on-a-greek-beach
                [post_title] => Easing back on a Greek Beach
                [post_author] => 1
                [post_date] => 2010-11-09 12:52:22
                [year] => 2010
                [month] => 11
                [post_type] => post
            )
    
        [10] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 150
                [post_name] => panorama-expose-reduced-pension-limits-what-next-for-pensions
                [post_title] => Panorama Expose, reduced Pension Limits, what next for Pensions?
                [post_author] => 1
                [post_date] => 2010-10-18 15:30:15
                [year] => 2010
                [month] => 10
                [post_type] => post
            )
    
        [11] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 148
                [post_name] => investing-is-not-for-wimps-or-is-that-lunch
                [post_title] => Investing is ‘Not for Wimps’, or is that lunch?
                [post_author] => 1
                [post_date] => 2010-10-04 16:30:15
                [year] => 2010
                [month] => 10
                [post_type] => post
            )
    
        [12] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 70
                [post_name] => do-italians-have-the-right-to-call-us-3rd-world
                [post_title] => Do Italians have the right to call us 3rd World? 
                [post_author] => 1
                [post_date] => 2010-09-27 12:36:14
                [year] => 2010
                [month] => 9
                [post_type] => post
            )
    
        [13] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 147
                [post_name] => are-they-a-snip
                [post_title] => Are they a Snip? 
                [post_author] => 1
                [post_date] => 2010-09-13 13:54:10
                [year] => 2010
                [month] => 9
                [post_type] => post
            )
    
        [14] => stdClass Object
            (
                [slug] => financial-news
                [ID] => 146
                [post_name] => in-bed-with-madonna-pension-benefits
                [post_title] => In Bed with Madonna & Pension Benefits
                [post_author] => 1
                [post_date] => 2010-09-06 13:53:44
                [year] => 2010
                [month] => 9
                [post_type] => post
            )
    
    )
    
  • 2011
  • 2010

Categories