(SELECT p_sale.quantity AS `order_value`, p.*, product_shop.*, pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_upd`, DATE_SUB("2024-06-12 00:00:00", INTERVAL 0 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, MAX(ag.`is_color_group`), CONCAT_WS("-", "spa", "a", p.id_product, pa.id_product_attribute) as `id_product_pack`, 1 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 11 AND c.nright <= 16) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 7 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 7 ) 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=7) 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 m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 7) JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON ( p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=7 ) LEFT JOIN `ps_product_sale` p_sale ON (p_sale.`id_product` = p.`id_product`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE product_shop.`id_shop` = 7 AND product_shop.`active` = 1 AND cp.`id_category` > 0 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute`) UNION ALL (SELECT p_sale.quantity AS `order_value`, p.*, product_shop.*, pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-06-12 00:00:00", INTERVAL 0 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, "0" as `is_color_group`, "spa-nochanges" as `id_product_pack`, 0 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 11 AND c.nright <= 16) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 7 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 7 ) 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=7) 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 m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` 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` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=7) LEFT JOIN `ps_product_sale` p_sale ON (p_sale.`id_product` = p.`id_product`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE product_shop.`id_shop` = 7 AND product_shop.`active` = 1 AND cp.`id_category` > 0 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `order_value` DESC LIMIT 0,12(SELECT p_sale.quantity AS `order_value`, p.*, product_shop.*, pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_upd`, DATE_SUB("2024-06-12 00:00:00", INTERVAL 0 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, MAX(ag.`is_color_group`), CONCAT_WS("-", "spa", "a", p.id_product, pa.id_product_attribute) as `id_product_pack`, 1 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 11 AND c.nright <= 16) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 7 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 7 ) 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=7) 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 m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` JOIN `ps_pm_spa_cache` pa_cartesian ON (pa_cartesian.`id_product` = p.`id_product` AND pa_cartesian.`id_product_attribute` = pa.`id_product_attribute` AND pa_cartesian.`id_shop` = 7) JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON ( p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.id_shop=7 ) LEFT JOIN `ps_product_sale` p_sale ON (p_sale.`id_product` = p.`id_product`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE product_shop.`id_shop` = 7 AND product_shop.`active` = 1 AND cp.`id_category` > 0 AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 0 = 1, stock.`out_of_stock` = 1)) AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.`id_product`, pa.`id_product_attribute`) UNION ALL (SELECT p_sale.quantity AS `order_value`, p.*, product_shop.*, pl.`name`, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(stock.quantity, 0) AS quantity_sql, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-06-12 00:00:00", INTERVAL 0 DAY)) > 0 AS new, (product_shop.`price` + IFNULL(product_attribute_shop.`price`, 0)) AS orderprice, cp.`position`, a.`position` as `position_attribute`, pa.`id_product_attribute` as pai_id_product_attribute, "0" as `is_color_group`, "spa-nochanges" as `id_product_pack`, 0 AS spa_eligible_product FROM `ps_category_product` cp RIGHT JOIN `ps_category` c ON (c.`id_category` = cp.`id_category` AND c.nleft >= 11 AND c.nright <= 16) LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 7) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 7 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 7 ) 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=7) 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 m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute` pa ON pa.`id_product` = p.`id_product` 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` AND (a.`id_attribute_group` IN (1)) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`id_product_attribute` = pac.`id_product_attribute` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=7) LEFT JOIN `ps_product_sale` p_sale ON (p_sale.`id_product` = p.`id_product`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1 AND stock.id_shop = 0 ) WHERE product_shop.`id_shop` = 7 AND product_shop.`active` = 1 AND cp.`id_category` > 0 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product HAVING (COUNT(a.`id_attribute`) = 0) ) ORDER BY `order_value` DESC LIMIT 0,51 Compra Botas Caña Alta de Cuero en ZAPPA.cl
pin
pin

¿Dónde quieres recibir tu compra?

Botas Mujer

Las impactantes botas altas de Zappa.cl son unas verdaderas piezas de moda. Fabricadas con una calidad insuperable, estas botas de cuero destacan por su calidad premium, que garantiza durabilidad y un acabado impecable. No esperes más, y encuentra en nuestro catálogo las increíbles botas largas, botas texanas, bucaneras que tenemos para ofrecerte, y deja una huella imborrable con cada paso que des.

Producto añadido a la lista de deseos
Producto añadido para comparar.

Al navegar en nuestro sitio aceptas el uso de cookies para mejorar tu experiencia.
Revisa nuestra política de privacidad y nuestra política de cookies.

Cookies!