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 3144, 12
You cannot add that amount of "White Base Printed Design on Poly Crepe Dress Material Fabric" to the cart because there is not enough stock (0.5 remaining).