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