SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 1 AND pl.id_product = 5412071 AND product_shop.active = 1 LIMIT 1 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 5412071) LIMIT 1 SELECT * FROM `ps_product_lang` WHERE `id_product` = 5412071 AND `id_shop` = 1 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 978 LIMIT 1 SELECT cla.name as category_name, fg.parcel_terminal_allowed, fg.outside_estonia_allowed, fgl.title as feature_group, fgl.id_feature_group, fgl2.title as feature_group_name, fgl2.slug as feature_group_slug FROM ps_category_lang cla LEFT JOIN ps_product p ON (p.id_product = 5412071) LEFT JOIN ps_feature_group fg ON (fg.id_feature_group = p.id_feature_group) LEFT JOIN ps_feature_group_lang fgl ON (fgl.id_feature_group = p.id_feature_group AND fgl.id_lang = 2) LEFT JOIN ps_feature_group_lang fgl2 ON (fgl2.id_feature_group = p.id_feature_group AND fgl2.id_lang = 1) WHERE cla.id_category = 978 AND cla.id_shop = 1 AND cla.id_lang = 2 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 5412071) AND (b.id_shop = 1) LIMIT 1 SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 2) LIMIT 1 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 19995 AND `active` = 1 LIMIT 1 SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 5412071 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 5412071 LIMIT 1 SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 5412071 LIMIT 1 SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 5412071 LIMIT 1 SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 5412071 LIMIT 1 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5412071 ORDER BY `id_specific_price_priority` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:43:00' >= `from` AND '2025-01-08 23:43:00' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 5412071) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0,1,4) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY price ASC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 5412071) SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5412071 AND id_shop=1 LIMIT 1 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5412071 AND `id_group` = 1 LIMIT 1 SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=5412071 SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 5412071 LIMIT 1 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5412071) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 5412071) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 5412071) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 5412071 AND id_shop = 1 LIMIT 1 SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 5412071 AND image_shop.`cover` = 1 LIMIT 1 SELECT id_image FROM ps_image WHERE id_image = 51379928 LIMIT 1 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 2 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 5412071) AND (b.id_shop = 1) LIMIT 1 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 3 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 5412071) AND (b.id_shop = 1) LIMIT 1 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 4 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 5412071) AND (b.id_shop = 1) LIMIT 1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 5412071 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1 SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 978 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC SELECT *, ( IF ('2025-01-08 23:43:00' >= `from` AND '2025-01-08 23:43:00' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN(0, 5412071) AND `id_shop` IN(0, 1) AND `id_currency` IN(0, 1) AND `id_country` IN(0, 86) AND `id_group` IN(0, 1) AND `id_customer` IN(0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`, si.is_sample, si.is_winner FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_sample_images` si ON (si.`id_image` = i.`id_image`) WHERE i.`id_product` = 5412071 ORDER BY `position` SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'large_photopoint' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'photopoint_large' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'medium_photopoint' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'photopoint_medium' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'home_photopoint' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'photopoint_home' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'cart_photopoint' LIMIT 1 SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'photopoint_cart' LIMIT 1 SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name, a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`, product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`, product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 5412071 AND al.`id_lang` = 1 AND agl.`id_lang` = 1 GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1 SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 5412071 SELECT p.*, product_shop.*, pl.*, MAX(image_shop.`id_image`) id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack FROM `ps_pack` a LEFT JOIN `ps_product` p ON p.id_product = a.id_product_item LEFT JOIN `ps_product_lang` pl ON p.id_product = pl.id_product AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 WHERE product_shop.`id_shop` = 1 AND a.`id_product_pack` = 5412071 GROUP BY product_shop.id_product SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 5412071 LIMIT 1 SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, DATEDIFF( p.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE `id_product_1` = 5412071 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 1 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 19995) LIMIT 1 SELECT gr.id_feature_group, gr.id_feature, gr.id_feature_value, gl.title as group_name, fl.name as name, fl.tooltip as tooltip, vl.value as value FROM ps_feature_group_relations_product gr LEFT JOIN ps_feature f ON(f.id_feature = gr.id_feature) LEFT JOIN ps_feature_value_lang vl ON(vl.id_feature_value = gr.id_feature_value AND vl.id_lang = 1) LEFT JOIN ps_feature_group fg ON(fg.id_feature_group = gr.id_feature_group) LEFT JOIN ps_feature_group_lang gl ON(gl.id_feature_group = gr.id_feature_group AND gl.id_lang = 1) LEFT JOIN ps_feature_lang fl ON(fl.id_feature = gr.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_group_relations fgr ON(fgr.id_feature = gr.id_feature AND fgr.id_feature_group = gr.id_feature_group ) WHERE f.only_in_elastic = 0 AND gr.id_product = 5412071 ORDER BY fg.position ASC, gr.id_feature_group ASC, fgr.position ASC SELECT * FROM ps_product_videos WHERE id_product = 5412071 ORDER BY position ASC SELECT COUNT(*) FROM ps_pack WHERE id_product_item = 5412071 LIMIT 1 SELECT DISTINCT w.id_warehouse, CONCAT(w.reference, " - ", w.name) as name FROM `ps_warehouse` w LEFT JOIN `ps_stock` `s` ON s.id_warehouse = w.id_warehouse WHERE (s.id_product = 5412071) ORDER BY w.reference ASC SELECT reserved FROM ps_stock_available WHERE id_product = 5412071 LIMIT 1 SELECT * FROM `ps_orders` a WHERE (a.id_order = 1) LIMIT 1 SELECT * FROM `ps_customer` a WHERE (a.id_customer = 1) LIMIT 1 SELECT * FROM ps_company WHERE id_customer = 1 LIMIT 1 SELECT * FROM ps_company_users WHERE id_customer = 1 LIMIT 1 SELECT * FROM `ps_address` a WHERE (a.id_address = 697) LIMIT 1 SELECT p.* FROM ps_promo p LEFT JOIN ps_promo_shop ps ON(ps.id_promo = p.id_promo AND ps.id_shop = 1) WHERE ps.id_shop IS NOT NULL AND NOW() BETWEEN p.start_date AND p.end_date AND (FIND_IN_SET(2247, p.buum_cats) > 0 OR FIND_IN_SET(5412071, p.product_ids)) ORDER BY p.id_promo DESC SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 5412071 AND meta_key = 'secondary_ean' LIMIT 1 Bombki przezroczyste 10cm zestaw 10szt Ruhhy 22277 - Christmas decor - Photopoint
SELECT *, ( IF ('2025-01-08 23:43:00' >= `from` AND '2025-01-08 23:43:00' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 5412071) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0,1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY price ASC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:43:00' >= `from` AND '2025-01-08 23:43:00' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 5412071) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0,6) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY price ASC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:43:00' >= `from` AND '2025-01-08 23:43:00' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 86, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 5412071) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 86) AND `id_group` IN (0,3) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:00' <= `to`) ) AND id_cart IN (0, 0) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY price ASC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1 SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 5412071 AND meta_key = 'unit' LIMIT 1 SELECT * FROM ps_feature_group_relations_product WHERE id_product = 5412071 AND id_feature = 1384 LIMIT 1 SELECT unit, ratio FROM ps_product WHERE id_product = 5412071 AND ratio != 1 AND ratio != 0 LIMIT 1

