Web Catalog v3.0 -> General Purpose Downlight -> Line Voltage -> 5" - PAR16 Spots

The MR16 adjustable trim provides the aiming capabilities of a small aperture trim while maintaining the appearance of the 5" trim. These trims have a large degree of rotation that allow for pinpoint illumination in an accent lighting application. The MR16 lamp has a controlled beam spread that produces the level of light intensity needed to properly highlight an object.

Invalid Request.

Error executing query, sql= SELECT DISTINCT Products.Product_ref,Products.OverideCS, Web_listCompRootCodeIDs, GenType,SeriesID,Series,Cat2ID,GroupID,RootCodeOrder,genTypeID,Type,TypeID,GroupName,GroupID,GroupDesign,Volt,LampType,SeriesID,SeriesShortDesc,SeriesIDOrder,CatOrder,GroupOrder,GenTypebg_img,WebCat_TOC_LG.RootCodeID,Products.RootID, Products.product_ref,Products.password_protected, Products.IsNew, WebCat_TOC_LG.Web_CS, Products.CommonDesc , Products.SRootDesc , Products.Gtype, WebCat_TOC_LG.LAwoDim2, Products.HighresPhoto, Products.ies,Products.revitFile, Products.instruction,CS_2ndpgs FROM WebCat_TOC_LG INNER JOIN Products ON WebCat_TOC_LG.RootID = Products.RootID WHERE GroupID = 49 ORDER BY Products.product_ref;
Error= [Microsoft][ODBC Microsoft Access Driver] The specified field 'Products.revitFile' could refer to more than one table listed in the FROM clause of your SQL statement.