mysql> SELECT fm.id, fm.game_id, fs.*, count(fs.position) as poscnt
    -> FROM fantasy_match fm, fantasy_starter fs
    -> WHERE fm.id = fs.match_id
    -> AND fm.game_id = 26
    -> AND fm.status = 'pending'
    -> AND fs.position = 'RB'
    -> AND fs.rank = 0
    -> GROUP BY fm.id, fs.member_id, fs.position
    -> HAVING poscnt <> 2;
+-------+---------+---------+----------+-----------+----------+------------------+------+--------+
| id    | game_id | id      | match_id | member_id | position | person_key       | rank | poscnt |
+-------+---------+---------+----------+-----------+----------+------------------+------+--------+
| 34344 |      26 | 1340504 |    34344 |  10682950 | RB       | l.nfl.com-p.2438 |    0 |      1 |
| 37436 |      26 | 1493138 |    37436 |        21 | RB       | l.nfl.com-p.6618 |    0 |      1 |
+-------+---------+---------+----------+-----------+----------+------------------+------+--------+


mysql> select * from fantasy_starter where match_id = 34344;
+---------+----------+-----------+----------+------------------+------+
| id      | match_id | member_id | position | person_key       | rank |
+---------+----------+-----------+----------+------------------+------+
| 1340472 |    34344 |  10682950 | WR       | l.nfl.com-p.7334 |    1 |
| 1340474 |    34344 |  10682950 | WR       | l.nfl.com-p.886  |    2 |
| 1340476 |    34344 |  10682950 | WR       | l.nfl.com-p.5667 |    3 |
| 1340478 |    34344 |  10682950 | WR       | l.nfl.com-p.3540 |    0 |
| 1340480 |    34344 |  10682950 | WR       | l.nfl.com-p.1417 |    0 |
| 1340482 |    34344 |  10682950 | WR       | l.nfl.com-p.6494 |    0 |
| 1340484 |    34344 |  10682950 | TE       | l.nfl.com-p.6778 |    4 |
| 1340486 |    34344 |  10682950 | TE       | l.nfl.com-p.5065 |    0 |
| 1340488 |    34344 |  10682950 | DT       | l.nfl.com-t.10   |    5 |
| 1340490 |    34344 |  10682950 | DT       | l.nfl.com-t.20   |    0 |
| 1340492 |    34344 |  10682950 | QB       | l.nfl.com-p.4608 |    6 |
| 1340494 |    34344 |  10682950 | QB       | l.nfl.com-p.1328 |    0 |
| 1340496 |    34344 |  10682950 | K        | l.nfl.com-p.1327 |    7 |
| 1340498 |    34344 |  10682950 | K        | l.nfl.com-p.3268 |    0 |
| 1340500 |    34344 |  10682950 | RB       | l.nfl.com-p.24   |    8 |
| 1340502 |    34344 |  10682950 | RB       | l.nfl.com-p.8285 |    9 |
| 1340504 |    34344 |  10682950 | RB       | l.nfl.com-p.2438 |    0 |
| 1316686 |    34344 |  15628352 | QB       | l.nfl.com-p.22   |    6 |
| 1316688 |    34344 |  15628352 | QB       | l.nfl.com-p.4820 |    0 |
| 1316690 |    34344 |  15628352 | RB       | l.nfl.com-p.7508 |    1 |
| 1316692 |    34344 |  15628352 | RB       | l.nfl.com-p.7551 |    2 |
| 1316694 |    34344 |  15628352 | RB       | l.nfl.com-p.6618 |    0 |
| 1316696 |    34344 |  15628352 | RB       | l.nfl.com-p.904  |    0 |
| 1316698 |    34344 |  15628352 | K        | l.nfl.com-p.1327 |    9 |
| 1316700 |    34344 |  15628352 | K        | l.nfl.com-p.4573 |    0 |
| 1316702 |    34344 |  15628352 | WR       | l.nfl.com-p.3540 |    3 |
| 1316704 |    34344 |  15628352 | WR       | l.nfl.com-p.5979 |    4 |
| 1316706 |    34344 |  15628352 | WR       | l.nfl.com-p.6386 |    5 |
| 1316708 |    34344 |  15628352 | WR       | l.nfl.com-p.4844 |    0 |
| 1316710 |    34344 |  15628352 | WR       | l.nfl.com-p.1246 |    0 |
| 1316712 |    34344 |  15628352 | WR       | l.nfl.com-p.7334 |    0 |
| 1316714 |    34344 |  15628352 | TE       | l.nfl.com-p.5814 |    7 |
| 1316716 |    34344 |  15628352 | TE       | l.nfl.com-p.3723 |    0 |
| 1316718 |    34344 |  15628352 | DT       | l.nfl.com-t.20   |    8 |
| 1316720 |    34344 |  15628352 | DT       | l.nfl.com-t.17   |    0 |
+---------+----------+-----------+----------+------------------+------+