Filters
Filters
Price
Producer

Socket

Color temperature


Luminous flux [lm]


LED quantity


Beam angle [°]

Max. power consumption [W]


Width [mm]


Height [mm]


Depth [mm]


Light color


Show Filters
SELECT t.id, t.pic, t.pnomer, ROUND(t.price*a.coef, 2) as price, t.name_en, t.short_en, t.used, t.unpacked, t.price as price_new, t.price_org, t.status_id, DATE_FORMAT(t.nav_date, '%d-%m-%Y'), t.nav_order, t.nav_date, t.delivery_days, DATE_FORMAT(t.delivery_date, '%d-%m-%Y'), t.disc_qty FROM products t JOIN atts a ON (a.id = ?) ,products_groups u WHERE t.status = '1' AND t.cz_en = '0' AND (t.id IN (SELECT b.product_id FROM productsgroups_active a, products_groups b WHERE a.id = b.group_id)) AND t.id = u.product_id AND t.discounted = '0' AND u.group_id IN (SELECT v.id FROM productsgroups_v2 v WHERE v.b_id = '1868' OR v.s_id = '1868' OR v.t_id = '1868' OR v.r_id = '1868' OR v.f_id = '1868' OR v.e_id = '1868') /*GROUP BY t.id*/ ORDER BY t.id DESC
EuroLight LED bulb E14 9W 3000 K OL-QP9001-W EuroLight LED bulb E14 9W 3000 K
✅ In Stock 90+ Бр.
Delivery Planned Delivery Date by Courier to you 30-04-2025
2.82 EUR
incl. VAT
Buy
EuroLight LED Bulb E14, 9W, 6500k OL-QP9001-W EuroLight LED Bulb E14, 9W, 6500k
✅ In Stock 80+ Бр.
Delivery Planned Delivery Date by Courier to you 30-04-2025
2.82 EUR
incl. VAT
Buy
EuroLight LED Bulb E14, 3W, 6500k, QP3003 QP3003-E14-P EuroLight LED Bulb E14, 3W, 6500k, QP3003
✅ In Stock 30+ Бр.
Delivery Planned Delivery Date by Courier to you 30-04-2025
2.27 EUR
incl. VAT
Buy
EuroLight LED Bulb E14, 5W, 3000k, QP5001 QP5001-E14-W EuroLight LED Bulb E14, 5W, 3000k, QP5001
✅ In Stock 90+ Бр.
Delivery Planned Delivery Date by Courier to you 30-04-2025
2.27 EUR
incl. VAT
Buy