Special Offers

Showing 1–6 of 35 results

6
6
6
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] => 35
            [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] => 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] => 2019-02-25 10:26:22 [post_modified_gmt] => 2019-02-25 10:26:22 [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 ) [1] => WP_Post Object ( [ID] => 291 [post_author] => 2 [post_date] => 2015-06-17 10:12:16 [post_date_gmt] => 2015-06-17 09:12:16 [post_content] => Looking for a used Aeron chair? The Herman Miller Aeron Is the perfect ergonomic chair for taking your back health seriously and our used Aeron chairs are excellent value too. When designers Bill Stumpf and Don Chadwick set out to create a chair that was health-positive, cross-performing, inclusively-sized and environmentally sensitive, they arrived at a design unlike the world had ever seen. Aeron demonstrated a pioneering step in ergonomics and material innovation, and provided a comfortable solution without the standard use of foam, fabric or leather. It changed people’s perception of what an office chair could be, and in doing so it soon found a place in popular culture. Graphite Herman Miller Aeron Chair From £999 RRP

Aeron Chair Features

  • Herman Miller Aeron Chair
  • Graphite mesh
  • Size B
  • Adjustable padded arms
  • Fully refurbished - As good as new
  • 12 month warranty
  • Available with lumbar support at £350
  [post_title] => Graphite Herman Miller Aeron Chair [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => herman-miller-aeron-chair [to_ping] => [pinged] => [post_modified] => 2019-03-07 11:33:22 [post_modified_gmt] => 2019-03-07 11:33:22 [post_content_filtered] => [post_parent] => 0 [guid] => http://79.170.44.83/newcityused.com/?post_type=product&p=291 [menu_order] => 30 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => 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] => 2019-02-25 10:25:36 [post_modified_gmt] => 2019-02-25 10:25:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=4291 [menu_order] => 33 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 7148 [post_author] => 4 [post_date] => 2018-01-20 09:28:04 [post_date_gmt] => 2018-01-20 09:28:04 [post_content] => Ahrend Silver Desk High Tambour Cupboard 720x800mm. Ahrend tambour door cabinets are an extremely high quality storage range. Their quality, meticulous finish and flexible layout possibilities mean that Ahrend tambour door cabinets are among the best on the market. Thanks to the wide range of available height dimensions, colour possibilities and tops, Ahrend tambour door cabinets can be combined with all the Ahrend furniture ranges.
  • 1 Adjustable shelf
  • Single sliding door to save space
  • Lockable provided with key, ideal for the new GDPR laws
  • Silver finish wood top
  • Adjustable feet with 20mm range
  • Steel welded carcass with a unique ciranol top
Lower Price when bought with additional items. Alternative sizes available in the same range. Feel free to call your local branch if you have questions or would like to order this product(s) [post_title] => Ahrend Silver Desk High Tambour Cupboard 720x800mm [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => ahrend-silver-tambour-cupboard-2 [to_ping] => [pinged] => [post_modified] => 2019-03-19 10:58:29 [post_modified_gmt] => 2019-03-19 10:58:29 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/used-storage/ahrend-silver-desk-high-tambour-cupboard-720x800mm/ [menu_order] => 108 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 7981 [post_author] => 4 [post_date] => 2018-05-19 11:47:05 [post_date_gmt] => 2018-05-19 10:47:05 [post_content] => Side filing cabinet in a contemporary, industrial grey colour. Mainestream Multi-Units 3 Filing drawers + Top slim media drawer Anti Tilt locking bar
  • Lockable and provided with key
[post_title] => Side Filing Cabinet [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => side-filing-cabinet [to_ping] => [pinged] => [post_modified] => 2019-03-22 14:51:53 [post_modified_gmt] => 2019-03-22 14:51:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7981 [menu_order] => 111 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 10929 [post_author] => 4 [post_date] => 2019-01-02 09:56:45 [post_date_gmt] => 2019-01-02 09:56:45 [post_content] => Retro 4 Drawer filing Cabinet
  • Classic Style
  • More Hard Wearing than Modern Models
  • Full Working Order But are Showing Signs of Wear.
[post_title] => Retro 4 Drawer filing Cabinet [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => retro-4-drawer-filing-cabinet [to_ping] => [pinged] => [post_modified] => 2019-01-02 09:57:58 [post_modified_gmt] => 2019-01-02 09:57:58 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10929 [menu_order] => 115 [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] => 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] => 2019-02-25 10:26:22 [post_modified_gmt] => 2019-02-25 10:26:22 [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 ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 35 [max_num_pages] => 6 [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 ) )