SELECT player, pitching.id, era, season, roster.nameID, IF( elig = 1,1,0) as elig FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY elig DESC, era ASC, player ASC SELECT player, pitching.id, w, season, roster.nameID FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY w DESC, player ASC SELECT player, pitching.id, k, season, roster.nameID FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY k DESC, player ASC SELECT player, pitching.id, ip, season, roster.nameID FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY ip DESC, player ASC SELECT player, pitching.id, whip, season, roster.nameID, IF( elig = 1,1,0) as elig FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY elig DESC, whip ASC, player ASC SELECT player, pitching.id, oba, season, roster.nameID, IF( elig = 1,1,0) as elig FROM pitching INNER JOIN roster ON pitching.id = roster.id WHERE player <> 'Totals' AND season = 21 AND game = 0 ORDER BY elig DESC, oba ASC, player ASC