Lipstick with Display L-386 (24PCS)
Model No: [L-386]
Lipstick with Display L-386 (24PCS)
Click to enlarge
Packing: 2 Dozens with Display / 24 PCS
Color: Combination A, B, C
Quantity1+ 3+ 5+ 
Package Price$19.00$17.00$16.00
Unit Price$0.79$0.71$0.67
% Savings0%11%16%

Quantity:

1146 - Table 'kaistudi_kaimartOSC.orders' doesn't exist

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p, categories c, products_to_categories p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and opa.products_id = '2286' and opa.orders_id = opb.orders_id and opb.products_id != '2286' 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 4

[TEP STOP]