Your WHERE conditions doesn't restrict on the rows being of the same party_id. If you where using modern JOIN syntax you should have seen it earlier.