SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`color`, `e`.`color_value`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`was_price`, `e`.`actual_wattage`, `e`.`cap_type`, `e`.`cap_type_value`, `e`.`bulb_types`, `e`.`bulb_types_value`, `e`.`bulb_shape`, `e`.`bulb_shape_value`, `e`.`material`, `e`.`finish`, `e`.`colour`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`is_imported`, `e`.`collection_style`, `e`.`collection_style_value`, `e`.`lookbook`, `e`.`lookbook_value`, `e`.`lookbook_image`, `e`.`beam_angle`, `e`.`beam_angle_value`, `e`.`bulb_colour_temperature`, `e`.`bulb_colour_temperature_value`, `e`.`equivilent_wattage`, `e`.`equivilent_wattage_value`, `e`.`bulb_lumens`, `e`.`google_promotion_code`, `e`.`google_promotion_code_value`, `e`.`high_street_price`, `e`.`bulb_qty`, `e`.`productpage_image`, `e`.`is_new`, `e`.`discontinued`, `e`.`cut_out_hole_size`, `e`.`product_type`, `e`.`style`, `e`.`offers`, `e`.`filter_collection`, `e`.`touch_activated_lhn`, `e`.`touch_activated_lhn_value`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_flat_8` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=8 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '518' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '4' AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 48

27 Item(s)

per page
Barrow SS 50W GU10 Dusk Till Dawn Down Light IP44 Wall Light Compare Products
IP44 Outdoor Wall Lantern with Dusk to Dawn Sensor Polypropylene Compare Products
IP44 White Outdoor Wall Lantern with PIR Sensor Compare Products
IP44 White Outdoor Wall Lantern with Dusk to Dawn Sensor Compare Products
IP44 Black / Silver Outdoor Wall Lantern with Dusk to Dawn Sensor Compare Products
Medlock PIR Stainless Steel & Opal Polycarbonate IP44 Bulkhead Compare Products
IP44 Kayleigh Outdoor Wall PIR Lantern Aluminium Compare Products
IP44 Wiltshire Outdoor Wall Dusk till Dawn Lantern Aluminium Compare Products
IP44 Kayleigh Outdoor Wall PIR Lantern Aluminium White Compare Products
IP44 Wiltshire Outdoor Wall Dusk till Dawn Lantern Aluminium White Compare Products
IP44 Wharf PIR Outdoor Wall Lantern Stainless Steel Compare Products
Stainless Steel PIR Outdoor Up/Down Wall Light for GU10 IP44 Compare Products
Stainless Steel Dusk Till Dawn Up/Down Wall Light GU10 IP44 Compare Products
Black PIR Outdoor Up/Down Wall Light for GU10 IP44 Compare Products
Griffin IP44 Black Motion Sensor PIR Bulkhead Wall Light Compare Products
Trentham Die Cast Aluminium 40W IP54 Bulkhead White Compare Products
Trentham Die Cast Aluminium 40W IP54 Bulkhead Black Compare Products
Arnside Polypropylene 60W  IP44 Bulkhead White Compare Products
Pendle Polypropylene 60W IP44 Bulkhead Black Compare Products
Pendle Polypropylene 60W IP44 Bulkhead White Compare Products
Carnforth Polypropylene 40W IP44 Bulkhead White Compare Products
IP44 Floyd Vandal Resistant Outdoor Bulkhead / Site Light Compare Products
Carnforth Polypropylene 40W IP44 Bulkhead Black Compare Products
Griffin IP44 Black Dusk till Dawn Sensor Bulkhead Wall Light Compare Products
IP44 Outdoor Wall Lantern with PIR Sensor Polypropylene Compare Products
IP44 Black / Silver Outdoor Wall Lantern with PIR Sensor Compare Products
Marco Robust Outdoor Bulkhead IP44 Compare Products

27 Item(s)

per page