SELECT *
FROM Items
INNER JOIN `year` ON Items.YR2 = Year.YR2
INNER JOIN `Condition` ON Items.MaterialID = `Condition`.Code
LEFT JOIN Series ON Items.SeriesID = Series.SeriesID
INNER JOIN Material ON Items.MaterialID = Material.MaterialID
INNER JOIN Category ON Items.CatID = Category.CatID
WHERE Items.CatID = '35';