2/18/2023 0 Comments Tableplus couponMax(CASE WHEN pm.meta_key = ‘maximum_amount’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS maximum_amount, - Maximum spend Max(CASE WHEN pm.meta_key = ‘minimum_amount’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS minimum_amount, - Minimum spend ![]() Max(CASE WHEN pm.meta_key = ‘expiry_date’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS expiry_date, - Coupon expiry date Max(CASE WHEN pm.meta_key = ‘free_shipping’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS free_shipping, - Allow free shipping Max(CASE WHEN pm.meta_key = ‘coupon_amount’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS coupon_amount, - Coupon amount ![]() ![]() Max(CASE WHEN pm.meta_key = ‘discount_type’ AND p.`ID` = pm.`post_id` THEN pm.`meta_value` END) AS discount_type, - Discount type
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
September 2023
Categories |