hitachi - tool accessories

Hitachi tools, Japan's leading manufacturer of Power Tools, air tools & accessories through cutting edge research, with an unmatched commitment to make their tools & accessories safer, easier and less tiring for the user through our uncompromising adherence to the highest standards of quality in design, material and workmanship. Hitachi extensive range covers cordless tools, power tools & air nail guns
SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`price`, `e`.`small_image`, `e`.`status`, `e`.`tax_class_id`, `e`.`url_key`, `e`.`thumbnail`, `e`.`short_description`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`required_options`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`links_purchased_separately`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`links_exist`, `e`.`wtp_model`, `e`.`call_for_price_active`, `e`.`tool_a_day_date`, `e`.`tool_a_day_price`, `e`.`wtp_nav_product`, `e`.`wtp_newsletter`, `e`.`wtp_bonus_description`, `e`.`wtp_bonus_type`, `e`.`wtp_bonus_type_value`, `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` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '588' AND cat_index.is_parent=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 WHERE (e.status = 1) ORDER BY `e`.`name` ASC LIMIT 48
-
-
-
Regular Price:
$69.00
Special Price
$35.00
-
Regular Price:
$99.00
Special Price
$69.00
-