SELECT UniqueID, Year, Make, Model, EquipPack, Type, Length, SleepCap, EngMake, EngModel, FuelType, Color, IntColor, Comments, Price, MSRP, Dealer, Comments, Price, Miles, PicBaseName, PictureTotal, CONCAT(PicBaseName, 'A.jpg') AS Picture, IF(PictureTotal >= 2, CONCAT(PicBaseName, 'B.jpg'), '') AS Picture2, IF(PictureTotal >= 3, CONCAT(PicBaseName, 'C.jpg'), '') AS Picture3, IF(PictureTotal >= 4, CONCAT(PicBaseName, 'D.jpg'), '') AS Picture4, IF(PictureTotal >= 5, CONCAT(PicBaseName, 'E.jpg'), '') AS Picture5, IF(PictureTotal >= 6, CONCAT(PicBaseName, 'F.jpg'), '') AS Picture6, IF(PictureTotal >= 7, CONCAT(PicBaseName, 'G.jpg'), '') AS Picture7, IF(PictureTotal >= 8, CONCAT(PicBaseName, 'H.jpg'), '') AS Picture8,  Stocknumber, SaleSpecial, Miles, ExtHeight, IntHeight, FreshWater, GreyWater, BlackWater, TireSize, FurnaceBTU, Option1, Option2, Option3, Option4, Option5, Option6, Option7, Option8, Option9, Option10, Option11, Option12, Option13, Option14, Option15, Option16, Option17, Option18, Option19, Option20, Option21, Option22, Option23, Option24, Option25, Option26, Option27, Option28, Option29, Option30, Option31, Option32, Option33, Option34, Option35, UTube, Configuration, Width, Height, Loading, Slides, TowWeight, DryWeight, GrossWeight, HitchWeight, CargoWeight, KitchenSpecs, BedroomSpecs, LivingSpecs,  BunkSpecs, Utube, BathroomSpecs, VIN, NewUsed, Title, Draft, FuelCapacity, SeatingCapacity, WeightCapacity, HorsePower, Hours, Hull, Livewell, MaxTorque, MaxBallast FROM campers WHERE Dealer = 'NewLondon' AND UniqueID = '6843' Not available