WordPress database error: [Incorrect DATETIME value: '']
SELECT * -- ,(SELECT GROUP_CONCAT(DISTINCT post_title) FROM wp_4vhhkf_posts WHERE FIND_IN_SET(ID,product_ids)>0)product FROM ( SELECT p.ID post_id,post_title coupon_code ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='product_ids' LIMIT 1)product_ids ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='product_categories')category ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='individual_use' LIMIT 1)individual ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='coupon_amount' LIMIT 1)coupon_amount ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='_wc_min_qty' LIMIT 1)min_qty ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='_wc_max_qty' LIMIT 1)max_qty ,(SELECT meta_value FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key='_wc_qty_ntf' LIMIT 1)qty_ntf ,(SELECT meta_key FROM wp_4vhhkf_postmeta WHERE post_id=p.ID AND meta_key LIKE '_wc_%_apply' AND meta_value='yes' LIMIT 1)apply ,DATE_FORMAT(FROM_UNIXTIME(meta_value),'%m-%d-%Y')exp_date ,CASE WHEN FROM_UNIXTIME(meta_value)<NOW() THEN 1 ELSE 0 END exp FROM wp_4vhhkf_posts p LEFT JOIN wp_4vhhkf_postmeta x ON x.post_id=p.ID AND x.meta_key='date_expires' WHERE post_type='shop_coupon' AND post_status='publish' AND IFNULL(NULLIF(FROM_UNIXTIME(x.meta_value),''),NOW())>=NOW() )a WHERE(individual='yes' OR apply IS NOT NULL) ORDER BY exp,individual DESC,CAST(coupon_amount AS SIGNED) DESC;

Shop - SugarKid
Make your kids happy

Coding ? Robots

Get mini Robots for your kids on Discounted Price

Explore Robots
Let's get digital

We ❤️ Gadgets

Get amazing Gadgets for Kidz

Explore Electronic Gadgets
Make sure your kidz learn in practical way

STEM ☕ KITS

Get all STEM KITS to make your kid learn in an enjoyable way

Explore STEM KITS

Showing 1–12 of 216 results

د.ع 18,000

Join the waitlist to be emailed when this product becomes available