Getting duplicate values

Question

hi ,

 

I am getting duplicate values . but i used distinct still getting duplicates

 

please help me

SELECT DISTINCT p.EmployeeId,
p.ProjectEmployeeId,
p.StartDate,
p.EndDate,
p.AllocationPercentage,
CONCAT(e.FirstName,' ', e.LastName)AS EmployeeName
FROM projectemployee p
LEFT OUTER JOIN employee e ON p.EmployeeId=e.EmployeeId
WHERE CURDATE() NOT BETWEEN p.StartDate AND p.EndDate OR p.AllocationPercentage <100
ORDER BY e.FirstName ASC;