Special Offers

Showing 1–6 of 40 results

6
6
7
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 (21)
) 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] => special-offers
        )

    [query_vars] => Array
        (
            [product_cat] => special-offers
            [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] => special-offers
        )

    [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] => special-offers
                                )

                            [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] => special-offers
                                )

                            [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] => 21
            [name] => Special Offers
            [slug] => special-offers
            [term_group] => 0
            [term_taxonomy_id] => 21
            [taxonomy] => product_cat
            [description] => 
            [parent] => 0
            [count] => 40
            [filter] => raw
        )

    [queried_object_id] => 21
    [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 (21)
) 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] => 9436
                    [post_author] => 7
                    [post_date] => 2018-08-01 15:54:58
                    [post_date_gmt] => 2018-08-01 14:54:58
                    [post_content] => This is a modern looking wave shaped desk in a beech finish with cantilever legs and two access ports.
  • Beech Wave Desk
  • Two Access Ports
  • Grey Cantilever Leg
  • Left Hand And Right Hand Available
  • 1 x Left Hand 3 x Right Hand
[post_title] => Beech Wave Desk With Cantilever Leg [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => beech-wave-desk-cantilever [to_ping] => [pinged] => [post_modified] => 2018-08-14 11:55:05 [post_modified_gmt] => 2018-08-14 10:55:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9436 [menu_order] => 8 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 4291 [post_author] => 4 [post_date] => 2017-01-12 17:41:59 [post_date_gmt] => 2017-01-12 17:41:59 [post_content] =>
  • Orangebox Joy Chair Black Edition
  • Synchronous Movement Mechanism
  • Seat Depth Adjustment
  • Height Adjustable Arms
  • Black Nylon Base
  • Xtreme Plus High Quality Fabric
[post_title] => Orangebox Joy Chair Black Edition [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-joy-chair-black-edition [to_ping] => [pinged] => [post_modified] => 2018-08-07 12:11:08 [post_modified_gmt] => 2018-08-07 11:11:08 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=4291 [menu_order] => 16 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 9773 [post_author] => 4 [post_date] => 2018-09-03 11:11:26 [post_date_gmt] => 2018-09-03 10:11:26 [post_content] =>
  • Orangebox Joy Chair Navy
  • Synchronous Movement Mechanism
  • Seat Depth Adjustment
  • Height Adjustable Arms
  • Black Nylon Base
  • Xtreme Plus High Quality Fabric
[post_title] => Orangebox Joy Chair Navy [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-joy-chair-navy [to_ping] => [pinged] => [post_modified] => 2018-09-03 11:19:07 [post_modified_gmt] => 2018-09-03 10:19:07 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9773 [menu_order] => 16 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 6084 [post_author] => 117 [post_date] => 2017-08-30 11:26:32 [post_date_gmt] => 2017-08-30 10:26:32 [post_content] => VERCO Graphite Salt and Pepper Chair VERCO was founded in 1912 and is known for it's quality.
  • Mesh back that wraps around your back
  • Durable arm pads
  • Think foam seat-pad
  • 5 star base
  • Height adjustable
  • Back lock
  • Great Price
VERCO Graphite Salt and Pepper Chair Is the perfect ergonomic chair for keeping your back health in check.
Lower Price when bought in bulk. Lower Price when bought with desk. Other furniture in different styles, colours and sizes available. Matching range of furniture options available. Feel free to call us on 01244 389111 if you have questions about this product. [post_title] => VERCO Graphite Salt and Pepper Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => verco-blue-salt-and-pepper-chair [to_ping] => [pinged] => [post_modified] => 2018-09-07 09:44:34 [post_modified_gmt] => 2018-09-07 08:44:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6084 [menu_order] => 18 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 6169 [post_author] => 117 [post_date] => 2017-09-01 09:57:08 [post_date_gmt] => 2017-09-01 08:57:08 [post_content] =>
  • Black Senator Sprint Leather Chair
  • Height adjustable arms
  • Designed for simplicity and ease of use with an understated style,
  • Sprint is a high performance, high comfort task chair.
  • Featuring a new synchro-mechanism, seat slide and back height adjustment
  • High quality real leather
  • Chrome base
[post_title] => Black Senator Sprint Leather Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-senator-sprint-leather-chair [to_ping] => [pinged] => [post_modified] => 2018-09-17 16:49:41 [post_modified_gmt] => 2018-09-17 15:49:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/seating/black-senator-sprint-leather-chair/ [menu_order] => 23 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 6665 [post_author] => 117 [post_date] => 2017-10-24 13:56:22 [post_date_gmt] => 2017-10-24 12:56:22 [post_content] => Orangebox Joy Black Leather Chair with Mesh Back
  • Leather Seat-pad
  • Chrome Base
  • Mesh Back
  • Back Lock
  • Tension Control
  • Height adjustment
Price reflects condition - wear on side of mesh back The Black Leather and Mesh Orangebox Joy Is the perfect ergonomic chair for taking your back health seriously. Lower Price when bought in bulk. Lower Price when bought with a desk Feel free to call us on 01244 389111 if you have questions or would like to order this product(s) [post_title] => Orangebox Joy Black Leather Chair with Mesh Back [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-joy-black-leather-chair-with-mesh-back [to_ping] => [pinged] => [post_modified] => 2018-09-07 13:32:30 [post_modified_gmt] => 2018-09-07 12:32:30 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6665 [menu_order] => 24 [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] => 9436 [post_author] => 7 [post_date] => 2018-08-01 15:54:58 [post_date_gmt] => 2018-08-01 14:54:58 [post_content] => This is a modern looking wave shaped desk in a beech finish with cantilever legs and two access ports.
  • Beech Wave Desk
  • Two Access Ports
  • Grey Cantilever Leg
  • Left Hand And Right Hand Available
  • 1 x Left Hand 3 x Right Hand
[post_title] => Beech Wave Desk With Cantilever Leg [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => beech-wave-desk-cantilever [to_ping] => [pinged] => [post_modified] => 2018-08-14 11:55:05 [post_modified_gmt] => 2018-08-14 10:55:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9436 [menu_order] => 8 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 40 [max_num_pages] => 7 [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] => cd1087414dff453a1c32218c86a6cb3e [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 ) )