[09:54 br@puig:~/build/pbpdata/raw_sql ]$ cat update_pbp_rough_switch_pitcher_handedness.sql

DROP TABLE IF EXISTS `tmp_switch_pitchers`;
CREATE TABLE `tmp_switch_pitchers` (
  `game_id` varchar(12) DEFAULT NULL,
  `result_batter` varchar(9) DEFAULT NULL,
  `result_pitcher` varchar(9) DEFAULT NULL,
  `pa_game_batting_team` mediumint(9) DEFAULT NULL,
  `result_batter_hand` char(1) DEFAULT NULL,
  `result_pitcher_hand` char(1) DEFAULT NULL
);


INSERT INTO `tmp_switch_pitchers` VALUES ('LAN201805300','knappan01','vendipa01',35,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('LAN201805300','hernace02','vendipa01',36,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('LAN201806080','albieoz01','vendipa01',18,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('LAN201809040','reyesjo01','vendipa01',38,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('CIN201809100','barnhtu01','vendipa01',24,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('CIN201809100','hamilbi02','vendipa01',27,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201809260','vargail01','vendipa01',35,'R','L');

INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','alonsyo01','vendipa01',13,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','maxwebr01','vendipa01',14,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','eibnebr01','vendipa01',15,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','olsonma02','vendipa01',16,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','smolija01','vendipa01',17,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','semiema01','vendipa01',18,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','wendljo01','vendipa01',19,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201610020','pindech01','vendipa01',20,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609200','goinsry01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609200','saundmi01','vendipa01',42,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609200','pillake01','vendipa01',43,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609160','rasmuco01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','morelmi01','vendipa01',44,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','mazarno01','vendipa01',45,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','desmoia01','vendipa01',46,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','beltrca01','vendipa01',47,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','beltrad01','vendipa01',48,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','odorro01','vendipa01',49,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','lucrojo01','vendipa01',50,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609060','andruel01','vendipa01',51,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','calhoko01','vendipa01',10,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','troutmi01','vendipa01',11,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','pujolal01','vendipa01',12,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','croncj01','vendipa01',13,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','marteje01','vendipa01',14,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','simmoan01','vendipa01',15,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','perezca02','vendipa01',16,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','cowarka01','vendipa01',17,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','pennicl01','vendipa01',18,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','calhoko01','vendipa01',19,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','troutmi01','vendipa01',20,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','pujolal01','vendipa01',21,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','croncj01','vendipa01',22,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','marteje01','vendipa01',23,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','simmoan01','vendipa01',24,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','perezca02','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','cowarka01','vendipa01',26,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','pennicl01','vendipa01',27,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201609030','calhoko01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','gomezca01','vendipa01',34,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','chiriro01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','mazarno01','vendipa01',36,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','ruary01','vendipa01',37,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','beltrca01','vendipa01',38,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','profaju01','vendipa01',39,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','odorro01','vendipa01',40,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608310','morelmi01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','andruel01','vendipa01',17,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','mazarno01','vendipa01',18,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','desmoia01','vendipa01',19,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','beltrca01','vendipa01',20,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','beltrad01','vendipa01',21,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','odorro01','vendipa01',22,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','lucrojo01','vendipa01',23,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','morelmi01','vendipa01',24,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','gomezca01','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','andruel01','vendipa01',26,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201608290','mazarno01','vendipa01',27,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','davisch02','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','trumbma01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','wietema01','vendipa01',32,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','alvarpe01','vendipa01',33,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','schoojo01','vendipa01',34,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','flahery01','vendipa01',35,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','jonesad01','vendipa01',36,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201606120','kimhy01','vendipa01',37,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('NYA201605240','headlch01','vendipa01',33,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('NYA201605240','gregodi01','vendipa01',34,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('NYA201605240','rominau01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','souzast01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','dickeco01','vendipa01',32,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','morrilo01','vendipa01',33,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','kiermke01','vendipa01',34,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','casalcu01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','guyerbr01','vendipa01',36,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','millebr02','vendipa01',37,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','longoev01','vendipa01',38,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','pearcst01','vendipa01',39,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','souzast01','vendipa01',40,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','dickeco01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201605170','morrilo01','vendipa01',42,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604260','lawribr01','vendipa01',41,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604260','garciav01','vendipa01',42,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604260','navardi01','vendipa01',43,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604250','eatonad02','vendipa01',36,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604250','rolliji01','vendipa01',37,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604250','abreujo02','vendipa01',38,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','hardyjj01','vendipa01',24,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','schoojo01','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','reimono01','vendipa01',26,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','rickajo01','vendipa01',27,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','machama01','vendipa01',28,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','jonesad01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','davisch02','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','trumbma01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201604210','josepca01','vendipa01',32,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201604150','holtbr01','vendipa01',24,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201604150','vazquch01','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201604150','bradlja02','vendipa01',26,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604130','headlch01','vendipa01',33,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604130','torrero01','vendipa01',34,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TOR201604130','rominau01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','canoro01','vendipa01',39,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','jonesja06','vendipa01',40,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','morrilo01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','omallsh01','vendipa01',42,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','millebr02','vendipa01',43,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','sucreje01','vendipa01',44,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','marteke01','vendipa01',45,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','seageky01','vendipa01',46,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201510030','hicksjo02','vendipa01',47,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509300','calhoko01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','calhoko01','vendipa01',19,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','troutmi01','vendipa01',20,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','pujolal01','vendipa01',21,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','murphda07','vendipa01',22,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','croncj01','vendipa01',23,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','freesda01','vendipa01',24,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ANA201509290','perezca02','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509260','byrdma01','vendipa01',13,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509260','crawfbr01','vendipa01',14,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509260','willima11','vendipa01',15,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509240','gimench01','vendipa01',17,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509240','deshide02','vendipa01',18,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509240','choosh01','vendipa01',19,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509240','fieldpr01','vendipa01',20,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','beltrad01','vendipa01',38,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','fieldpr01','vendipa01',39,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','venabwi01','vendipa01',40,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','morelmi01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','andruel01','vendipa01',42,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509220','odorro01','vendipa01',43,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509160','eatonad02','vendipa01',18,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509160','sanchca01','vendipa01',19,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509160','abreujo02','vendipa01',20,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509160','cabreme01','vendipa01',21,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509140','johnsmi04','vendipa01',34,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509140','flowety01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509140','eatonad02','vendipa01',36,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509140','ramiral03','vendipa01',37,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('CHA201509140','abreujo02','vendipa01',38,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('TEX201509130','andruel01','vendipa01',33,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509090','lowrije01','vendipa01',22,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509090','gattiev01','vendipa01',23,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509090','rasmuco01','vendipa01',24,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509090','gonzama01','vendipa01',25,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509090','congeha01','vendipa01',26,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','omallsh01','vendipa01',26,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','marteke01','vendipa01',27,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','seageky01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','canoro01','vendipa01',29,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','smithse01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','morrilo01','vendipa01',31,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509050','trumbma01','vendipa01',32,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509040','morrilo01','vendipa01',15,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509040','millebr02','vendipa01',16,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509040','hicksjo02','vendipa01',17,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509040','marteke01','vendipa01',18,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509020','murphda07','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201509020','aybarer01','vendipa01',31,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','lambja01','vendipa01',41,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','tomasya01','vendipa01',42,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','ahmedni01','vendipa01',43,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','castiwe01','vendipa01',44,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','inciaen01','vendipa01',45,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','owingch01','vendipa01',46,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508300','goldspa01','vendipa01',47,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508280','inciaen01','vendipa01',27,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508280','polloaj01','vendipa01',28,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508280','goldspa01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('ARI201508280','peralda01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508260','marteke01','vendipa01',27,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508260','seageky01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508260','cruzne02','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508260','canoro01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508260','smithse01','vendipa01',31,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','zuninmi01','vendipa01',26,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','marteke01','vendipa01',27,'L','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','seageky01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','cruzne02','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','canoro01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('SEA201508240','gutiefr01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508220','longoev01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508220','navada01','vendipa01',30,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508220','forsylo01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508210','navada01','vendipa01',28,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508210','longoev01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508210','loneyja01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508210','forsylo01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','ellisaj01','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','pederjo01','vendipa01',26,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','rolliji01','vendipa01',27,'R','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','hernaen02','vendipa01',28,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','turneju01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','gonzaad01','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201508180','vanslsc01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508170','clevest01','vendipa01',32,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508170','hardyjj01','vendipa01',33,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508170','urruthe01','vendipa01',34,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508170','josepca01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508150','parrage01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508150','jonesad01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BAL201508150','davisch02','vendipa01',30,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','gallojo01','vendipa01',22,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','andruel01','vendipa01',23,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','martile01','vendipa01',24,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','rosalad01','vendipa01',25,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','chiriro01','vendipa01',26,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','deshide02','vendipa01',27,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','choosh01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506100','fieldpr01','vendipa01',29,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506090','chiriro01','vendipa01',34,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506090','alberha01','vendipa01',35,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('OAK201506090','deshide02','vendipa01',36,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506070','pedrodu01','vendipa01',36,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','holtbr01','vendipa01',28,'L','L');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','ramirha01','vendipa01',29,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','napolmi01','vendipa01',30,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','bogaexa01','vendipa01',31,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','bettsmo01','vendipa01',32,'R','R');
INSERT INTO `tmp_switch_pitchers` VALUES ('BOS201506050','swihabl01','vendipa01',33,'L','R');