I only want to select the rows from dvd_moderators that appear only once, that is that have been moderated once only and not more and that don't match the userID given (9 in this example).dvd_moderators would look something like this:

id dogTag moderator
219 2 9
2226 2 7

Of course the moderator ID would change for other entries.Using a COUNT works mostly except when the userID matches the moderator:

Then it reports it as being moderated only once (which is a correct query, it is discarding the row that matches moderator = 9 and hence the count is coming out to 1 instead of 2) but incorrect for the purposes I need.Basically I want the rows that have been moderated only once and that one of those moderators does not match the userID (9 in the example above).How could I achieve this?Thanks.