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 = 4259506 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 = 4259506) LIMIT 1 SELECT * FROM `ps_product_lang` WHERE `id_product` = 4259506 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` = 781 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 = 4259506) 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 = 781 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 = 4259506) 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 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 = 4259506 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 = 4259506 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 = 4259506 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 = 4259506 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 = 4259506 LIMIT 1 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4259506 ORDER BY `id_specific_price_priority` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:42:50' >= `from` AND '2025-01-08 23:42:50' <= `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, 4259506) 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:42:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:50' <= `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` = 4259506) SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 4259506 AND id_shop=1 LIMIT 1 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4259506 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`=4259506 SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 4259506 LIMIT 1 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4259506) 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 = 4259506) 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 = 4259506) 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` = 4259506 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` = 4259506 AND image_shop.`cover` = 1 LIMIT 1 SELECT id_image FROM ps_image WHERE id_image = 44929633 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 = 4259506) 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 = 4259506) 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 = 4259506) AND (b.id_shop = 1) LIMIT 1 SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 4259506 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1 SELECT *, ( IF ('2025-01-08 23:42:50' >= `from` AND '2025-01-08 23:42:50' <= `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, 4259506) 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:42:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:50' <= `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` = 4259506 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` = 4259506 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` = 4259506 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` = 4259506 GROUP BY product_shop.id_product SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 4259506 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` = 4259506 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 = 10739) 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 = 4259506 ORDER BY fg.position ASC, gr.id_feature_group ASC, fgr.position ASC SELECT * FROM ps_product_videos WHERE id_product = 4259506 ORDER BY position ASC SELECT COUNT(*) FROM ps_pack WHERE id_product_item = 4259506 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 = 4259506) ORDER BY w.reference ASC SELECT reserved FROM ps_stock_available WHERE id_product = 4259506 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(624, p.buum_cats) > 0 OR FIND_IN_SET(4259506, p.product_ids)) ORDER BY p.id_promo DESC SELECT * FROM ps_meta_values WHERE type = 'product' AND item_id = 4259506 AND meta_key = 'secondary_ean' LIMIT 1 Table clock Bicycle Black Metal 95 x 50 x 12 cm - Alarm clocks & clock radios - Photopoint
SELECT *, ( IF ('2025-01-08 23:42:50' >= `from` AND '2025-01-08 23:42:50' <= `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, 4259506) 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:42:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:50' <= `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:50' >= `from` AND '2025-01-08 23:42:50' <= `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, 4259506) 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:42:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:50' <= `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:50' >= `from` AND '2025-01-08 23:42:50' <= `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, 4259506) 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:42:50' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-08 23:42:50' <= `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 = 4259506 AND meta_key = 'unit' LIMIT 1 SELECT * FROM ps_feature_group_relations_product WHERE id_product = 4259506 AND id_feature = 1384 LIMIT 1 SELECT unit, ratio FROM ps_product WHERE id_product = 4259506 AND ratio != 1 AND ratio != 0 LIMIT 1

Table clock Bicycle Black Metal 95 x 50 x 12 cm

SELECT * FROM ps_dailydeals WHERE id_product = 4259506 LIMIT 1
69,99 €

583,25 € / M

Monthly payment starting from 2,09 €

Open installments calculator

Photopoint hire purchase calculator

Please add some items to your shopping cart and choose "hire purchase" for the payment type

Main info

If you want to add a touch of originality to your home, you will do so with Table clock Bicycle Black Metal 95 x 50 x 12 cm.



  • Type: Table clock
  • Design: Bicycle
  • Colour: Black
  • Material: Metal
  • Approx. dimensions: 95 x 50 x 12 cm

Dimensions and weights

Gross weight
3.4 kg
Package width
97.5 cm
Package height
16 cm
Package length
52 cm

Product codes

EAN
8430852834287

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 = 4259506 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