string(458) "SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.homegourmet.be' OR su.domain_ssl = 'www.homegourmet.be') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC" string(518) "SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name" string(258) "SELECT c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)" string(89) "SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1" string(58) "SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = 33) LIMIT 1" string(283) " SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 33 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1" string(80) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agilemultipleseller" LIMIT 1" string(78) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agilemultipleshop" LIMIT 1" string(62) "SELECT id_seller FROM `ps_sellerinfo` WHERE id_shop=33 LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=36 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 32) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 32" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 2108) LIMIT 1" string(105) "SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)" string(237) "SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 3) LIMIT 1" string(69) "SELECT * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1" string(135) "SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1" string(130) " SELECT domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1" string(74) "SELECT `id_module` FROM `ps_module` WHERE `name` = "webpgenerator" LIMIT 1" string(90) "SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 143 AND `id_shop` = 1 LIMIT 1" string(180) " SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1" string(63) "SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1" string(95) " SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1" string(547) "SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` `h` ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` " string(43) "SELECT `name`, `alias` FROM `ps_hook_alias`" string(39) "SELECT `id_hook`, `name` FROM `ps_hook`" string(241) " SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1" string(39) "SELECT name, alias FROM `ps_hook_alias`" string(241) " SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1" string(186) "SELECT m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC" string(53) "SELECT * FROM `ps_currency` c ORDER BY `iso_code` ASC" string(133) "SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1" string(74) "SELECT c.id_currency FROM `ps_currency` c WHERE (iso_code = 'EUR') LIMIT 1" string(245) "SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1 LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1" string(133) "SELECT `id_lang` FROM `ps_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT 1" string(80) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agileproductreviews" LIMIT 1" string(140) "SELECT * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1" string(64) "SELECT * FROM `ps_group_lang` WHERE `id_group` = 1" string(97) " SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1" string(155) "SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1" string(70) "SELECT * FROM `ps_currency_lang` WHERE `id_currency` = 1" string(103) " SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1" string(57) "SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1" string(282) " SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1" string(80) "SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)" string(241) " SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1" string(37) "SHOW TABLES LIKE "%ps_social_login_%"" string(87) "SELECT `id_hook` FROM `ps_social_login_position` WHERE (`id_shop`=1) AND (`active`= 1) " string(80) " SELECT `name` FROM `ps_hook` WHERE `id_hook` = 117 LIMIT 1" string(79) " SELECT `name` FROM `ps_hook` WHERE `id_hook` = 64 LIMIT 1" string(80) " SELECT `name` FROM `ps_hook` WHERE `id_hook` = 712 LIMIT 1" string(266) "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` = 15010810) AND (b.`id_shop` = 1) LIMIT 1" string(106) " SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 0 AND `active` = 1 LIMIT 1" string(68) " SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1" string(229) "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" string(353) "SELECT h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position" string(479) " SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 3 AND tr.`id_tax_rules_group` = 13 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC" string(55) "SELECT * FROM `ps_tax` a WHERE (a.`id_tax` = 6) LIMIT 1" string(60) "SELECT * FROM `ps_tax_lang` WHERE `id_tax` = 6" string(586) " 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)INNER JOIN ps_product_owner product_owner ON (p.id_product=product_owner.id_product AND IFNULL(product_owner.id_owner,0) IN (36)) WHERE p.id_product = 15010810 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "2024-05-03 00:00:00", INTERVAL 20 DAY ) ) > 0 " string(349) "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 = 15010810 LIMIT 1" string(638) "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) 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 ) WHERE product_attribute_shop.default_on = 1 AND IFNULL(stock.quantity, 0) >= 1 AND pa.id_product = 15010810 LIMIT 1" string(62) "SELECT 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1" string(69) "SELECT 1 FROM `ps_specific_price` WHERE id_product = 15010810 LIMIT 1" string(584) "SELECT p.`id_product`, product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) 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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 15010810) ORDER BY id_product_attribute " string(187) " SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 15010810 AND id_shop=1 LIMIT 1" string(160) " 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`=15010810" string(157) "SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(156) "SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(160) "SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(152) "SELECT location FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(142) " SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 15 LIMIT 1" string(1266) " SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` 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)INNER JOIN ps_object_owner attribute_object_owner ON (attribute_object_owner.entity='attribute' AND pac.id_attribute= attribute_object_owner.id_object AND IFNULL(attribute_object_owner.id_owner,0) IN (36,0)) WHERE pa.`id_product` = 15010810" string(39) "SELECT id_tab, class_name FROM `ps_tab`" string(108) " SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 15010810 AND id_shop = 1 LIMIT 1" string(268) "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` = 1 WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1" string(76) " SELECT `iso_code` FROM `ps_country` WHERE `id_country` = 3 LIMIT 1" string(76) "SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1" string(245) "SELECT m.`id_module` as `active`, ms.`id_module` as `shop_active` FROM `ps_module` m LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module` WHERE `name` = "ps_categorytree" AND ms.`id_shop` IN (1) LIMIT 1" string(81) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agilepricecomparison" LIMIT 1" string(376) " SELECT cl.*,c.*, cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE 1 ORDER BY cl.name ASC" string(44) "SELECT * FROM `ps_state` ORDER BY `name` ASC" string(64) "SELECT * FROM ps_product_owner WHERE id_product=15010810 LIMIT 1" string(83) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellerlistoptions" LIMIT 1" string(213) " SELECT * FROM `ps_sellerinfo` si LEFT JOIN `ps_shop` s ON si.id_shop = s.id_shop LEFT JOIN `ps_sellerinfo_lang` sl ON si.id_sellerinfo = sl.id_sellerinfo WHERE si.active = 1 AND sl.id_lang = 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=3 LIMIT 1" string(69) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 2) LIMIT 1" string(74) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 2" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(66) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 35) LIMIT 1" string(84) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '3' LIMIT 1" string(65) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 3) LIMIT 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=6 LIMIT 1" string(69) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 5) LIMIT 1" string(74) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 5" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(66) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 66) LIMIT 1" string(84) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '6' LIMIT 1" string(65) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 6) LIMIT 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=7 LIMIT 1" string(69) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 6) LIMIT 1" string(74) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 6" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(66) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 42) LIMIT 1" string(84) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '7' LIMIT 1" string(65) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 7) LIMIT 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=8 LIMIT 1" string(69) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 7) LIMIT 1" string(74) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 7" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(66) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 77) LIMIT 1" string(84) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '8' LIMIT 1" string(65) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 8) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=11 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 10) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 10" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(67) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 325) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '11' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 11) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=19 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 18) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 18" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(67) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 499) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '19' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 19) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=24 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 23) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 23" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 1044) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '24' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 24) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=28 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 27) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 27" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 1606) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '28' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 28) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=29 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 28) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 28" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 1872) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '30' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 30) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=36 LIMIT 1" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '33' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 33) LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=38 LIMIT 1" string(70) "SELECT * FROM `ps_sellerinfo` a WHERE (a.`id_sellerinfo` = 33) LIMIT 1" string(75) "SELECT * FROM `ps_sellerinfo_lang` WHERE `id_sellerinfo` = 33" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT * FROM `ps_customer` a WHERE (a.`id_customer` = 2329) LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '31' LIMIT 1" string(66) "SELECT * FROM `ps_shop_url` a WHERE (a.`id_shop_url` = 31) LIMIT 1" string(558) " SELECT c.*, cl.* 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)INNER JOIN ps_category_owner category_owner ON (c.id_category=category_owner.id_category AND IFNULL(category_owner.id_owner,0) IN (36,0)) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 AND c.`active` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC " string(73) "SELECT id_owner FROM ps_product_owner WHERE id_product = 15010810 LIMIT 1" string(164) "SELECT sl.company FROM `ps_sellerinfo` si LEFT JOIN `ps_sellerinfo_lang` sl ON si.id_sellerinfo = sl.id_sellerinfo WHERE si.id_seller = 7 AND sl.id_lang = 1 LIMIT 1" string(73) "SELECT id_owner FROM ps_product_owner WHERE id_product = 15010810 LIMIT 1" string(478) " SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 3 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC" string(102) "SELECT c.`nleft`, c.`nright`, c.`level_depth` FROM `ps_category` c WHERE (c.`id_category` = 2) LIMIT 1" string(104) " SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 15 AND id_shop = 1 LIMIT 1" string(674) " 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)INNER JOIN ps_category_owner category_owner ON (c.id_category=category_owner.id_category AND IFNULL(category_owner.id_owner,0) IN (36,0)) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE `id_parent` = 15 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC" string(601) "SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`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)INNER JOIN ps_category_owner category_owner ON (c.id_category=category_owner.id_category AND IFNULL(category_owner.id_owner,0) IN (36,0)) WHERE `id_lang` = 1 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC" string(349) "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 = 15010810 LIMIT 1" string(393) "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 = 15010810 LIMIT 1" string(1152) "SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_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) 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` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 15010810 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`" string(160) "SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 4044) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(160) "SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 4045) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(92) "SELECT COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1" string(112) "SELECT COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1" string(110) "SELECT 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-05-03 00:00:00' AND '2024-05-03 23:59:59' LIMIT 1" string(108) "SELECT 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-05-03 00:00:00' AND '2024-05-03 23:59:59' LIMIT 1" string(179) " SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 15010810 ORDER BY `id_specific_price_priority` DESC LIMIT 1" string(680) " SELECT *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 3, 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 3) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-05-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-05-03 00:00:00' <= `to`) ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC " string(123) " SELECT `price_display_method` FROM `ps_group` WHERE `id_group` = 3 LIMIT 1" string(1266) " SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` 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)INNER JOIN ps_object_owner attribute_object_owner ON (attribute_object_owner.entity='attribute' AND pac.id_attribute= attribute_object_owner.id_object AND IFNULL(attribute_object_owner.id_owner,0) IN (36,0)) WHERE pa.`id_product` = 15010810" string(2471) "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`, image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute, DATEDIFF( p.`date_add`, DATE_SUB( "2024-05-03 00:00:00", 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)INNER JOIN ps_product_owner product_owner ON (p.id_product=product_owner.id_product AND IFNULL(product_owner.id_owner,0) IN (36)) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_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_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`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` = 15010810 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product" string(285) "SELECT ash.* FROM ps_product_owner AS po LEFT JOIN ps_agile_seller_holiday AS ash ON (ash.id_seller = po.id_owner) WHERE po.id_product = 15010810 AND ash.day_from <= '2024-05-09' AND ash.day_to >= '2024-05-09' LIMIT 1" string(1152) "SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_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) 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` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 15010810 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(350) "SELECT * FROM `ps_anproducttabs_content` a0 LEFT JOIN `ps_anproducttabs` `a1` ON (a0.`id_anproducttabs` = a1.`id_anproducttabs`) LEFT JOIN `ps_anproducttabs_content_lang` `a2` ON (a0.`id_anproducttabs_content` = a2.`id_anproducttabs_content`) WHERE (a0.`active` = 1) AND (a0.`id_product` = 15010810) AND (a2.`id_lang` = 1) ORDER BY a1.`position` asc " string(64) "SELECT * FROM ps_product_owner WHERE id_product=15010810 LIMIT 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=7 LIMIT 1" string(165) "SELECT * FROM `ps_sellerinfo` a LEFT JOIN `ps_sellerinfo_lang` `b` ON a.`id_sellerinfo` = b.`id_sellerinfo` AND b.`id_lang` = 1 WHERE (a.`id_sellerinfo` = 6) LIMIT 1" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(79) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agilesellerratings" LIMIT 1" string(303) "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` = 15010810 AND image_shop.`cover` = 1 LIMIT 1" string(96) "SELECT name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 15 LIMIT 1" string(311) " SELECT product_attribute_shop.`price` 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_attribute` = 4044 LIMIT 1" string(105) "SELECT `id_order` FROM `ps_orders` WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1" string(954) "SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 15010810 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 15010810 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1" string(105) "SELECT `id_order` FROM `ps_orders` WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1" string(960) "SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 4044 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 15010810 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 4044 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 15010810 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1" string(660) "SELECT pa.`available_date` FROM `ps_product` p LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)INNER JOIN ps_product_owner product_owner ON (p.id_product=product_owner.id_product AND IFNULL(product_owner.id_owner,0) IN (36)) 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 p.`id_product` = 15010810 AND pa.`id_product` = 15010810 AND pa.`id_product_attribute` = 4044 LIMIT 1" string(831) " SELECT name, value, pf.id_feature, f.position FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)LEFT JOIN ps_object_owner feature_object_owner ON (feature_object_owner.entity='feature' AND f.id_feature= feature_object_owner.id_object AND IFNULL(feature_object_owner.id_owner,0) IN (36)) WHERE pf.id_product = 15010810 ORDER BY f.position ASC" string(1032) " SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pa.`id_product_attribute` = pac.`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) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 15010810 AND pac.`id_product_attribute` = 4044 AND agl.`id_lang` = 1" string(203) "SELECT * FROM `ps_product_attribute` a LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1 WHERE (a.`id_product_attribute` = 4044) LIMIT 1" string(403) " SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` 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) WHERE i.`id_product` = 15010810 ORDER BY `position`" string(111) "SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 15010810" string(376) " SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (4045, 4044) AND il.`id_lang` = 1 ORDER by i.`position`" string(105) "SELECT * FROM `ps_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(111) "SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 15010810" string(376) " SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (4045, 4044) AND il.`id_lang` = 1 ORDER by i.`position`" string(241) "SELECT 1 FROM ps_cart_product cp INNER JOIN ps_product p ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1" string(455) "(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-05-03 00:00:00" AND date_to <= "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-05-03 00:00:00" AND date_from <= "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-05-03 00:00:00" AND date_to > "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1" string(410) "(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = ""))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND free_shipping = 1 AND carrier_restriction = 1)" string(455) "(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2024-05-03 00:00:00" AND date_to <= "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2024-05-03 00:00:00" AND date_from <= "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2024-05-03 00:00:00" AND date_to > "2024-05-03 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1" string(430) "(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0 OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = ""))) AND NOW() BETWEEN cr.date_from AND cr.date_to AND cr.`active` = 1 AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")" string(79) "SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1" string(88) "SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1" string(266) "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` = 15010810) AND (b.`id_shop` = 1) LIMIT 1" string(142) " SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 4 AND cl.id_shop = 1 AND cl.`id_category` = 15 LIMIT 1" string(79) " SELECT format FROM `ps_address_format` WHERE `id_country` = 3 LIMIT 1" string(94) " SELECT `need_identification_number` FROM `ps_country` WHERE `id_country` = 3 LIMIT 1" string(150) "SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 3) LIMIT 1" string(68) "SELECT * FROM `ps_country_lang` WHERE `id_country` = 3" string(80) " SELECT id_required_field, object_name, field_name FROM ps_required_field " string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=36 LIMIT 1" string(166) "SELECT * FROM `ps_sellerinfo` a LEFT JOIN `ps_sellerinfo_lang` `b` ON a.`id_sellerinfo` = b.`id_sellerinfo` AND b.`id_lang` = 1 WHERE (a.`id_sellerinfo` = 32) LIMIT 1" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(68) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=36 LIMIT 1" string(111) "SELECT `name` FROM `ps_country_lang` WHERE `id_country` = 3 AND `id_lang` = 1 LIMIT 1" string(85) " SELECT id_shop_url FROM ps_shop_url WHERE main=1 AND id_shop = '33' LIMIT 1" string(202) "SELECT * FROM `ps_category` a0 LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`) WHERE (a0.`nleft` < 221) AND (a0.`nright` > 312) AND (a1.`id_lang` = 1) ORDER BY a0.`nleft` asc " string(1152) "SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_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) 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` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 15010810 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`" string(156) "SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 15) LIMIT 1" string(89) "SELECT * FROM `ps_category_lang` WHERE `id_category` = 15 AND `id_shop` = 1" string(134) " SELECT tb.id_anthemeblock FROM `ps_anthemeblock` tb WHERE tb.`status` = 1 AND tb.`id_parent` = 0" string(222) "SELECT * FROM `ps_anthemeblock` a0 LEFT JOIN `ps_anthemeblock_lang` `a1` ON (a0.`id_anthemeblock` = a1.`id_anthemeblock`) WHERE (a0.`id_anthemeblock` IN(1, 5, 17, 18, 41)) AND (a1.`id_lang` = 1) ORDER BY a0.`position` asc " string(198) "SELECT * FROM `ps_anthemeblock_data` a0 LEFT JOIN `ps_anthemeblock_data_lang` `a1` ON (a0.`id_anthemeblock_data` = a1.`id_anthemeblock_data`) WHERE (a0.`id_anthemeblock` = 1) AND (a1.`id_lang` = 1) " string(199) "SELECT * FROM `ps_anthemeblock_data` a0 LEFT JOIN `ps_anthemeblock_data_lang` `a1` ON (a0.`id_anthemeblock_data` = a1.`id_anthemeblock_data`) WHERE (a0.`id_anthemeblock` = 18) AND (a1.`id_lang` = 1) " string(199) "SELECT * FROM `ps_anthemeblock_data` a0 LEFT JOIN `ps_anthemeblock_data_lang` `a1` ON (a0.`id_anthemeblock_data` = a1.`id_anthemeblock_data`) WHERE (a0.`id_anthemeblock` = 17) AND (a1.`id_lang` = 1) " string(199) "SELECT * FROM `ps_anthemeblock_data` a0 LEFT JOIN `ps_anthemeblock_data_lang` `a1` ON (a0.`id_anthemeblock_data` = a1.`id_anthemeblock_data`) WHERE (a0.`id_anthemeblock` = 41) AND (a1.`id_lang` = 1) " string(198) "SELECT * FROM `ps_anthemeblock_data` a0 LEFT JOIN `ps_anthemeblock_data_lang` `a1` ON (a0.`id_anthemeblock_data` = a1.`id_anthemeblock_data`) WHERE (a0.`id_anthemeblock` = 5) AND (a1.`id_lang` = 1) " string(79) "SELECT `id_module` FROM `ps_module` WHERE `name` = "agileprepaidcredit" LIMIT 1" string(72) "SELECT `id_module` FROM `ps_module` WHERE `name` = "ps_facebook" LIMIT 1" string(90) "SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 137 AND `id_shop` = 1 LIMIT 1" string(80) " SELECT `name` FROM `ps_hook` WHERE `id_hook` = 538 LIMIT 1" Mouchart & Fils Vins Livraison Bruxelles - Château-Neuf-Du-Pape - Domaine Bois de Boursan - 2014
string(64) "SELECT * FROM ps_product_owner WHERE id_product=15010810 LIMIT 1" string(67) "SELECT id_sellerinfo FROM `ps_sellerinfo` WHERE id_seller=7 LIMIT 1"
Château-Neuf-Du-Pape - Domaine Bois de Boursan - 2014

Château-Neuf-Du-Pape - Domaine Bois de Boursan - 2020

32,50 €
string(121) " SELECT COUNT(*) FROM `ps_an_wishlist_products` WHERE `id_product` = 15010810 LIMIT 1" string(52) " SELECT * FROM `ps_hook` h ORDER BY `name`" string(279) "SELECT * FROM `ps_anthemeblock` a0 LEFT JOIN `ps_anthemeblock_lang` `a1` ON (a0.`id_anthemeblock` = a1.`id_anthemeblock`) WHERE (a0.`status` = 1) AND (a0.`id_parent` = 0) AND (a0.`hook_ids` like '%displayProductAdditionalInfo2') AND (a1.`id_lang` = 1) ORDER BY a0.`position` asc "
0

Options

string(508) " SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, cl.`id_lang` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`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)INNER JOIN ps_category_owner category_owner ON (c.id_category=category_owner.id_category AND IFNULL(category_owner.id_owner,0) IN (36,0)) WHERE cl.`id_lang` = 1 AND c.`id_category` IN (15)"

