SELECT * FROM historictaskprobe
WHERE EXISTS (
SELECT 1 FROM historictaskprobe p2
WHERE historictaskprobe.size = p2.size
AND historictaskprobe.basename = p2.basename
AND historictaskprobe.abspath = p2.abspath
AND historictaskprobe.size = p2.size
AND historictaskprobe.type = p2.type
AND historictaskprobe.historictask_id > p2.historictask_id
);