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] => 23
)
[operator] => AND
)
)
[wpse18703_title] => Antique Heriz runner
[post__not_in] => Array
(
[0] => 29201
)
)
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 (29201) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (23)
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 '%Antique Heriz%') OR (wp_posts.post_title LIKE '%Heriz runner%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Heriz%') + (wp_posts.post_title LIKE '%Heriz runner%')) DESC LIMIT 0, 10
8117
Antique Heriz runner
Circa 1920
328 x 102 cm 10’9” x 3’4”
£3,400
9770
Antique Heriz runner
Circa 1915
405 x 105 cm 13’3” x 3’5”
£3,850
9528
Rare Antique Heriz runner
Circa 1890
578 x 95 cm 18’11” x 3’1”
£15,500
10300
Rare Narrow Antique Heriz runner
Circa 1890
316 x 65 cm 10’4” x 2’1”
£3,950
9233
Antique Heriz runner
Circa 1930
450 x 80 cm 14’9” x 2’7”
£4,200
5802
Antique Heriz runner
Circa 1910
419 x 91 cm 13’8” x 2’11”
£5,600
5624
Antique Heriz runner
Circa 1910
540 x 110 cm 17’8” x 3’7”
£7,800
8203
Antique Heriz runner
Circa 1910
550 x 105 cm 18’ x 3’5”
£6,500
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] => 23
)
)
)
[wpse18703_title] => Antique Heriz runner
[post__not_in] => Array
(
[0] => 29201
[1] => 22800
[2] => 26297
[3] => 28622
[4] => 29116
[5] => 29211
[6] => 23463
[7] => 19472
[8] => 21873
)
)
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 (29201,22800,26297,28622,29116,29211,23463,19472,21873) AND (
wp_term_relationships.term_taxonomy_id IN (23)
) 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 '%Antique Heriz%') OR (wp_posts.post_title LIKE '%Heriz runner%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Heriz%') + (wp_posts.post_title LIKE '%Heriz runner%')) 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] => £5,000 to £10,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 23
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 29201
[1] => 22800
[2] => 26297
[3] => 28622
[4] => 29116
[5] => 29211
[6] => 23463
[7] => 19472
[8] => 21873
)
)
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 (29201,22800,26297,28622,29116,29211,23463,19472,21873) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (23)
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 = '£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
10495
Antique Malayer runner
Circa 1900
620 x 98 cm 20’4” x 3’2”
£10,000
10496
Rare Antique Baktiari runner
Circa 1890
393 x 96 cm 12’10” x 3’1”
£5,850
