SELECT TOP 1 Wi.ReferenceNumber AS workflowinstancereference, AdDe.Description AS decision, Ad.meetingdate, Ard.ApplicationNumber
FROM App.ApplicationDetails Ard
	INNER JOIN App.ApplicationAdjudications Ara ON Ard.ApplicationDetailID = Ara.ApplicationDetailID
	INNER JOIN App.Vw_AdjudicationDetails Ad ON Ara.AdjudicationDetailID = Ad.AdjudicationDetailID
	INNER JOIN App.AdjudicationDecisions AdDe ON Ara.FinalAdjudicationDecisionID = AdDe.AdjudicationDecisionID
	INNER JOIN Wf.WorkflowInstances Wi ON Ard.WorkflowInstanceID = Wi.WorkflowInstanceID
	WHERE  Ard.ApplicationDetailID = [[applicationdetailid]]  ORDER BY Ara.AdjudicationDetailID DESC 