Showing 1–6 of 28 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 (713) ) 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_tag] => new-storage
)
[query_vars] => Array
(
[product_tag] => new-storage
[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_tag
[term] => new-storage
)
[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_tag
[terms] => Array
(
[0] => new-storage
)
[field] => slug
[operator] => IN
[include_children] => 1
)
)
[relation] => AND
[table_aliases:protected] => Array
(
[0] => wp_term_relationships
)
[queried_terms] => Array
(
[product_tag] => Array
(
[terms] => Array
(
[0] => new-storage
)
[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] => 713
[name] => New Storage
[slug] => new-storage
[term_group] => 0
[term_taxonomy_id] => 713
[taxonomy] => product_tag
[description] =>
[parent] => 0
[count] => 28
[filter] => raw
)
[queried_object_id] => 713
[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 (713)
) 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] => 8102
[post_author] => 144
[post_date] => 2018-06-12 14:40:49
[post_date_gmt] => 2018-06-12 13:40:49
[post_content] => Beech MFC office storage cupboards available in various different sizes, featuring metal handles and height adjustable shelves as well as hinged keys to securely lock the unit.
- In new condition
- Solid 18mm back side and panels
- 18mm height adjustable shelves included
- Lockable and supplied with hinged keys
- Metal handles
- Part of the Endurance range
Cupboard Sizes Available
- Height 730mm/1200mm/1800mm x Width 800mm x Depth 450mm
- In new condition
- Ball bearing runners on all drawers
- Lockable with hinged keys
- Hinged keys
- 2 drawer and slimline models also available
- Part of the Endurance range
- H650mm x W300mm x D500mm
- In new condition
- Comes complete with 4 shelves
- Lockable with brushed metal handles
- Available in 2 colours - crown cut oak or American black walnut
- Matching desks and boardroom table available
- H1800mm x W800mm x D450mm
- In new condition
- Ball bearing runners on all drawers
- Lockable with hinged keys
- Metal handles
- Hinged keys
- Part of the Endurance range
- Other sizes also available
- H730mm x D438mm x D600mm
- In new condition
- Light Oak or Beech finishes
- Ball bearing runners on all drawers
- Lockable with hinged keys
- Metal handles
- Hinged keys
- Part of the Endurance range
- Other sizes also available
- Height 730mm x Width 438mm x Depth 600mm
- In new condition
- Desk high double door storage cupboard
- Comes complete with 1 shelf
- Lockable with brushed metal handles
- Available in 2 colours
- Matching desks and boardroom table available
- Height 730mm x Width 800mm x Depth 450mm
- In new condition
- Solid 18mm back side and panels
- 18mm height adjustable shelves included
- Lockable and supplied with hinged keys
- Metal handles
- Part of the Endurance range
Cupboard Sizes Available
- Height 730mm/1200mm/1800mm x Width 800mm x Depth 450mm
