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

    [query_vars] => Array
        (
            [product_cat] => best-sellers
            [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] => 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) 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') 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] => 10670
                    [post_author] => 4
                    [post_date] => 2018-12-13 15:23:23
                    [post_date_gmt] => 2018-12-13 15:23:23
                    [post_content] => Slimline Metal 3 Drawer Pedestal Silver
  • Lockable and Provided with 1 Key
  • Box drawers
[post_title] => Slimline Metal 3 Drawer Pedestal Silver [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => slimline-metal-3-drawer-pedestal-silver [to_ping] => [pinged] => [post_modified] => 2018-12-19 12:03:16 [post_modified_gmt] => 2018-12-19 12:03:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10670 [menu_order] => 63 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => 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 ) [2] => WP_Post Object ( [ID] => 10665 [post_author] => 4 [post_date] => 2018-12-13 15:10:37 [post_date_gmt] => 2018-12-13 15:10:37 [post_content] => Single Door Tambour Cupboard with White Top
  • Lockable
  • One Adjustable Shelf
[post_title] => Single Door Tambour Cupboard with White Top [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => single-door-tambour-cupboard-with-white-top [to_ping] => [pinged] => [post_modified] => 2019-01-09 13:08:52 [post_modified_gmt] => 2019-01-09 13:08:52 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10665 [menu_order] => 75 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 10891 [post_author] => 4 [post_date] => 2018-12-20 16:20:09 [post_date_gmt] => 2018-12-20 16:20:09 [post_content] => Single Door Tambour Cupboard with Opaque Glass Top
  • Lockable
  • One Adjustable Shelf
[post_title] => Single Door Tambour Cupboard with Opaque Glass Top [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => single-door-tambour-cupboard-with-opaque-glass-top [to_ping] => [pinged] => [post_modified] => 2019-01-09 13:08:11 [post_modified_gmt] => 2019-01-09 13:08:11 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10891 [menu_order] => 76 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 10660 [post_author] => 4 [post_date] => 2018-12-13 15:02:31 [post_date_gmt] => 2018-12-13 15:02:31 [post_content] => Single Door Tambour Storage Cupboard
  • Lockable
  • One Adjustable Shelf
[post_title] => Single Door Tambour Storage Cupboard [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => single-door-tambour-storage-cupboard [to_ping] => [pinged] => [post_modified] => 2019-02-06 10:04:05 [post_modified_gmt] => 2019-02-06 10:04:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10660 [menu_order] => 77 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => 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 ) ) [post_count] => 6 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 10670 [post_author] => 4 [post_date] => 2018-12-13 15:23:23 [post_date_gmt] => 2018-12-13 15:23:23 [post_content] => Slimline Metal 3 Drawer Pedestal Silver
  • Lockable and Provided with 1 Key
  • Box drawers
[post_title] => Slimline Metal 3 Drawer Pedestal Silver [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => slimline-metal-3-drawer-pedestal-silver [to_ping] => [pinged] => [post_modified] => 2018-12-19 12:03:16 [post_modified_gmt] => 2018-12-19 12:03:16 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10670 [menu_order] => 63 [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_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] => 1e0d1feef6d3fbd9f684b7d5b74faad7 [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 ) )