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 (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 96, 12
You cannot add that amount of "Off White base color Stripes print on Cotton Viscose Linen Fabric For Women's Kurta" to the cart because there is not enough stock (0.5 remaining).