Quantité

Cépage(s): Syrah, Grenache
Millésime: 2020
Loin des Château-Neuf ultra concentré et riche, ici on joue plutôt la carte de l’élégance et de la finesse, même s’il est puissant et charpenté. Il peut se boire jeune sur son fruit frais mais se gardera une dizaine d’année.

string(52) " SELECT * FROM `ps_hook` h ORDER BY `name`" string(278) "SELECT * FROM `ps_anthemeblock` a0 LEFT JOIN `ps_anthemeblock_lang` `a1` ON (a0.`id_anthemeblock` = a1.`id_anthemeblock`) WHERE (a0.`status` = 1) AND (a0.`id_parent` = 0) AND (a0.`hook_ids` like '%displayProductAdditionalInfo') AND (a1.`id_lang` = 1) ORDER BY a0.`position` asc "
Hurry up! Only 6 item(s) left in Stock!
string(52) " SELECT * FROM `ps_hook` h ORDER BY `name`" string(270) "SELECT * FROM `ps_anthemeblock` a0 LEFT JOIN `ps_anthemeblock_lang` `a1` ON (a0.`id_anthemeblock` = a1.`id_anthemeblock`) WHERE (a0.`status` = 1) AND (a0.`id_parent` = 0) AND (a0.`hook_ids` like '%displayFooterProduct') AND (a1.`id_lang` = 1) ORDER BY a0.`position` asc " string(157) "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` = 15010810) LIMIT 1" string(93) "SELECT * FROM `ps_product_lang` WHERE `id_product` = 15010810 AND `id_shop` = 1" string(142) " SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 15 LIMIT 1" string(156) "SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(160) "SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(152) "SELECT location FROM `ps_stock_available` WHERE (id_product = 15010810) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1" string(1152) "SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_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) 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` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) WHERE pa.`id_product` = 15010810 GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`" string(403) " SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` 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) WHERE i.`id_product` = 15010810 ORDER BY `position`" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(1939) "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`) WHERE pa.`id_product` = 15010810 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" string(111) "SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = 15010810" string(376) " SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `ps_product_attribute_image` pai LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (4045, 4044) AND il.`id_lang` = 1 ORDER by i.`position`"

