Showing 1–6 of 24 results
6
6
4
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) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_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 (1037) ) 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 wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC LIMIT 0, 6
WP_Query Object
(
[query] => Array
(
[product_cat] => best-sellers
)
[query_vars] => Array
(
[product_cat] => best-sellers
[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] => popularity
[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] => best-sellers
)
[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] => best-sellers
)
[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] => best-sellers
)
[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] => 1037
[name] => Best Sellers
[slug] => best-sellers
[term_group] => 0
[term_taxonomy_id] => 1037
[taxonomy] => product_cat
[description] =>
[parent] => 0
[count] => 24
[filter] => raw
)
[queried_object_id] => 1037
[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) LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup ON wp_posts.ID = wc_product_meta_lookup.product_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 (1037)
) 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 wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC LIMIT 0, 6
[posts] => Array
(
[0] => 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 £325 +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.
Features
- White Curved Front 3 Drawer Pedestal
- Two Drawers with one Filing Drawer
- Lockable and provided with key
- Castors are fitted so the pedestal is mobile and easily to move
- £39+VAT each when you buy 20 or more
Features
- Price shown for desk only
- Can be purchased with pedestal as shown for £119 + vat
- Top quality UK manufactured item
- 25mm worktops with a 2mm impact resistant edge trim
- Also available with a white top
- Standard silver finish leg with integrated cable management
- Integrated cable tray which doubles as a modesty panel
- Two integrated cable ports
- Adjustable feet for uneven floors
- Compatible with all pedestal and storage options
- Used / second hand - in very good condition
- Mesh back that wraps around your back
- Durable arm pads
- Think foam seat-pad
- 5 star base
- Height adjustable
- Back lock
- Great Price
VERCO Graphite Salt and Pepper Chair Is the perfect ergonomic chair for keeping your back health in check.
Lower Price when bought in bulk. Lower Price when bought with desk. Other furniture in different styles, colours and sizes available. Matching range of furniture options available. Feel free to call us on 01244 389111 if you have questions about this product. Used / Second Hand Verco Salt N Pepper Mesh Office Chair, With Arms, Adjustable, Swivel Base City Office Furniture offer a wide range of quality mesh office chairs. This is a superb quality mesh office chair by Verco, which is 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] => Verco Salt N Pepper Task / Office Chair, With Arms, Adjustable, Swivel Base [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => verco-blue-salt-and-pepper-chair [to_ping] => [pinged] => [post_modified] => 2019-11-27 11:03:07 [post_modified_gmt] => 2019-11-27 11:03:07 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6084 [menu_order] => 48 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 11134 [post_author] => 4 [post_date] => 2019-01-14 15:18:22 [post_date_gmt] => 2019-01-14 15:18:22 [post_content] => Black Folding Chair 0-50 Chairs £6+Vat 50-100 Chairs £5+Vat 100+ Chairs £4+Vat [post_title] => Black Folding Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-folding-chair [to_ping] => [pinged] => [post_modified] => 2019-11-27 11:03:37 [post_modified_gmt] => 2019-11-27 11:03:37 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11134 [menu_order] => 332 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 7243 [post_author] => 4 [post_date] => 2018-02-02 09:57:17 [post_date_gmt] => 2018-02-02 09:57:17 [post_content] => The Orangebox Go Swivel Chair in Black Leather is a classic operator style chair that's ideal for offices.- Black leather
- Adjustable arms
- Swivel base
- Height adjustable
- Also a popular choice to be used as a conference room chair
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 £325 +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.
