Shopping Cart
0 item(s) - $0.00
Galaxy-header

Surf Tumbler 105629


Call for Price

Description
Stylish 250 ml square base glass tumbler. All the branding options available are dishwasher safe.
Colours
Clear.
Dimensions
W 70mm x H 86mm.
Presented in Black gift box.



Branding Options
Pad Print: 35mm x 40mm.
Imitation Etch: 35mm x 40mm.
Laser Engraving: 25mm x 30mm.
Packaging
Loose packed

  • Model: 105629
  • 5000 Units in Stock


This product was added to our catalog on Friday 14 October, 2016.

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'galaxypr_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 = '880' and opa.orders_id = opb.orders_id and opb.products_id != '880' 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]