select l.LotNumber, i.ItemID, rfs.RFSID, i.DateSubmitted, tr.TradeName, sub.CompanyName, i.Location, i.Title, i.Description, i.Reviewed, i.InspectionRequired,
i.Appointment, i.DateSubmitted, i.DateCompleted, i.DateClosed, i.CurrentAge, it.ItemDescription, pr.TheProblem
from Projects p
inner join ProjectPhases pp on p.ProjectID = pp.ProjectID
inner join Lots l on l.PhaseID = pp.PhaseID
inner join RequestForService rfs on rfs.LotID = l.LotID
inner join Items i on rfs.RFSID = i.RFS
inner join RequestTypes rt on rt.ReqTypeID = rfs.ReqTypeID
inner join Trades tr on i.TradeID = tr.TradeID
inner join SubContractors sub on i.SubID = sub.SubID
inner join ItemToRepair it on i.Item2RepairID = it.Item2RepairID
inner join Problem pr on i.ProblemID = pr.ProblemID
where p.ProjectName = 'Alameda Landing - Linear'