SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 781 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 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 = 48242 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 = 48242 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 = 48242 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 = 48242 LIMIT 1 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 48242 ORDER BY `id_specific_price_priority` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:43:11' >= `from` AND '2025-01-08 23:43:11' <= `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, 48242) 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:11' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:11' <= `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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 48242 AND `id_group` = 1 LIMIT 1 SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 48242 AND id_shop = 1 LIMIT 1 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 4 LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 781) 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 = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 48242) AND (b.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` = 48242 AND image_shop.`cover` = 1 LIMIT 1 SELECT id_image FROM ps_image WHERE id_image = 0 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 = 48242) 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 = 48242) AND (b.id_shop = 1) LIMIT 1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 48242 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1 SELECT c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE c.nleft <= 56 AND c.nright >= 57 AND c.nleft >= 2 AND c.nright <= 305 AND cl.id_lang = 4 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC 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` = 4 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 781 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:11' >= `from` AND '2025-01-08 23:43:11' <= `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, 48242) 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:11' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:11' <= `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` = 4) LEFT JOIN `ps_sample_images` si ON (si.`id_image` = i.`id_image`) WHERE i.`id_product` = 48242 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` = 48242 AND al.`id_lang` = 4 AND agl.`id_lang` = 4 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` = 4) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4) 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` = 48242 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` = 4 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` = 4) 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` = 4 AND cl.id_shop = 1 WHERE product_shop.`id_shop` = 1 AND a.`id_product_pack` = 48242 GROUP BY product_shop.id_product SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 48242 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` = 4 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 4 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` = 4) 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` = 48242 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product 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 = 4) 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 = 4) LEFT JOIN ps_feature_lang fl ON(fl.id_feature = gr.id_feature AND fl.id_lang = 4) 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 = 48242 ORDER BY fg.position ASC, gr.id_feature_group ASC, fgr.position ASC SELECT * FROM ps_product_videos WHERE id_product = 48242 ORDER BY position ASC SELECT COUNT(*) FROM ps_pack WHERE id_product_item = 48242 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 = 48242) ORDER BY w.reference ASC SELECT reserved FROM ps_stock_available WHERE id_product = 48242 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 id_product FROM ps_product WHERE id_product = 48242 AND pallet_shipping = 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(624, p.buum_cats) > 0 OR FIND_IN_SET(48242, p.product_ids)) ORDER BY p.id_promo DESC SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 48242 AND meta_key = 'secondary_ean' LIMIT 1 TFA 60.2015 Alarm Clock with Indoor Climate - Pulksteņi un modinātāji - Photopoint
SELECT *, ( IF ('2025-01-08 23:43:11' >= `from` AND '2025-01-08 23:43:11' <= `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, 48242) 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:11' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:11' <= `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:11' >= `from` AND '2025-01-08 23:43:11' <= `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, 48242) 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:11' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:11' <= `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:11' >= `from` AND '2025-01-08 23:43:11' <= `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, 48242) 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:11' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:11' <= `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 = 48242 AND meta_key = 'unit' LIMIT 1 SELECT * FROM ps_feature_group_relations_product WHERE id_product = 48242 AND id_feature = 1384 LIMIT 1 SELECT unit, ratio FROM ps_product WHERE id_product = 48242 AND ratio != 1 AND ratio != 0 LIMIT 1

TFA 60.2015 Alarm Clock with Indoor Climate

SELECT id_campaign FROM ps_campaign WHERE (campaign_start < '2025-01-08 23:43:11' AND campaign_end > '2025-01-08 23:43:11') AND only_logged_in_users = 0 SELECT * FROM ps_dailydeals WHERE id_product = 48242 LIMIT 1
13,99 €

Pamatinformācija

TFA 60.2015 alarm clock with indoor climate

Color backlight (on keypress), temperature, humidity, comfort level, max.-min., weather symbol, date, alarm, snooze

Features:

  • Range: T: 0...+50°C (+32 °F...122 °F), H: 20 ... 99%
    table standing, 120 x 35 x 78 mm, 134 g, 3 x 1,5 V AAA batteries not included

Type Alarm Clock
Temperature Indicator Indoor Temperature
Measuring Range (°C) -5 ... +50
Energy Supply Batteries
Type of Battery / Rechargeable Battery AAA (Micro)
Required Number of Batteries / Rechargeable Batteries 3
Colour Silver / Black
Display Digital

Izmēri un svars

Bruto svars
0.13 kg
Iepakojuma platums
12 cm
Iepakojuma augstums
7.8 cm
Iepakojuma garums
3.5 cm

Produktu kodi

EAN
4009816025494
Ražotāja kods
60.2015

Pasūtījumiem virs 99 € Photopoint piedāvā bezmaksas piegādi Igaunijas teritorijā. Ieskatieties cilnē „Piegāde”, lai iegūtu precīzāku piegādes cenu aprēķinu.

Jūs varat izvēlēties vēlamo piegādes veidu iepirkumu grozā: SELECT id_feature_group FROM ps_product WHERE id_product = 48242 LIMIT 1
Omniva paku termināls

Jūs varat pasūtīt preces uz jebkuru no Omniva paku termināļiem. Izvēlieties vēlamo termināli iepirkumu grozā. Līdzko sūtījums ieradīsies, Jums tiks nosūtīts SMS ziņojums ar unikālu kodu. Dodieties uz termināli nedēļas laikā, ievadiet kodu un paņemiet savu sūtījumu. Tas ir tieši tik vienkārši!
Omniva paku termināļu adreses skatīt šeit. Omniva kurjera piegāde

Kurjers nogādās Jūsu preces no Photopoint tieši uz Jūsu norādīto adresi. Piegāde tiek veikta darba dienās no 08:00 līdz 17:00. Kurjers Jums piezvanīs pirms ierašanās, tāpēc turiet savu telefonu tuvumā. Lūdzu, pārliecinieties, ka piegādes galamērķī atrodas persona, kas būs ir tiesīga saņemt sūtījumu.

Prece var tikt pasūtīta tikai mūsu interneta veikalā. Piegāde sākot no 4-7 darba dienām Igaunijas teritorijā.

Preču salīdzinājums

Aizvērt