select C.Vintage, A.*, B.id as CartID, B.VintageID, B.VolumeID, B.Photo, B.Photo2, B.Photo3, B.Amount, B.Qty, B.Packing, B.Status as OnlineStatus from tblWine as A, tblOnlineShop as B, tblVintage as C where B.VintageID=C.id and A.UT_Status=1 and B.UT_Status=1 and B.Status=2 and A.id=B.WineID and A.CountryID=9 group by A.id, B.VintageID, B.VolumeID order by B.UT_Sort desc, id desc



Shop Wines