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.
FINALLY! The lotion you have been asking for!
The same #1 selling Japanese formula from Yu-Be... now in a moisturizing body lotion!
Our glycerin formula with a unique blend of vitamin E, B2 and camphor provides ideal daily hydration and protection for many troublesome dry skin conditions. The perfect year-round, all-over body moisturizer.
Smooth, easy-to-apply glycerin lotion helps hydrate, soothe and smooth dry, sensitive skin.
Moisturizes and protects against dry skin during the cold months - then soothes sunburns and replenishes moisture in the summer. (Yu-Be does not contain SPF protection)
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 = '41' and opa.orders_id = opb.orders_id and opb.products_id != '41' 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