SELECT DISTINCTROW tRecordings.Year, tRecordings.Medium_code, tRecordings.Recording_number, tRecordings.Cover, tSingers.CName, tTitles.CTitle, tTitles.Type, tTitles.Title_number, tCastCodes.Cast_name
FROM tCastCodes INNER JOIN ((tRecordings INNER JOIN tTitles ON tRecordings.TNumber = tTitles.Title_number) INNER JOIN (tSingRec INNER JOIN tSingers ON tSingRec.Singer_number = tSingers.Singer_number) ON tRecordings.Recording_number = tSingRec.RNumber) ON tCastCodes.Cast_code = tRecordings.Cast_code
WHERE (((tSingers.Singer_number)=#URL.Singer#) AND ((tTitles.Title_number)=[tRecordings].[TNumber]) AND ((tCastCodes.Cast_code)=[tRecordings].[Cast_code]) AND ((tTitles.Type)='FST' Or (tTitles.Type) Is Null))
ORDER BY tRecordings.Year
#qSingRec.CName#