Bombki przezroczyste 10cm zestaw 10szt Ruhhy 22277

SELECT * FROM ps_dailydeals WHERE id_product = 5412071 LIMIT 1
5,99 €

Main info

BOMBKI PRZEŹROCZYSTE ROZKŁADANE NA PÓŁ 10 cm 10 szt
  • ROZKŁADANE NA PÓŁ ? bombka rozkłada się na pół, dzięki temu masz możliwość włożenia do środka pięknych ozdób takich jak: piórka, brokat, mech, sztuczny śnieg, wstążki czy confetti. Można także zrobić słodką bombkę wystarczy parę cukierków i gotowe. Kule można także pomalować od środka czy z zewnątrz.
  • DIY - bombki akrylowe to oryginalne ozdoby choinkowe, które możesz udekorować techniką decoupage, home decor i innymi. Dzięki nim stworzysz unikalne i jedyne w swoim rodzaju dekoracje świąteczne. Przy zdobieniu bombek ogranicza cię tylko wyobraźnia!
  • ZESTAW 10 SZT BOMBEK - te wyjątkowe bombki akrylowe to ponadczasowa propozycja, która spodoba się fanom ?zrób to sam?. Z pewnością dodadzą one uroku każdej świątecznej aranżacji. A duży zestaw pozwoli Ci na dekorowanie w gronie rodzinnym.
  • BEZPIECZNY AKRYL - dzięki temu, że bombki wykonane zostały z wysokiej jakości tworzywa sztucznego nie musisz martwić się, że potłuką się przy upadku. Jest to doskonałe rozwiązanie dla rodzin z małymi dziećmi oraz zwierzętami takimi jak psy czy koty. Niwelują one ryzyko skaleczenia się Twojej pociechy lub pupila.
  • SPECYFIKACJA - kolor: przeźroczysty; materiał: PS; średnica: 10 cm; waga: 379 g; waga w opakowaniu: 532 g.

