Buy second hand / used Elite office furniture.
Showing the single result
1
1
1
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 (2527) ) 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] => office-furniture-brands/used-elite-office-furniture ) [query_vars] => Array ( [product_cat] => used-elite-office-furniture [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] => used-elite-office-furniture ) [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] => used-elite-office-furniture ) [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] => used-elite-office-furniture ) [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] => 2527 [name] => Elite [slug] => used-elite-office-furniture [term_group] => 0 [term_taxonomy_id] => 2527 [taxonomy] => product_cat [description] => Buy second hand / used Elite office furniture. [parent] => 2495 [count] => 1 [filter] => raw ) [queried_object_id] => 2527 [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 (2527) ) 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] => 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
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