->vSQL=  
   Select DISTINCT
  Items.*
  , 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',ISt.Price-((ISt.SaleAmount/100)*ISt.Price),ISt.Price-ISt.SaleAmount),2), 0) as IStStoreSalePrice
  , ISt.IntShowPrice as IntShowPrice
  , ISt.IntShowStock as IntShowStock
  , ISt.SpecialOrder
From
  Items Items
  , ItemStatus ISt
Where
  Items.Active="Y" 
  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 = '586'
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
 
Services
Terms
Privacy Policy
About
Contact Us

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