Product 1/2

Previous
Return to the Product List
Next

31102 - Lacquer Jewelry Box with Orchids

$150.00

This beautiful Aizu lacquer musical jewelry box features large colorful orchids on its lid. The box is lined in velvet and has a compartment for jewelry and rings. Use a soft, clean cloth to gently wipe off when dusty or soiled. A very beautiful and unique gift. It features a set 18 note Sankyo musical movement.

Available in Red or Black.

Size: 6 1/2" L x 3 3/4" W x 2 3/4" H

Please Choose:



1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ritaford_zc1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from zen_orders_products opa, zen_orders_products opb, zen_orders o, zen_products p where opa.products_id = '117' and opa.orders_id = opb.orders_id and opb.products_id != '117' 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 6]