Best Sellers

Showing 1–6 of 26 results

6
6
5
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 (1037)
) 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] => best-sellers
        )

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

    [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] => best-sellers
                                )

                            [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] => best-sellers
                                )

                            [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] => 1037
            [name] => Best Sellers
            [slug] => best-sellers
            [term_group] => 0
            [term_taxonomy_id] => 1037
            [taxonomy] => product_cat
            [description] => 
            [parent] => 0
            [count] => 26
            [filter] => raw
        )

    [queried_object_id] => 1037
    [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 (1037)
) 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] => 6923
                    [post_author] => 117
                    [post_date] => 2017-12-16 12:35:01
                    [post_date_gmt] => 2017-12-16 12:35:01
                    [post_content] => This white curved front 3 drawer pedestal is a stylish yet practical addition to any workspace.

Features

  • White Curved Front 3 Drawer Pedestal
  • Two Drawers with one Filing Drawer
  • Lockable and provided with key
  • Castors are fitted so the pedestal is mobile and easily to move
  • £39+VAT  each when you buy 20 or more
[post_title] => White Curved Front 3 Drawer Pedestal [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => white-curved-front-3-drawer-pedestal [to_ping] => [pinged] => [post_modified] => 2019-10-08 11:20:03 [post_modified_gmt] => 2019-10-08 10:20:03 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6923 [menu_order] => 88 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 7901 [post_author] => 4 [post_date] => 2018-04-27 14:16:55 [post_date_gmt] => 2018-04-27 13:16:55 [post_content] => Elite Kassini rectangular desk in walnut with pedestal, however, the price shown is for the desk only. The desk includes modern silver legs and integrated cable management.

Features

  • Price shown for desk only
  • Can be purchased with pedestal as shown for £119 + vat
  • Top quality UK manufactured item
  • 25mm worktops with a 2mm impact resistant edge trim
  • Also available with a white top
  • Standard silver finish leg with integrated cable management
  • Integrated cable tray which doubles as a modesty panel
  • Two integrated cable ports
  • Adjustable feet for uneven floors
  • Compatible with all pedestal and storage options
[post_title] => Elite Kassini Rectangular Desk in Walnut with Pedestal [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => elite-kassini-rectangular-desk-walnut [to_ping] => [pinged] => [post_modified] => 2019-10-02 15:32:12 [post_modified_gmt] => 2019-10-02 14:32:12 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7901 [menu_order] => 221 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => 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 £1030 RRP

Aeron Chair Features

  • Herman Miller Aeron Chair
  • Graphite mesh
  • Size B
  • Adjustable padded arms
  • Fully refurbished
  • Available with lumbar support at £325 +VAT
  • 12 Month Warranty
[post_title] => Herman Miller Aeron Designer Office Chair in Graphite / Mesh. Size B [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => herman-miller-aeron-designer-office-chair-graphite-mesh-size-b [to_ping] => [pinged] => [post_modified] => 2019-10-08 11:38:14 [post_modified_gmt] => 2019-10-08 10:38:14 [post_content_filtered] => [post_parent] => 0 [guid] => http://79.170.44.83/newcityused.com/?post_type=product&p=291 [menu_order] => 9 [post_type] => product [post_mime_type] => [comment_count] => 2 [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 Salt N Pepper Task / Office Chair in Graphite, With Arms, Wheels [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-10-03 10:01:41 [post_modified_gmt] => 2019-10-03 09:01:41 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6084 [menu_order] => 48 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 7243 [post_author] => 4 [post_date] => 2018-02-02 09:57:17 [post_date_gmt] => 2018-02-02 09:57:17 [post_content] => The Orangebox Go Swivel Chair in Black Leather is a classic operator style chair that's ideal for offices.
  • Black leather
  • Adjustable arms
  • Swivel base
  • Height adjustable
  • Also a popular choice to be used as a conference room chair
Used Second Hand Orangebox Go Designer Black Leather Office Chair, Adjustable Arms. [post_title] => Orangebox Go Designer Black Leather Office Chair, Adjustable Arms, Swivel [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => orangebox-go-swivel-chair-in-black-leather [to_ping] => [pinged] => [post_modified] => 2019-10-08 13:40:42 [post_modified_gmt] => 2019-10-08 12:40:42 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7243 [menu_order] => 50 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => 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
Used / Second Hand Senator Sprint Black Leather Office Chair, With Arms, Adjustable. [post_title] => Senator Sprint Black Leather Office Chair, With Adjustable Arms, Seat Slide & Back Height [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] => 2019-10-08 13:37:15 [post_modified_gmt] => 2019-10-08 12:37:15 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/seating/black-senator-sprint-leather-chair/ [menu_order] => 149 [post_type] => product [post_mime_type] => [comment_count] => 2 [filter] => raw ) ) [post_count] => 6 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 6923 [post_author] => 117 [post_date] => 2017-12-16 12:35:01 [post_date_gmt] => 2017-12-16 12:35:01 [post_content] => This white curved front 3 drawer pedestal is a stylish yet practical addition to any workspace.

Features

  • White Curved Front 3 Drawer Pedestal
  • Two Drawers with one Filing Drawer
  • Lockable and provided with key
  • Castors are fitted so the pedestal is mobile and easily to move
  • £39+VAT  each when you buy 20 or more
[post_title] => White Curved Front 3 Drawer Pedestal [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => closed [post_password] => [post_name] => white-curved-front-3-drawer-pedestal [to_ping] => [pinged] => [post_modified] => 2019-10-08 11:20:03 [post_modified_gmt] => 2019-10-08 10:20:03 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6923 [menu_order] => 88 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 26 [max_num_pages] => 5 [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] => 8300b0c397b2946797350163878015a6 [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 ) )