Château-Neuf-Du-Pape -...

32,50 €

Envie de faire le plein de bonnes choses avec votre Château-Neuf-Du-Pape - Domaine Bois de Boursan - 2020, et de vous faire livrer à domicile chez les meilleurs artisans de Bruxelles? Voici la liste de nos commerces :


- La Bella Frutta: Un des meilleurs primeurs à Bruxelles. Un vaste choix de fruits et légumes en tout genre!


- Laurent Gerbaud: la star montante du chocolat belge !


- Mouchart & Fils: Depuis près de 120 ans, la maison Mouchart & Fils sélectionne et vend des vins et spiritueux d'exceptions.


- La Fruitière: Fromager affineur, la Fruitière va vous faire redécouvrir le fromage!


- Cafés Looze: Torréfaction artisanale belge de cafés.


- Cokoa Pâtisserie Florale: Traiteur sucré sur-mesure basé à Bruxelles. Un vrai atelier de saveurs!


- Wesley's Butcher Shop: Boucher Irlandais incontournable du centre de Bruxelles proposant des viandes d'exception.


- Forcado: DÉCOUVREZ aussi la créativité dépassant le savoir-faire


- La Bella Italia: La cuisine est tenue par 3 chefs cuisiniers qui proposent des plats, épicerie fine, charcuteries, fromages et autres délicieuses saveurs.



Références spécifiques

string(368) "INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')" string(44) "DELETE FROM ps_product_lang WHERE id_shop!=1" string(45) "DELETE FROM ps_category_lang WHERE id_shop!=1" string(45) "DELETE FROM ps_category_shop WHERE id_shop!=1" string(40) "DELETE FROM ps_cms_shop WHERE id_shop!=1" string(40) "DELETE FROM ps_cms_lang WHERE id_shop!=1" string(49) "DELETE FROM ps_cms_category_shop WHERE id_shop!=1" string(49) "DELETE FROM ps_cms_category_lang WHERE id_shop!=1" string(52) " SELECT * FROM `ps_hook` h ORDER BY `name`" string(277) "SELECT * FROM `ps_anthemeblock` a0 LEFT JOIN `ps_anthemeblock_lang` `a1` ON (a0.`id_anthemeblock` = a1.`id_anthemeblock`) WHERE (a0.`status` = 1) AND (a0.`id_parent` = 0) AND (a0.`hook_ids` like '%displayBeforeBodyClosingTag') AND (a1.`id_lang` = 1) ORDER BY a0.`position` asc "