Mine

SELECT Items.ItemID, Items.YR2, Items.Item_Name, Items.QCode, `Condition`.`Condition`, Items.Price, Items.Picture, Items.Dated, Items.Code, Year.YR FROM Items INNER JOIN Year ON Items.YR2 = Year.YR2 INNER JOIN `Condition` ON Items.MaterialID = `Condition`.Code INNER 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' ORDER BY Item_Name