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 Bakshaish Carpet
[post__not_in] => Array
(
[0] => 29014
)
)
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 (29014) 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 Bakshaish%') OR (wp_posts.post_title LIKE '%Bakshaish Carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Bakshaish%') + (wp_posts.post_title LIKE '%Bakshaish Carpet%')) DESC LIMIT 0, 10
9335
Antique Bakshaish carpet
Circa 1860
588 x 396 cm 19’3” x 12’11”
£75,000
8977
Rare Antique Bakshaish carpet
Circa 1880
437 x 330 cm 14’4” x 10’9”
£52,000
3723
Antique Bakshaish carpet
Circa 1880
434 x 376 cm 14’2” x 12’4”
£ POA
2596
Antique Bakshaish carpet
Circa 1880
640 x 434 cm 20’11” x 14’2”
£65,000
210
Antique Bakshaish carpet
Circa 1880
665 x 380 cm 21’9” x 12’5”
£ POA
5269
Antique Bakshaish carpet
Circa 1875
370 x 239 cm 12’1” x 7’10”
£25,000
6966
Antique Bakshaish carpet
Circa 1870
397 x 307 cm 13’ x 10’
£65,000
4844
Antique Bakshaish Persian carpet
Circa 1860
426 x 337 cm 13’11” x 11’
£ POA
7988
Early Antique square Bakshaish carpet
Circa 1860
358 x 295 cm 11’8” x 9’8”
£35,000
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 Bakshaish Carpet
[post__not_in] => Array
(
[0] => 29014
[1] => 24059
[2] => 23086
[3] => 14569
[4] => 14595
[5] => 14704
[6] => 14945
[7] => 16885
[8] => 14840
[9] => 19700
)
)
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 (29014,24059,23086,14569,14595,14704,14945,16885,14840,19700) 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 Bakshaish%') OR (wp_posts.post_title LIKE '%Bakshaish Carpet%')) GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Bakshaish%') + (wp_posts.post_title LIKE '%Bakshaish 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] => £15,000 to £20,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 25
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 29014
[1] => 24059
[2] => 23086
[3] => 14569
[4] => 14595
[5] => 14704
[6] => 14945
[7] => 16885
[8] => 14840
[9] => 19700
)
)
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 (29014,24059,23086,14569,14595,14704,14945,16885,14840,19700) 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 = '£15,000 to £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
6140
Antique Ushak carpet
Circa 1900
366 x 274 cm 12’ x 8’11”
£18,000