FREE SHIPPING ON ALL ORDERS OVER $50!
We currently only ship to customers in the United States via UPS and US MAIL. Please allow 7-10 days for delivery.
A great gift for someone on the go! Comes wrapped in a re-usable Yu-Be tote bag (14"w x 11"t x 5"d). Includes Free Lip Balm, Free Heel Socks, Free Tote Bag and Free Shipping. This gift set has a total retail value OVER $107!
Deluxe Gift Set Includes:
- (1) 1 fl. oz. Tube - Yu-Be Moisturizing Cream ($16)
- (1) 2.2 fl. oz. Jar - Yu-Be Moisturizing Cream ($25)
- (1) 10.25 fl. oz. Body Lotion ($29)
- (1) 6.75 fl. oz. Foaming Skin Polish ($19)
- (1) FREE Lip Balm $5 RETAIL VALUE!
- (1 pr) FREE Heel & Elbow Socks: $13 RETAIL VALUE!
- (1) FREE Yu-Be tote bag!
- (1) FREE samples of all Yu-Be products!
- FREE Shipping!
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'yu_be_com.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '53' and opa.orders_id = opb.orders_id and opb.products_id != '53' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 3