Seville

Buy second hand / used Seville office furniture.

Showing the single result

1
1
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 (2534)
) 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-seville-office-furniture
        )

    [query_vars] => Array
        (
            [product_cat] => used-seville-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-seville-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-seville-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-seville-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] => 2534
            [name] => Seville
            [slug] => used-seville-office-furniture
            [term_group] => 0
            [term_taxonomy_id] => 2534
            [taxonomy] => product_cat
            [description] => Buy second hand / used Seville office furniture.

            [parent] => 2495
            [count] => 1
            [filter] => raw
        )

    [queried_object_id] => 2534
    [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 (2534)
) 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] => 603
                    [post_author] => 4
                    [post_date] => 2015-07-03 17:26:28
                    [post_date_gmt] => 2015-07-03 16:26:28
                    [post_content] => This leather Seville chair looks super stylish and makes the ideal manager's chair.

The high back provides great levels of comfort whilst the chair provides multiple options to adjust it to suit your needs.

The chrome star base on castors and chrome arms further enhance the looks of this chair which is brand new and has never been used, but available at a fraction of the usual retail price!

Chair Features

  • In new condition
  • Leather
  • Fixed chrome arms with hard-wearing vinyl top
  • Chrome 5 star base
  • Twin lever - height and back adjustable
  • High back with headrest
  • Rear mesh air vent
  • Stylish stitching design
  • Cancelled order - Never been used, the rest are still boxed
New Seville Black Leather Executive Office Chair, High Back, Adjustable, With Arms City Office Furniture offer a wide range of quality new and used office chairs. This is a new leather executive office chair, ergonomic, in black, adjustable, with arms and a swivel base. Buy quality new and used executive chairs from City New & Used Office Furniture. We have UK showrooms in Chester, Hull and Harlow and can deliver within a 50 mile radius of these locations. Free local delivery and installation is available within a 50 mile radius of our branch showrooms. Some exclusions may apply and be subject to a minimum order charge of £250. Please contact us for further details. [post_title] => Seville Black Leather Executive Office Chair, High Back, Adjustable, With Arms (new) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-leather-managers-chair [to_ping] => [pinged] => [post_modified] => 2019-11-28 11:41:55 [post_modified_gmt] => 2019-11-28 11:41:55 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=603 [menu_order] => 157 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 1 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 603 [post_author] => 4 [post_date] => 2015-07-03 17:26:28 [post_date_gmt] => 2015-07-03 16:26:28 [post_content] => This leather Seville chair looks super stylish and makes the ideal manager's chair. The high back provides great levels of comfort whilst the chair provides multiple options to adjust it to suit your needs. The chrome star base on castors and chrome arms further enhance the looks of this chair which is brand new and has never been used, but available at a fraction of the usual retail price!

Chair Features

  • In new condition
  • Leather
  • Fixed chrome arms with hard-wearing vinyl top
  • Chrome 5 star base
  • Twin lever - height and back adjustable
  • High back with headrest
  • Rear mesh air vent
  • Stylish stitching design
  • Cancelled order - Never been used, the rest are still boxed
New Seville Black Leather Executive Office Chair, High Back, Adjustable, With Arms City Office Furniture offer a wide range of quality new and used office chairs. This is a new leather executive office chair, ergonomic, in black, adjustable, with arms and a swivel base. Buy quality new and used executive chairs from City New & Used Office Furniture. We have UK showrooms in Chester, Hull and Harlow and can deliver within a 50 mile radius of these locations. Free local delivery and installation is available within a 50 mile radius of our branch showrooms. Some exclusions may apply and be subject to a minimum order charge of £250. Please contact us for further details. [post_title] => Seville Black Leather Executive Office Chair, High Back, Adjustable, With Arms (new) [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-leather-managers-chair [to_ping] => [pinged] => [post_modified] => 2019-11-28 11:41:55 [post_modified_gmt] => 2019-11-28 11:41:55 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=603 [menu_order] => 157 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 1 [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] => ec4c1479cd24cb028c4e1ce1d08f948b [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 ) )