MySQL server version: 5.0.96-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] => 2639
[post_name] => bespoke-tiles-and-wallpaper
[post_title] => Bespoke Tiles and Wallpaper
[post_author] => 4
[post_date] => 2013-05-16 04:49:09
[year] => 2013
[month] => 5
)
[1] => stdClass Object
(
[slug] => blog
[ID] => 2557
[post_name] => new-work-in-progress
[post_title] => New Work in Progress
[post_author] => 4
[post_date] => 2013-02-20 12:29:43
[year] => 2013
[month] => 2
)
[2] => 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
)
[3] => 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
)
[4] => 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
)
[5] => 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
)
[6] => 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
)
[7] => 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
)
)
Every tile used had been either a factory reject or had been recycled from old projects and we utilised almost all our rejected tiles that had been gathering over the years to form a kaleidoscopic patchwork effect. London customers wanting to see our tiles in action, get down to Broadway Market, Hackney.
Your comments are always appreciated!
Fabrications will be part the London Design Festival and Open House London both happening this September.


