LightStream Technology Corporation Ltd My Account  Cart Contents  Checkout  
  Top » Catalog 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
Welcome to LightStream Welcome to LightStream
Welcome Guest! Would you like to log yourself in? Or would you prefer to create an account?

 Irelands Premier Security products distributor.

 Welcome to Lightstream!

Our site is still under construction, so please bear with us. In the meantime, please feel free to browse our ever increasing range of products from some of the world's best security manufacturers. 

'Our focus at Lightstream is on Security and Surveillance products and solutions. We provide quality systems and products from major manufacturers with unrivalled support and commitment'.

Unit G4,Calmount Business Park,

Ballymount, Dublin 12,

01 4080111

 LightStream are authorised distributors for:



New Products For October
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Site Map
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