string(2533) "SELECT DISTINCT *, `pd`.`name` AS `name`, `p`.`image`, `pms`.`price`, `pms`.`out_of_stock_status_id` AS `stock_status_id`, ( SELECT `_pd`.`price` FROM `oc_product_discount` AS `_pd` WHERE `_pd`.`product_id` = `p`.`product_id` AND `_pd`.`customer_group_id` = '1' AND `_pd`.`quantity` = '1' AND (( `_pd`.`date_start` IS NULL OR `_pd`.`date_start` <= NOW() ) AND ( `_pd`.`date_end` IS NULL OR `_pd`.`date_end` >= NOW() )) ORDER BY `_pd`.`priority` ASC, `_pd`.`price` ASC LIMIT 1 ) AS `discount`, ( SELECT `_ps`.`price` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `special`, ( SELECT `_ps`.`default_price` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `default_price`, ( SELECT `_ps`.`date_end` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `countdown_end`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc_product_to_store` AS `p2s` INNER JOIN `oc_product_store` AS `pms` ON ( `pms`.`product_id` = `p2s`.`product_id` AND `pms`.`store_id` = '6' AND `pms`.`status` = 1 AND `pms`.`purchasable` = 1 ) INNER JOIN `oc_product` AS `p` ON ( `p`.`product_id` = `pms`.`product_id` AND ( `p`.`date_available` IS NULL OR `p`.`date_available` <= NOW() )) INNER JOIN `oc_product_description` AS `pd` ON ( `pd`.`product_id` = `p`.`product_id` AND `pd`.`store_id` = '6' AND `pd`.`language_id` = '7' ) WHERE `p`.`quantity` > 1 AND `p2s`.`store_id` = '6' AND `p`.`manufacturer_id` = '420' AND `p`.`product_id` != '16709' ORDER BY RAND() LIMIT 5"

string(2499) "SELECT DISTINCT *, `pd`.`name` AS `name`, `p`.`image`, `pms`.`price`, `pms`.`out_of_stock_status_id` AS `stock_status_id`, ( SELECT `_pd`.`price` FROM `oc_product_discount` AS `_pd` WHERE `_pd`.`product_id` = `p`.`product_id` AND `_pd`.`customer_group_id` = '1' AND `_pd`.`quantity` = '1' AND (( `_pd`.`date_start` IS NULL OR `_pd`.`date_start` <= NOW() ) AND ( `_pd`.`date_end` IS NULL OR `_pd`.`date_end` >= NOW() )) ORDER BY `_pd`.`priority` ASC, `_pd`.`price` ASC LIMIT 1 ) AS `discount`, ( SELECT `_ps`.`price` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `special`, ( SELECT `_ps`.`default_price` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `default_price`, ( SELECT `_ps`.`date_end` FROM `oc_product_special` AS `_ps` WHERE `_ps`.`product_id` = `p`.`product_id` AND `_ps`.`customer_group_id` = '1' AND `_ps`.`store_id` = '6' AND (( `_ps`.`date_start` IS NULL OR `_ps`.`date_start` <= NOW() ) AND ( `_ps`.`date_end` IS NULL OR `_ps`.`date_end` >= NOW() )) ORDER BY `_ps`.`priority` ASC, `_ps`.`price` ASC LIMIT 1) AS `countdown_end`, (SELECT `pr`.`points` FROM `oc_product_reward` `pr` WHERE `pr`.`product_id` = `p`.`product_id` AND `pr`.`customer_group_id` = '1') AS `reward`, (SELECT COUNT(*) FROM `oc_review` `r` WHERE `r`.`product_id` = `p`.`product_id` AND `r`.`status` = '1' GROUP BY `r`.`product_id`) AS `reviews` FROM `oc_product_to_store` AS `p2s` INNER JOIN `oc_product_store` AS `pms` ON ( `pms`.`product_id` = `p2s`.`product_id` AND `pms`.`store_id` = '6' AND `pms`.`status` = 1 AND `pms`.`purchasable` = 1 ) INNER JOIN `oc_product` AS `p` ON ( `p`.`product_id` = `pms`.`product_id` AND ( `p`.`date_available` IS NULL OR `p`.`date_available` <= NOW() )) INNER JOIN `oc_product_description` AS `pd` ON ( `pd`.`product_id` = `p`.`product_id` AND `pd`.`store_id` = '6' AND `pd`.`language_id` = '7' ) WHERE `p`.`quantity` > 1 AND `p2s`.`store_id` = '6' AND `p`.`product_id` != '16709' ORDER BY RAND() LIMIT 5"

Livrare rapidăIn 24 de ore de la comanda

Centru de relații cu cliențiiLuni-Vineri 9:00 - 15:00

Plata securizataCumpărați în siguranță

PromoțiiVânzări de până la 50%

Firma verificataEste pe piață de mai bine de 10 ani