Yu-Be Travel Set: 1 Cream Tube & 1 Balm + FREE BAG and FREE SAMPLES
FREE SHIPPING ON ALL ORDERS OVER $50!
We currently only ship to customers in the United States and Canada via UPS and US MAIL. Please allow 7-10 days for delivery.
A great chance for Yu-Be fans to get their favorite products and a FREE GIFT as well!
Not only will you receive (1) 1 fl oz tube of Yu-Be Moisturizing Skin Cream AND a YU-BE LIP THERAPY but you will also get a custom Yu-Be travel pouch for FREE. This clear vinyl zipper bag is the perfect size to carry your personal care items, cosmetics or any other small items when you are on the go.
Also comes with FREE SAMPLES of our other Yu-Be products for you to try!
WHAT A DEAL!
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 = '37' and opa.orders_id = opb.orders_id and opb.products_id != '37' 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