SELECT t.trackedentityinstanceid, t.uid, pi.programid, pi.status,t.created, COUNT(*)
FROM programinstance pi
INNER JOIN trackedentityinstance t ON (t.trackedentityinstanceid=pi.trackedentityinstanceid)
WHERE pi.trackedentityinstanceid IS NOT NULL AND pi.status='ACTIVE' GROUP BY t.trackedentityinstanceid, t.uid, pi.programid, pi.status, t.created HAVING COUNT(*) > 1 order by t.created;