Blog Archive: 2011

Browse by Category

• Blog
  • Crinson news
  • Events
  • Inspiration
  • New Collection
  • New Installations
  • Special Commissions

Archives

MySQL server version: 5.0.95-community-log

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => 
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 4
    [showPostDate] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [animate] => 1
    [postTitleLength] => 20
    [showPostCount] => 
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [number] => 3
)
POST QUERY:
 SELECT hh_terms.slug, hh_posts.ID,
    hh_posts.post_name, hh_posts.post_title, hh_posts.post_author,
    hh_posts.post_date, YEAR(hh_posts.post_date) AS 'year',
    MONTH(hh_posts.post_date) AS 'month' 
    FROM hh_posts LEFT JOIN hh_term_relationships ON hh_posts.ID =
    hh_term_relationships.object_id 
		LEFT JOIN hh_term_taxonomy ON hh_term_taxonomy.term_taxonomy_id =
																			hh_term_relationships.term_taxonomy_id
		LEFT JOIN hh_terms ON hh_terms.term_id = 
		                          hh_term_taxonomy.term_id 
  WHERE post_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND post_type = 'post'    
  GROUP BY hh_posts.ID 
  ORDER BY hh_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => blog
            [ID] => 2457
            [post_name] => fabrications
            [post_title] => Fabrications Revamp
            [post_author] => 4
            [post_date] => 2012-05-02 07:53:25
            [year] => 2012
            [month] => 5
        )

    [1] => stdClass Object
        (
            [slug] => blog
            [ID] => 2430
            [post_name] => restroom-paradise-in-stockholm
            [post_title] => Restroom Paradise in Stockholm
            [post_author] => 4
            [post_date] => 2012-04-28 13:22:28
            [year] => 2012
            [month] => 4
        )

    [2] => stdClass Object
        (
            [slug] => news
            [ID] => 1206
            [post_name] => launching-our-new-website
            [post_title] => Launching our new website
            [post_author] => 5
            [post_date] => 2011-08-18 21:37:54
            [year] => 2011
            [month] => 8
        )

    [3] => stdClass Object
        (
            [slug] => events
            [ID] => 42
            [post_name] => 100-design-2010-2
            [post_title] => 100% Design 2010
            [post_author] => 5
            [post_date] => 2010-09-17 19:02:37
            [year] => 2010
            [month] => 9
        )

    [4] => stdClass Object
        (
            [slug] => new-installations
            [ID] => 37
            [post_name] => sir-david-tangs-bejing-penthouse-suites
            [post_title] => Sir David Tang's Bejing Penthouse Suites
            [post_author] => 5
            [post_date] => 2010-06-27 14:13:58
            [year] => 2010
            [month] => 6
        )

    [5] => stdClass Object
        (
            [slug] => blog
            [ID] => 20
            [post_name] => boundary-hotel-by-sir-terence-conran-and-peter-prescott
            [post_title] => Boundary Hotel by Sir Terence Conran and Peter Prescott
            [post_author] => 5
            [post_date] => 2009-10-18 01:12:54
            [year] => 2009
            [month] => 10
        )

)

• 2012
  • May (1)
  • April (1)
• 2011
  • August (1)
• 2010
  • September (1)
  • June (1)
• 2009
  • October (1)