Array
(
[post_type] => product
[post_status] => publish
[posts_per_page] => 10
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => _stock_status
[value] => instock
[compare] => =
[type] => CHAR
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 20
[1] => 16
)
[operator] => AND
)
)
[wpse18703_title] => Kensington Collection
[post__not_in] => Array
(
[0] => 23999
)
)
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.ID NOT IN (23999) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (16,20)
AND object_id = wp_posts.ID
) = 2
) AND (
( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value = 'instock' )
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ((wp_posts.post_title LIKE '%Kensington Collection%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Kensington Collection%')) DESC LIMIT 0, 10
8900
Kensington Collection
Contemporary
363 x 293 cm 11’10” x 9’7”
£6,950
8126
Kensington Collection - Viscose rugs
Contemporary
373 x 274 cm 12’2” x 8’11”
£4,800
Array
(
[post_type] => product
[post_status] => publish
[posts_per_page] => 10
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => _stock_status
[value] => instock
[compare] => =
[type] => CHAR
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 20
[1] => 16
)
)
)
[wpse18703_title] => Kensington Collection
[post__not_in] => Array
(
[0] => 23999
[1] => 24191
[2] => 21858
)
)
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) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1 AND wp_posts.ID NOT IN (23999,24191,21858) AND (
wp_term_relationships.term_taxonomy_id IN (16,20)
) AND (
( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value = 'instock' )
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ((wp_posts.post_title LIKE '%Kensington Collection%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Kensington Collection%')) DESC LIMIT 0, 10
8663
Kensington Collection - Viscose rug
Contemporary
238 x 151 cm 7’9” x 4’11”
£1,700
8072
Kensington Collection - Viscose rug
Contemporary
228 x 162 cm 7’5” x 5’3”
£2,800
Array
(
[post_type] => product
[post_status] => publish
[posts_per_page] => 10
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => _stock_status
[value] => instock
[compare] => =
[type] => CHAR
)
[1] => Array
(
[key] => price_guide
[value] => £5,000 to £10,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 20
[1] => 16
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 23999
[1] => 24191
[2] => 21858
[3] => 22472
[4] => 22475
)
)
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND wp_posts.ID NOT IN (23999,24191,21858,22472,22475) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (16,20)
AND object_id = wp_posts.ID
) = 2
) AND (
( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value = 'instock' )
AND
( mt1.meta_key = 'price_guide' AND mt1.meta_value = '£5,000 to £10,000' )
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
9303
Contemporary Carpet 'Colours'
Contemporary
361 x 275 cm 11’10” x 9’
£5,200
7997
Vintage Distressed carpet
Contemporary
433 x 292 cm 14’2” x 9’6”
£5,750
7998
Vintage Distressed carpet
Contemporary
388 x 298 cm 12’8” x 9’9”
£5,200
7996
Vintage Distressed carpet
Contemporary
405 x 289 cm 13’3” x 9’5”
£5,500
6377
Contemporary Glaze wool and silk carpet
Contemporary
296 x 254 cm 9’8” x 8’3”
£6,300
7694
Modern wool and silk carpet
Contemporary
368 x 272 cm 12’ x 8’11”
£7,500