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 Shashavan Kelleh
[post__not_in] => Array
(
[0] => 25912
)
)
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 (25912) 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 Shashavan%') OR (wp_posts.post_title LIKE '%Shashavan Kelleh%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Shashavan%') + (wp_posts.post_title LIKE '%Shashavan Kelleh%')) 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
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 25
)
)
)
[wpse18703_title] => Antique Shashavan Kelleh
[post__not_in] => Array
(
[0] => 25912
)
)
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 (25912) 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 Shashavan%') OR (wp_posts.post_title LIKE '%Shashavan Kelleh%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Shashavan%') + (wp_posts.post_title LIKE '%Shashavan Kelleh%')) 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] => 25
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 25912
)
)
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 (25912) 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 = '£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
10285
Antique Tabriz carpet
Circa 1920
368 x 255 cm 12’ x 8’4”
£6,500
10284
Rare Antique Heriz carpet
Circa 1890
266 x 167 cm 8’8” x 5’5”
£7,500
10223
Antique Heriz carpet
Circa 1900
346 x 244 cm 11’4” x 8’
£7,500
9903
Antique Heriz carpet
Circa 1900
324 x 253 cm 10’7” x 8’3”
£6,250
9904
Antique 'Ahar' Heriz carpet
Circa 1910
330 x 246 cm 10’9” x 8’
£6,500
9163
Antique Amritsar rug
Circa 1890
260 x 170 cm 8’6” x 5’6”
£6,950
10073
Antique Bessarabian Kilim
Circa 1920
290 x 243 cm 9’6” x 7’11”
£5,800
9512
Antique Bessarabian Kilim
Circa 1890
270 x 186 cm 8’10” x 6’1”
£9,500
8320
Antique Bessarabian Kilim
Circa 1920
266 x 159 cm 8’8” x 5’2”
£6,200
8321
Antique Bessarabian Kilim
Circa 1890
294 x 192 cm 9’7” x 6’3”
£8,900