SPECYFIKACJA

  • kolor: przeźroczysty
  • materiał: PS
  • średnica: 10 cm
  • waga: 379 g
  • waga w opakowaniu: 532 g

W ZESTAWIE

  • 10 sztuk bombek

Bombki są doskonałe do tworzenia kreatywnych projektów, świetnie nadaje się również do dekoracji wieloma technikami - malowanie, decoupage, drapanie itp. Dzięki temu, że kule są przezroczyste, można je malować od środka lub wypełnić np. piórkami, cekinami, brokatem czy sztucznym śniegiem. Umożliwia to udekorowanie bazy zarówno w środku, jak i na zewnątrz.

PRODUCENT:

ISO TRADE Spółka z o.o.
ul. Hangarowa 15
59-220 Legnica, Polska

office@iso-trade.biz

OSOBA ODPOWIEDZIALNA W UE:

ISO TRADE

TREŚĆ OSTRZEŻENIA:

-Bombki choinkowe powinny być przechowywane w miejscu niedostępnym dla dzieci.
-Należy unikać stosowania agresywnych środków czyszczących lub szorstkich materiałów do czyszczenia bombek, aby nie uszkodzić powierzchni dekoracyjnych.
-Należy pamiętać, aby nie obciążać gałęzi choinki zbyt dużą ilością bombek, co może prowadzić do ich złamania lub uszkodzenia drzewa.

Product codes

EAN
5900779944718

Photopoint offers free shipping for orders over 99 € delivered to Estonia. Take a look in the tab "Delivery" for a more precise delivery estimate.

For this product you can select the desired delivery method at the shopping cart:

Photopoint store Pick-up


Place your order from Photopoint web store and pick your goods up from one of Photopoint`s brick and mortar stores. The delivery to Photopoint store is free even for orders less than 99 €. You will be noticed by e-mail when your order is ready for pick-up.

The Photopoint stores are located in Tallinn and Tartu. See the exact locations from here.

SELECT id_feature_group FROM ps_product WHERE id_product = 5412071 LIMIT 1

Omniva parcel terminal 

You can order the goods to one of the Omniva Parcel terminals. Choose the desired terminal at the shopping cart. As the shipment arrives to the selected terminal, you will be sent an SMS-notification with an unique code. Go to the terminal within a week, enter the code and take your package. It is as simple as that.

See Omniva Parcel terminal locations here.

SmartPOST parcel terminal

Did not find an Omniva terminal at suitable location? Try SmartPost. Choose the desired terminal at the shopping cart. As the shipment arrives to the selected terminal, you will be sent an SMS-notification with an unique code. Go to the terminal within a week, enter the code and take your package. This method actually works for all parcel terminals.

See SmartPOST parcel terminal locations here.

DPD parcel locker

Make sure you check out also the locations of DPD parcel lockers. These are located all over Estonia. The delivery is the same. As the shipment arrives to the selected locker, you will be sent an SMS with a unique code. Go to the locker, enter the code and take your package.

See DPD parcel locker locations here.

Smartpost Finland parcel terminal

SmartPOST Finland is the best way to order goods to Finland. These terminals work the same way as in Estonia. As the shipment arrives to the selected terminal in Finland, you will be sent an SMS-notification with an unique code. Go to the terminal, enter the code and take your package.

See SmartPOST Finland parcel terminal locations here.

Matkahuolto parcel service

Matkahuolto is easy way to order goods to Finland. These are located also in smaller Finnish towns. As the shipment arrives to the selected Matkahuolto outlet, you will be sent an SMS-notification or an e-mail. Go to the outlet, show your ID and take your package.

See Matkahuolto outlet locations here.

Omniva courier delivery

The courier will transport your goods from Photopoint straight to the provided address. The delivery will take place at workdays from 08:00 to 17:00. Hold your phone near you as the courier will call you prior to its arrival. Please make sure there is someone at the destination, eligible to receive the shipment. 

The product can only be ordered from our online store and it takes from 7-10 working days for delivery within Estonia.

Product comparison

Close