6
6
28
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 (15,1005,2473,2474,2475,2476,2477,2478,2542,2547,2548,2549,2729)
) 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] => seating
)
[query_vars] => Array
(
[product_cat] => seating
[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] => seating
)
[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] => seating
)
[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] => seating
)
[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] => 15
[name] => Seating
[slug] => seating
[term_group] => 0
[term_taxonomy_id] => 15
[taxonomy] => product_cat
[description] => City Used Office Furniture is the leading supplier of used office chairs. We sell a huge range second hand seating in our UK showrooms. Available types include chairs for operators , reception, stacking, break out, draughtsman, executive, conference, meeting, bar stools and bean bags. Our range of seating includes basic, folding, stackable, cantilever, tub, armchair and sofa styles. Brands include Herman Miller, Orangebox, Steelcase, Ergohuman, Verco, Senato & Haworth
Our wide selection of seating covers all sizes, including small, medium and large - from basic used office chairs to designer models such as the Herman Miller Aeron, Vitra Operator and Wiesner Executive Chairs. Many of our second hand office chairs offer adjustable tilt and height, with lumber support, swivel movement and castor wheels. They are finished in mesh, fabric and leather with foam padding. The frames are commonly made from plastic, steel (chrome) and wood. Whatever your needs, for the office or home, we have plenty of choice.
Office Furniture Showrooms
We have showrooms with new and second hand used office chairs in the North West and South East regions of the UK. They cover areas such as Cheshire, North Wales, Wirral, Manchester, Yorkshire, London and Essex. We also offer free local delivery on all orders and free site surveys. For more information about any of our products and services, please contact us for more details.
[parent] => 0
[count] => 160
[filter] => raw
)
[queried_object_id] => 15
[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 (15,1005,2473,2474,2475,2476,2477,2478,2542,2547,2548,2549,2729)
) 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] => 18067
[post_author] => 4
[post_date] => 2020-03-25 16:35:33
[post_date_gmt] => 2020-03-25 16:35:33
[post_content] => Our blue compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame.
For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish.
Our blue compact chairs are also the ideal choice when you need to provide high volume seating, for example at conferences.
Our compact chairs are also available in purple fabric.
Features
- Stackable upto 10 classic style banqueting chair
- Ideal at formal occasion, events, office and village hall
- Discounts available for large quantities
Dimensions
H 900mm
W 425mm
D 430mm
SH 460mm
[post_title] => Blue Compact Stacking Chair
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => blue-compact-stacking-chair
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 08:52:54
[post_modified_gmt] => 2020-03-27 08:52:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18067
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[1] => WP_Post Object
(
[ID] => 18137
[post_author] => 324
[post_date] => 2020-03-27 11:03:00
[post_date_gmt] => 2020-03-27 11:03:00
[post_content] => Brown Le Corbusier Style - 2 Seater
Good condition
[post_title] => Brown Le Corbusier Style - 2 Seater
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => brown-le-corbusier-style-2-seater
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 11:06:11
[post_modified_gmt] => 2020-03-27 11:06:11
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18137
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[2] => WP_Post Object
(
[ID] => 18138
[post_author] => 324
[post_date] => 2020-03-27 11:06:58
[post_date_gmt] => 2020-03-27 11:06:58
[post_content] => Brown Le Corbusier Style - 3 Seater
Good condition
[post_title] => Brown Le Corbusier Style - 3 Seater
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => brown-le-corbusier-style-3-seater
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 11:07:59
[post_modified_gmt] => 2020-03-27 11:07:59
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18138
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[3] => WP_Post Object
(
[ID] => 18133
[post_author] => 324
[post_date] => 2020-03-27 11:00:08
[post_date_gmt] => 2020-03-27 11:00:08
[post_content] => Brown Le Corbusier Style Armchair
Good condition
[post_title] => Brown Le Corbusier Style Armchair
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => brown-le-corbusier-style-armchair
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 11:00:09
[post_modified_gmt] => 2020-03-27 11:00:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18133
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[4] => WP_Post Object
(
[ID] => 18140
[post_author] => 7
[post_date] => 2020-03-27 13:51:23
[post_date_gmt] => 2020-03-27 13:51:23
[post_content] => Our Burgundy and Gold compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame.
For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish.
Features
- Stackable upto 10 classic style banqueting chair
- Ideal at formal occasion, events, office and village hall
- Discounts available for large quantities
Dimensions
H 900mm
W 425mm
D 430mm
SH 460mm
[post_title] => Burgundy And Gold Banqueting Chairs
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => burgundy-and-gold-banqueting-chairs
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 13:51:27
[post_modified_gmt] => 2020-03-27 13:51:27
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18140
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[5] => WP_Post Object
(
[ID] => 18127
[post_author] => 7
[post_date] => 2020-03-27 10:59:11
[post_date_gmt] => 2020-03-27 10:59:11
[post_content] => Le Corbusier's LC2 2 seater sofa design from the 1920s remains contemporary and an established icon of modern style more than 80 years on.
- Chrome Frame
- Modern Design
- Red Leather
- 4 Available
[post_title] => Le Corbusier Style Two Seater Sofa
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => le-corbusier-style-two-seater-sofa
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 11:01:35
[post_modified_gmt] => 2020-03-27 11:01:35
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18127
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
)
[post_count] => 6
[current_post] => -1
[in_the_loop] =>
[post] => WP_Post Object
(
[ID] => 18067
[post_author] => 4
[post_date] => 2020-03-25 16:35:33
[post_date_gmt] => 2020-03-25 16:35:33
[post_content] => Our blue compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame.
For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish.
Our blue compact chairs are also the ideal choice when you need to provide high volume seating, for example at conferences.
Our compact chairs are also available in purple fabric.
Features
- Stackable upto 10 classic style banqueting chair
- Ideal at formal occasion, events, office and village hall
- Discounts available for large quantities
Dimensions
H 900mm
W 425mm
D 430mm
SH 460mm
[post_title] => Blue Compact Stacking Chair
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => blue-compact-stacking-chair
[to_ping] =>
[pinged] =>
[post_modified] => 2020-03-27 08:52:54
[post_modified_gmt] => 2020-03-27 08:52:54
[post_content_filtered] =>
[post_parent] => 0
[guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18067
[menu_order] => 0
[post_type] => product
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
)
[comment_count] => 0
[current_comment] => -1
[found_posts] => 166
[max_num_pages] => 28
[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] => 669093610fee5b7f3fe69191e8df47c2
[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
)
)
