SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 4 AND cl.`id_category` = 105 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 (4) SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4548502 ORDER BY `id_specific_price_priority` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:42:39' >= `from` AND '2025-01-08 23:42:39' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 125, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 4, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 4548502) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 4) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 125) 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:42:39' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:39' <= `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` = 4548502 AND `id_group` = 1 LIMIT 1 SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 4548502 AND id_shop = 4 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 = 4 WHERE (a.id_category = 4548502) AND (b.id_shop = 4) 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 = 4 WHERE (a.id_product = 4548502) AND (b.id_shop = 4) 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` = 4548502 AND image_shop.`cover` = 1 LIMIT 1 SELECT id_image FROM ps_image WHERE id_image = 50070119 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 = 4548502) 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 = 2 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 4 WHERE (a.id_product = 4548502) AND (b.id_shop = 4) 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 = 4 WHERE (a.id_product = 4548502) AND (b.id_shop = 4) LIMIT 1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 4548502 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:42:40' >= `from` AND '2025-01-08 23:42:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 125, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 4, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN(0, 4548502) AND `id_shop` IN(0, 4) AND `id_currency` IN(0, 1) AND `id_country` IN(0, 125) 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:42:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:40' <= `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 = 4) 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` = 4548502 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 `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 = 4) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 4) WHERE pa.`id_product` = 4548502 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 = 4 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 = 4 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 = 4) LEFT JOIN `ps_category_lang` cl ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 4 AND cl.id_shop = 4 WHERE product_shop.`id_shop` = 4 AND a.`id_product_pack` = 4548502 GROUP BY product_shop.id_product SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 4548502 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 = 4) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 4 AND pl.id_shop = 4 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 4 AND cl.id_shop = 4 ) 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 = 4 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 = 4 AND stock.id_shop_group = 0 ) WHERE `id_product_1` = 4548502 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 = 4548502 ORDER BY fg.position ASC, gr.id_feature_group ASC, fgr.position ASC SELECT * FROM ps_product_videos WHERE id_product = 4548502 ORDER BY position ASC SELECT COUNT(*) FROM ps_pack WHERE id_product_item = 4548502 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 = 4548502) ORDER BY w.reference ASC SELECT reserved FROM ps_stock_available WHERE id_product = 4548502 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 reference FROM ps_product WHERE id_product = 4548502 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 = 4) WHERE ps.id_shop IS NOT NULL AND NOW() BETWEEN p.start_date AND p.end_date AND (FIND_IN_SET(277, p.buum_cats) > 0 OR FIND_IN_SET(4548502, p.product_ids)) ORDER BY p.id_promo DESC SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 4548502 AND meta_key = 'secondary_ean' LIMIT 1 Xilence cooler FM2+/FM1/FM2/AM3/AM2+/AM2 - Procesora dzesēšana - Photopoint.lv
SELECT *, ( IF ('2025-01-08 23:42:40' >= `from` AND '2025-01-08 23:42:40' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 125, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 4, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 4548502) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 4) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 125) 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:42:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:40' <= `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:42:40' >= `from` AND '2025-01-08 23:42:40' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 125, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 4, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 4548502) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 4) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 125) 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:42:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:40' <= `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:42:40' >= `from` AND '2025-01-08 23:42:40' <= `to`, 1, 0) + IF (`id_group` = 0, 2, 0) + IF (`id_country` = 125, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 4, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` FORCE INDEX (idx_price) WHERE `id_product` IN (0, 4548502) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 4) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 125) 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:42:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:40' <= `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 = 4548502 AND meta_key = 'unit' LIMIT 1 SELECT * FROM ps_feature_group_relations_product WHERE id_product = 4548502 AND id_feature = 1384 LIMIT 1 SELECT unit, ratio FROM ps_product WHERE id_product = 4548502 AND ratio != 1 AND ratio != 0 LIMIT 1
Sākumlapa » Datori & IT»Datoru komponentes»Procesora dzesēšana»Xilence cooler FM2+/FM1/FM2/AM3/AM2+/AM2
SELECT pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 4 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 4) LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`) LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 4 ) WHERE p.`id_product` = 4548502 AND l.`active` = 1

Xilence cooler FM2+/FM1/FM2/AM3/AM2+/AM2

SELECT * FROM ps_dailydeals WHERE id_product = 4548502 LIMIT 1
18,99 €

Pamatinformācija

Uzmanību: atlikušas tikai pāris preces!

Pievienot grozam

Piegāde 7-10 darba dienu laikā

Piegāde sākot no 0 €

14 14 dienu atgriešanas politika, iepērkoties tiešsaistē

Izmēri un svars

Iepakojuma platums
12 cm
Iepakojuma augstums
10 cm
Iepakojuma garums
15 cm

Produktu kodi

EAN
4044953500275
Ražotāja kods
XC025

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 = 4548502 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 7-10 darba dienām Igaunijas teritorijā.

Preču salīdzinājums

Aizvērt