SEARCH
Group
All
SELECT distinct a.name, c.Name as SName, c.id as SID,c.[order] FROM productgroup a, productgroupsubgroup b, subgroups c, subgroupproduct d, products e,Products2 Products2,Lamps2 Lamps2 LEFT OUTER JOIN CMS_Item_Numbers CMS_Item_Numbers ON 1=1 LEFT OUTER JOIN Lamp_Type Lamp_Type On Lamp_Type.ID=LampType WHERE b.pgid = a.id AND b.sid = c.id AND d.sid = c.id AND d.pid = e.id AND a.CondName IN ('martinlight') AND Products2.ID=e.ID AND e.DisContinued LIKE '0' AND e.Releasedate <= getdate() AND e.Subsidiary LIKE '_1________' AND c.Segments LIKE '__________1' AND e.Segments LIKE '__________1' ORDER BY c.[order]
Moving Heads
Scanners
Effects
Projectors
Uplights
Spotlights
Image Projectors
Fluorescent Luminaires
Fiber Illuminators
Strobes
Lasers
LED Luminaires
LED Display Systems
Controllers
Media Servers
Visualizers
Lighting Accessories
Family
All
MAC
Applications
All
Select DISTINCT Seg_Name FROM segmentation segmentation,productgroup a, productgroupsubgroup b, subgroups c,App_Prod App_Prod, subgroupproduct d, products e,Products2 Products2,CMS_Item_Numbers CMS_Item_Numbers LEFT OUTER JOIN Lamps2 Lamps2 ON Lamps2.PartNo=CMS_Item_Numbers.ItemNo LEFT OUTER JOIN Lamp_Type Lamp_Type On Lamp_Type.ID=LampType WHERE b.pgid = a.id AND b.sid = c.id AND d.sid = c.id AND d.pid = e.id AND a.CondName IN ('martinlight') AND Products2.ID=e.ID AND e.DisContinued LIKE '0' AND e.Releasedate <= getdate() AND e.Subsidiary LIKE '_1________' AND c.Segments LIKE '__________1' AND e.Segments LIKE '__________1' AND App_Prod.PID=e.ID AND segmentation.ID=App_Prod.app_id AND c.ID=0 ORDER BY Seg_Name
Airports & Transit Areas
Club
Concerts
Cruise Ships
Events
Historical & Cultural
Hotels & Hospitality
Houses of Worship
Offices & Corporate
Parks & Landscapes
Residential
Retail & Shopping
Sport & Leisure
Television
Theatre
Lamp
All
Metal Halide
Tungsten Halogen
Wattage
All
150
250
575
700
1200
1500
Beam Type
All
Profile
Wash
IP Rating
All
SELECT DISTINCT Text_US FROM TempProdComp INNER JOIN Products products ON Products.Name=TempProdComp.ProductName AND Products.Releasedate<=GetDate() INNER JOIN subgroupproduct subgroupproduct ON subgroupproduct.PID=Products.ID INNER JOIN subgroups subgroups ON subgroups.ID=subgroupproduct.SID INNER JOIN productgroupsubgroup productgroupsubgroup ON productgroupsubgroup.SID=Subgroups.ID INNER JOIN productgroup productgroup ON productgroup.ID=productgroupsubgroup.PGID INNER JOIN CMS_Item_Numbers CMS_Item_Numbers ON CMS_Item_Numbers.PID=subgroupproduct.PID INNER JOIN Products2 Products2 ON Products2.ID=products.ID LEFT OUTER JOIN Lamps2 Lamps2 ON Lamps2.PartNo=CMS_Item_Numbers.ItemNo LEFT OUTER JOIN Lamp_Type Lamp_Type On Lamp_Type.ID=LampType LEFT OUTER JOIN App_Prod App_Prod ON App_Prod.PID=products.ID LEFT OUTER JOIN segmentation segmentation ON segmentation.ID=App_Prod.app_id WHERE Heading1_US='Construction' and Heading2_US='Protection rating' and left(Text_US,2)='ip' AND subgroups.ID=0 ORDER BY Text_US
IP20