SELECT `e`.*, `at_inventory_in_stock`.`is_in_stock` AS `inventory_in_stock`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) AS `shipto_countries`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `cataloginventory_stock_item` AS `at_inventory_in_stock` ON (at_inventory_in_stock.`product_id`=e.entity_id) AND ((at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=1 ) OR (at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=0) OR (at_inventory_in_stock.use_config_manage_stock = 1 )) INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='31' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='11' INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `catalog_product_entity_varchar` AS `at_shipto_countries_default` ON (`at_shipto_countries_default`.`entity_id` = `e`.`entity_id`) AND (`at_shipto_countries_default`.`attribute_id` = '354') AND `at_shipto_countries_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_shipto_countries` ON (`at_shipto_countries`.`entity_id` = `e`.`entity_id`) AND (`at_shipto_countries`.`attribute_id` = '354') AND (`at_shipto_countries`.`store_id` = 31) INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 1 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '1' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE AND (((IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) IS NULL) OR (IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) = '') OR (IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) = '0') OR (FIND_IN_SET('US', IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value))))) AND (links.product_id = 12615) AND (`e`.`entity_id` != '12615') ORDER BY `position` ASC SELECT `e`.*, `at_inventory_in_stock`.`is_in_stock` AS `inventory_in_stock`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) AS `shipto_countries`, `links`.`link_id`, `link_attribute_position_int`.`value` AS `position` FROM `catalog_product_entity` AS `e` INNER JOIN `cataloginventory_stock_item` AS `at_inventory_in_stock` ON (at_inventory_in_stock.`product_id`=e.entity_id) AND ((at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=1 ) OR (at_inventory_in_stock.use_config_manage_stock = 0 AND at_inventory_in_stock.manage_stock=0) OR (at_inventory_in_stock.use_config_manage_stock = 1 )) INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='31' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='11' INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `catalog_product_entity_varchar` AS `at_shipto_countries_default` ON (`at_shipto_countries_default`.`entity_id` = `e`.`entity_id`) AND (`at_shipto_countries_default`.`attribute_id` = '354') AND `at_shipto_countries_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_varchar` AS `at_shipto_countries` ON (`at_shipto_countries`.`entity_id` = `e`.`entity_id`) AND (`at_shipto_countries`.`attribute_id` = '354') AND (`at_shipto_countries`.`store_id` = 31) INNER JOIN `catalog_product_link` AS `links` ON links.linked_product_id = e.entity_id AND links.link_type_id = 4 LEFT JOIN `catalog_product_link_attribute_int` AS `link_attribute_position_int` ON link_attribute_position_int.link_id = links.link_id AND link_attribute_position_int.product_link_attribute_id = '4' INNER JOIN `catalog_product_entity` AS `product_entity_table` ON links.product_id = product_entity_table.entity_id WHERE AND (((IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) IS NULL) OR (IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) = '') OR (IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value) = '0') OR (FIND_IN_SET('US', IF(at_shipto_countries.value_id > 0, at_shipto_countries.value, at_shipto_countries_default.value))))) AND (links.product_id = 12615) AND (`e`.`entity_id` != '12615') ORDER BY `position` ASC J534321 Tochigi Leather Belt

J534321 Tochigi Leather Belt

SKU
J534321
US$159.00
In stock
Options
J534321
 LengthInchMax length to belt holeMin Length to Belt Hole
30100288777
32105319282
34110339787

* Required Fields

Material

Tochigi leather
Full vegetable tannin finish

A tannin agent extracted from the bark of South American mimosa
Genuine leather that has been tanned over time.
The tanning method is skillfully made using the skills of the craftsman
It is wild and highly complete leather.

Email to a Friend
More Information
Item Number J534321