SELECT DISTINCTROW tRecordings.Year, tRecordings.Medium_code, tRecordings.Recording_number, tRecordings.Cover, tConductors.CondFullName, 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 (tCondRec INNER JOIN tConductors ON tCondRec.Cond_number = tConductors.Cond_number) ON tRecordings.Recording_number = tCondRec.Recording_number) ON tCastCodes.Cast_code = tRecordings.Cast_code
WHERE (((tConductors.Cond_number)=#URL.Conductor#) 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
<CFOUTPUT>#qConductor.CondFullName#</CFOUTPUT>