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 = 4 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 4) WHERE pl.id_lang = 1 AND pl.id_product = 2115983 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 = 4 WHERE (a.id_product = 2115983) LIMIT 1 SELECT * FROM `ps_product_lang` WHERE `id_product` = 2115983 AND `id_shop` = 4 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 4 AND cl.`id_category` = 974 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 = 2115983) 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 = 974 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 = 4 WHERE (a.id_product = 2115983) AND (b.id_shop = 4) LIMIT 1 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 4 AND cl.`id_category` = 974 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 `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 7210 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 = 4) WHERE p.id_product = 2115983 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 20 DAY ) ) > 0 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2115983 ORDER BY `id_specific_price_priority` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:43:14' >= `from` AND '2025-01-08 23:43:14' <= `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, 2115983) 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:43:14' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:14' <= `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`, 0 as id_product_attribute FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 4) WHERE (p.`id_product` = 2115983) SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 2115983 AND id_shop=4 LIMIT 1 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2115983 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`=2115983 SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 2115983 LIMIT 1 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 2115983) AND (id_product_attribute = 0) AND (id_shop = 4) AND (id_shop_group = 0) LIMIT 1 SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 2115983) AND (id_product_attribute = 0) AND (id_shop = 4) AND (id_shop_group = 0) LIMIT 1 SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 2115983) AND (id_product_attribute = 0) AND (id_shop = 4) AND (id_shop_group = 0) LIMIT 1 SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 2115983 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 = 1 LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 4 WHERE (a.id_category = 974) 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` = 2115983 AND image_shop.`cover` = 1 LIMIT 1 SELECT id_image FROM ps_image WHERE id_image = 31934917 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 = 2115983) 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 = 2115983) AND (b.id_shop = 4) LIMIT 1 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 4 AND cl.`id_category` = 974 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 = 2115983) AND (b.id_shop = 4) LIMIT 1 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 3 AND cl.id_shop = 4 AND cl.`id_category` = 974 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 = 4 WHERE (a.id_product = 2115983) AND (b.id_shop = 4) LIMIT 1 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 4 AND cl.id_shop = 4 AND cl.`id_category` = 974 LIMIT 1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 2115983 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1 SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 974 AND id_shop = 4 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 = 4 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 4) WHERE c.nleft <= 216 AND c.nright >= 217 AND c.nleft >= 2 AND c.nright <= 305 AND cl.id_lang = 1 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 = 4) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 4 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 974 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:14' >= `from` AND '2025-01-08 23:43:14' <= `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, 2115983) 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:43:14' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:14' <= `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` = 1) LEFT JOIN `ps_sample_images` si ON (si.`id_image` = i.`id_image`) WHERE i.`id_product` = 2115983 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` = 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 = 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` = 2115983 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 = 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` = 1) 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` = 1 AND cl.id_shop = 4 WHERE product_shop.`id_shop` = 4 AND a.`id_product_pack` = 2115983 GROUP BY product_shop.id_product SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 2115983 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` = 1 AND pl.id_shop = 4 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 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` = 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 = 4 AND stock.id_shop_group = 0 ) WHERE `id_product_1` = 2115983 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 = 4 WHERE (a.id_manufacturer = 7210) 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 = 2115983 ORDER BY fg.position ASC, gr.id_feature_group ASC, fgr.position ASC SELECT * FROM ps_product_videos WHERE id_product = 2115983 ORDER BY position ASC SELECT COUNT(*) FROM ps_pack WHERE id_product_item = 2115983 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 = 2115983) ORDER BY w.reference ASC SELECT reserved FROM ps_stock_available WHERE id_product = 2115983 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 = 4) WHERE ps.id_shop IS NOT NULL AND NOW() BETWEEN p.start_date AND p.end_date AND (FIND_IN_SET(2011, p.buum_cats) > 0 OR FIND_IN_SET(2115983, p.product_ids)) ORDER BY p.id_promo DESC SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 2115983 AND meta_key = 'secondary_ean' LIMIT 1 Car Wheel Rim Momo REVENGE ANTHRACITE 17" 8,0 x 17" ET25 PCD 5x112 CB 79,6 - Other car spare parts - Photopoint.lv
SELECT *, ( IF ('2025-01-08 23:43:14' >= `from` AND '2025-01-08 23:43:14' <= `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, 2115983) 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:43:14' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:14' <= `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:14' >= `from` AND '2025-01-08 23:43:14' <= `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, 2115983) 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:43:14' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:14' <= `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:14' >= `from` AND '2025-01-08 23:43:14' <= `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, 2115983) 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:43:14' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:43:14' <= `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 = 2115983 AND meta_key = 'unit' LIMIT 1 SELECT * FROM ps_feature_group_relations_product WHERE id_product = 2115983 AND id_feature = 1384 LIMIT 1 SELECT unit, ratio FROM ps_product WHERE id_product = 2115983 AND ratio != 1 AND ratio != 0 LIMIT 1

Car Wheel Rim Momo REVENGE ANTHRACITE 17" 8,0 x 17" ET25 PCD 5x112 CB 79,6

SELECT * FROM ps_dailydeals WHERE id_product = 2115983 LIMIT 1
288,99 €

Main info

Warning: Last items in stock!

Equip your vehicle with the latest industry products! Buy Car Wheel Rim Momo REVENGE ANTHRACITE 17" 8,0 x 17" ET25 PCD 5x112 CB 79,6 and don't miss out on anything!
  • Wheel Rim Depth (ET): ET25
  • Wheel Rim Fitment (PCD): PCD 5x112
  • Bearing size (CB): CB 79,6
  • Approx. diameter: 19"
  • Width: 8,5 x 19"

Dimensions and weights

Gross weight
12 kg
Package width
55 cm
Package height
35 cm
Package length
55 cm

Product codes

EAN
8024055143088

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 = 2115983 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 12-17 working days for delivery within Estonia.

Product comparison

Close