New Arrivals

Showing 1–6 of 202 results

6
6
34
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') 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] => 
            [static] => 
            [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] => 202
            [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') 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] => 10176
                    [post_author] => 144
                    [post_date] => 2018-10-16 15:45:04
                    [post_date_gmt] => 2018-10-16 14:45:04
                    [post_content] => Black leather armchair

Soft black leather

Fixed cushions

Superb Quality

Robust Contract quality

Would look great in any waiting area, reception or breakout area
                    [post_title] => Black leather armchair
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => black-leather-armchair
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2018-10-16 15:45:05
                    [post_modified_gmt] => 2018-10-16 14:45:05
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10176
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 9964
                    [post_author] => 144
                    [post_date] => 2018-09-13 13:31:49
                    [post_date_gmt] => 2018-09-13 12:31:49
                    [post_content] => This Allermuir host laptop table is a standalone table for use as a laptop support or work surface and is proportioned accordingly, with a weighted stable base and elegant column.
A convenient hand grip to the underside of the edge together with side slides under the base plate allows the user to easily glide the table closer.
[post_title] => Allermuir host laptop table [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => allermuir-host-laptop-table [to_ping] => [pinged] => [post_modified] => 2018-10-04 10:24:56 [post_modified_gmt] => 2018-10-04 09:24:56 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9964 [menu_order] => 1 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 9678 [post_author] => 144 [post_date] => 2018-08-23 11:43:27 [post_date_gmt] => 2018-08-23 10:43:27 [post_content] => Allermuir open white circular coffee table.
  • Polished aluminium base.
  • Circular Top.
Can be purchased with the 2 Allermuir Open Lounge chairs as pictured in Cherry Red Leather for £225 [post_title] => Allermuir open white circular coffee table [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => allermuir-open-white-circular-coffee-table [to_ping] => [pinged] => [post_modified] => 2018-08-29 12:23:31 [post_modified_gmt] => 2018-08-29 11:23:31 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9678 [menu_order] => 2 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 9763 [post_author] => 4 [post_date] => 2018-08-31 16:39:43 [post_date_gmt] => 2018-08-31 15:39:43 [post_content] =>
  • Height Settable
  • Oak Top
  • Metal Frame
[post_title] => Bene Double Wave Height Settable Desk [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bene-double-wave-height-settable-desk [to_ping] => [pinged] => [post_modified] => 2018-08-31 16:39:43 [post_modified_gmt] => 2018-08-31 15:39:43 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9763 [menu_order] => 3 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 9818 [post_author] => 4 [post_date] => 2018-09-05 11:49:11 [post_date_gmt] => 2018-09-05 10:49:11 [post_content] => Reupholstered Black Fabric Operator Chair with Arms
  • Adjustable Back Height
  • Height Adjustment
  • Back Tilt
  • Chrome Base
  • Fixed Arms
  [post_title] => Reupholstered Black Fabric Operator Chair with Arms [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => reupholstered-black-fabric-operator-chair-with-arms [to_ping] => [pinged] => [post_modified] => 2018-09-07 12:57:34 [post_modified_gmt] => 2018-09-07 11:57:34 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=9818 [menu_order] => 4 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 10117 [post_author] => 144 [post_date] => 2018-10-08 16:11:52 [post_date_gmt] => 2018-10-08 15:11:52 [post_content] => Mesh back office chair Height adjustable seat Height adjustable arms Reclining action Lumbar support Dimensions (mm) Seat Height 470 to 560 Seat Width 520 Seat Depth 490 Back Height 670 Back Width 475 Arm Height (from floor) 680 to 840 Overall Width (across arms) 650 [post_title] => Mesh back office chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => mesh-back-office-chair [to_ping] => [pinged] => [post_modified] => 2018-10-08 16:11:53 [post_modified_gmt] => 2018-10-08 15:11:53 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10117 [menu_order] => 5 [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] => 10176 [post_author] => 144 [post_date] => 2018-10-16 15:45:04 [post_date_gmt] => 2018-10-16 14:45:04 [post_content] => Black leather armchair Soft black leather Fixed cushions Superb Quality Robust Contract quality Would look great in any waiting area, reception or breakout area [post_title] => Black leather armchair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => black-leather-armchair [to_ping] => [pinged] => [post_modified] => 2018-10-16 15:45:05 [post_modified_gmt] => 2018-10-16 14:45:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=10176 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 202 [max_num_pages] => 34 [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_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] => 44126da01e151298710e0f762f7e7680 [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 ) )