I think the problem is in the GROUP BY clause. If I remember correctly, group by alone will return 1 record.