This will count the second field ignoring duplicates

perl -F: -e 'END { print "$_ $c{$_}\n" for keys %c }' \
       -ane '$c{$F[1]}++ unless $d{"@F[1,2]"}++'
[download]

I assume this is what you meant no duplicates in the third field.
HTH

_________
broquaint