Genesis Finance Buy Now and Split the Costs with Genesis Finance Options - Limited Companies Only

Lighting & Power

Lighting & Power Banner Picture
SELECT DISTINCT P.ID FROM Products AS P LEFT JOIN ProductCats AS PC ON P.ID = PC.ProductID WHERE ProductStatus ='1' AND (PC.CatID = '913'OR PC.CatID = '1176'OR PC.CatID = '1177'OR PC.CatID = '1178'OR PC.CatID = '768'OR PC.CatID = '770'OR PC.CatID = '769'OR PC.CatID = '285'OR PC.CatID = '960'OR PC.CatID = '284'OR PC.CatID = '72'OR PC.CatID = '71'OR PC.CatID = '74'OR PC.CatID = '1051'OR PC.CatID = '73'OR PC.CatID = '603'OR PC.CatID = '124'OR PC.CatID = '207'OR PC.CatID = '123'OR PC.CatID = '126'OR PC.CatID = '1352'OR PC.CatID = '125'OR PC.CatID = '1304'OR PC.CatID = '128'OR PC.CatID = '130'OR PC.CatID = '131'OR PC.CatID = '132'OR PC.CatID = '1305'OR PC.CatID = '129'OR PC.CatID = '1306'OR PC.CatID = '133'OR PC.CatID = '1062'OR PC.CatID = '134'OR PC.CatID = '1307'OR PC.CatID = '138'OR PC.CatID = '1308'OR PC.CatID = '139'OR PC.CatID = '1234'OR PC.CatID = '1235'OR PC.CatID = '949'OR PC.CatID = '695'OR PC.CatID = '1474'OR PC.CatID = '1473'OR PC.CatID = '205'OR PC.CatID = '204'OR PC.CatID = '1320'OR PC.CatID = '206'OR PC.CatID = '982'OR PC.CatID = '1264') LIMIT 0,9;
Wind-Up Torch 3 LED Rechargeable

Wind-Up Torch 3 LED Rechargeable

0.5W LED Spotlight 1 x PJ996 Cell

0.5W LED Spotlight 1 x PJ996 Cell

Cassette Type Cable Reel 10m 4 x 230V 1.00mm² Thermal Trip

Cassette Type Cable Reel 10m 4 x 230V 1.00mm² Thermal Trip

Cable Reel 15m 4 x 230V Thermal Trip

Cable Reel 15m 4 x 230V Thermal Trip

Cable Reel Box Type 15m 4 x 230V 1.25mm² Thermal Trip

Cable Reel Box Type 15m 4 x 230V 1.25mm² Thermal Trip

Cable Reel 25m 4 x 230V 1.25mm² Thermal Trip

Cable Reel 25m 4 x 230V 1.25mm² Thermal Trip

Cable Reel 25m 4 x 230V 2.5mm² Thermal Trip

Cable Reel 25m 4 x 230V 2.5mm² Thermal Trip

Cable Reel Box Type 25m 4 x 230V 1.25mm² Thermal Trip

Cable Reel Box Type 25m 4 x 230V 1.25mm² Thermal Trip

Cable Reel 25m 4 x 230V 1.25mm² Thermal Trip with RCD Plug

Cable Reel 25m 4 x 230V 1.25mm² Thermal Trip with RCD Plug

Page 1 of 37 pages