Stacking Chairs

Showing 1–6 of 13 results

6
6
3
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 (156)
) 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_tag] => stacking-chairs
        )

    [query_vars] => Array
        (
            [product_tag] => stacking-chairs
            [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_tag
            [term] => stacking-chairs
        )

    [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] => stacking-chairs
                                )

                            [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] => stacking-chairs
                                )

                            [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] => 156
            [name] => Stacking Chairs
            [slug] => stacking-chairs
            [term_group] => 0
            [term_taxonomy_id] => 156
            [taxonomy] => product_tag
            [description] => 
            [parent] => 0
            [count] => 13
            [filter] => raw
        )

    [queried_object_id] => 156
    [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 (156)
) 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] => 7575
                    [post_author] => 4
                    [post_date] => 2018-03-05 10:47:01
                    [post_date_gmt] => 2018-03-05 10:47:01
                    [post_content] => Mobile Stacking Meeting Chair by OCee Design
  • Other colour options available
[post_title] => Mobile Stacking Meeting Chair by OCee Design [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => mobile-stacking-meeting-chair-ocee-design [to_ping] => [pinged] => [post_modified] => 2018-03-28 14:38:36 [post_modified_gmt] => 2018-03-28 13:38:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7575 [menu_order] => 180 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 7504 [post_author] => 4 [post_date] => 2018-02-16 16:37:56 [post_date_gmt] => 2018-02-16 16:37:56 [post_content] => Sky Blue Stacking Chair
  • Stackable up to 4 high
[post_title] => Sky Blue Stacking Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => sky-blue-stacking-chair [to_ping] => [pinged] => [post_modified] => 2018-05-09 16:43:30 [post_modified_gmt] => 2018-05-09 15:43:30 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/seating/sky-blue-stacking-chair/ [menu_order] => 191 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 7470 [post_author] => 4 [post_date] => 2018-02-16 14:33:07 [post_date_gmt] => 2018-02-16 14:33:07 [post_content] => Grey Stackable Meeting Chair with Beech Frame
  • Stackable up to 4 high
[post_title] => Grey Stackable Meeting Chair with Beech Frame [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => grey-stackable-meeting-chair-beech-frame [to_ping] => [pinged] => [post_modified] => 2018-02-16 14:33:07 [post_modified_gmt] => 2018-02-16 14:33:07 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7470 [menu_order] => 194 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 7969 [post_author] => 4 [post_date] => 2018-05-10 12:48:27 [post_date_gmt] => 2018-05-10 11:48:27 [post_content] =>
  • Stackable classic style banqueting chair
  • Ideal at formal occasions and multi use function rooms
  • Blue with Silver Frame
  • Priced to reflect condition
        [post_title] => Blue Compact Stacking Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => purple-compact-stacking-chair-copy [to_ping] => [pinged] => [post_modified] => 2018-05-31 09:52:19 [post_modified_gmt] => 2018-05-31 08:52:19 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/shop/seating/purple-compact-stacking-chair-copy/ [menu_order] => 231 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [4] => WP_Post Object ( [ID] => 7032 [post_author] => 117 [post_date] => 2018-01-10 09:56:22 [post_date_gmt] => 2018-01-10 09:56:22 [post_content] => Stackable classic style banqueting chair •   Ideal at formal occasions and weddings •   Discounts available for large quantities* Dimensions H  900mm W 425mm D 430mm SH 460mm Colour Purple with silver frame Ideal for • Banqueting events • Weddings • Conferences • Parties * Based on orders of 100 chairs or more [post_title] => Purple Compact Stacking Chair [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => purple-compact-stacking-chair [to_ping] => [pinged] => [post_modified] => 2018-03-26 19:08:14 [post_modified_gmt] => 2018-03-26 18:08:14 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7032 [menu_order] => 232 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [5] => WP_Post Object ( [ID] => 6875 [post_author] => 117 [post_date] => 2017-12-09 19:40:24 [post_date_gmt] => 2017-12-09 19:40:24 [post_content] =>
  • Ideal for conferences and training too, G16 Meeting Chair by Orangebox is stackable up to 6 high, making it a space saving solution for the modern office.
  • Real leather seat pad
  • Vibrant blue suede finish padded back rest
  • Chrome cantilever frame
  • Excellent quality chair
[post_title] => G16 Meeting Chair by Orangebox [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => g16-meeting-chair-orangebox [to_ping] => [pinged] => [post_modified] => 2018-09-07 13:26:05 [post_modified_gmt] => 2018-09-07 12:26:05 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=6875 [menu_order] => 429 [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] => 7575 [post_author] => 4 [post_date] => 2018-03-05 10:47:01 [post_date_gmt] => 2018-03-05 10:47:01 [post_content] => Mobile Stacking Meeting Chair by OCee Design
  • Other colour options available
[post_title] => Mobile Stacking Meeting Chair by OCee Design [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => mobile-stacking-meeting-chair-ocee-design [to_ping] => [pinged] => [post_modified] => 2018-03-28 14:38:36 [post_modified_gmt] => 2018-03-28 13:38:36 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=7575 [menu_order] => 180 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 13 [max_num_pages] => 3 [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] => 76260c384b37d4f13161e9387c4da412 [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 ) )