Interstuhl

Buy second hand / used Interstuhl office furniture.

Showing all 4 results

4
4
1
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 (2512)
) 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] => office-furniture-brands/used-interstuhl-office-furniture
        )

    [query_vars] => Array
        (
            [product_cat] => used-interstuhl-office-furniture
            [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] => used-interstuhl-office-furniture
        )

    [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] => used-interstuhl-office-furniture
                                )

                            [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] => used-interstuhl-office-furniture
                                )

                            [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] => 2512
            [name] => Interstuhl
            [slug] => used-interstuhl-office-furniture
            [term_group] => 0
            [term_taxonomy_id] => 2512
            [taxonomy] => product_cat
            [description] => Buy second hand / used Interstuhl office furniture.
            [parent] => 2495
            [count] => 4
            [filter] => raw
        )

    [queried_object_id] => 2512
    [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 (2512)
) 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] => 13872
                    [post_author] => 4
                    [post_date] => 2019-06-05 14:47:59
                    [post_date_gmt] => 2019-06-05 13:47:59
                    [post_content] => Interstuhl Soft Leather Chair Soft Grey

Upholstered in Soft Grey Leather on a Black Frame

£55 EACH WHEN YOU BUY 4 OR MORE

£89 EACH WHEN YOU BUY UNDER 4 OF THEM
                    [post_title] => Interstuhl Soft Leather Chair Soft Grey
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => interstuhl-soft-leather-chair-soft-grey
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-10-02 15:33:39
                    [post_modified_gmt] => 2019-10-02 14:33:39
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13872
                    [menu_order] => 160
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 13873
                    [post_author] => 4
                    [post_date] => 2019-06-05 15:04:19
                    [post_date_gmt] => 2019-06-05 14:04:19
                    [post_content] => Interstuhl Soft Leather Chair Fudge

Upholstered in Fudge Leather on a White Frame
                    [post_title] => Interstuhl Soft Leather Chair Fudge
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => interstuhl-soft-leather-chair-fudge
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-10-02 15:33:29
                    [post_modified_gmt] => 2019-10-02 14:33:29
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13873
                    [menu_order] => 161
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [2] => WP_Post Object
                (
                    [ID] => 12736
                    [post_author] => 4
                    [post_date] => 2019-03-26 09:05:43
                    [post_date_gmt] => 2019-03-26 09:05:43
                    [post_content] => Interstuhl Axos 364A hiback Black Leather

Management swivel
armchair high backrest, armrests,
5 star base with castor

An emotional and objective seat of intelligence. For people who identify with reducing things to the beauty of the essential form, but still generous in the details. People who want to have all the comforts beneath them. There are many occasions for lying back to think about things during the day - to sort your ideas or to find the peace and quiet to concentrate on the issue, escape the hectic pace for a moment. It is in fact critical that you do. Dynamic seating frees your head too.
                    [post_title] => Interstuhl Axos 364A hiback Black Leather
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => interstuhl-axos-364a-hiback-black-leather
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-10-04 17:14:11
                    [post_modified_gmt] => 2019-10-04 16:14:11
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=12736
                    [menu_order] => 224
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [3] => WP_Post Object
                (
                    [ID] => 10653
                    [post_author] => 4
                    [post_date] => 2018-12-12 14:39:17
                    [post_date_gmt] => 2018-12-12 14:39:17
                    [post_content] => Interstuhl Mesh Back Office Chair Black
  • Arm Height Adjustment
  • Seat Height Adjustment
  • Back Tilt and Lock
[post_title] => Interstuhl Mesh Back Office Chair Black [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => interstuhl-mesh-back-office-chair-black [to_ping] => [pinged] => [post_modified] => 2019-10-02 15:33:53 [post_modified_gmt] => 2019-10-02 14:33:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10653 [menu_order] => 285 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 4 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 13872 [post_author] => 4 [post_date] => 2019-06-05 14:47:59 [post_date_gmt] => 2019-06-05 13:47:59 [post_content] => Interstuhl Soft Leather Chair Soft Grey Upholstered in Soft Grey Leather on a Black Frame £55 EACH WHEN YOU BUY 4 OR MORE £89 EACH WHEN YOU BUY UNDER 4 OF THEM [post_title] => Interstuhl Soft Leather Chair Soft Grey [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => interstuhl-soft-leather-chair-soft-grey [to_ping] => [pinged] => [post_modified] => 2019-10-02 15:33:39 [post_modified_gmt] => 2019-10-02 14:33:39 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=13872 [menu_order] => 160 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 4 [max_num_pages] => 1 [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] => 6c3cce0128607cb1bf3172fb6fde9638 [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 ) )