Evolution
Filtered by :
Diameter
- 3-1/2 in (38)
- 4 in (23)
Trim Models
- Adjustable (20)
- Decorative Glass (6)
- Double Gimbal (3)
- Downlight (19)
- Shower (11)
- Wall Wash (4)
Source
- GU10 LED (47)
- MR16 LED (52)
- PAR16 LED (47)
- PAR20 LED (9)
Shape
- Round (37)
- Square (22)
Installation Type
- New Construction (61)
- Remodel (58)
61 Products
-
string(861) "(Select distinct D.*, DT.idTrim, Null as idProduit from download D left join download_trim DT on DT.idDownload=D.idDownload join entry E on E.idTranslation=D.nom
where DT.idTrim in (195,196,198,199,203,205,207,209,211,213,215,217,219,221,223,225,227,229,231,233,235,237,239,241,243,245,247,249,252,254,256,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,311,313,314,315,316,317,604,607) and (E.text like '%Technical sheet%' OR E.text like '%Brochure%' OR E.text like '%IES %'))union
(Select D.*, Null as idTrim, DP.idProduit from download D left join download_produit DP on DP.idDownload=D.idDownload
join entry E on E.idTranslation=D.nom where DP.idProduit in (3) and (E.text like '%Technical sheet%' OR E.text like '%Brochure%' OR E.text like '%IES %')) order by idProduit DESC, idTrim DESC"
An error happened during the search.
© Contrast Lighting Inc. 2005-2017.
All Rights Reserved.
Term of Use I User Confidentiality