sp tools
SP Tools are manufactured to some of the highest standards and are suitable for all trades. Each hand tool is available singularly or you can make your buying decision by selecting one of our comprehensive range of complete tool sets, including the popular apprentice starter kits.
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 = '515' 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:
$19.00
Special Price
$9.95
-
-
Regular Price:
$359.00
Special Price
$275.00
-
Regular Price:
$150.00
Special Price
$129.00
-
Regular Price:
$259.00
Special Price
$199.00
-
Regular Price:
$69.00
Special Price
$49.00
-
Regular Price:
$259.00
Special Price
$179.00
-
Regular Price:
$99.00
Special Price
$79.00
-
Regular Price:
$79.00
Special Price
$59.00
-
Regular Price:
$119.00
Special Price
$99.00
-
Regular Price:
$159.00
Special Price
$129.00
-
Regular Price:
$129.00
Special Price
$99.00
-
Regular Price:
$359.00
Special Price
$285.00
-
-
Regular Price:
$49.00
Special Price
$29.00
-
Regular Price:
$49.00
Special Price
$39.00