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] => Arts and Crafts design carpet
[post__not_in] => Array
(
[0] => 26486
)
)
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 (26486) 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 '%Arts and%') OR (wp_posts.post_title LIKE '%and Crafts%') OR (wp_posts.post_title LIKE '%Crafts design%') OR (wp_posts.post_title LIKE '%design carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Arts and%') + (wp_posts.post_title LIKE '%and Crafts%') + (wp_posts.post_title LIKE '%Crafts design%') + (wp_posts.post_title LIKE '%design carpet%')) DESC LIMIT 0, 10
9814
Arts and Crafts design carpet
Contemporary
391 x 300 cm 12’9” x 9’10”
£7,800
9809
Arts and Crafts design carpet
Contemporary
320 x 250 cm 10’5” x 8’2”
£5,300
9807
Arts and Crafts design carpet
Contemporary
270 x 220 cm 8’10” x 7’2”
£3,950
9815
Arts and Crafts design carpet
Contemporary
290 x 200 cm 9’6” x 6’6”
£3,850
9810
Arts and Crafts design carpet
Contemporary
300 x 200 cm 9’10” x 6’6”
£3,950
9811
Arts and Crafts design carpet
Contemporary
320 x 218 cm 10’5” x 7’1”
£4,600
9771
Arts and Crafts design square carpet
Contemporary
286 x 260 cm 9’4” x 8’6”
£5,500
10260
Voysey design carpet
Contemporary
331 x 261 cm 10’10” x 8’6”
£5,650
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] => Arts and Crafts design carpet
[post__not_in] => Array
(
[0] => 26486
[1] => 26180
[2] => 26182
[3] => 26476
[4] => 26478
[5] => 26480
[6] => 26484
[7] => 26562
[8] => 27934
)
)
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 (26486,26180,26182,26476,26478,26480,26484,26562,27934) 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 '%Arts and%') OR (wp_posts.post_title LIKE '%and Crafts%') OR (wp_posts.post_title LIKE '%Crafts design%') OR (wp_posts.post_title LIKE '%design carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Arts and%') + (wp_posts.post_title LIKE '%and Crafts%') + (wp_posts.post_title LIKE '%Crafts design%') + (wp_posts.post_title LIKE '%design carpet%')) DESC LIMIT 0, 10
9808
Arts and Crafts design rug
Contemporary
210 x 148 cm 6’10” x 4’10”
£2,350
7219
Arts and Crafts carpet
Contemporary
307 x 247 cm 10’ x 8’1”
£5,800