Seating

Showing 1–6 of 171 results

6
6
29
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)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') 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] => 
            [static] => 
            [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 UK’s leading supplier of second hand office chairs and designer seating. Choose from our massive range of  used operator chairs, reception seating, meeting chairs and bar stools. Our second hand designer range includes Herman Miller Aeron chairs, Vitra operator chairs and Wiesner meeting chairs.

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] => 171
            [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)
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish') 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] => 11733
                    [post_author] => 144
                    [post_date] => 2019-02-11 08:57:34
                    [post_date_gmt] => 2019-02-11 08:57:34
                    [post_content] => 

ALLERMUIR MOLLIE CHAIR (WHITE)

Allermuir Mollie Chair Designed by John Coleman A luxurious and satisfying design, Mollie is suited to hotel and restaurant dining, bars or corporate environments. The classic silhouette of the design offers deep and full back support and a generous seat width. With a white leather seat cushion and padded backrest the Mollie chair sits on a unique styled base. The sculpted wooden shell on the seat of this bistro chair is finished in a polished walnut offering a sense style. [post_title] => ALLERMUIR MOLLIE CHAIR (WHITE) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => allermuir-mollie-chair-white [to_ping] => [pinged] => [post_modified] => 2019-02-14 10:46:36 [post_modified_gmt] => 2019-02-14 10:46:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11733 [menu_order] => 2 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 11792 [post_author] => 4 [post_date] => 2019-02-13 14:33:22 [post_date_gmt] => 2019-02-13 14:33:22 [post_content] => Black Mesh Operator Chair with Blue Seat Pad [post_title] => Black Mesh Operator Chair with Blue Seat Pad [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-mesh-operator-chair-with-blue-seat-pad [to_ping] => [pinged] => [post_modified] => 2019-02-13 14:33:22 [post_modified_gmt] => 2019-02-13 14:33:22 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11792 [menu_order] => 6 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 11797 [post_author] => 4 [post_date] => 2019-02-13 16:21:36 [post_date_gmt] => 2019-02-13 16:21:36 [post_content] => Executive Ribbed Chair Cream
  • Back Tilt
  • Height adjustment
  • Chrome base
  • Chrome fixed arms
  • unused but some are showing light marks
      [post_title] => Executive Ribbed Chair Cream [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => executive-ribbed-chair-cream [to_ping] => [pinged] => [post_modified] => 2019-02-14 09:43:48 [post_modified_gmt] => 2019-02-14 09:43:48 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11797 [menu_order] => 12 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 11690 [post_author] => 4 [post_date] => 2019-02-07 10:04:41 [post_date_gmt] => 2019-02-07 10:04:41 [post_content] => Giroflex Padded Meeting Chair
  • Cantilever Frame
  • Aqua Fabric
[post_title] => Giroflex Padded Meeting Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => giroflex-padded-meeting-chair [to_ping] => [pinged] => [post_modified] => 2019-02-07 10:04:42 [post_modified_gmt] => 2019-02-07 10:04:42 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11690 [menu_order] => 13 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 11785 [post_author] => 4 [post_date] => 2019-02-13 14:18:40 [post_date_gmt] => 2019-02-13 14:18:40 [post_content] => Green Operator Chair
  • Height adjustable arms
  • Back tilt
  • Back height adjustment
  • Seat height adjustment
  [post_title] => Green Operator Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => green-operator-chair-2 [to_ping] => [pinged] => [post_modified] => 2019-02-13 14:18:41 [post_modified_gmt] => 2019-02-13 14:18:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11785 [menu_order] => 16 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 11691 [post_author] => 4 [post_date] => 2019-02-07 10:11:17 [post_date_gmt] => 2019-02-07 10:11:17 [post_content] => Mesh Back Operator Chair
  • Mesh Back
  • Folding Arms
  • Back Tilt
  • Height Adjustment
  • Vinyl Easy Wipe Seat
[post_title] => Mesh Back Operator Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => mesh-back-operator-chair [to_ping] => [pinged] => [post_modified] => 2019-02-12 15:51:03 [post_modified_gmt] => 2019-02-12 15:51:03 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11691 [menu_order] => 23 [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] => 11733 [post_author] => 144 [post_date] => 2019-02-11 08:57:34 [post_date_gmt] => 2019-02-11 08:57:34 [post_content] =>

ALLERMUIR MOLLIE CHAIR (WHITE)

Allermuir Mollie Chair Designed by John Coleman A luxurious and satisfying design, Mollie is suited to hotel and restaurant dining, bars or corporate environments. The classic silhouette of the design offers deep and full back support and a generous seat width. With a white leather seat cushion and padded backrest the Mollie chair sits on a unique styled base. The sculpted wooden shell on the seat of this bistro chair is finished in a polished walnut offering a sense style. [post_title] => ALLERMUIR MOLLIE CHAIR (WHITE) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => allermuir-mollie-chair-white [to_ping] => [pinged] => [post_modified] => 2019-02-14 10:46:36 [post_modified_gmt] => 2019-02-14 10:46:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11733 [menu_order] => 2 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 171 [max_num_pages] => 29 [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_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] => dd202f69aa2ed8deeb37e84a10d11114 [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 ) )