Stools

Showing all 4 results

4
4
1
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 (168)
) 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] => stools
        )

    [query_vars] => Array
        (
            [product_tag] => stools
            [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] => stools
        )

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

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

                            [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] => 168
            [name] => Stools
            [slug] => stools
            [term_group] => 0
            [term_taxonomy_id] => 168
            [taxonomy] => product_tag
            [description] => 
            [parent] => 0
            [count] => 4
            [filter] => raw
        )

    [queried_object_id] => 168
    [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 (168)
) 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] => 12666
                    [post_author] => 4
                    [post_date] => 2019-03-21 11:31:32
                    [post_date_gmt] => 2019-03-21 11:31:32
                    [post_content] => Girsberger Sway Sit Stand Stool

Stand or sit – why not do both? Does your body sometimes tell you that you’ve been sitting for too long? But you don’t really want to stand either? Or would you really like to take the weight off your feet but can’t do your work sitting down? The solution is sway. This stool designed by Burkhard Vogtherr is simple, elegant and healthy. And its uses are almost limit- less: wherever sitting is best avoided and standing can get too strenuous, sway is in its element. What makes sway so special is the fact that its leg is flexibly mounted. You thus automatically adopt a healthy, non-static sitting posture.

RRP £279
                    [post_title] => Girsberger Sway Sit Stand Stool
                    [post_excerpt] => 
                    [post_status] => publish
                    [comment_status] => closed
                    [ping_status] => closed
                    [post_password] => 
                    [post_name] => girsberger-sway-sit-stand-stool
                    [to_ping] => 
                    [pinged] => 
                    [post_modified] => 2019-03-21 11:32:11
                    [post_modified_gmt] => 2019-03-21 11:32:11
                    [post_content_filtered] => 
                    [post_parent] => 0
                    [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=12666
                    [menu_order] => 0
                    [post_type] => product
                    [post_mime_type] => 
                    [comment_count] => 0
                    [filter] => raw
                )

            [1] => WP_Post Object
                (
                    [ID] => 4969
                    [post_author] => 58
                    [post_date] => 2017-03-28 14:41:21
                    [post_date_gmt] => 2017-03-28 13:41:21
                    [post_content] => 
  • Wooden Backed Black Seated Stool
  • Beech wood shaped low level back
  • Black vinyl seat pad
  • Chrome legs and foot rest
  • Shaped chrome base
[post_title] => Wooden Backed Black Seated Stool [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => wooden-backed-black-seated-stool [to_ping] => [pinged] => [post_modified] => 2017-11-08 10:40:25 [post_modified_gmt] => 2017-11-08 10:40:25 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=4969 [menu_order] => 599 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [2] => WP_Post Object ( [ID] => 4689 [post_author] => 58 [post_date] => 2017-03-09 13:50:50 [post_date_gmt] => 2017-03-09 13:50:50 [post_content] => Connection Vent Bar Stool is functional and stylish. Designed by Roger Webb Associates, the Vent has simple, elegant lines that are designed to work in cafe, bar and breakout areas.
  • Connection original product (New RRP £217.00)
  • Clean line design
  • Weight 8kg
[post_title] => Connection Vent Bar Stool [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => connection-vent-bar-stool [to_ping] => [pinged] => [post_modified] => 2018-12-20 11:03:24 [post_modified_gmt] => 2018-12-20 11:03:24 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=4689 [menu_order] => 600 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [3] => WP_Post Object ( [ID] => 4724 [post_author] => 58 [post_date] => 2017-03-13 12:21:24 [post_date_gmt] => 2017-03-13 12:21:24 [post_content] =>
  • Bistro Stool Z Frame Black Seat
  • Chrome Z frame
  • Black vinyl seat
  • Chrome foot rest
  • Ideal for break out areas, bars & kitchens
[post_title] => Bistro Stool Z Frame Black Seat [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => bistro-stool-z-frame-black-seat [to_ping] => [pinged] => [post_modified] => 2018-05-09 17:24:27 [post_modified_gmt] => 2018-05-09 16:24:27 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=4724 [menu_order] => 601 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 4 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 12666 [post_author] => 4 [post_date] => 2019-03-21 11:31:32 [post_date_gmt] => 2019-03-21 11:31:32 [post_content] => Girsberger Sway Sit Stand Stool Stand or sit – why not do both? Does your body sometimes tell you that you’ve been sitting for too long? But you don’t really want to stand either? Or would you really like to take the weight off your feet but can’t do your work sitting down? The solution is sway. This stool designed by Burkhard Vogtherr is simple, elegant and healthy. And its uses are almost limit- less: wherever sitting is best avoided and standing can get too strenuous, sway is in its element. What makes sway so special is the fact that its leg is flexibly mounted. You thus automatically adopt a healthy, non-static sitting posture. RRP £279 [post_title] => Girsberger Sway Sit Stand Stool [post_excerpt] => [post_status] => publish [comment_status] => closed [ping_status] => closed [post_password] => [post_name] => girsberger-sway-sit-stand-stool [to_ping] => [pinged] => [post_modified] => 2019-03-21 11:32:11 [post_modified_gmt] => 2019-03-21 11:32:11 [post_content_filtered] => [post_parent] => 0 [guid] => http://cityusedofficefurniture.co.uk/?post_type=product&p=12666 [menu_order] => 0 [post_type] => product [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 4 [max_num_pages] => 1 [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] => 0e57e500d1218ed5c90f609a55fe2733 [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 ) )