Special Offers

Showing 1–6 of 39 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] => 39
            [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] => 11584
                    [post_author] => 144
                    [post_date] => 2019-02-02 13:53:49
                    [post_date_gmt] => 2019-02-02 13:53:49
                    [post_content] => Beech Desk with built in Pedestal
  • Lockable Pedestal Provide With 1 Keys
  • Beech Desk with built in Pedestal and Operator Chair £95 + vat
  [post_title] => Beech Desk with built in Pedestal [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => beech-desk-with-built-in-pedestal [to_ping] => [pinged] => [post_modified] => 2019-02-15 20:51:51 [post_modified_gmt] => 2019-02-15 20:51:51 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11584 [menu_order] => 36 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => 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-01-25 15:38:09 [post_modified_gmt] => 2019-01-25 15:38:09 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/used-storage/ahrend-silver-desk-high-tambour-cupboard-720x800mm/ [menu_order] => 71 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => 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-02-09 13:51:14 [post_modified_gmt] => 2019-02-09 13:51:14 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7981 [menu_order] => 74 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => 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] => 80 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => 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-11 10:32:36 [post_modified_gmt] => 2019-02-11 10:32:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6084 [menu_order] => 101 [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] => 2019-02-06 15:40:06 [post_modified_gmt] => 2019-02-06 15:40:06 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6665 [menu_order] => 102 [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] => 11584 [post_author] => 144 [post_date] => 2019-02-02 13:53:49 [post_date_gmt] => 2019-02-02 13:53:49 [post_content] => Beech Desk with built in Pedestal
  • Lockable Pedestal Provide With 1 Keys
  • Beech Desk with built in Pedestal and Operator Chair £95 + vat
  [post_title] => Beech Desk with built in Pedestal [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => beech-desk-with-built-in-pedestal [to_ping] => [pinged] => [post_modified] => 2019-02-15 20:51:51 [post_modified_gmt] => 2019-02-15 20:51:51 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=11584 [menu_order] => 36 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 39 [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 ) )