Trochus Bamboo - 4 x 7mm - 18pc

$7.50
Sale: $3.75
Save: 50% off

This bead is a made into a Bamboo tube shape from the Trochus shell and has a creamy Pearl lustre.
It has a small hole through it's length and measures 4mm (3/16") wide x 7mm (5/16") long.
Quantity:18 per pack

Sold Out
  • 0 Units in Stock


This product was added to our catalog on Tuesday 28 October, 2008.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'afford_ajms.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 orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1181' and opa.orders_id = opb.orders_id and opb.products_id != '1181' 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]