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] => 24
)
[operator] => AND
)
)
[wpse18703_title] => Antique Tibetan Khaden rug
[post__not_in] => Array
(
[0] => 22623
)
)
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 (22623) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (24)
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 Tibetan%') OR (wp_posts.post_title LIKE '%Tibetan Khaden%') OR (wp_posts.post_title LIKE '%Khaden rug%')) AND (wp_posts.post_password = '') GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Tibetan%') + (wp_posts.post_title LIKE '%Tibetan Khaden%') + (wp_posts.post_title LIKE '%Khaden rug%')) 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] => 24
)
)
)
[wpse18703_title] => Antique Tibetan Khaden rug
[post__not_in] => Array
(
[0] => 22623
)
)
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 (22623) AND (
wp_term_relationships.term_taxonomy_id IN (24)
) 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 Tibetan%') OR (wp_posts.post_title LIKE '%Tibetan Khaden%') OR (wp_posts.post_title LIKE '%Khaden rug%')) AND (wp_posts.post_password = '') GROUP BY wp_posts.ID ORDER BY ((wp_posts.post_title LIKE '%Antique Tibetan%') + (wp_posts.post_title LIKE '%Tibetan Khaden%') + (wp_posts.post_title LIKE '%Khaden rug%')) 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] => up to £5,000
[compare] => =
)
)
[tax_query] => Array
(
[0] => Array
(
[include_children] =>
[taxonomy] => product_cat
[terms] => Array
(
[0] => 24
)
[operator] => AND
)
)
[post__not_in] => Array
(
[0] => 22623
)
)
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 (22623) AND (
(
SELECT COUNT(1)
FROM wp_term_relationships
WHERE term_taxonomy_id IN (24)
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 = 'up to £5,000' )
) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND (wp_posts.post_password = '') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
8267
Antique Baktiari rug
Circa 1900
208 x 132 cm 6’9” x 4’3”
£2,950
8149
Antique Kazak Caucasian rug
Circa 1880
210 x 135 cm 6’10” x 4’5”
£5,200
9369
Antique Hamadan rug
Circa 1910
111 x 75 cm 3’7” x 2’5”
£1,150
9373
Antique Veramin rug
Circa 1920
215 x 140 cm 7’ x 4’7”
£3,950
8701
Antique Karaja rug
Circa 1900
202 x 140 cm 6’7” x 4’7”
£3,950
9189
Antique Turkish Melas rug
Circa 1870
169 x 113 cm 5’6” x 3’8”
£4,500
9037
Antique Cuenca Spanish rug
Circa 1920
173 x 122 cm 5’8” x 4’
£4,200
8755
Silk Hereke rug
Circa 1960
97 x 66 cm 3’2” x 2’1”
£4,800
8930
Antique Baktiari rug
Circa 1910
203 x 138 cm 6’7” x 4’6”
£3,250
6217
Antique Perepedil rug
Circa 1890
166 x 111 cm 5’5” x 3’7”
£2,950
