Seating

Showing 1–6 of 172 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] => 172
            [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] => 13559
                    [post_author] => 4
                    [post_date] => 2019-05-20 14:01:35
                    [post_date_gmt] => 2019-05-20 13:01:35
                    [post_content] => Black Le Corbusier Style 2 Seater Sofa
                    [post_title] => Black Le Corbusier Style 2 Seater Sofa
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => black-le-corbusier-style-2-seater-sofa
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-05-20 14:01:35
                    [post_modified_gmt] => 2019-05-20 13:01:35
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13559
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 13527
                    [post_author] => 4
                    [post_date] => 2019-05-18 14:49:25
                    [post_date_gmt] => 2019-05-18 13:49:25
                    [post_content] => Black Le Corbusier Style Armchair
                    [post_title] => Black Le Corbusier Style Armchair
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => black-le-corbusier-style-armchair
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-05-18 14:49:25
                    [post_modified_gmt] => 2019-05-18 13:49:25
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13527
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 13601
                    [post_author] => 4
                    [post_date] => 2019-05-21 13:47:43
                    [post_date_gmt] => 2019-05-21 12:47:43
                    [post_content] => This chair offers ergonomics, value for money, style and durability.
  • Aluminium Base
  • Height Adjustable
  • Back tilt Lock
  [post_title] => Green Fabric Operator Chair Aluminium Base [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => green-fabric-operator-chair-aluminium-base [to_ping] => [pinged] => [post_modified] => 2019-05-21 13:47:43 [post_modified_gmt] => 2019-05-21 12:47:43 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13601 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 13612 [post_author] => 4 [post_date] => 2019-05-21 13:53:46 [post_date_gmt] => 2019-05-21 12:53:46 [post_content] => This chair offers ergonomics, value for money, style and durability.
  • Height Adjustable
  • Back Tilt Lock
  [post_title] => Green Operator Chair with Black Base [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => green-operator-chair-with-black-base [to_ping] => [pinged] => [post_modified] => 2019-05-21 13:53:46 [post_modified_gmt] => 2019-05-21 12:53:46 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13612 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 13616 [post_author] => 4 [post_date] => 2019-05-21 14:43:39 [post_date_gmt] => 2019-05-21 13:43:39 [post_content] => Light Oak Circular Table with 4 Chairs
  • Light Oak Table with Chrome Post Legs
  • Central Cut Out on Table for Wire Access
  • 4 Stackable Green Conference Chairs
[post_title] => Light Oak Circular Table with 4 Chairs [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => light-oak-circular-table-with-4-chairs [to_ping] => [pinged] => [post_modified] => 2019-05-21 14:45:17 [post_modified_gmt] => 2019-05-21 13:45:17 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13616 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 13619 [post_author] => 4 [post_date] => 2019-05-22 16:08:12 [post_date_gmt] => 2019-05-22 15:08:12 [post_content] => Linking Compact Chairs
  • Linking Clip Attached
Orders of 150 or more £7+ VAT each  or £9.99+VAT each [post_title] => Linking Compact Chairs [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => linking-compact-chairs [to_ping] => [pinged] => [post_modified] => 2019-05-22 16:58:39 [post_modified_gmt] => 2019-05-22 15:58:39 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13619 [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] => 13559 [post_author] => 4 [post_date] => 2019-05-20 14:01:35 [post_date_gmt] => 2019-05-20 13:01:35 [post_content] => Black Le Corbusier Style 2 Seater Sofa [post_title] => Black Le Corbusier Style 2 Seater Sofa [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-le-corbusier-style-2-seater-sofa [to_ping] => [pinged] => [post_modified] => 2019-05-20 14:01:35 [post_modified_gmt] => 2019-05-20 13:01:35 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13559 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 172 [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 ) )