Buy second hand / used Tensa Konrad 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 (2522) ) 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-tensa-konrad-office-furniture ) [query_vars] => Array ( [product_cat] => used-tensa-konrad-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-tensa-konrad-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-tensa-konrad-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-tensa-konrad-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] => 2522 [name] => Tensa Konrad [slug] => used-tensa-konrad-office-furniture [term_group] => 0 [term_taxonomy_id] => 2522 [taxonomy] => product_cat [description] => Buy second hand / used Tensa Konrad office furniture. [parent] => 2495 [count] => 1 [filter] => raw ) [queried_object_id] => 2522 [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 (2522) ) 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] => 9139 [post_author] => 4 [post_date] => 2018-06-29 12:06:43 [post_date_gmt] => 2018-06-29 11:06:43 [post_content] =>
- Fixed Arms
- Real Black Leather
- Chrome Style Frame
- Please enquire for delivery if needed.
- Fixed Arms
- Real Black Leather
- Chrome Style Frame
- Please enquire for delivery if needed.