SELECT SQL_CALC_FOUND_ROWS UniqueID, Dealer, Year, Make, Model, FullModel, Body, BodyStyle, Doors, Color, IntColor, BaseColor, BaseIntColor, Transmission, Cylinders, Liters, EngineDescription, AC, Comments, Pedigree, IF(0 > 0, Price + 0, Price) AS Price, DownPayment, PmntAmount, InternetPrice, SuggestedRetail, WholesalePrice, VehicleCost, Miles, Excess, TMU, PictureTotal, City, Hwy, DateAdded, DateUpdated, VIN, StockNumber, OptionsAll, Measurements, Warranty, Drivetrain, EquipPack, SalesStatus, Notes, NewUsed, Utube, FuelType, LotLocation, GoodMake, TextID, VIN AS VINTrue FROM Inventory  WHERE (Dealer = 'VA1608') ORDER BY StockNumber DESC DESC LIMIT 75, 25