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 = '741' 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

1 - 48 of 522

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page

Bulk Deal

Product Code: bulk
Bulk Deal

Out of stock

Compare Products
MiniSun ES 4w 36 SMD LED Candle Bulb 2700k 330 Lumens Compare Products

Dimmable E14 4W LED Filament Candle Bulb CLEAR 6500K

Product Code: 21647
Discontinued
Dimmable E14 4W LED Filament Candle Bulb CLEAR 6500K Compare Products
MiniSun SES 4w 36 SMD LED Candle Bulb 6000k 330 Lumens Compare Products

Burgess Satin Nickel Modern Table Lamp (NO SHADE)

Product Code: 22440
Discontinued
Burgess Satin Nickel Modern Table Lamp (NO SHADE) Compare Products
Set of 20 Battery Operated Silver Ball  LED Chain Lights Compare Products
Rowan Polished Brass Flush Ceiling Light Marble Glass Compare Products

Oyster Frosted Pendant Glass Shade

Product Code: 19691
Discontinued
Oyster Frosted Pendant Glass Shade Compare Products

Mini Arco Metal NE Pendant Shade Gloss Red

Product Code: 16119
Discontinued
Mini Arco Metal NE Pendant Shade Gloss Red Compare Products

Mini G9 Touch Table Lamp Antique Brassed

Product Code: 16813
Discontinued
Mini G9 Touch Table Lamp Antique Brassed Compare Products
Mirage Silver Grey / Black 42” Ceiling Fan with Opal Glass Compare Products
Set of 10 Battery Operated Football Disc LED Chain Lights Compare Products
Apothecary Bottle 2700K LED Chain Light Table Lamp Battery Operated Compare Products

22W, 5ft T8 LED Tube, 6000K, 2,000lm

Product Code: 23785
Discontinued
22W, 5ft T8 LED Tube, 6000K, 2,000lm Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “J” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “C” Compare Products
MiniSun e-Cone 50w SMD LED Warehouse Bulb 6000K 5000lm Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “V” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “N” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “G” Compare Products
MiniSun 10W WHITE Slim Line Pro2 SMD LED 6000K Floodlight Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “Z” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “R” Compare Products

Seki Chrome 3D Glass NE Pendant Shade

Product Code: 23028
Discontinued
Seki Chrome 3D Glass NE Pendant Shade Compare Products

Oba Droplet NE Pendant Cream

Product Code: 15597
Discontinued
Oba Droplet NE Pendant Cream Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “K” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “D” Compare Products
Langdon IP44 Chrome 8W LED Over Mirror Bathroom Light 6500K Compare Products
MiniSun e-Cone 100W SMD LED Warehouse Bulb 6000K 8800lm Compare Products
IP44 Wharf Outdoor Angled Wall Lantern BLACK Stainless Steel Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “W” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “O” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “H” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “&” Compare Products
Pair of Satin Nickel Touch Table Lamps with Cream Shades Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “S” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “L” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “X” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “P” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “B” Compare Products
IP44 Wharf Outdoor Angled Wall Lantern Stainless Steel Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “T” Compare Products
Calypso Black Touch Table Lamp TC Shade with Chrome Decal Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “M” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “F” Compare Products

Stakke 3 Tier Non Elec Brushed Aluminium White Inner

Product Code: 20895
Discontinued
Stakke 3 Tier Non Elec Brushed Aluminium White Inner Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “Y” Compare Products
Carousel Vintage / Antique Carnival Alphabet Letter “Q” Compare Products

1 - 48 of 522

Page:
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
per page