 |
Better Health through Digestion with an Ayurvedic Diet
|
|
|
Notice: Undefined variable: DISCOUNT_QRY in /hsphere/local/home/jimmel/joyfulbelly.com/Ayurveda/products.php on line 92
Database error: Invalid SQL: SELECT p.PRODUCT_ID, INGREDIENT_ID, PRODUCT, SUMMARY, IMAGE_URL, WEIGHT, SELLING_PRICE, P3, T3, UNITS, SELLING_QTY, SUPPLIER
, (if(((DateDiff(CURDATE(), FEATURED) mod 365 <= 60) AND FEATURED IS NOT NULL), 2, (p.PRODUCT_ID in (SELECT PRODUCT_ID FROM inventory_order where INVENTORY_ACTION='EXPIRED' AND ENTRY_DATE > CURDATE() - INTERVAL 30 DAY)))) AS SPECIAL_STILL, NULL AS COUPON_PRICE, FEATURED
FROM products p
WHERE PUBLISH IS NOT NULL AND and (if(((DateDiff(CURDATE(), FEATURED) mod 365 <= 60) AND FEATURED IS NOT NULL), 2, (p.PRODUCT_ID in (SELECT PRODUCT_ID FROM inventory_order where INVENTORY_ACTION='EXPIRED' AND ENTRY_DATE > CURDATE() - INTERVAL 30 DAY))) OR FEATURED IS NOT NULL)
ORDER BY PRODUCT
SQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and (if(((DateDiff(CURDATE(), FEATURED) mod 365 <= 60) AND FEATURED IS NOT NULL)' at line 4)
Session halted.
Create a Diet