Menu

305 BUFFALO ST | HAMBURG | NY

Knives & Tools

SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`name`, `e`.`short_description`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`small_image`, `e`.`thumbnail`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`status`, `e`.`url_key`, `e`.`required_options`, `e`.`image_label`, `e`.`small_image_label`, `e`.`thumbnail_label`, `e`.`msrp_enabled`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `e`.`tax_class_id`, `e`.`price_type`, `e`.`weight_type`, `e`.`price_view`, `e`.`shipment_type`, `e`.`links_purchased_separately`, `e`.`links_exist`, `e`.`second_thumb`, `e`.`lightspeed_custom_sku`, `e`.`lightspeed_ean`, `e`.`lightspeed_height`, `e`.`lightspeed_tags`, `e`.`lightspeed_vendor`, `e`.`lightspeed_item_type`, `e`.`lightspeed_upc`, `e`.`lightspeed_manu_sku`, `e`.`lightspeed_manufacturer`, `e`.`lightspeed_taxable`, `e`.`lightspeed_length`, `e`.`lightspeed_width`, `e`.`cpsp_enable`, `e`.`cpsp_expand_prices`, `e`.`cpsp_show_lowest`, `e`.`cpsp_show_maxregular`, `e`.`cpsp_enable_tier`, `e`.`cpsp_show_last_price`, `e`.`cpsp_use_preselection`, `e`.`cpsp_use_tier_lowest`, `e`.`lightspeed_5_attribute1`, `e`.`lightspeed_5_attribute1_value`, `e`.`type`, `e`.`color_color`, `e`.`color_color_value`, `e`.`color_size_color`, `e`.`color_size_color_value`, `e`.`color_size_size`, `e`.`color_size_size_value`, `e`.`size_size`, `e`.`size_size_value`, `e`.`three_attributes_attribute1`, `e`.`three_attributes_attribute1_value`, `e`.`three_attributes_attribute2`, `e`.`three_attributes_attribute2_value`, `e`.`three_attributes_attribute3`, `e`.`three_attributes_attribute3_value`, `e`.`lightspeed_5_attribute2`, `e`.`lightspeed_5_attribute2_value`, `e`.`lightspeed_5_attribute3`, `e`.`lightspeed_5_attribute3_value`, `e`.`lightspeed_6_attribute1`, `e`.`lightspeed_6_attribute1_value`, `e`.`lightspeed_7_attribute1`, `e`.`lightspeed_7_attribute1_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_6` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=6 AND cat_index.visibility IN(2, 4) AND cat_index.category_id = '1028' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '6' AND price_index.customer_group_id = 0 WHERE (e.status = 1) ORDER BY `cat_index_position` ASC, `cat_index`.`position` ASC LIMIT 12

Items 1 to 12 of 35 total

View12All
Page:
  1. 1
  2. 2
  3. 3

Items 1 to 12 of 35 total

View12All
Page:
  1. 1
  2. 2
  3. 3