Topic: archaic

Browse by Category

• Blog

Archives

MySQL server version: 

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
    [accordion] => 0
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 20
    [showPostCount] => 
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [animate] => 1
    [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' ,
    hh_posts.post_type
    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_status='publish' AND hh_posts.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] => 3008
            [post_name] => murage-wallpaper
            [post_title] => Murage Wallpaper
            [post_author] => 4
            [post_date] => 2014-01-21 04:29:47
            [year] => 2014
            [month] => 1
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => blog
            [ID] => 3019
            [post_name] => new-tile-collection-alchemy
            [post_title] => New Tile Collection - Alchemy
            [post_author] => 4
            [post_date] => 2014-01-19 03:29:57
            [year] => 2014
            [month] => 1
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => blog
            [ID] => 2656
            [post_name] => a-sneak-preview-of-the-new-range
            [post_title] => A sneak preview of the new range...
            [post_author] => 4
            [post_date] => 2013-12-31 09:25:22
            [year] => 2013
            [month] => 12
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => blog
            [ID] => 2997
            [post_name] => free-international-delivery-for-wallpaper-orders-made-in-january
            [post_title] => Free international delivery for wallpaper orders made in January
            [post_author] => 4
            [post_date] => 2013-12-31 04:25:22
            [year] => 2013
            [month] => 12
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => blog
            [ID] => 2557
            [post_name] => new-work-in-progress
            [post_title] => New Work in Progress
            [post_author] => 4
            [post_date] => 2013-12-20 12:29:43
            [year] => 2013
            [month] => 12
            [post_type] => post
        )

    [5] => stdClass Object
        (
            [slug] => blog
            [ID] => 2799
            [post_name] => shop-window-wallpapers-northcote-melbourne
            [post_title] => Shop Window Wallpapers, Northcote, Melbourne
            [post_author] => 4
            [post_date] => 2013-09-19 14:02:02
            [year] => 2013
            [month] => 9
            [post_type] => post
        )

    [6] => stdClass Object
        (
            [slug] => blog
            [ID] => 2693
            [post_name] => new-wallpapers
            [post_title] => New Wallpapers
            [post_author] => 4
            [post_date] => 2013-01-23 08:26:38
            [year] => 2013
            [month] => 1
            [post_type] => post
        )

    [7] => stdClass Object
        (
            [slug] => blog
            [ID] => 2639
            [post_name] => bespoke-tiles-and-wallpaper
            [post_title] => Bespoke Tiles and Wallpaper
            [post_author] => 4
            [post_date] => 2013-01-16 04:49:09
            [year] => 2013
            [month] => 1
            [post_type] => post
        )

    [8] => stdClass Object
        (
            [slug] => blog
            [ID] => 2869
            [post_name] => pre-orders-for-new-tile-book
            [post_title] => New Tile Book
            [post_author] => 4
            [post_date] => 2013-01-15 07:01:48
            [year] => 2013
            [month] => 1
            [post_type] => post
        )

    [9] => stdClass Object
        (
            [slug] => blog
            [ID] => 2928
            [post_name] => murage-at-home
            [post_title] => Murage at home
            [post_author] => 4
            [post_date] => 2013-01-05 03:46:24
            [year] => 2013
            [month] => 1
            [post_type] => post
        )

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

    [11] => stdClass Object
        (
            [slug] => blog
            [ID] => 2457
            [post_name] => fabrications
            [post_title] => Fabrications Revamp
            [post_author] => 4
            [post_date] => 2012-01-02 07:53:25
            [year] => 2012
            [month] => 1
            [post_type] => post
        )

    [12] => stdClass Object
        (
            [slug] => blog
            [ID] => 1206
            [post_name] => launching-our-new-website
            [post_title] => Launching our new website
            [post_author] => 5
            [post_date] => 2011-01-18 21:37:54
            [year] => 2011
            [month] => 1
            [post_type] => post
        )

    [13] => stdClass Object
        (
            [slug] => blog
            [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-12-27 14:13:58
            [year] => 2010
            [month] => 12
            [post_type] => post
        )

    [14] => stdClass Object
        (
            [slug] => blog
            [ID] => 42
            [post_name] => 100-design-2010-2
            [post_title] => 100% Design 2010
            [post_author] => 5
            [post_date] => 2010-01-17 19:02:37
            [year] => 2010
            [month] => 1
            [post_type] => post
        )

    [15] => 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-12-18 01:12:54
            [year] => 2009
            [month] => 12
            [post_type] => post
        )

)

• 2014
  • January (2)
• 2013
  • December (3)
  • September (1)
  • January (4)
• 2012
  • January (2)
• 2011
  • January (1)
• 2010
  • December (1)
  • January (1)
• 2009
  • December (1)