UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sony Imagesoft' WHERE gamename = '3 Ninjas Kick Back' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = '36 Great Holes Starring Fred Couples (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = '688 Attack Sub' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Ballistic' WHERE gamename = 'AAAHH!!! Real Monsters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Addams Family Values' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Addams Family, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Adventures of Batman and Robin, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Adventures of Mighty Max, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SunSoft' WHERE gamename = 'Aero the Acro-Bat' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Aero the Acro-Bat 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Aerobiz' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Aerobiz Supersonic' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'After Burner Complete (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'After Burner II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = '' WHERE gamename = 'Air Buster' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1990', publisher = 'Asmik Corporation of America' WHERE gamename = 'Air Diver' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA Corporation, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Alex Kidd in the Enchanted Castle' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Arena Entertainment' WHERE gamename = 'Alien 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Alien Soldier' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Alien Storm' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'Alisia Dragoon' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Altered Beast' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'GameTek, Inc.' WHERE gamename = 'American Gladiators' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'TecMagik, Inc.' WHERE gamename = 'Andre Agassi Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Konami Corporation' WHERE gamename = 'Animaniacs' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure', year = '1992', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Another World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Electronic Arts' WHERE gamename = 'Aquatic Games - Starring James Pond, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Misc.', year = '1996', publisher = 'Sega of America, Inc.' WHERE gamename = 'Arcade Classics' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Arch Rivals' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Arcus Odyssey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'Ariel - The Little Mermaid' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Arnold Palmer Tournament Golf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Arrow Flash' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Unique', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Art Alive!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Art of Fighting' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Asterix and the Great Rescue' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Asterix and the Power of The Gods' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Atomic Robo-Kid' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Data East Corporation' WHERE gamename = 'Atomic Runner' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'ATP Tour Championship Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Australian Rugby League' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Tengen' WHERE gamename = 'Awesome Possum Kicks Dr. Machino\'s Butt!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'ASCII Entertainment Software, Inc.' WHERE gamename = 'AWS Pro Moves Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Ayrton Senna\'s Super Monaco GP II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'B.O.B' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Arena Entertainment' WHERE gamename = 'Back to the Future Part III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Ballz' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Hi Tech Expressions' WHERE gamename = 'Barbie Super Model' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Barkley Shut Up and Jam!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Accolade, Inc.' WHERE gamename = 'Barkley Shut Up and Jam! 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Barney\'s Hide & Seek Game' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'Bass Masters Classic Pro Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'Bass Masters Classics' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SunSoft' WHERE gamename = 'Batman' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sunsoft' WHERE gamename = 'Batman - Revenge of the Joker' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Batman Forever' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Batman Returns' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Battle Squadron' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Arena Entertainment' WHERE gamename = 'Battlemaster' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Extreme Entertainment Group' WHERE gamename = 'Battletech' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation, Tradewest, Inc.' WHERE gamename = 'Battletoads' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Battletoads and Double Dragon' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1995', publisher = 'Front Street Publishing' WHERE gamename = 'BC Racers (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Beast Wrestler' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SunSoft' WHERE gamename = 'Beauty and the Beast - Belle\'s Quest' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sunsoft' WHERE gamename = 'Beauty and the Beast - Roar of the Beast' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Viacom New Media' WHERE gamename = 'Beavis and Butt-head' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Berenstain Bears\', The - Camping Adventure' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1993', publisher = 'Electro-Brain' WHERE gamename = 'Best of the Best - Championship Karate' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'Beyond Oasis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'Bill Walsh College Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'Bill Walsh College Football \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1990', publisher = 'Nuvision Entertainment, Inc.' WHERE gamename = 'Bimini Run' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Bio-Hazard Battle' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Blackthorne (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Blades of Vengeance' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SunSoft' WHERE gamename = 'Blaster Master 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'Block Out' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Misc.', year = '1995', publisher = '' WHERE gamename = 'Blockbuster World Video Game Championship II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Blood Shot' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Body Count' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Bonanza Bros.' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, Racing/Driving', year = '1994', publisher = 'SEGA Corporation, SEGA of America, Inc.' WHERE gamename = 'Bonkers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Boogerman' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Electro Brain Corp.' WHERE gamename = 'Boxing Legends of the Ring' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Psygnosis Limited, Sony Imagesoft' WHERE gamename = 'Bram Stoker\'s Dracula' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Brett Hull Hockey \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = 'Brian Lara Cricket' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = '' WHERE gamename = 'Brian Lara Cricket 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'GameTek, Inc.' WHERE gamename = 'Brutal - Paws of Fury' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'GameTek, Inc.' WHERE gamename = 'Brutal Unleashed - Above the Claw (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Core Design Ltd.' WHERE gamename = 'Bubba N Stix' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Bubble and Squeak' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Bubsy II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Bubsy in Claws Encounters of the Furred Kind' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Buck Rogers - Countdown to Doomsday' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Budokan - The Martial Spirit' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Bugs Bunny in Double Trouble' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'Bulls vs Blazers and the NBA Playoffs' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc., Electronic Arts Victor' WHERE gamename = 'Bulls vs Lakers and the NBA Playoffs' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Burning Force' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Cadash' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Caesars Palace' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Cal Ripken Jr. Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Mentrix Software' WHERE gamename = 'Caliber Fifty' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'California Games' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1994', publisher = 'Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Cannon Fodder' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Data East USA, Inc.' WHERE gamename = 'Captain America and the Avengers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Captain Planet and the Planeteers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA Corporation, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Castle of Illusion Starring Mickey Mouse' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Konami of America, Inc.' WHERE gamename = 'Castlevania - Bloodlines' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Castlevania - The New Generation' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, Strategy', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Centurion - Defender of Rome' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'Chakan - The Forever Man' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Flying Edge' WHERE gamename = 'Champions World Class Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Mentrix Software, Inc.' WHERE gamename = 'Championship Bowling' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Championship Pool' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Tradewest, Inc.' WHERE gamename = 'Championship Pro-Am' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Spectrum Holobyte, Inc.' WHERE gamename = 'Chaos Engine, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1992', publisher = 'Taito Corporation' WHERE gamename = 'Chase HQ II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'American Softworks Corporation' WHERE gamename = 'Chavez II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Cheese Cat-Astrophe Starring Speedy Gonzales' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1993', publisher = '' WHERE gamename = 'Chester Cheetah' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Kaneko' WHERE gamename = 'Chester Cheetah 2 - Wild Wild Quest' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Virgin Games' WHERE gamename = 'Chi Chi\'s Pro Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Chiki Chiki Boys' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Chuck II - Son of Chuck' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Core Design Ltd.' WHERE gamename = 'Chuck Rock' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Clay Fighter' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Cliffhanger' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1992', publisher = 'Parker Brothers' WHERE gamename = 'Clue' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'Coach K College Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'College Football USA 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'College Football USA 97 - The Road to New Orleans' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'College Football\'s National Championship' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'College Football\'s National Championship II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'College Slam' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Columns' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Columns III - Revenge of Columns' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Combat Cars' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Comix Zone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Konami of America, Inc.' WHERE gamename = 'Contra - Hard Corps' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Ltd., Virgin Games, Inc.' WHERE gamename = 'Cool Spot' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Corporation' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Cosmic Carnage (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Codemasters' WHERE gamename = 'Cosmic Spacehead' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Crack Down' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'CrossFire' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Crue Ball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1994', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Crusader of Centy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Crystal\'s Pony Tale' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Cutthroat Island' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Virgin Games' WHERE gamename = 'Cyber-Cop' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports, Strategy', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'CyberBall' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Cyborg Justice' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'D&D - Warriors of the Eternal Sun' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Daffy Duck in Hollywood' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Dark Castle' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1995', publisher = '' WHERE gamename = 'Darxide (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1993', publisher = 'Data East Corporation' WHERE gamename = 'Dashin\' Desperadoes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'David Crane\'s Amazing Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'David Robinson\'s Supreme Court' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tengen' WHERE gamename = 'Davis Cup World Tour Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SunSoft' WHERE gamename = 'Daze Before Christmas, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Kaneko Co., Ltd., Kaneko USA, Ltd.' WHERE gamename = 'Deadly Moves' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Death and Return of Superman, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'RazorSoft' WHERE gamename = 'Death Duel' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Decap Attack' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Demolition Man' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Desert Demolition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Desert Strike - Return to the Gulf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Pinball', year = '1992', publisher = '' WHERE gamename = 'Devilish - The Next Possession' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Dick Tracy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Dick Vitale\'s Awesome Baby! College Hoops' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Virgin Interactive Entertainment (Europe) Ltd.' WHERE gamename = 'Dino Dini\'s Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'Renovation Products, Inc., Wolf Team' WHERE gamename = 'Dino Land' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Dinosaurs for Hire' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Disney\'s Aladdin' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Kaneko' WHERE gamename = 'DJ Boy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Disney Interactive' WHERE gamename = 'Donald in Maui Mallard' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Doom (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1995', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Doom Troopers - The Mutant Chronicles' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1993', publisher = 'ASCII Entertainment Software, Inc.' WHERE gamename = 'Double Clutch' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Ballistic' WHERE gamename = 'Double Dragon' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Double Dragon 3 - The Rosetta Stone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Tradewest, Inc.' WHERE gamename = 'Double Dragon V - The Shadow Falls' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Konami Corporation' WHERE gamename = 'Double Dribble - The Playoff Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Dr. Robotnik\'s Mean Bean Machine' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Dragon - The Bruce Lee Story' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1992', publisher = 'Tengen' WHERE gamename = 'Dragon\'s Fury' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1994', publisher = 'Tengen' WHERE gamename = 'Dragon\'s Revenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Dune - The Battle for Arrakis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Dynamite Duke' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Dynamite Headdy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'EA Hockey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1993', publisher = 'Electronic Arts UK' WHERE gamename = 'EA Sports Double Header' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Earnest Evans' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Earthworm Jim' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Earthworm Jim 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'ECCO - The Tides of Time' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'ECCO Jr.' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'ECCO The Dolphin' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'El Viento' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'TecnoSoft' WHERE gamename = 'Elemental Master' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1994', publisher = '' WHERE gamename = 'Escape From Mars Starring Taz' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN Baseball Tonight' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN National Hockey Night' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN SpeedWorld' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN Sunday Night NFL' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'ESWAT Cyber Police - City Under Siege' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Eternal Champions' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'European Club Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Evander Holyfield\'s Real Deal Boxing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Ex-Mutants' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Exile' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Playmates Interactive Entertainment' WHERE gamename = 'Exo-Squad' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1993', publisher = 'Electronic Arts' WHERE gamename = 'F-117 Night Storm' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1993', publisher = 'MicroProse Software, Inc.' WHERE gamename = 'F-15 Strike Eagle II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'F-22 Interceptor' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1995', publisher = '' WHERE gamename = 'F1 World Championship' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1995', publisher = 'Domark Software, Inc.' WHERE gamename = 'F1 World Championship Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'Faery Tale Adventure, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'GameTek' WHERE gamename = 'Family Feud' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Fantasia' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Codemasters USA' WHERE gamename = 'Fantastic Dizzy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'Fatal Fury' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'Fatal Fury 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Fatal Labyrinth' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'Fatal Rewind' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'Ferrari Grand Prix Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Fever Pitch Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'FIFA International Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1995', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'FIFA International Soccer 96 (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'FIFA Soccer 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'FIFA Soccer 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'FIFA Soccer 97 Gold Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'FIFA Soccer 98 - Road to the World Cup' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Treco, U.S.A.' WHERE gamename = 'Fighting Masters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Final Zone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'DreamWorks' WHERE gamename = 'Fire Shark' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Flashback - The Quest for Identity' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Flicky' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Flintstones, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Foreman For Real' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Forgotten Worlds' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Frank Thomas Big Hurt Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1998', publisher = 'Majesco' WHERE gamename = 'Frogger' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'Tradewest, Inc.' WHERE gamename = 'Fun-N-Games' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'G-LOC Air Battle' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'GameTek' WHERE gamename = 'Gadget Twins, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Renovation Products, Inc., Telenet Japan Co., Ltd.' WHERE gamename = 'Gaiares' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Gain Ground' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Galaxy Force II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Garfield - Caught in the Act' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Buena Vista Interactive' WHERE gamename = 'Gargoyles' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Tengen' WHERE gamename = 'Gauntlet 4' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'GemFire' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1994', publisher = 'Electronic Arts' WHERE gamename = 'General Chaos' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Generations Lost' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1994', publisher = 'KOEI Corporation' WHERE gamename = 'Genghis Khan II - Clan of the Gray Wolf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'George Foreman\'s KO Boxing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Ghostbusters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Ghouls \'N Ghosts' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Accolade Europe Ltd., Mindscape, Inc.' WHERE gamename = 'Gods' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Golden Axe' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Golden Axe II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Goofy\'s Hysterical History Tour' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Granada' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Grand Slam Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Great Circus Mystery, The - Starring Mickey & Minnie' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Great Waldo Search, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Greatest Heavyweights of the Ring' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Greendog - The Beached Surfer Dude' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Tengen' WHERE gamename = 'GRIND Stormer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Growl' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Gunship' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Gunstar Heroes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation', year = '1990', publisher = 'Tengen' WHERE gamename = 'Hard Drivin\'' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'HardBall \'94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Accolade, Inc.' WHERE gamename = 'HardBall \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'HardBall III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Ballistic' WHERE gamename = 'HardBall!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Haunting Starring Polterguy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Head-On Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Bignet USA' WHERE gamename = 'Heavy Nova' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Seismic Software, Inc.' WHERE gamename = 'Hellfire' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'SEGA of America, Inc., TecnoSoft' WHERE gamename = 'Herzog Zwei' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Data East USA, Inc.' WHERE gamename = 'High Seas Havoc' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Hit The Ice' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Home Alone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Home Alone 2 - Lost in New York' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sony Imagesoft' WHERE gamename = 'Hook' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'GameTek' WHERE gamename = 'Humans, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Hurricanes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = '' WHERE gamename = 'Hyper Dunk - The Playoff Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'IMG International Tour Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Immortal, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Flying Edge' WHERE gamename = 'Incredible Crash Dummies, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Incredible Hulk, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Indiana Jones and the Last Crusade' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Sage\'s Creation, Inc.' WHERE gamename = 'Insector X' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Domark Software, Ltd' WHERE gamename = 'International Rugby' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Konami Corporation' WHERE gamename = 'International Superstar Soccer Deluxe' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'Accolade, Inc.' WHERE gamename = 'Ishido - The Way of the Stones' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Izzy\'s Quest for the Olympic Rings' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Jack Nicklaus\' Power Challenge Golf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Domark Software, Ltd' WHERE gamename = 'James Bond 007 - The Duel' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1990', publisher = '' WHERE gamename = 'James Buster Douglas Knock Out Boxing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'James Pond - Underwater Agent' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'James Pond 3 - Operation Starfish' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'James Pond II - Codename RoboCod' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Jammit' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Jennifer Capriati Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Educational', year = '1992', publisher = 'GameTek, Inc.' WHERE gamename = 'Jeopardy!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'GameTek' WHERE gamename = 'Jeopardy! Deluxe' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1994', publisher = 'GameTek' WHERE gamename = 'Jeopardy! Sports Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'RazorSoft' WHERE gamename = 'Jerry Glanville\'s Pigskin Footbrawl' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Jewel Master' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Jimmy White\'s Whirlwind Snooker' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'Joe & Mac Caveman Ninja' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1990', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Joe Montana Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = '' WHERE gamename = 'Joe Montana Sports Talk Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Joe Montana Sports Talk Football 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'John Madden Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'John Madden Football \'92' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'EA Sports' WHERE gamename = 'John Madden Football \'93' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'EA Sports' WHERE gamename = 'John Madden Football \'93 - Championship Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'John Madden NFL 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Jordan vs Bird - Super One-on-One' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = '' WHERE gamename = 'Journey From Darkness - Strider Returns' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Judge Dredd - The Movie' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'Micronet' WHERE gamename = 'Junction' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Jungle Book, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Electronic Arts' WHERE gamename = 'Jungle Strike' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Jurassic Park' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Jurassic Park - Rampage Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1997', publisher = '' WHERE gamename = 'Jurassic Park 2 - The Lost World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Justice League Task Force' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Sage\'s Creation, Inc.' WHERE gamename = 'Ka-Ge-Ki - Fists of Steel' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1994', publisher = 'Domark Software, Inc., Time Warner Interactive, Inc.' WHERE gamename = 'Kawasaki Superbike Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Kick Off 3 - European Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Kid Chameleon' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'King of the Monsters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Takara Co., Ltd.' WHERE gamename = 'King of the Monsters 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Vic Tokai Inc.' WHERE gamename = 'King Salmon - The Big Catch' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'King\'s Bounty' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Tengen' WHERE gamename = 'Klax' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Knuckles\' Chaotix (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Kolibri (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Flying Edge' WHERE gamename = 'Krusty\'s Super Funhouse' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Lakers vs Celtics and the NBA Playoffs' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Landstalker - The Treasures of King Nole' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Last Action Hero' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Corporation, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Last Battle' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Lawnmower Man, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1992', publisher = '' WHERE gamename = 'Legend of Galahad, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Sunsoft' WHERE gamename = 'Lemmings' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Psygnosis Limited' WHERE gamename = 'Lemmings 2 - The Tribes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami (America), Inc.' WHERE gamename = 'Lethal Enforcers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Konami (America), Inc.' WHERE gamename = 'Lethal Enforcers II - Gun Fighters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'LHX Attack Chopper' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Liberty or Death' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Light Crusader' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Lightening Force - Quest for the Darkstar' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Virgin Interactive Entertainment (Europe) Ltd., Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Lion King, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Lost Vikings, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1993', publisher = 'Electronic Arts' WHERE gamename = 'Lotus II RECS' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Electronic Arts' WHERE gamename = 'Lotus Turbo Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'M-1 Abrams Battle Tank' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Seismic Software, Inc.' WHERE gamename = 'M.U.S.H.A' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports, Strategy', year = '1994', publisher = 'EA Sports' WHERE gamename = 'Madden NFL 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports, Strategy', year = '1995', publisher = 'EA Sports' WHERE gamename = 'Madden NFL 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'Madden NFL 97' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'Madden NFL 98' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1995', publisher = '' WHERE gamename = 'Magic School Bus, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1994', publisher = '' WHERE gamename = 'Man Overboard! - S.S. Lucifer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Marble Madness' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1994', publisher = 'EA Sports' WHERE gamename = 'Mario Andretti Racing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Sega of America, Inc.' WHERE gamename = 'Mario Lemieux Hockey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1994', publisher = '' WHERE gamename = 'Marko\'s Magic Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Marsupilami' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Marvel Land' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sony Imagesoft' WHERE gamename = 'Mary Shelley\'s Frankenstein' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'Renovation Products, Inc., Toshiba-EMI Ltd.' WHERE gamename = 'Master of Monsters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Math Blaster - Episode 1' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = '' WHERE gamename = 'Mazin Saga' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'McDonald\'s Treasure Land Adventure' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Mega Bomberman' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'CSK Research Institute Corp., Virgin Games, Inc.' WHERE gamename = 'Mega Lo Mania' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = '' WHERE gamename = 'Mega SWIV' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Data East USA, Inc.' WHERE gamename = 'Mega Turrican' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Megaman - The Wily Wars' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Mercs' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Metal Head (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Michael Jackson\'s Moonwalker' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Virgin Games' WHERE gamename = 'Mick & Mack as the Global Gladiators' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Mickey Mania - Timeless Adventures of Mickey Mouse' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1994', publisher = 'Hi Tech Expressions' WHERE gamename = 'Mickey\'s Ultimate Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1993', publisher = 'Codemasters' WHERE gamename = 'Micro Machines' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1995', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Micro Machines - Turbo Tournament \'96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1994', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Micro Machines 2 - Turbo Tournament' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1996', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Micro Machines Military - It\'s a Blast!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Data East Corporation' WHERE gamename = 'Midnight Resistance' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1993', publisher = 'Domark Software, Ltd' WHERE gamename = 'Mig-29 Fighter Pilot' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Electronic Arts' WHERE gamename = 'Might and Magic - Gates to Another World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Mighty Morphin Power Rangers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Mighty Morphin Power Rangers - The Movie' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Ballistic' WHERE gamename = 'Mike Ditka Power Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1995', publisher = 'Data East USA, Inc.' WHERE gamename = 'Minnesota Fats Pool Legend' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Educational', year = '1992', publisher = 'Software Toolworks, Inc., The' WHERE gamename = 'Miracle Piano Teaching System' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Psygnosis Limited' WHERE gamename = 'Misadventures of Flink, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'MLBPA Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'EA Sports' WHERE gamename = 'MLBPA Sports Talk Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Parker Brothers' WHERE gamename = 'Monopoly' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Arena Entertainment' WHERE gamename = 'Mortal Kombat' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Williams Entertainment' WHERE gamename = 'Mortal Kombat 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Mortal Kombat II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Mortal Kombat II (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Motocross Championship (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Mr. Nutz' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tengen' WHERE gamename = 'Ms. Pac-Man' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Muhammad Ali Heavyweight Boxing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Mutant League Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Mutant League Hockey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Mystic Defender' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'DreamWorks' WHERE gamename = 'Mystical Fighter' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'NBA Action' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = 'NBA Action \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'NBA All-Star Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Midway' WHERE gamename = 'NBA Hang Time' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc., Arena Entertainment' WHERE gamename = 'NBA Jam' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NBA Jam Tournament Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NBA Jam Tournament Edition (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'NBA Live 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'NBA Live 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'NBA Live 97' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'NBA Live 98' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'NBA Showdown 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Mindscape, Inc.' WHERE gamename = 'NCAA College Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'NCAA Final Four College Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Newman-Haas IndyCar Racing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'NFL \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'Sega of America, Inc.' WHERE gamename = 'NFL 98' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'NFL Football \'94 Starring Joe Montana' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = '' WHERE gamename = 'NFL Prime Time' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NFL Quarterback Club' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NFL Quarterback Club (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NFL Quarterback Club 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'NHL 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'NHL 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'NHL 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation, Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'NHL 97' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'NHL 98' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'NHL All-Star Hockey \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc., Electronic Arts Victor' WHERE gamename = 'NHL Hockey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'NHLPA Hockey \'93' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Nigel Mansell\'s World Championship' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Psygnosis' WHERE gamename = 'No Escape' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1993', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Nobunaga\'s Ambition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Electronic Arts' WHERE gamename = 'Normy\'s Beach Babe-O-Rama' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Corporation' WHERE gamename = 'Olympic Gold - Barcelona 92' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = '' WHERE gamename = 'Olympic Summer Games Atlanta 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Olympic Winter Games - Lillehammer 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Ballistic' WHERE gamename = 'Onslaught' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'Ooze, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Operation Europe - Path to Victory 1939-1945' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Ottifants, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Out of this World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, Racing/Driving', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Outlander' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'OutRun' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'OutRun 2019' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1994', publisher = 'Data East USA, Inc.' WHERE gamename = 'OutRunners' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Educational, Strategy', year = '1993', publisher = 'KOEI Corporation' WHERE gamename = 'P.T.O. Pacific Theater of Operations' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Pac-Attack' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure', year = '1994', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Pac-Man 2 - The New Adventures' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tengen' WHERE gamename = 'Pac-Mania' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Fox Interactive' WHERE gamename = 'Pagemaster, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tengen' WHERE gamename = 'Paperboy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Tengen' WHERE gamename = 'Paperboy II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Sega of America, Inc.' WHERE gamename = 'Pat Riley Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega Sports' WHERE gamename = 'Pebble Beach Golf Links' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Pele!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Pele\'s World Tournament Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Pete Sampras Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Codemasters' WHERE gamename = 'Pete Sampras Tennis 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'PGA European Tour' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'PGA Tour 96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'PGA Tour Golf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'EA Sports' WHERE gamename = 'PGA Tour Golf II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports, Strategy', year = '1994', publisher = 'EA Sports' WHERE gamename = 'PGA Tour Golf III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1994', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Phantasy Star - The End of the Millenium' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Phantasy Star II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Phantasy Star III - Generations of Doom' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Viacom New Media' WHERE gamename = 'Phantom 2040' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Phelios' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'TecMagik, Inc.' WHERE gamename = 'Pink Goes to Hollywood' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Buena Vista Games, Inc., Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Pinocchio' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Pirates of Dark Water, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG, Simulation, Strategy', year = '1993', publisher = 'MicroProse Software, Inc.' WHERE gamename = 'Pirates! Gold' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tengen' WHERE gamename = 'Pit Fighter' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Pitfall (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Activision, Inc.' WHERE gamename = 'Pitfall - The Mayan Adventure' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = '' WHERE gamename = 'Pocahontas' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Populous' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = '' WHERE gamename = 'Populous II - Two Tribes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Power Drive' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Power Monger' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Powerball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Arena Entertainment' WHERE gamename = 'Predator 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Gremlin Interactive Ltd.' WHERE gamename = 'Premier Manager' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Gremlin Interactive Ltd.' WHERE gamename = 'Premier Manager 97' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Primal Rage' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Primal Rage (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Domark Software, Inc.' WHERE gamename = 'Prince of Persia' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tradewest, Inc.' WHERE gamename = 'Pro Quarterback' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = '' WHERE gamename = 'Probotector' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Psycho Pinball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Psygnosis' WHERE gamename = 'Puggsy' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Capcom Eurosoft' WHERE gamename = 'Punisher, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Quack Shot Starring Donald Duck' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Quad Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation', year = '1993', publisher = 'Tengen' WHERE gamename = 'Race Drivin\'' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Activision, Inc.' WHERE gamename = 'Radical Rex' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Micronet' WHERE gamename = 'Raiden Trad' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Rambo III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Tengen' WHERE gamename = 'Rampart' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Ranger-X' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Rastan Saga II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Tengen' WHERE gamename = 'RBI Baseball 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tengen' WHERE gamename = 'RBI Baseball 4' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Tengen' WHERE gamename = 'RBI Baseball 93' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tengen' WHERE gamename = 'RBI Baseball 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Time Warner Interactive' WHERE gamename = 'RBI Baseball 95 (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Red Zone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Ren and Stimpy Show, The - Stimpy\'s Invention' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Revenge of Shinobi, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Revolution X' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1994', publisher = 'Sega of America, Inc.' WHERE gamename = 'Richard Scarry\'s Busytown' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Rings of Power' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Rise of the Robots' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1994', publisher = 'Parker Brothers' WHERE gamename = 'Risk' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Risky Woods' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Ristar' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Tengen' WHERE gamename = 'Road Blasters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving, Simulation', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Road Rash' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1995', publisher = 'Electronic Arts' WHERE gamename = 'Road Rash 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Road Rash II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Robocop 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Robocop Versus The Terminator' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1994', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Rock n\' Roll Racing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Rocket Knight Adventures' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1993', publisher = '' WHERE gamename = 'Rocky and Bullwinkle, The Adventures of' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'Roger Clemens\' MVP Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Rolling Thunder 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Rolling Thunder 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Rolo to the Rescue' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'KOEI Corporation' WHERE gamename = 'Romance of the Three Kingdoms II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1994', publisher = 'KOEI Corporation' WHERE gamename = 'Romance of the Three Kingdoms III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'Rugby World Cup 1995' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Taito Corporation' WHERE gamename = 'Sagaia' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Saint Sword' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'Samurai Shodown' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Saturday Night Slam Masters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Scooby Doo Mystery' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Black Pearl Software' WHERE gamename = 'SeaQuest DSV' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Psygnosis Limited' WHERE gamename = 'Second Samurai, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Sega Sports 1 (Wimbledon, Ult.Soccer, Super Monaco)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Sensible Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Sensible Soccer - International Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1994', publisher = 'Electronic Arts' WHERE gamename = 'Sesame Street Counting Cafe' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Sage\'s Creation, Inc.' WHERE gamename = 'Shadow Blasters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Shadow Dancer - The Secret of Shinobi' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Electronic Arts, Inc., Victor Musical Industries, Inc.' WHERE gamename = 'Shadow of the Beast' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Electronic Arts, Inc., Psygnosis Limited' WHERE gamename = 'Shadow of the Beast 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Shadow Squadron (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Shadowrun' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = '' WHERE gamename = 'Shane Warne Cricket' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1994', publisher = 'Activision, Inc.' WHERE gamename = 'Shanghai 2 - Dragon\'s Eye' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Shaq Fu' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Shining Force' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Shining Force II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Shining in the Darkness' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Shinobi III - Return of the Ninja Master' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'DreamWorks' WHERE gamename = 'Shove It! - The Warehouse Game' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1992', publisher = 'Data East USA, Inc.' WHERE gamename = 'Side Pocket' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Simpsons, The - Bart vs The Space Mutants' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Simpsons, The - Bart\'s Nightmare' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Core Design Ltd.' WHERE gamename = 'Skeleton Krew' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1994', publisher = 'Electronic Arts' WHERE gamename = 'Skitchin\'' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = 'RazorSoft' WHERE gamename = 'Slaughter Sport' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1996', publisher = '' WHERE gamename = 'Smurfs 2, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1996', publisher = 'Infogrames' WHERE gamename = 'Smurfs, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sega of Europe' WHERE gamename = 'Snake Rattle \'n\' Roll' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1993', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Socket' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Sol-Deace' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Spectrum HoloByte, Inc.' WHERE gamename = 'Soldiers of Fortune' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG', year = '1994', publisher = '' WHERE gamename = 'Soleil' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic 3D Blast' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic and Knuckles' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Multi Cart', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic and Knuckles & Sonic 1' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Multi Cart', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic and Knuckles & Sonic 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Multi Cart', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Sonic and Knuckles & Sonic 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Multi Cart', year = '1997', publisher = 'Majesco Sales, Inc., SEGA Enterprises Ltd.' WHERE gamename = 'Sonic Classics (Compilation)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Sonic Spinball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA Corporation, Tec Toy Indústria de Brinquedos S.A.' WHERE gamename = 'Sonic The Hedgehog' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SEGA Corporation, SEGA of America, Inc.' WHERE gamename = 'Sonic The Hedgehog 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Enterprises Ltd., SEGA Corporation, SEGA of America, Inc.' WHERE gamename = 'Sonic The Hedgehog 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1992', publisher = 'Treco, U.S.A.' WHERE gamename = 'Sorcerer\'s Kingdom' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Space Harrier (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Space Harrier II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Space Invaders 91' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Konami of America, Inc.' WHERE gamename = 'Sparkster' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1991', publisher = 'Arena Entertainment, Mirrorsoft Ltd.' WHERE gamename = 'Speed Ball 2 - Brutal Deluxe' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Spider-Man - The Animated Series' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Sega of America, Inc.' WHERE gamename = 'Spider-Man - Web of Fire (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Spider-Man and Venom - Maximum Carnage' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Spider-Man and Venom - Separation Anxiety' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Spider-Man and X-Men - Arcade\'s Revenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Spider-Man vs The Kingpin' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Infogrames' WHERE gamename = 'Spirou' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Splatterhouse 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Splatterhouse 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Spot Goes to Hollywood' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Ballistic' WHERE gamename = 'Star Control' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Star Trek - Deep Space 9 - Crossroads of Time' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1994', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Star Trek - Starfleet Academy Bridge Simulator (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1994', publisher = '' WHERE gamename = 'Star Trek - The Next Generation' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'LucasArts, SEGA Corporation' WHERE gamename = 'Star Wars Arcade (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Starflight' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Stargate' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'Steel Empire, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'Tengen' WHERE gamename = 'Steel Talons' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'RazorSoft, Inc.' WHERE gamename = 'Stormlord' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Entertainment, Inc.' WHERE gamename = 'Street Fighter II\' - Special Champion Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1995', publisher = 'Ubi Soft Entertainment Software' WHERE gamename = 'Street Racer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = 'Treco, U.S.A.' WHERE gamename = 'Street Smart' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Streets of Rage' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sega of America, Inc.' WHERE gamename = 'Streets of Rage 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Streets of Rage 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Strider' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Strider II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Striker' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Sub-Terrania' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Summer Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'Sunset Riders' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Simulation, Sports', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Super Baseball 2020' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1993', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Super Battle Tank - War in the Gulf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Super Battleship' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SunSoft' WHERE gamename = 'Super Fantasy Zone' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Super Hang-On' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Arena Entertainment' WHERE gamename = 'Super High Impact' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1990', publisher = 'Seismic Software Inc.' WHERE gamename = 'Super Hydlide' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Super Kick Off' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = '' WHERE gamename = 'Super League' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1990', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Super Monaco Grand Prix' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Ballistic' WHERE gamename = 'Super Off Road' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1990', publisher = 'SEGA Corporation' WHERE gamename = 'Super Real Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1995', publisher = 'Codemasters Software Company Limited, The' WHERE gamename = 'Super Skidmarks' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Flying Edge' WHERE gamename = 'Super Smash TV' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Super Street Fighter II - The New Challengers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Super Thunder Blade' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Video System' WHERE gamename = 'Super Volleyball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sunsoft' WHERE gamename = 'Superman' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Sword of Sodan' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1989', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Sword of Vermilion' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Syd of Valis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Time Warner Interactive' WHERE gamename = 'Sylvester & Tweety in Cagey Capers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, RPG, Strategy', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Syndicate' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'T-MEK (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Arena Entertainment' WHERE gamename = 'T2 - The Arcade Game' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Tale Spin' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Dreamworks, Masaya' WHERE gamename = 'Target Earth' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Treco, U.S.A.' WHERE gamename = 'Task Force Harrier EX' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'SEGA Enterprises Ltd.' WHERE gamename = 'Taz-Mania' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Team USA Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Techno Clash' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'RazorSoft' WHERE gamename = 'Technocop' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Tecmo Super Bowl II SE' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl III Final Edition' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Hockey' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super NBA Basketball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Sims Co., Ltd.' WHERE gamename = 'Tecmo World Cup \'93' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation' WHERE gamename = 'Teenage Mutant Ninja Turtles - The Hyperstone Heist' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Teenage Mutant Ninja Turtles - Tournament Fighters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'Tempo (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Flying Edge, Inc.' WHERE gamename = 'Terminator 2 - Judgment Day' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Virgin Games' WHERE gamename = 'Terminator, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1992', publisher = 'Accolade, Inc., Ballistic' WHERE gamename = 'Test Drive II - The Duel' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Theme Park' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Thomas the Tank Engine & Friends' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Technosoft' WHERE gamename = 'Thunder Force II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Technosoft' WHERE gamename = 'Thunder Force III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Thunder Fox' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Fox Interactive' WHERE gamename = 'Tick, The' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'Time Killers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Ballistic' WHERE gamename = 'Tinhead' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Infogrames' WHERE gamename = 'Tintin Au Tibet' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Konami Industry Co. Ltd.' WHERE gamename = 'Tiny Toon Adventures - Acme All-Stars' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami, Inc.' WHERE gamename = 'Tiny Toon Adventures - Buster\'s Hidden Treasure' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'American Softworks Corporation' WHERE gamename = 'TNN Bass Tournament of Champions' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'American Softworks Corporation' WHERE gamename = 'TNN Outdoors Bass Tournament \'96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Micro World' WHERE gamename = 'Todd\'s Adventures in Slime World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SEGA Corporation' WHERE gamename = 'Toejam & Earl' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'Toejam & Earl in Panic on Funkotron' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Toki - Going Ape Spit' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Hi Tech Expressions' WHERE gamename = 'Tom and Jerry - Frantic Antics' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'SEGA Corporation' WHERE gamename = 'Tommy Lasorda Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'Tony La Russa Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Tony La Russa Baseball 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1994', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Top Gear 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = 'Total Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'Toughman Contest' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'Toughman Contest (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'Toxic Crusaders' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Toy Story' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Toys' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'DreamWorks' WHERE gamename = 'Trampoline Terror!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Traysia' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'Triple Play \'96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'Triple Play Gold' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Trouble Shooter' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tradewest, Inc.' WHERE gamename = 'Troy Aikman NFL Football' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'True Lies' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Accolade, Inc., Ballistic' WHERE gamename = 'Turrican' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SEGA of America, Inc., Treco' WHERE gamename = 'Twin Cobra' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Data East Corporation, Data East USA, Inc.' WHERE gamename = 'Two Crude Dudes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1993', publisher = '' WHERE gamename = 'Tyrants - Fight Through Time' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Ultimate Mortal Kombat 3' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Ultimate Qix' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'SEGA Europe Ltd.' WHERE gamename = 'Ultimate Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Uncharted Waters' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Uncharted Waters - New Horizons' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Accolade, Inc.' WHERE gamename = 'Universal Soldier' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Unnecessary Roughness 95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Urban Strike' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Valis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Valis III' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Vapor Trail' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Vectorman' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'SEGA Corporation' WHERE gamename = 'Vectorman 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'American Sammy Corporation' WHERE gamename = 'Viewpoint' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'Virtua Fighter (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'SEGA Corporation' WHERE gamename = 'Virtua Fighter 2' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1994', publisher = 'SEGA Corporation' WHERE gamename = 'Virtua Racing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1994', publisher = 'SEGA of America, Inc.' WHERE gamename = 'Virtua Racing Deluxe (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Virtual Bart' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Virtual Pinball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'VR Troopers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Children', year = '1994', publisher = '' WHERE gamename = 'Wacky Worlds' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Mentrix Software, Inc.' WHERE gamename = 'Wardner' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Warlock' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Warpspeed' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulator', year = '1991', publisher = 'Micronet' WHERE gamename = 'Warrior of Rome' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Micronet' WHERE gamename = 'Warrior of Rome II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1991', publisher = 'Treco, U.S.A.' WHERE gamename = 'Warsong' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Time Warner Interactive' WHERE gamename = 'Wayne Gretzsky NHLPA All-Stars' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Wayne\'s World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'We\'re Back! - A Dinosaur\'s Tale' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Weaponlord' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'GameTek, Inc.' WHERE gamename = 'Wheel of Fortune' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Educational', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Where in the World is Carmen Sandiego' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Adventure, Educational', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Where in Time is Carmen Sandiego' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Whip Rush 2222 AD' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Williams Arcade\'s Greatest Hits' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1993', publisher = 'SEGA Enterprises Ltd., SEGA of America, Inc.' WHERE gamename = 'Wimbledon Championship Tennis' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Dreamworks, NCS Corporation' WHERE gamename = 'Wings of Wor' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Ballistic' WHERE gamename = 'Winter Challenge' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Psygnosis Limited' WHERE gamename = 'Wiz \'n\' Liz - The Frantic Wabbit Wescue' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Wolf Child' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Wolverine Adamantium Rage' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'SEGA Enterprises Ltd., SEGA Corporation' WHERE gamename = 'Wonder Boy in Monster World' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'World Championship Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega Sports' WHERE gamename = 'World Championship Soccer II' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'World Class Leaderboard Golf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = '' WHERE gamename = 'World Cup Italia 90' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'World Cup USA 94' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'SEGA of America, Inc.' WHERE gamename = 'World Heroes' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sega of America, Inc.' WHERE gamename = 'World of Illusion Starring Mickey Mouse & Donald Duck' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sega Sports' WHERE gamename = 'World Series Baseball' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sega Sports' WHERE gamename = 'World Series Baseball \'95' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Sega Sports' WHERE gamename = 'World Series Baseball \'95 (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Sega Sports' WHERE gamename = 'World Series Baseball \'96' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'Sega Sports' WHERE gamename = 'World Series Baseball \'98' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1992', publisher = 'Virgin Games, Ltd.' WHERE gamename = 'World Trophy Soccer' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1996', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Worms' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF RAW' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Fighting', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF RAW (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Acclaim Entertainment, Inc., Flying Edge, Inc.' WHERE gamename = 'WWF Royal Rumble' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Flying Edge, Inc.' WHERE gamename = 'WWF Super Wrestlemania' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF Wrestlemania Arcade' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF Wrestlemania Arcade (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SEGA Corporation' WHERE gamename = 'X-Men' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'X-Men 2 - Clone Wars' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'SEGA of America, Inc.' WHERE gamename = 'X-perts' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Xenon 2 - Megablast' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Platform', year = '1994', publisher = '' WHERE gamename = 'Yogi Bear\'s Cartoon Capers' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Young Indiana Jones - Instrument of Chaos' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1991', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Ys III - Wanderers from Ys' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Electronic Arts' WHERE gamename = 'Zany Golf' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'SEGA Corporation' WHERE gamename = 'Zaxxon\'s Motherbase 2000 (32X)' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'SunSoft' WHERE gamename = 'Zero the Kamikaze Squirrel' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Zero Tolerance' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Toaplan Co., Ltd.' WHERE gamename = 'Zero Wing' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Zombies Ate My Neighbors' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'GameTek, Inc.' WHERE gamename = 'Zool' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Sega of America, Inc.' WHERE gamename = 'Zoom!' AND gametype = 'GENESIS';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1995', publisher = 'Viacom New Media' WHERE gamename = 'Zoop' AND gametype = 'GENESIS';