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] => 25
)
[operator] => AND
)
)
[wpse18703_title] => Antique Hamadan carpet
[post__not_in] => Array
(
[0] => 25863
)
)
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 (25863) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (25)
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 Hamadan%') OR (wp_posts.post_title LIKE '%Hamadan carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Hamadan%') + (wp_posts.post_title LIKE '%Hamadan carpet%')) DESC LIMIT 0, 10
6572
Antique Hamadan carpet
Circa 1910
570 x 296 cm 18’8” x 9’8”
£26,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] => 25
)
)
)
[wpse18703_title] => Antique Hamadan carpet
[post__not_in] => Array
(
[0] => 25863
[1] => 16772
)
)
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 (25863,16772) AND (
wp_term_relationships.term_taxonomy_id IN (25)
) 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 Hamadan%') OR (wp_posts.post_title LIKE '%Hamadan carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Hamadan%') + (wp_posts.post_title LIKE '%Hamadan 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] => over £20,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 25
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 25863
[1] => 16772
)
)
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 (25863,16772) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (25)
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 = 'over £20,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
9950
Rare Antique Ziegler carpet
Circa 1890
532 x 385 cm 17’5” x 12’7”
£95,000
9951
Rarest Antique Ziegler carpet
Circa 1890
550 x 435 cm 18’ x 14’3”
£195,000
9949
Rare Antique Ziegler carpet
Circa 1890
760 x 470 cm 24’11” x 15’5”
£115,000
9436
Rarest Antique Ziegler carpet
Circa 1880
412 x 327 cm 13’6” x 10’8”
£120,000
9707
Rare Antique Ziegler carpet
Circa 1880
416 x 322 cm 13’7” x 10’6”
£45,000
8765
Antique Sultanabad carpet
Circa 1890
361 x 237 cm 11’10” x 7’9”
£ POA
9239
Antique Farahan carpet
Circa 1860
301 x 220 cm 9’10” x 7’2”
£ POA
9683
Antique Tabriz carpet
Circa 1890
457 x 316 cm 14’11” x 10’4”
£22,000
9699
Antique Ushak carpet
Circa 1900
500 x 280 cm 16’4” x 9’2”
£36,000
