Select DISTINCT
  , if(ISt.Price < ISt.MAP, ISt.MAP, ISt.Price) as IStPrice
  , ISt.MAP as MAP
  , if(Items.SaleAmount > 0, format(if(Items.SaleType='P',ISt.Price-((Items.SaleAmount/100)*ISt.Price),ISt.Price-Items.SaleAmount),2), Items.SalePrice) as IStSalePrice
  , ISt.Quantity
  , ISt.MinQuantity
  , ISt.WQuantity
  , ISt.WMinQuantity
  , ISt.SaleType as IStSaleType
  , ISt.SaleAmount as IStSaleAmount
  , if(ISt.SaleType Is Not Null, format(if(ISt.SaleType='P',((1-(ISt.SaleAmount/100))*ISt.Price),ISt.Price-ISt.SaleAmount),2), 0) as IStStoreSalePrice
  , ISt.IntShowPrice as IntShowPrice
  , ISt.IntShowStock as IntShowStock
  , ISt.SpecialOrder
  , ISt.MapOverRide
  Items Items
  , ItemStatus ISt
  and ISt.ItemNo=substr(Items.PLU,1,locate('-',concat(Items.PLU, '-'))-1)
  and ISt.Price > 0.00
  and (ISt.MinQuantity + ISt.WMinQuantity>0.00 or ISt.SpecialOrder=1) and Items.PLU = '481'
Order by
    Items.SortOrder, Items.Description

->getMessage(): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query

Vacuum Doctor - Online Store
Vacuum Doctor
Vacuum Doctor
Kalamazoo, Portage, Battle Creek Michigan
Sales - Service - Repair - Parts - Supplies
Sewing and Quilting Supplies
Janitorial Supplies
New - Used - Rebuilt
Bags - Filters - Belts - Attachments
Privacy Policy
Contact Us

The Vacuum Doctor has changed their name. We are now Bernie's Sew & Vac. Please visit our new site at: BerniesSewVac.com

This site will continue to take orders and be updated with new products but Bernie's Sew & Vac will be main site.

Sorry but the item you are looking for is currently not available on our online store.