Find the perfect antique rug for your home at our showroom or through our bespoke 'at-home' viewing service.
0
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts
LEFT JOIN wp_postmeta AS custom_status ON custom_status.post_id = wp_posts.ID AND custom_status.meta_key = 'status_toggle'
LEFT JOIN wp_postmeta AS stock_status ON stock_status.post_id = wp_posts.ID AND stock_status.meta_key = '_stock_status'
WHERE 1=1 AND wp_posts.ID IN (1,21934,25680,25732,25740,25747,25806,25816,26039,26047,26053,26346,26355,26364,26375,26381,26386,26393,28329,28348,28354,28360,28366,28371,28376,28381,28428,37020,37025,37029,37034,37041,37047,37162,37173,37178,37184,37189,37195,37201,37207,37213,37226,37233,37241,37247,37253) AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND ( (
stock_status.meta_value = 'instock'
AND wp_posts.post_status = 'publish'
AND custom_status.meta_value NOT LIKE '%\"reserved\"%'
) OR (
custom_status.meta_value LIKE '%\"reserved\"%'
) )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
LIMIT 0, 20;