New Arrivals

Showing 1–6 of 171 results

6
6
29
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 (491)
) 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] => new-arrivals
        )

    [query_vars] => Array
        (
            [product_cat] => new-arrivals
            [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] => new-arrivals
        )

    [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] => new-arrivals
                                )

                            [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] => new-arrivals
                                )

                            [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] => 491
            [name] => New Arrivals
            [slug] => new-arrivals
            [term_group] => 0
            [term_taxonomy_id] => 491
            [taxonomy] => product_cat
            [description] => 
            [parent] => 0
            [count] => 171
            [filter] => raw
        )

    [queried_object_id] => 491
    [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 (491)
) 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] => 18067
                    [post_author] => 4
                    [post_date] => 2020-03-25 16:35:33
                    [post_date_gmt] => 2020-03-25 16:35:33
                    [post_content] => Our blue compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame.

For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish.

Our blue compact chairs are also the ideal choice when you need to provide high volume seating, for example at conferences.

Our compact chairs are also available in purple fabric.

Features
  • Stackable upto 10 classic style banqueting chair
  • Ideal at formal occasion, events, office and village hall
  • Discounts available for large quantities
Dimensions H  900mm W 425mm D 430mm SH 460mm   [post_title] => Blue Compact Stacking Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => blue-compact-stacking-chair [to_ping] => [pinged] => [post_modified] => 2020-03-27 08:52:54 [post_modified_gmt] => 2020-03-27 08:52:54 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18067 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 18137 [post_author] => 324 [post_date] => 2020-03-27 11:03:00 [post_date_gmt] => 2020-03-27 11:03:00 [post_content] => Brown Le Corbusier Style - 2 Seater Good condition   [post_title] => Brown Le Corbusier Style - 2 Seater [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => brown-le-corbusier-style-2-seater [to_ping] => [pinged] => [post_modified] => 2020-03-27 11:06:11 [post_modified_gmt] => 2020-03-27 11:06:11 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18137 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 18138 [post_author] => 324 [post_date] => 2020-03-27 11:06:58 [post_date_gmt] => 2020-03-27 11:06:58 [post_content] => Brown Le Corbusier Style - 3 Seater Good condition   [post_title] => Brown Le Corbusier Style - 3 Seater [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => brown-le-corbusier-style-3-seater [to_ping] => [pinged] => [post_modified] => 2020-03-27 11:07:59 [post_modified_gmt] => 2020-03-27 11:07:59 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18138 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 18133 [post_author] => 324 [post_date] => 2020-03-27 11:00:08 [post_date_gmt] => 2020-03-27 11:00:08 [post_content] => Brown Le Corbusier Style Armchair Good condition   [post_title] => Brown Le Corbusier Style Armchair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => brown-le-corbusier-style-armchair [to_ping] => [pinged] => [post_modified] => 2020-03-27 11:00:09 [post_modified_gmt] => 2020-03-27 11:00:09 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18133 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 18140 [post_author] => 7 [post_date] => 2020-03-27 13:51:23 [post_date_gmt] => 2020-03-27 13:51:23 [post_content] => Our Burgundy and Gold compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame. For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish. Features
  • Stackable upto 10 classic style banqueting chair
  • Ideal at formal occasion, events, office and village hall
  • Discounts available for large quantities
Dimensions H  900mm W 425mm D 430mm SH 460mm [post_title] => Burgundy And Gold Banqueting Chairs [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => burgundy-and-gold-banqueting-chairs [to_ping] => [pinged] => [post_modified] => 2020-03-27 13:51:27 [post_modified_gmt] => 2020-03-27 13:51:27 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18140 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 18127 [post_author] => 7 [post_date] => 2020-03-27 10:59:11 [post_date_gmt] => 2020-03-27 10:59:11 [post_content] => Le Corbusier's LC2 2 seater sofa design from the 1920s remains contemporary and an established icon of modern style more than 80 years on.
  • Chrome Frame
  • Modern Design
  • Red Leather
  • 4 Available
[post_title] => Le Corbusier Style Two Seater Sofa [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => le-corbusier-style-two-seater-sofa [to_ping] => [pinged] => [post_modified] => 2020-03-27 11:01:35 [post_modified_gmt] => 2020-03-27 11:01:35 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18127 [menu_order] => 0 [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] => 18067 [post_author] => 4 [post_date] => 2020-03-25 16:35:33 [post_date_gmt] => 2020-03-25 16:35:33 [post_content] => Our blue compact chairs are stackable and they are ideal for use at a wide variety of events. These chairs are very comfortable and feature padded seatbacks and pads on a silver frame. For weddings and formal events, these chairs can be further dressed in bows and seat covers should you wish. Our blue compact chairs are also the ideal choice when you need to provide high volume seating, for example at conferences. Our compact chairs are also available in purple fabric. Features
  • Stackable upto 10 classic style banqueting chair
  • Ideal at formal occasion, events, office and village hall
  • Discounts available for large quantities
Dimensions H  900mm W 425mm D 430mm SH 460mm   [post_title] => Blue Compact Stacking Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => blue-compact-stacking-chair [to_ping] => [pinged] => [post_modified] => 2020-03-27 08:52:54 [post_modified_gmt] => 2020-03-27 08:52:54 [post_content_filtered] => [post_parent] => 0 [guid] => https://cityusedofficefurniture.co.uk/?post_type=product&p=18067 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 171 [max_num_pages] => 29 [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_privacy_policy] => [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] => 7c31000c4fbfb056bef29b30ff0a3a9b [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 ) )