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] => 16
)
[operator] => AND
)
)
[wpse18703_title] => Voysey design carpet
[post__not_in] => Array
(
[0] => 24186
)
)
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 (24186) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (16)
AND object_id = wp_posts.ID
) = 1
) 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 '%Voysey design%') OR (wp_posts.post_title LIKE '%design carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Voysey design%') + (wp_posts.post_title LIKE '%design carpet%')) DESC LIMIT 0, 10
9504
Heriz design carpet
Contemporary
390 x 312 cm 12’9” x 10’2”
£6,500
9502
Donegal Arts and Craft design carpet
Contemporary
381 x 318 cm 12’6” x 10’5”
£6,200
9503
Bidjar Garrus design carpet
Contemporary
310 x 268 cm 10’2” x 8’9”
£5,500
8065
Classical Tabriz design carpet
Contemporary
357 x 279 cm 11’8” x 9’1”
£9,500
6066
Mamluk design carpet
Contemporary
302 x 205 cm 9’10” x 6’8”
£4,200
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] => 16
)
)
)
[wpse18703_title] => Voysey design carpet
[post__not_in] => Array
(
[0] => 24186
[1] => 24404
[2] => 24375
[3] => 24370
[4] => 19861
[5] => 22403
)
)
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 (24186,24404,24375,24370,19861,22403) AND (
wp_term_relationships.term_taxonomy_id IN (16)
) 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 '%Voysey design%') OR (wp_posts.post_title LIKE '%design carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Voysey design%') + (wp_posts.post_title LIKE '%design carpet%')) DESC LIMIT 0, 10
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] => up to £5,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 16
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 24186
[1] => 24404
[2] => 24375
[3] => 24370
[4] => 19861
[5] => 22403
)
)
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 (24186,24404,24375,24370,19861,22403) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (16)
AND object_id = wp_posts.ID
) = 1
) AND (
( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value = 'instock' )
AND
( mt1.meta_key = 'price_guide' AND mt1.meta_value = 'up to £5,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
8882
Ziegler carpet
Contemporary
358 x 266 cm 11’8” x 8’8”
£3,500
9138
Modern Sultanabad carpet
Contemporary
280 x 183 cm 9’2” x 6’
£4,150
7803
Modern Kilim rug
Contemporary
288 x 210 cm 9’5” x 6’10”
£950
7804
Modern Kilim rug
Contemporary
302 x 211 cm 9’10” x 6’11”
£950
3676
Agra carpet
Contemporary
302 x 249 cm 9’10” x 8’2”
£3,500
