LightStream Technology Corporation Ltd My Account  Cart Contents  Checkout  
  Top » Catalog » Shipping & Returns Cart Contents  |  Checkout   
Quick Find
Use keywords to find the product you are looking for.
Advanced Search
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Site Map
Shipping & Returns Shipping & Returns
There is a standard shipping fee of 5euro for all products shipped to the Republic of Ireland. This covers up to 10Kg and is delivered via AnPost on overnight delivery. For heavier deliveries, please just place your order, and when its over 10Kgs, we will contact you to confirm freight prices. You are more than welcome to collect goods from our Dublin trade counter between 9-5 Mon - Fri. You are also more than welcome to send your own courier to collect the goods. For returns, all goods to be returned must have an RMA - Returns authorisation number. Please email for an RMA number. All goods returned for credit must be in original packaging.
3065 - Expression #1 of ORDER BY clause is not in SELECT list, references column 'lightstr_zyxel.p.products_ordered' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10


Shopping Cart
0 items