FROM hud_product_to_category p2c LEFT JOIN hud_product p ON (p2c.product_id = p.product_id) LEFT JOIN hud_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN hud_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = "1" AND p.status = "1" AND ((p.stock_status_id != 12 AND p.stock_status_id != 17) OR p.quantity > 0) AND p.date_available <= NOW() AND p2s.store_id = "0" AND p2c.category_id = '112'
 FROM hud_product_to_category p2c LEFT JOIN hud_product p ON (p2c.product_id = p.product_id) LEFT JOIN hud_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN hud_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = "1" AND p.status = "1" AND ((p.stock_status_id != 12 AND p.stock_status_id != 17) OR p.quantity > 0) AND p.date_available <= NOW() AND p2s.store_id = "0" AND p2c.category_id = '112' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,24
Elinchrom South Africa | Monolights and Heads | Outdoorphoto

Elinchrom Monolights and Heads



Elinchrom BRX 250/250 Umbrella To-Go Kit

Elinchrom BRX 250/250 Umbrella To-Go Kit

You might wonder why you need the Elinchrom BRX range? Well, to put it simple, because it combines f..

R 26,195.00
Stock: In Stock
Elinchrom BRX 500/500 Softbox To-Go Kit

Elinchrom BRX 500/500 Softbox To-Go Kit

Have Control Over Your LightingYou might wonder why you need the Elinchrom BRX range? Well, to put i..

R 38,895.00
Stock: Awaiting Stock
Elinchrom D-Lite RX 2/2 Umbrella To-Go Kit

Elinchrom D-Lite RX 2/2 Umbrella To-Go Kit

With its exceptional portability and uncompromising quality, work suddenly becomes play with this kit.

Stock: In Stock
Elinchrom D-Lite RX 4/4 Softbox To-Go Kit

Elinchrom D-Lite RX 4/4 Softbox To-Go Kit

Elinchrom’s D-Lite RX range doesn’t let you wonder on why this is a solid purchase. It offers unique..

Stock: In Stock
Elinchrom ELC Pro HD 1000/1000 To Go Studio Lighting Kit

Elinchrom ELC Pro HD 1000/1000 To Go Studio Lighting Kit

The ELC Pro HD 1000/1000 To Go 2 Light Kit is a powerful core kit for photographers working in the s..

R 52,295.00
Stock: Awaiting Stock
Showing 1 to 5 of 5 (1 Pages)

Newsletter

Connect With Us

Safe Shopping
With SSL Security and Thawte Certificates in place you can be sure of 100% Secure Shopping