Seating

Showing 1–6 of 155 results

6
6
26
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] => 155
            [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] => 9647
                    [post_author] => 4
                    [post_date] => 2018-08-21 15:39:57
                    [post_date_gmt] => 2018-08-21 14:39:57
                    [post_content] => This is an upholstered black fabric armchair, ideal for use in office breakout or reception areas.
                    [post_title] => Black Fabric Reception Armchair
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => black-fabric-reception-armchair
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2018-08-29 13:35:29
                    [post_modified_gmt] => 2018-08-29 12:35:29
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9647
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 9932
                    [post_author] => 4
                    [post_date] => 2018-09-12 13:25:35
                    [post_date_gmt] => 2018-09-12 12:25:35
                    [post_content] => 
  • Upholstered in Soft Touch Faux Leather
  • Brand New (Cancelled order)
  • High Grade Foam for enhanced comfort and durability
[post_title] => Black Leather 3 Seater Sofa [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-leather-3-seater-sofa [to_ping] => [pinged] => [post_modified] => 2018-09-12 13:35:34 [post_modified_gmt] => 2018-09-12 12:35:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9932 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 9813 [post_author] => 4 [post_date] => 2018-09-05 11:39:26 [post_date_gmt] => 2018-09-05 10:39:26 [post_content] =>
  • Swivel Base
  • Real Leather
  • Chrome Base
[post_title] => Black Leather Swan Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-leather-swan-chair [to_ping] => [pinged] => [post_modified] => 2018-09-21 11:40:51 [post_modified_gmt] => 2018-09-21 10:40:51 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9813 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 9637 [post_author] => 4 [post_date] => 2018-08-21 13:38:57 [post_date_gmt] => 2018-08-21 12:38:57 [post_content] => This black office reception area chair has fixed arms and features a contemporary laminated wood, bent frame.
  • Fixed Arms
  • Laminated wood bent frame
[post_title] => Black Reception Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-reception-chair [to_ping] => [pinged] => [post_modified] => 2018-08-29 13:55:42 [post_modified_gmt] => 2018-08-29 12:55:42 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9637 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 9685 [post_author] => 7 [post_date] => 2018-08-23 12:23:58 [post_date_gmt] => 2018-08-23 11:23:58 [post_content] =>
  • Boss Design Alexa Reception Set
  • Two Seat Sofa
  • Two Arm Chairs
  • One Coffee Table
  • Rouge Red Leather
  • Sleek And With An Echo Of Minimalist Design
[post_title] => Boss Design Alexa Reception Set [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => boss-design-alexa-reception-set [to_ping] => [pinged] => [post_modified] => 2018-09-21 11:47:40 [post_modified_gmt] => 2018-09-21 10:47:40 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9685 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 9799 [post_author] => 4 [post_date] => 2018-09-04 15:38:08 [post_date_gmt] => 2018-09-04 14:38:08 [post_content] =>
  • Chrome style frame
  • Black Leather Seat Pad
[post_title] => Boss Design Leather Meeting Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => boss-design-leather-meeting-chair [to_ping] => [pinged] => [post_modified] => 2018-09-04 15:38:08 [post_modified_gmt] => 2018-09-04 14:38:08 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9799 [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] => 9647 [post_author] => 4 [post_date] => 2018-08-21 15:39:57 [post_date_gmt] => 2018-08-21 14:39:57 [post_content] => This is an upholstered black fabric armchair, ideal for use in office breakout or reception areas. [post_title] => Black Fabric Reception Armchair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-fabric-reception-armchair [to_ping] => [pinged] => [post_modified] => 2018-08-29 13:35:29 [post_modified_gmt] => 2018-08-29 12:35:29 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9647 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 155 [max_num_pages] => 26 [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 ) )