Showing 1–6 of 52 results
6
6
9
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 (21) ) 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 wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
WP_Query Object
(
[query] => Array
(
[product_cat] => special-offers
)
[query_vars] => Array
(
[product_cat] => special-offers
[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] => 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] => special-offers
)
[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] => special-offers
)
[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] => special-offers
)
[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] => 21
[name] => Special Offers
[slug] => special-offers
[term_group] => 0
[term_taxonomy_id] => 21
[taxonomy] => product_cat
[description] =>
[parent] => 0
[count] => 52
[filter] => raw
)
[queried_object_id] => 21
[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 (21)
) 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 wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 6
[posts] => Array
(
[0] => WP_Post Object
(
[ID] => 12645
[post_author] => 4
[post_date] => 2019-03-20 10:36:20
[post_date_gmt] => 2019-03-20 10:36:20
[post_content] => KI cream 3 drawer side filer, ideal for any office environment. Ideal for using with A4 ad Foolscap hanging files and includes lock.
Features
- Side Filer / Filing Cabinet
- Used, in excellent condition
- Lockable, with keys provided
- 3 drawers / compartments
- White colour
- Dimensions: Height 1150mm x Width 1100mm x Depth 460mm
- Ideal for office or home for storing files, folders, personal or confidential documents
- Filing Bars included so can be used for A4 and Foolscap hanging files
- Anti-tilt
- Large load capacity
- Levelling feet included
Features
- 2 Adjustable shelves
- Sliding doors to save space
- Lockable provided with key
- 3rd shelf can be purchased for £12+VAT
- £105+Vat when Bought with Slimline Pedestal
- Twin Port Holes for Cable Access
- Desk dimensions 1200x600mm
- Maple effect desk top
- Angled legs
- Central port hole for cable management
Desk Features
- Used, in excellent condition throughout.
- Rectangular desk shape, large size 2m width.
- Includes matching 3 drawer lockable under desk pedestal.
- Light wood (beech) finish with light grey metal legs.
- Height Range: 620mm to 920mm.
- Dimensions: Width 2000mm x Depth 1000mm (200cm x 100cm).
- Large supply of stock - multi buy discounts available.
Features - Herman Miller Aeron
- Used, in excellent condition (refurbished)
- Herman Miller Aeron Mesh Office Chair
- Graphite mesh
- Size B
- Adjustable padded arms
- Fully refurbished
- Available with lumbar support at £325 +VAT
- 12 Month Warranty
- 4 different versions available: 1. No lumber support or forward tilt. 2. With lumber support / no forward tilt. 3. With forward tilt / no lumber. 4. With forward tilt and lumber support.
Features
- Side Filer / Filing Cabinet
- Used, in excellent condition
- Lockable, with keys provided
- 3 drawers / compartments
- White colour
- Dimensions: Height 1150mm x Width 1100mm x Depth 460mm
- Ideal for office or home for storing files, folders, personal or confidential documents
- Filing Bars included so can be used for A4 and Foolscap hanging files
- Anti-tilt
- Large load capacity
- Levelling feet included
