var ClinicalASSPATINCVM = (from s in db.ClinicalAssets
                                       join cp in db.ClinicalPATs on s.ClinicalAssetID equals cp.ClinicalAssetID into AP
                                       from subASSPAT in AP.DefaultIfEmpty()
                                       join ci in db.ClinicalINSs on s.ClinicalAssetID equals ci.ClinicalAssetID into AI
                                       from subASSINC in AI.DefaultIfEmpty()
                                       join co in db.ClinicalReadings on s.ClinicalAssetID equals co.ClinicalAssetID into AR
                                       let subASSRED = AR.OrderByDescending(subASSRED => subASSRED.MeterReadingDone).FirstOrDefault()


                                       select new ClinicalASSPATINCVM
                                       {
                                           ClinicalAssetID = s.ClinicalAssetID,
                                           AssetTypeName = s.AssetTypeName,
                                           ProductName = s.ProductName,
                                           ModelName = s.ModelName,
                                           SupplierName = s.SupplierName,
                                           ManufacturerName = s.ManufacturerName,
                                           SerialNo = s.SerialNo,
                                           PurchaseDate = s.PurchaseDate,
                                           PoNo = s.PoNo,
                                           Costing = s.Costing,
                                           TeamName = s.TeamName,
                                           StaffName = s.StaffName,
                                           WarrantyEndDate = subASSPAT.WarrantyEndDate,
                                           InspectionDate = subASSPAT.InspectionDate,
                                           InspectionOutcomeResult = subASSPAT.InspectionOutcomeResult,
                                           InspectionDocumnets = subASSPAT.InspectionDocumnets,
                                           LastTypeofInspection = subASSINC.LastTypeofInspection,
                                           NextInspectionDate = subASSINC.NextInspectionDate,
                                           NextInspectionType = subASSINC.NextInspectionType,
                                           MeterReadingDone = subASSRED.MeterReadingDone,
                                           MeterReadingDue = subASSRED.MeterReadingDue,
                                           MeterReading = subASSRED.MeterReading,
                                           MeterUnitsUsed = subASSRED.MeterUnitsUsed,
                                           FilterReplaced = subASSRED.FilterReplaced


                                       }).FirstOrDefault(x => x.ClinicalAssetID == id);