Showing 1–6 of 44 results
6
6
8
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1534)
)
AND
wp_term_relationships.term_taxonomy_id IN (21)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
WP_Query Object
(
[query] => Array
(
[product_cat] => special-offers
)
[query_vars] => Array
(
[product_cat] => special-offers
[error] =>
[m] =>
[p] => 0
[post_parent] =>
[subpost] =>
[subpost_id] =>
[attachment] =>
[attachment_id] => 0
[name] =>
[pagename] =>
[page_id] => 0
[second] =>
[minute] =>
[hour] =>
[day] => 0
[monthnum] => 0
[year] => 0
[w] => 0
[category_name] =>
[tag] =>
[cat] =>
[tag_id] =>
[author] =>
[author_name] =>
[feed] =>
[tb] =>
[paged] => 0
[meta_key] =>
[meta_value] =>
[preview] =>
[s] =>
[sentence] =>
[title] =>
[fields] =>
[menu_order] =>
[embed] =>
[category__in] => Array
(
)
[category__not_in] => Array
(
)
[category__and] => Array
(
)
[post__in] => Array
(
)
[post__not_in] => Array
(
)
[post_name__in] => Array
(
)
[tag__in] => Array
(
)
[tag__not_in] => Array
(
)
[tag__and] => Array
(
)
[tag_slug__in] => Array
(
)
[tag_slug__and] => Array
(
)
[post_parent__in] => Array
(
)
[post_parent__not_in] => Array
(
)
[author__in] => Array
(
)
[author__not_in] => Array
(
)
[orderby] => menu_order title
[order] => ASC
[meta_query] => Array
(
)
[tax_query] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[field] => term_taxonomy_id
[terms] => Array
(
[0] => 1534
)
[operator] => NOT IN
)
)
[wc_query] => product_query
[posts_per_page] => 6
[ignore_sticky_posts] =>
[suppress_filters] =>
[cache_results] => 1
[update_post_term_cache] => 1
[lazy_load_term_meta] => 1
[update_post_meta_cache] => 1
[post_type] =>
[nopaging] =>
[comments_per_page] => 50
[no_found_rows] =>
[taxonomy] => product_cat
[term] => special-offers
)
[tax_query] => WP_Tax_Query Object
(
[queries] => Array
(
[relation] => AND
[0] => Array
(
[taxonomy] => product_visibility
[terms] => Array
(
[0] => 1534
)
[field] => term_taxonomy_id
[operator] => NOT IN
[include_children] => 1
)
[1] => Array
(
[taxonomy] => product_cat
[terms] => Array
(
[0] => special-offers
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[product_cat] => Array
(
[terms] => Array
(
[0] => special-offers
)
[field] => slug
)
)
[primary_table] => wp_posts
[primary_id_column] => ID
)
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
)
[relation] =>
[meta_table] =>
[meta_id_column] =>
[primary_table] =>
[primary_id_column] =>
[table_aliases:protected] => Array
(
)
[clauses:protected] => Array
(
)
[has_or_relation:protected] =>
)
[date_query] =>
[queried_object] => WP_Term Object
(
[term_id] => 21
[name] => Special Offers
[slug] => special-offers
[term_group] => 0
[term_taxonomy_id] => 21
[taxonomy] => product_cat
[description] =>
[parent] => 0
[count] => 44
[filter] => raw
[term_order] => 0
)
[queried_object_id] => 21
[request] => SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (1534)
)
AND
wp_term_relationships.term_taxonomy_id IN (21)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 18218
[post_author] => 324
[post_date] => 2020-04-02 13:23:34
[post_date_gmt] => 2020-04-02 12:23:34
[post_content] => 4 Drawer Side Filer - Oak Top
Lockable
Excellent Condition
Filing bars not included
[post_title] => 4 Drawer Side Filer - Oak Top
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4-drawer-side-filer-oak-top
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-02 14:14:12
[post_modified_gmt] => 2020-04-02 13:14:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18218
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 18232
[post_author] => 324
[post_date] => 2020-04-03 11:18:12
[post_date_gmt] => 2020-04-03 10:18:12
[post_content] => Allermuir Designer Stool
Excellent Condition
£39 each
White & Slate
[post_title] => Allermuir Designer Stool
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => allermuir-designer-stool
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-03 11:18:12
[post_modified_gmt] => 2020-04-03 10:18:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18232
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 18205
[post_author] => 324
[post_date] => 2020-04-01 15:16:08
[post_date_gmt] => 2020-04-01 14:16:08
[post_content] => FlexiForm 4 Drawer Filing Cabinet
Average Condition
Some Keys Missing
[post_title] => FlexiForm 4 Drawer Filing Cabinet
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => flexiform-4-drawer-filing-cabinet
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-01 15:16:08
[post_modified_gmt] => 2020-04-01 14:16:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18205
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 18225
[post_author] => 324
[post_date] => 2020-04-03 11:05:23
[post_date_gmt] => 2020-04-03 10:05:23
[post_content] => Senator Bar Stool
Red leather seat pad
Excellent condition
£40 Each
[post_title] => Senator Bar Stool
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => senator-bar-stool
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-03 11:19:08
[post_modified_gmt] => 2020-04-03 10:19:08
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18225
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 18239
[post_author] => 324
[post_date] => 2020-04-03 16:11:24
[post_date_gmt] => 2020-04-03 15:11:24
[post_content] => White Poseur Table & Designer Chair Package
Senator Designer Stools
Excellent Condition
Fantastic Price
Won't be around for long !
[post_title] => White Poseur Table & Designer Chair Package
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => white-poseur-table-designer-chair-package
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-03 16:11:40
[post_modified_gmt] => 2020-04-03 15:11:40
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18239
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 291
[post_author] => 2
[post_date] => 2015-06-17 10:12:16
[post_date_gmt] => 2015-06-17 09:12:16
[post_content] => Looking for a used Aeron chair? The Herman Miller Aeron Is the perfect ergonomic office chair for taking your back health seriously and our used Aeron mesh chairs are excellent value too.
When designers Bill Stumpf and Don Chadwick set out to create a chair that was health-positive, cross-performing, inclusively-sized and environmentally sensitive, they arrived at a design unlike the world had ever seen.
Aeron demonstrated a pioneering step in ergonomics and material innovation, and provided a comfortable solution without the standard use of foam, fabric or leather. It changed people’s perception of what an office chair could be, and in doing so it soon found a place in popular culture.
Features - Herman Miller Aeron
- Used, in excellent condition (refurbished)
- Herman Miller Aeron Mesh Office Chair
- Graphite mesh
- Size B
- Adjustable padded arms
- Fully refurbished
- Available with lumbar support at £350 +VAT
- 12 Month Warranty
- 4 different versions available: 1. No lumber support or forward tilt. 2. With lumber support / no forward tilt. 3. With forward tilt / no lumber. 4. With forward tilt and lumber support.
Used / Second Hand Herman Miller Aeron Mesh Office Chair, Fully Adjustable, Ergonomic, Size B
City Office Furniture offer a wide range of quality office chairs. This is a superb quality Herman Miller Aeron mesh office chair, which is fully adjustable with arms and a swivel base.
Buy quality new and used / second hand mesh office chairs from City Used Office Furniture. We have UK showrooms in Chester, Hull and Harlow and can deliver within a 50 mile radius of these locations.
Free local delivery and installation is available within a 50 mile radius of our branch showrooms. Some exclusions may apply and be subject to a minimum order charge of £250. Please contact us for further details
[post_title] => Herman Miller Aeron Mesh Office Chair, Fully Adjustable, Ergonomic, Size B
[post_excerpt] =>
[post_status] => publish
[comment_status] => open
[ping_status] => closed
[post_password] =>
[post_name] => herman-miller-aeron-designer-office-chair-graphite-mesh-size-b
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-30 10:24:13
[post_modified_gmt] => 2020-03-30 09:24:13
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://79.170.44.83/newcityused.com/?post_type=product&p=291
[menu_order] => 5
[post_type] => product
[post_mime_type] =>
[comment_count] => 1
[filter] => raw
)
)
[post_count] => 6
[current_post] => -1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 18218
[post_author] => 324
[post_date] => 2020-04-02 13:23:34
[post_date_gmt] => 2020-04-02 12:23:34
[post_content] => 4 Drawer Side Filer - Oak Top
Lockable
Excellent Condition
Filing bars not included
[post_title] => 4 Drawer Side Filer - Oak Top
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => 4-drawer-side-filer-oak-top
[to_ping] =>
[pinged] =>
[post_modified] => 2020-04-02 14:14:12
[post_modified_gmt] => 2020-04-02 13:14:12
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18218
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 44
[max_num_pages] => 8
[max_num_comment_pages] => 0
[is_single] =>
[is_preview] =>
[is_page] =>
[is_archive] => 1
[is_date] =>
[is_year] =>
[is_month] =>
[is_day] =>
[is_time] =>
[is_author] =>
[is_category] =>
[is_tag] =>
[is_tax] => 1
[is_search] =>
[is_feed] =>
[is_comment_feed] =>
[is_trackback] =>
[is_home] =>
[is_privacy_policy] =>
[is_404] =>
[is_embed] =>
[is_paged] =>
[is_admin] =>
[is_attachment] =>
[is_singular] =>
[is_robots] =>
[is_posts_page] =>
[is_post_type_archive] =>
[query_vars_hash:WP_Query:private] => 5a61f31a0dbf11c4b5853996f3500e64
[query_vars_changed:WP_Query:private] => 1
[thumbnails_cached] =>
[stopwords:WP_Query:private] =>
[compat_fields:WP_Query:private] => Array
(
[0] => query_vars_hash
[1] => query_vars_changed
)
[compat_methods:WP_Query:private] => Array
(
[0] => init_query_flags
[1] => parse_tax_query
)
)
