SELECT SQL_CALC_FOUND_ROWS ujw_posts.*
FROM ujw_posts LEFT JOIN ujw_term_relationships ON (ujw_posts.ID = ujw_term_relationships.object_id)
WHERE 1=1 AND (
ujw_posts.ID NOT IN (
SELECT object_id
FROM ujw_term_relationships
WHERE term_taxonomy_id IN (23)
)
AND
ujw_posts.ID NOT IN (
SELECT object_id
FROM ujw_term_relationships
WHERE term_taxonomy_id IN (11)
)
AND
ujw_term_relationships.term_taxonomy_id IN (90,91,92,95,96,97,98,99,100,101,102,103,104,105,106,107,108,110,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,129,131,132,133,134,135,136,137,138,139,140,141,150,155,287,288,290,295,308,309,311,332,333,373,374,674,957,1052,1067,1117,1118,1119,1159,1191,1200,1225,1233,1285,1288,1289,1290,1316,1438,1439,1440,1441,1442,1443,1444,1445,1477,1478,1500,1501,1502,1503,1504,1505,1506,1507,1523,1525,1526,1532,1691,1692,1693,1694,1738,1775,1844,1847,1861,1885,1944,2185,2203,2449,2471,2586,2624,2625,2628,2670,2686,2707,2760,2776,3029,3032,3037,3038,3039,3040,3041,3042,3043,3044,4591,5553,5569,6512,6607,8571,12651,12652,16075,16076,17667,18168)
) AND ((ujw_posts.post_type = 'product' AND (ujw_posts.post_status = 'publish' OR ujw_posts.post_status = 'acf-disabled')))
GROUP BY ujw_posts.ID
ORDER BY ujw_posts.post_date DESC, ujw_posts.ID DESC
LIMIT 0, 12
You cannot add that amount of "Navy blue base color Floral print on Cotton Poplin fabric for Women's Top" to the cart because there is not enough stock (0.25 remaining).
