When I put this in phpMyAdmin, I get the exact results I want in a pretty table with two columns, the tkid and the count for how many times that tkid shows up in the xd2e_trooptrack_attendee table.