UPDATE gamemetadata SET genre = 'Action, Simulation, Sports', year = '1993', publisher = 'K. Amusement Leasing Co., Tradewest, Inc.' WHERE gamename = '2020 Super Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sony Imagesoft' WHERE gamename = '3 Ninjas Kick Back' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = '' WHERE gamename = '7th Saga, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = '90 Minutes - European Prime Goal' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'A.S.P. Air Strike Patrol' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Viacom New Media' WHERE gamename = 'AAAHH!!! Real Monsters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Data East Corporation' WHERE gamename = 'ABC Monday Night Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'ACME Animation Factory' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG, Strategy', year = '1990', publisher = 'Enix Corporation' WHERE gamename = 'ActRaiser' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Enix America Inc.' WHERE gamename = 'ActRaiser 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'AD&D - Eye of the Beholder' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Addams Family Values' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Addams Family, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Addams Family, The - Pugsley\'s Scavenger Hunt' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Adventures of Batman & Robin, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Adventures of Dr. Franken, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Adventures of Kid Kleets, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Adventures of Rocky and Bullwinkle and Friends, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = '' WHERE gamename = 'Adventures of Tintin, The - Prisoners of the Sun' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Mc O\'River, Inc.' WHERE gamename = 'Aero Fighters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SunSoft' WHERE gamename = 'Aero the Acro-Bat' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Aero the Acro-Bat 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Aerobiz' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Strategy', year = '1993', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Aerobiz Supersonic' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Cybersoft, Inc.' WHERE gamename = 'Air Cavalry' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'Al Unser Jr\'s Road to the Top' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Aladdin' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'LJN Ltd.' WHERE gamename = 'Alien 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Activision, Inc.' WHERE gamename = 'Alien vs. Predator' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'All-American Championship Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1993', publisher = 'GameTek, Inc.' WHERE gamename = 'American Gladiators' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'American Tail, An - Fievel Goes West' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Radiance Software' WHERE gamename = 'Andre Agassi Tennis' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Animaniacs' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Another World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Miscellaneous', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Arcade\'s Greatest Hits' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Miscellaneous', year = '1997', publisher = 'Midway Home Entertainment' WHERE gamename = 'Arcade\'s Greatest Hits - The Atari Collection 1' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'HAL America, Inc.' WHERE gamename = 'Arcana' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Psygnosis' WHERE gamename = 'Archer MacLean\'s Dropzone' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'ASCII Corporation, Titus Interactive S.A.' WHERE gamename = 'Ardy Lightfoot' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1997', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Arkanoid - Doh It Again' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'K. Amusement Leasing Co., TAKARA Co., Ltd.' WHERE gamename = 'Art of Fighting' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Infogrames Entertainment, S.A.' WHERE gamename = 'Asterix' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Infogrames UK' WHERE gamename = 'Asterix & Obelix' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation' WHERE gamename = 'Axelay' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'B.O.B.' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = '' WHERE gamename = 'Ballz 3D' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'Barbie Super Model' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Hi Tech Entertainment' WHERE gamename = 'Barbie Vacation Adventure' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Accolade, Inc., ITC' WHERE gamename = 'Barkley Shut Up and Jam!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Malibu Games' WHERE gamename = 'Bass Masters Classic' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'Bass Masters Classic - Pro Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'HOT-B USA Inc.' WHERE gamename = 'Bassin\'s Black Bass' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Batman - Revenge of the Joker' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Batman Forever' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'Batman Returns' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'American Sammy Corporation' WHERE gamename = 'Battle Blaze' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Battle Cars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Battle Clash' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Battle Grand Prix' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Tradewest, Inc.' WHERE gamename = 'Battletoads & Double Dragon - The Ultimate Team' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Tradewest, Inc.' WHERE gamename = 'Battletoads in Battlemaniacs' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Bandai America, Inc.' WHERE gamename = 'Bazooka Blitzkrieg' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Beauty and the Beast' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Viacom New Media' WHERE gamename = 'Beavis and Butt-head' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Motown Games' WHERE gamename = 'Bebe\'s Kids' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Beethoven\'s 2nd' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Electro Brain Corp.' WHERE gamename = 'Best of the Best - Championship Karate' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Big Sky Trooper' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Konami Corporation' WHERE gamename = 'Biker Mice From Mars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Bill Laimbeer\'s Combat Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'Bill Walsh College Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Activision, Inc.' WHERE gamename = 'Bio Metal' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = '' WHERE gamename = 'Blackhawk' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Interplay Productions, Inc., Kotobuki System Co., Ltd.' WHERE gamename = 'Blackthorne' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Blazeon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = '' WHERE gamename = 'Blazing Skies' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Blues Brothers, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Hi Tech Expressions' WHERE gamename = 'Bobby\'s World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Bonkers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Interplay Entertainment Corp.' WHERE gamename = 'Boogerman - A Pick and Flick Adventure' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'Electro Brain Corp.' WHERE gamename = 'Boxing Legends of the Ring' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'Enix America Inc.' WHERE gamename = 'Brain Lord' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1994', publisher = '' WHERE gamename = 'Brainies, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Bram Stoker\'s Dracula' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Brandish' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Brawl Brothers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1994', publisher = 'Spectrum Holobyte, Inc.' WHERE gamename = 'BreakThru!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1993', publisher = 'Capcom Co., Ltd., Square Soft, Inc.' WHERE gamename = 'Breath of Fire' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1994', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc., Laguna GmbH' WHERE gamename = 'Breath of Fire II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Brett Hull Hockey' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Accolade, Inc.' WHERE gamename = 'Brett Hull Hockey \'95' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Bronkie Health Hero' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'THQ, Inc.' WHERE gamename = 'Brunswick World Tournament of Champions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Cybersoft, Inc., GameTek, Inc., Kemco' WHERE gamename = 'Brutal - Paws of Fury' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Accolade, Inc.' WHERE gamename = 'Bubsy II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Bubsy in Claws Encounters of the Furred Kind' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sunsoft of America' WHERE gamename = 'Bugs Bunny - Rabbit Rampage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc., Electronic Arts Victor' WHERE gamename = 'Bulls Vs Blazers and the NBA Playoffs' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1995', publisher = 'Taito America Corp.' WHERE gamename = 'Bust-A-Move' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'Cacoma Knight in Bizyland' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Cal Ripken Jr. Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'DTMC, Inc.' WHERE gamename = 'California Games II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'American Softworks Corporation' WHERE gamename = 'Cannondale Cup' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Capcom\'s MVP Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Capcom\'s Soccer Shootout' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Mindscape, Inc.' WHERE gamename = 'Captain America and The Avengers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Captain Commando' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Educational', year = '1992', publisher = 'Health Hero Network' WHERE gamename = 'Captain Novolin' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1995', publisher = 'CyberSoft, Inc.' WHERE gamename = 'Carrier Aces' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Natsume Inc.' WHERE gamename = 'Casper' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Konami Co., Ltd., Konami (America), Inc.' WHERE gamename = 'Castlevania - Dracula X' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Castlevania - Vampire\'s Kiss' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Champions World Class Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Championship Pool' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Championship Soccer \'94' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Chaos Engine, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'American Softworks Corporation' WHERE gamename = 'Chavez' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1995', publisher = 'American Softworks Corporation' WHERE gamename = 'Chavez II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = '' WHERE gamename = 'Chessmaster, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Kaneko' WHERE gamename = 'Chester Cheetah - Too Cool to Fool' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Kaneko' WHERE gamename = 'Chester Cheetah - Wild Wild Quest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Extreme Entertainment Group, Inc.' WHERE gamename = 'Choplifter III' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1995', publisher = 'Square Co., Ltd.' WHERE gamename = 'Chrono Trigger' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sony Imagesoft' WHERE gamename = 'Chuck Rock' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1995', publisher = '' WHERE gamename = 'Civilization' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Clay Fighter' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = '' WHERE gamename = 'Clay Fighter - Tournament Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Interplay Entertainment Corp., Interplay Productions Ltd.' WHERE gamename = 'Clay Fighter 2 - Judgment Clay' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Claymates' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Cliffhanger' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Parker Brothers' WHERE gamename = 'Clue' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'College Football USA \'97 - The Road to New Orleans' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'College Slam Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Combatribes, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Data East USA, Inc.' WHERE gamename = 'Congo\'s Caper' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation' WHERE gamename = 'Contra III - The Alien Wars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Cool Spot' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Cool World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Cutthroat Island' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'Takara Co., Ltd.' WHERE gamename = 'Cyber Spin' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Cybernator' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Asmik Corporation of America' WHERE gamename = 'D-Force' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SunSoft, Sunsoft of America' WHERE gamename = 'Daffy Duck - The Marvin Missions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Darius Twin' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'David Crane\'s Amazing Tennis' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sunsoft' WHERE gamename = 'Daze Before Christmas' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Death and Return of Superman, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Acclaim Entertainment, Inc., Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Demolition Man' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Capcom Entertainment, Inc.' WHERE gamename = 'Demon\'s Crest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Dennis the Menace' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = '' WHERE gamename = 'Desert Fighter' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Desert Strike - Return to the Gulf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Dig & Spike Volleyball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Irem America Corp.' WHERE gamename = 'Dino City' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Virgin Interactive Entertainment (Europe) Ltd.' WHERE gamename = 'Dino Dini\'s Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Dirt Trax FX' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Donkey Kong Country' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Donkey Kong Country - Competition Cartridge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Donkey Kong Country 2 - Diddy\'s Kong Quest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Nintendo Co. Ltd.' WHERE gamename = 'Donkey Kong Country 3 - Dixie Kong\'s Double Trouble' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Doom' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Renovation Products, Inc.' WHERE gamename = 'Doomsday Warrior' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Tradewest, Inc.' WHERE gamename = 'Double Dragon V - The Shadow Falls' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc., Virgin Interactive Entertainment (Europe) Ltd.' WHERE gamename = 'Dragon - The Bruce Lee Story' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1994', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Dragon View' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Data East Corporation, Elite Systems, Ltd., Konami Corporation' WHERE gamename = 'Dragon\'s Lair' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'Kemco/Seika' WHERE gamename = 'Drakkhen' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Triffix Entertainment Inc.' WHERE gamename = 'Dream TV' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'Victor, JVC Musical Industries, Inc.' WHERE gamename = 'Dungeon Master' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1993', publisher = 'Enix Corporation' WHERE gamename = 'E.V.O. Search for Eden' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Earthbound' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Earthworm Jim' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Earthworm Jim 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Eek! The Cat' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'GameTek' WHERE gamename = 'Elite Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Emmitt Smith Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1993', publisher = 'Sony Imagesoft, Sony Music Entertainment (Japan), Inc.' WHERE gamename = 'Equinox' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Eric Cantona Football Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN Baseball Tonight' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN National Hockey Night' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN Speedworld' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'ESPN Sunday Night NFL' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = 'Taito Corporation' WHERE gamename = 'Euro Football Champ' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = '' WHERE gamename = 'Exhaust Heat' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Extra Innings' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1990', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'F-ZERO' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Ubisoft Entertainment' WHERE gamename = 'F1 Pole Position' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Human Entertainment' WHERE gamename = 'F1 Pole Position 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'F1 ROC - Race of Champions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'F1 ROC II - Race of Champions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = '' WHERE gamename = 'F1 World Championship Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Bullet-Proof Software, Inc.' WHERE gamename = 'Faceball 2000' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Malibu Games' WHERE gamename = 'Family Dog' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'GameTek' WHERE gamename = 'Family Feud' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Takara Co., Ltd.' WHERE gamename = 'Fatal Fury' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Takara Co., Ltd.' WHERE gamename = 'Fatal Fury 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Takara Co., Ltd.' WHERE gamename = 'Fatal Fury Special' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Fever Pitch Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = '' WHERE gamename = 'FIFA 97 - Gold Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'FIFA 98 - Road to World Cup' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'FIFA International Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'FIFA Soccer 96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Data East Corporation' WHERE gamename = 'Fighter\'s History' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1992', publisher = 'Square Co., Ltd.' WHERE gamename = 'Final Fantasy - Mystic Quest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Square Soft, Inc.' WHERE gamename = 'Final Fantasy II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1994', publisher = 'Square Soft, Inc.' WHERE gamename = 'Final Fantasy III' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Final Fight' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Final Fight 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Final Fight 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Final Fight Guy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'DTMC Inc.' WHERE gamename = 'Fire Striker' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Firemen, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Storm, SunSoft' WHERE gamename = 'Firepower 2000' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'First Samurai' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Flashback - The Quest for Identity' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Flintstones, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Flintstones, The - The Treasure of Sierra Madrock' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'American Sammy Corporation' WHERE gamename = 'Football Fury' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Foreman For Real' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Frank Thomas\' Big Hurt Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'GameTek' WHERE gamename = 'Frantic Flea' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1998', publisher = 'Majesco' WHERE gamename = 'Frogger' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1994', publisher = 'GameTek, Inc.' WHERE gamename = 'Full Throttle Racing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'Tradewest, Inc.' WHERE gamename = 'Fun \'N Games' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Gemfire' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1993', publisher = 'KOEI Corporation' WHERE gamename = 'Genghis Khan II - Clan of the Gray Wolf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'George Foreman\'s KO Boxing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Ghoul Patrol' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Mindscape, Inc., Mindscape International Ltd.' WHERE gamename = 'Gods' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Goof Troop' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'GP-1' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'GP-1 Part II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Konami Corporation' WHERE gamename = 'Gradius III' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Great Circus Mystery Starring Mickey & Minnie, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1993', publisher = '' WHERE gamename = 'Great Waldo Search, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Gunforce - Battle Fire Engulfed Terror Island' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Hagane' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'HAL America, Inc.' WHERE gamename = 'HAL\'s Hole in One Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Hammerlock Wrestling' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = '' WHERE gamename = 'Hanna Barbera\'s Turbo Toons' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Accolade, Inc.' WHERE gamename = 'Hardball III' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Electronic Arts, Inc., Hi-Tech Expressions, Inc.' WHERE gamename = 'Harley\'s Humongous Adventure' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1996', publisher = 'Natsume, Inc., Pack-In-Video Co., Ltd' WHERE gamename = 'Harvest Moon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Head-On Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1995', publisher = '' WHERE gamename = 'Hebereke\'s Popoitto' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1993', publisher = '' WHERE gamename = 'Hebereke\'s Popoon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Hit the Ice' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Home Alone' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Home Alone 2 - Lost in New York' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1995', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Home Improvement' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Hook' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = '' WHERE gamename = 'Humans, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1995', publisher = '' WHERE gamename = 'Hungry Dinosaurs' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Hunt for Red October, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Hurricanes, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Mc O\'River, Inc.' WHERE gamename = 'Hyper V-Ball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1991', publisher = 'HAL America, Inc.' WHERE gamename = 'HyperZone' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Ignition Factor, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Illusion of Gaia' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Imperium' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Titus Interactive S.A.' WHERE gamename = 'Incantation' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Incredible Crash Dummies, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Incredible Hulk, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Indiana Jones\' Greatest Adventures' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Inindo - Way of the Ninja' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Inspector Gadget' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Konami Corporation' WHERE gamename = 'International Superstar Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Konami Corporation' WHERE gamename = 'International Superstar Soccer Deluxe' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'International Tennis Tour' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Irem Skins Game, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Itchy & Scratchy Game, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Izzy\'s Quest for the Olympic Rings' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tradewest, Inc.' WHERE gamename = 'Jack Nicklaus Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'James Bond Jr' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Millennium Interactive Ltd.' WHERE gamename = 'James Pond 3 - Operation Starfish' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'James Pond\'s Crazy Sports' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'GTE Entertainment' WHERE gamename = 'Jammit' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = '' WHERE gamename = 'Jelly Boy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'GameTek' WHERE gamename = 'Jeopardy!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'GameTek' WHERE gamename = 'Jeopardy! Deluxe Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'GameTek' WHERE gamename = 'Jeopardy! Sports Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Jetsons, The - Invasion of the Planet Pirates' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = '' WHERE gamename = 'Jim Lee\'s WildC.A.T.S' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Electro Brain Corp.' WHERE gamename = 'Jim Power - The Lost Dimension in 3D' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Simulation, Sports', year = '1992', publisher = 'Ubisoft Entertainment' WHERE gamename = 'Jimmy Connors Pro Tennis Tour' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'American Sammy Corporation' WHERE gamename = 'Jimmy Houston\'s Bass Tournament U.S.A.' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Data East USA, Inc.' WHERE gamename = 'Joe & Mac' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Data East Corporation' WHERE gamename = 'Joe & Mac 2 - Lost in the Tropics' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'John Madden Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'John Madden Football \'93' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1994', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'JRR Tolkien\'s The Lord of the Rings - Volume 1' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Judge Dredd' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Jungle Book, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Electronic Arts' WHERE gamename = 'Jungle Strike' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Jurassic Park' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Jurassic Park Part 2 - The Chaos Continues' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Justice League Task Force' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Kablooey' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'GameTek, Inc.' WHERE gamename = 'Kawasaki Caribbean Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = 'Time Warner Interactive, Inc.' WHERE gamename = 'Kawasaki Superbike Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Ken Griffey Jr. Presents Major League Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Ken Griffey Jr.\'s Winning Run' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Datam Polystar, SETA U.S.A., Inc.' WHERE gamename = 'Kendo Rage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Kevin Keegan\'s Player Manager' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Kick Off' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Kick Off 3 - European Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Kid Klown in Crazy Chase' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Killer Instinct' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1995', publisher = 'Enix America Inc.' WHERE gamename = 'King Arthur & The Knights of Justice' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Jaleco Ltd., Jaleco USA, Inc.' WHERE gamename = 'King Arthur\'s World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'King of Dragons, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'King of the Monsters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Takara Co., Ltd.' WHERE gamename = 'King of the Monsters 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Kirby Super Star' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Kirby\'s Avalanche' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Kirby\'s Dream Course' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1997', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Kirby\'s Dream Land 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1994', publisher = 'Nintendo Co. Ltd.' WHERE gamename = 'Kirby\'s Ghost Trap' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Knights of the Round' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Krusty\'s Super Fun House' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = 'Williams Entertainment' WHERE gamename = 'Kyle Petty\'s No Fear Racing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1991', publisher = 'Kemco/Seika' WHERE gamename = 'Lagoon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Titus Software Corp.' WHERE gamename = 'Lamborghini - American Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Last Action Hero' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Lawnmower Man, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Arcade Zone Ltd., Seika Corporation' WHERE gamename = 'Legend' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Legend of The Mystical Ninja, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1991', publisher = '' WHERE gamename = 'Legend of Zelda, The - A Link to the Past' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'SunSoft' WHERE gamename = 'Lemmings' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Psygnosis Limited' WHERE gamename = 'Lemmings 2 - The Tribes' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'DTMC Inc.' WHERE gamename = 'Lester the Unlikely' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Konami of America, Inc.' WHERE gamename = 'Lethal Enforcers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Lethal Weapon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Liberty or Death' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Lion King, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = '' WHERE gamename = 'Lock On' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'SunSoft' WHERE gamename = 'Looney Tunes B-Ball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'SunSoft' WHERE gamename = 'Looney Tunes Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1997', publisher = '' WHERE gamename = 'Lost Vikings II, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Lost Vikings, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Lucky Luke' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Lufia & The Fortress of Doom' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1996', publisher = 'Natsume, Inc., Taito Corporation' WHERE gamename = 'Lufia II - Rise of the Sinistrals' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'Madden NFL \'94' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports, Strategy', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Madden NFL \'95' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports, Strategy', year = '1995', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Madden NFL \'96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'Madden NFL \'97' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'Madden NFL \'98' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Magic Boy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Magic Johnson\'s Super Slam Dunk' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Magic Sword' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Magical Quest Starring Mickey Mouse, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = 'Manchester United Championship Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1992', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Mario is Missing!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1992', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Mario Paint' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'Mario\'s Early Years - Fun With Letters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Mario\'s Early Years - Fun With Numbers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1994', publisher = 'Software Toolworks, Inc.' WHERE gamename = 'Mario\'s Early Years - Preschool Fun' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, Educational', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Mario\'s Time Machine' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Natsume Inc.' WHERE gamename = 'Mark Davis\' The Fishing Master' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Marko\'s Magic Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Marvel Super Heroes - War of the Gems' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sony Imagesoft' WHERE gamename = 'Mary Shelley\'s Frankenstein' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Mask, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1994', publisher = 'Davidson' WHERE gamename = 'Math Blaster - Episode 1' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Disney Interactive, Inc.' WHERE gamename = 'Maui Mallard in Cold Shadow' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'ToHo Co. Ltd.' WHERE gamename = 'Mecarobot Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'Activision, Inc.' WHERE gamename = 'Mechwarrior' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1995', publisher = 'Activision, Inc.' WHERE gamename = 'Mechwarrior 3050' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Mega lo Mania' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc., Laguna GmbH' WHERE gamename = 'Mega Man VII' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc., Nintendo UK Entertainment Limited' WHERE gamename = 'Mega Man X' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc., Laguna GmbH' WHERE gamename = 'Mega Man X 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc., Laguna GmbH' WHERE gamename = 'Mega Man X 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Mega Man\'s Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Metal Combat - Falcon\'s Revenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Metal Marines' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'FCI, Inc.' WHERE gamename = 'Metal Morph' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Konami Corporation' WHERE gamename = 'Metal Warriors' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Bullet-Proof Software' WHERE gamename = 'Michael Andretti\'s Indy Car Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Electronic Arts' WHERE gamename = 'Michael Jordan - Chaos in the Windy City' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Sony Electronic Publishing Ltd.' WHERE gamename = 'Mickey Mania' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1991', publisher = '' WHERE gamename = 'Mickey\'s Playtown Adventure - A Day of Discovery!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Hi Tech Expressions' WHERE gamename = 'Mickey\'s Ultimate Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Micro Machines' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1995', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Micro Machines 2 - Turbo Tournament' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1993', publisher = 'Elite Systems, Ltd.' WHERE gamename = 'Might and Magic II - Gates to Another World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1995', publisher = 'FCI, Inc.' WHERE gamename = 'Might and Magic III - Isles of Terra' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = '' WHERE gamename = 'Mighty Max' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Bandai America, Inc.' WHERE gamename = 'Mighty Morphin Power Rangers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Bandai America, Inc.' WHERE gamename = 'Mighty Morphin Power Rangers - The Fighting Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Bandai America, Inc.' WHERE gamename = 'Mighty Morphin Power Rangers - The Movie' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'MLBPA Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Black Pearl Software' WHERE gamename = 'MoHawk & Headphone Jack' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Parker Brothers' WHERE gamename = 'Monopoly' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Mortal Kombat' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Williams Entertainment' WHERE gamename = 'Mortal Kombat 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Mortal Kombat II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Mountain Bike Rally' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Mr. Do!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Mr. Nutz' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Ms. Pac-Man' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = '' WHERE gamename = 'Musya' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1995', publisher = 'Playmates Interactive Entertainment' WHERE gamename = 'Mutant Chronicles - Doom Troopers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Natsume Inc.' WHERE gamename = 'Natsume Championship Wrestling' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'LJN, Ltd.' WHERE gamename = 'NBA All-Star Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Konami of America, Inc.' WHERE gamename = 'NBA Give \'N Go' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Midway' WHERE gamename = 'NBA Hang Time' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NBA Jam' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NBA Jam - Tournament Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'EA Sports' WHERE gamename = 'NBA Live \'95' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'NBA Live \'96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'EA Sports' WHERE gamename = 'NBA Live \'97' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'NBA Live \'98' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'NBA Showdown' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'NCAA Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'NCAA Final Four Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Mindscape, Inc.' WHERE gamename = 'NCAA Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Newman-Hass Indy Car Featuring Nigel Mansell' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'NFL Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'LJN Ltd.' WHERE gamename = 'NFL Quarterback Club' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NFL Quarterback Club \'96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'EA Sports' WHERE gamename = 'NHL \'94' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'NHL \'95' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'EA Sports' WHERE gamename = 'NHL \'96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'NHL \'97' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1997', publisher = 'EA Sports' WHERE gamename = 'NHL \'98' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'NHL Stanley Cup' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'NHLPA Hockey \'93' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Viacom New Media' WHERE gamename = 'Nickelodeon GUTS' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'GameTek' WHERE gamename = 'Nigel Mansell\'s World Championship Racing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Tecmo, Inc.' WHERE gamename = 'Ninja Gaiden Trilogy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Ninja Warriors, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'No Escape' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1991', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Nobunaga\'s Ambition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Nobunaga\'s Ambition - Lord of Darkness' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Romstar Incorporated' WHERE gamename = 'Nolan Ryan\'s Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'SETA Corporation, SETA U.S.A., Inc.' WHERE gamename = 'Nosferatu' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1994', publisher = 'Bullet-Proof Software' WHERE gamename = 'Obitus' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1994', publisher = 'Enix America Inc.' WHERE gamename = 'Ogre Battle - The March of the Black Queen' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'Olympic Summer Games 96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing, Strategy', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'On the Ball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1993', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Operation Europe - Path to Victory 1939-45' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Operation Logic Bomb' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Taito America Corp.' WHERE gamename = 'Operation Thunderbolt' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Titus Interactive S.A.' WHERE gamename = 'Oscar' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Out of This World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Mindscape, Inc.' WHERE gamename = 'Out to Lunch' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, Driving/Racing', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Outlander' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Namco Europe Limited, Namco Hometek Inc.' WHERE gamename = 'Pac-Attack' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1995', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Pac-in-Time' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1994', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Pac-Man 2 - The New Adventures' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Pacific Theater of Operations' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Pacific Theater of Operations II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Raya Systems, Inc.' WHERE gamename = 'Packy & Marlon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Pagemaster, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = 'Enix America Inc.' WHERE gamename = 'Paladin\'s Quest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Mindscape, Inc.' WHERE gamename = 'Paperboy 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Parodius - Non-Sense Fantasy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Peace Keepers, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Pebble Beach Golf Links' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1996', publisher = 'Black Pearl Software' WHERE gamename = 'PGA European Tour' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Black Pearl Software' WHERE gamename = 'PGA Tour 96' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'PGA Tour Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Phalanx - The Enforce Fighter A-144' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Viacom New Media' WHERE gamename = 'Phantom 2040' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1994', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Pieces' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1990', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Pilotwings' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Coconuts Japan Entertainment Co., Ltd., GameTek, Inc., GameTek UK, Ltd.' WHERE gamename = 'Pinball Dreams' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'GameTek' WHERE gamename = 'Pinball Fantasies' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'TecMagik, Inc.' WHERE gamename = 'Pink Panther in Pink Goes to Hollywood' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1996', publisher = 'Buena Vista Games, Inc., Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Pinocchio' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Pirates of Dark Water, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Pit Fighter' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Activision, Inc.' WHERE gamename = 'Pitfall - The Mayan Adventure' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Activision, Inc., Tradewest, Inc.' WHERE gamename = 'Plok!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Natsume Inc.' WHERE gamename = 'Pocky & Rocky' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = '' WHERE gamename = 'Pocky & Rocky 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Pop\'n Twinbee' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Konami of Europe GmbH' WHERE gamename = 'Pop\'n Twinbee - Rainbow Bell Adventures' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Acclaim Entertainment, Inc., Imagineer Co., Ltd.' WHERE gamename = 'Populous' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Populous II - Trials of the Olympian Gods' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Porky Pig\'s Haunted Holiday' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1995', publisher = '' WHERE gamename = 'Power Drive' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Power Instinct' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Power Monger' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Kaneko' WHERE gamename = 'Power Moves' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Titus Software Corp.' WHERE gamename = 'Power Piggs of the Dark Age' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1996', publisher = 'Bandai America, Inc.' WHERE gamename = 'Power Rangers Zeo - Battle Racers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Titus Software Corp.' WHERE gamename = 'Prehistorik Man' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Time Warner Interactive' WHERE gamename = 'Primal Rage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami of America, Inc.' WHERE gamename = 'Prince of Persia' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Psygnosis Limited' WHERE gamename = 'Prince of Persia 2 - The Shadow & The Flame' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tradewest, Inc.' WHERE gamename = 'Pro Quarterback' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Pro Sport Hockey' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Push-Over' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Putty Squad' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1995', publisher = '' WHERE gamename = 'Puzzle Bobble' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'NTVIC' WHERE gamename = 'Q-bert 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Irem Corp., Jaleco USA, Inc.' WHERE gamename = 'R-Type III - The Third Lightning' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Race Drivin\'' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, Sports', year = '1994', publisher = 'Activision, Inc.' WHERE gamename = 'Radical Rex' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Electro Brain Corp.' WHERE gamename = 'Raiden Trad' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1992', publisher = 'Electronic Arts' WHERE gamename = 'Rampart' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'DTMC Inc.' WHERE gamename = 'Ranma Nibunnoichi - Hard Battle' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Motown Games' WHERE gamename = 'Rap Jam - Volume One' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1996', publisher = 'Titus Software Corp.' WHERE gamename = 'Realm' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Absolute Entertainment, Inc., Altron Corporation, LOZC/G. Amusements Co., Ltd.' WHERE gamename = 'Redline F-1 Racer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Left Field Productions' WHERE gamename = 'Relief Pitcher' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Ren & Stimpy Show, The - Buckeroos!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Ren & Stimpy Show, The - Fire Dogs' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Ren & Stimpy Show, The - Time Warp' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Ren & Stimpy Show, The - Veediots!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc., Software Creations Ltd.' WHERE gamename = 'Revolution X' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Educational', year = '1993', publisher = 'Health Hero Network' WHERE gamename = 'Rex Ronan - Experimental Surgeon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Extreme Entertainment Group, Inc.' WHERE gamename = 'Riddick Bowe Boxing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'KOEI Corporation' WHERE gamename = 'Rise of the Phoenix' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Rise of the Robots' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Rival Turf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Road Riot 4WD' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Road Runner' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1992', publisher = 'SunSoft, Sunsoft of America' WHERE gamename = 'Road Runner\'s Death Valley Rally' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Robocop 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Robocop Versus The Terminator' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1994', publisher = 'Enix America Inc.' WHERE gamename = 'Robotrek' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Interplay Productions, Inc., Namco Limited' WHERE gamename = 'Rock N\' Roll Racing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Rocketeer, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Viacom New Media' WHERE gamename = 'Rocko\'s Modern Life - Spunky\'s Dangerous Day' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Irem America Corp.' WHERE gamename = 'Rocky Rodent' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'LJN Ltd.' WHERE gamename = 'Roger Clemens\' MVP Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Romance of the Three Kingdoms II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Romance of the Three Kingdoms III - Dragon of Destiny' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1994', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Romance of the Three Kingdoms IV - Wall of Fire' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1991', publisher = '' WHERE gamename = 'RPM Racing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Run Saber' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'TAKARA Co., Ltd.' WHERE gamename = 'Samurai Shodown' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Saturday Night Slam Masters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = '' WHERE gamename = 'Scooby-Doo' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'THQ, Inc.' WHERE gamename = 'SeaQuest DSV' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1995', publisher = 'Nintendo Australia Pty., Ltd., Nintendo of Europe GmbH, Square Soft, Inc.' WHERE gamename = 'Secret of Evermore' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1993', publisher = 'Square Co., Ltd.' WHERE gamename = 'Secret of Mana' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1993', publisher = 'Tecmo, Inc., Tecmo, Ltd.' WHERE gamename = 'Secret of the Stars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Sensible Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Renegade Software' WHERE gamename = 'Sensible Soccer - International Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = '' WHERE gamename = 'Shadow, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1993', publisher = 'Data East Corporation, Laser Beam Entertainment Pty. Ltd.' WHERE gamename = 'Shadowrun' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Activision, Inc.' WHERE gamename = 'Shanghai II - Dragon\'s Eye' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Shaq Fu' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Shien\'s Revenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1993', publisher = 'Data East Corporation' WHERE gamename = 'Side Pocket' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Maxis' WHERE gamename = 'Sim Ant' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Sim City' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation, Strategy', year = '1995', publisher = 'Black Pearl Software' WHERE gamename = 'Sim City 2000' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational, Simulation', year = '1991', publisher = 'FCI, Imagineer Co., Ltd.' WHERE gamename = 'Sim Earth - The Living Planet' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Simpsons, The - Bart\'s Nightmare' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Titus Interactive S.A.' WHERE gamename = 'Sink or Swim' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Skuljagger - Revolt of the Westicans' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Sky Blazer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Smart Ball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Smash Tennis' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Smurfs 2, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Smurfs, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'American Softworks Corporation' WHERE gamename = 'Snow White in Happily Ever After' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Ocean Software Ltd., Yanoman Corporation' WHERE gamename = 'Soccer Kid' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Soccer Shootout' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Spectrum HoloByte, Inc.' WHERE gamename = 'Soldiers of Fortune' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Sonic Blast Man' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Taito America Corp.' WHERE gamename = 'Sonic Blast Man II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'SOS' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1992', publisher = 'Enix America Inc.' WHERE gamename = 'Soul Blazer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Space Ace' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Triffix Entertainment Inc.' WHERE gamename = 'Space Football - One on One' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Nintendo Co., Ltd., Taito Corporation' WHERE gamename = 'Space Invaders' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Toho Company Ltd.' WHERE gamename = 'Space Megaforce' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Natsume, Inc.' WHERE gamename = 'Spanky\'s Quest' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Konami Corporation' WHERE gamename = 'Sparkster' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Sony Electronic Publishing Ltd.' WHERE gamename = 'Spawn' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing, Strategy', year = '1994', publisher = 'Cybersoft, Inc.' WHERE gamename = 'Spectre' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = '' WHERE gamename = 'Speed Racer in My Most Dangerous Adventures' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Majesco' WHERE gamename = 'Speedy Gonzales - Los Gatos Bandidos' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = '' WHERE gamename = 'Spell Craft' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'LJN Ltd.' WHERE gamename = 'Spider-Man' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'LJN, Ltd.' WHERE gamename = 'Spider-Man & Venom - Maximum Carnage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Spider-Man & Venom - Separation Anxiety' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'LJN, Ltd.' WHERE gamename = 'Spider-Man and the X-Men in Arcade\'s Revenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'ASCII Entertainment Software, Inc.' WHERE gamename = 'Spindizzy Worlds' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Infogrames' WHERE gamename = 'Spirou' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Sporting News Power Baseball, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Malibu Games' WHERE gamename = 'Sports Illustrated Championship Football & Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Star Fox' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Star Fox Super Weekend Competition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Playmates Interactive Entertainment, Inc.' WHERE gamename = 'Star Trek - Deep Space Nine - Crossroads of Time' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'Interplay Productions, Inc.' WHERE gamename = 'Star Trek - Starfleet Academy Starship Bridge Simulator' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'Spectrum HoloByte, Inc.' WHERE gamename = 'Star Trek - The Next Generation - Future\'s Past' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Stargate' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'Tengen' WHERE gamename = 'Steel Talons' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Sterling Sharpe - End 2 End' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Stone Protectors' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'Irem America Corp.' WHERE gamename = 'Street Combat' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc.' WHERE gamename = 'Street Fighter Alpha 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Street Fighter II - The World Warrior' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Street Fighter II Turbo - Hyper Fighting' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'GTE Interactive Media' WHERE gamename = 'Street Hockey \'95' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Ubisoft Entertainment' WHERE gamename = 'Street Racer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'NTVIC' WHERE gamename = 'Strike Gunner' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Elite Systems, Ltd.' WHERE gamename = 'Striker' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Stunt Race FX' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Sunset Riders' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Super Adventure Island' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Super Adventure Island II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = '' WHERE gamename = 'Super Air Diver' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'Super Alfred Chicken' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Super Aquatic Games, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Super Baseball Simulator 1.000' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Super Bases Loaded' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Super Bases Loaded 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Super Bases Loaded 3 - License to Steal' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Super Batter Up' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Super Battleship' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Super Battletank - War in the Gulf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Super Battletank 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'HOT-B USA Inc.' WHERE gamename = 'Super Black Bass' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Super Bomberman' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Super Bomberman 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Super Bomberman 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Super Bonk' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'American Technos Inc.' WHERE gamename = 'Super Bowling' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Super Buster Bros.' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Virgin Games' WHERE gamename = 'Super Caesars Palace' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Konami Co., Ltd., Konami, Inc.' WHERE gamename = 'Super Castlevania IV' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Super Chase H.Q.' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Super Conflict - The Mideast' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Tradewest, Inc.' WHERE gamename = 'Super Double Dragon' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Super Earth Defense Force' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Super Ghouls \'N Ghosts' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = '' WHERE gamename = 'Super Goal!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Super Goal! 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'ToHo Co. Ltd.' WHERE gamename = 'Super Godzilla' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Super High Impact' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Super Hockey' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Super Ice Hockey' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Nintendo Co. Ltd.' WHERE gamename = 'Super International Cricket' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'American Softworks Corporation' WHERE gamename = 'Super James Pond' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Super Mario All-Stars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Mario All-Stars + Super Mario World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Super Mario Kart' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1996', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Mario RPG - Legend of the Seven Stars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1990', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Super Mario World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Super Mario World 2 - Yoshi\'s Island' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Super Metroid' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1993', publisher = '' WHERE gamename = 'Super Morph' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1992', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Super Ninja Boy' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Wisdom Tree, Inc.' WHERE gamename = 'Super Noah\'s Ark 3D' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Super Nova' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'Tradewest Sports' WHERE gamename = 'Super Off Road' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Tradewest, Inc.' WHERE gamename = 'Super Off Road - The Baja' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Super Pang' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1994', publisher = 'Nintendo Co. Ltd.' WHERE gamename = 'Super Pinball - Behind the Mask' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Play Action Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Super Probotector - The Alien Rebels' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Super Punch-Out!!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Super Putty' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Irem America Corp.' WHERE gamename = 'Super R-Type' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Time Warner Interactive' WHERE gamename = 'Super R.B.I. Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Super Shadow of the Beast' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Virgin Interactive Entertainment, Inc.' WHERE gamename = 'Super Slapshot' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Super Smash T.V.' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Super Soccer Champ' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Extreme Entertainment Group, Inc.' WHERE gamename = 'Super Solitaire' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'JVC Musical Industries, Inc., Nintendo of America Inc., Victor Entertainment Inc.' WHERE gamename = 'Super Star Wars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Super Star Wars - Return of the Jedi' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Super Star Wars - The Empire Strikes Back' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Super Street Fighter II - The New Challengers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = '' WHERE gamename = 'Super Strike Eagle' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Tonkin House' WHERE gamename = 'Super Tennis' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'American Softworks Corporation' WHERE gamename = 'Super Troll Islands' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Kemco/Seika' WHERE gamename = 'Super Turrican' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Super Turrican 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Super Valis IV' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Super Widget' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing, Simulation', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Suzuka 8 Hours' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'SWAT Kats - The Radical Squadron' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG, Strategy', year = '1994', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Syndicate' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = '' WHERE gamename = 'Syvalion' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'T2 - The Arcade Game' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'Sunsoft' WHERE gamename = 'Taz-Mania' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Baseball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl II - Special Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl III - Final Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super NBA Basketball' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'Teenage Mutant Ninja Turtles - Tournament Fighters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation' WHERE gamename = 'Teenage Mutant Ninja Turtles IV - Turtles in Time' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'LJN, Ltd.' WHERE gamename = 'Terminator 2 - Judgment Day' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = '' WHERE gamename = 'Terminator, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1995', publisher = 'Enix Corporation, Nintendo of Europe GmbH' WHERE gamename = 'Terranigma' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1992', publisher = 'Accolade, Inc.' WHERE gamename = 'Test Drive II - The Duel' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Tetris & Dr. Mario' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Tetris 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Tetris Attack' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Theme Park' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Thomas the Tank Engine and Friends' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Seika Corporation' WHERE gamename = 'Thunder Spirits' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Tick, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Malibu Games' WHERE gamename = 'Time Trax' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Timecop' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'Vic Tokai Inc.' WHERE gamename = 'TimeSlip' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1997', publisher = 'THQ, Inc.' WHERE gamename = 'Timon & Pumbaa\'s Jungle Games' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Tin Star' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Infogrames' WHERE gamename = 'Tintin in Tibet' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation, Konami of Europe GmbH, Konami of America, Inc., Konami UK Ltd.' WHERE gamename = 'Tiny Toon Adventures - Buster Busts Loose!' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'Konami of America, Inc.' WHERE gamename = 'Tiny Toon Adventures - Wacky Sports Challenge' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Sofel' WHERE gamename = 'TKO Super Championship Boxing' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'American Softworks Corporation' WHERE gamename = 'TNN Bass Tournament of Champions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Hi Tech Expressions' WHERE gamename = 'Tom & Jerry' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Electro Brain Corp.' WHERE gamename = 'Tony Meola\'s Sidekicks Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1992', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Top Gear' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1993', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Top Gear 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Driving/Racing', year = '1994', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Top Gear 3000' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Malibu Games' WHERE gamename = 'Total Carnage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = '' WHERE gamename = 'Toy Story' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Toys' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1993', publisher = 'Seika Corporation' WHERE gamename = 'Troddlers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Williams Entertainment Inc.' WHERE gamename = 'Troy Aikman NFL Football' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'True Lies' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Tuff E Nuff' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Turn and Burn - No-Fly Zone' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1994', publisher = '' WHERE gamename = 'Twisted Tales of Spike McFang, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Capcom Entertainment, Inc.' WHERE gamename = 'U.N. Squadron' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1994', publisher = 'FCI, Inc.' WHERE gamename = 'Ultima - Runes of Virtue II' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1992', publisher = 'FCI, Pony Canyon, Inc.' WHERE gamename = 'Ultima VI - The False Prophet' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1994', publisher = 'FCI, Pony Canyon, Inc.' WHERE gamename = 'Ultima VII - The Black Gate' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Ultimate Fighter' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Williams Entertainment' WHERE gamename = 'Ultimate Mortal Kombat 3' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1991', publisher = 'Bandai America, Inc.' WHERE gamename = 'Ultraman - Towards the Future' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Uncharted Waters' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Uncharted Waters - New Horizons' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Driving/Racing', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Uniracers' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Accolade, Inc.' WHERE gamename = 'Universal Soldier' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Untouchables, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1995', publisher = 'Black Pearl Software' WHERE gamename = 'Urban Strike' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Utopia - The Creation of a Nation' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Val d\'Isere Championship' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1995', publisher = 'Nintendo Co. Ltd.' WHERE gamename = 'Vegas Stakes' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Virtual Bart' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = '' WHERE gamename = 'Virtual Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1994', publisher = 'Electro Brain Corp.' WHERE gamename = 'Vortex' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = '' WHERE gamename = 'Waialae Country Club' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1995', publisher = 'Advanced Productions, Inc.' WHERE gamename = 'War 2410' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1996', publisher = '' WHERE gamename = 'War 3010 - The Revolution' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Wario\'s Woods' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'LJN, Ltd., Trimark Interactive' WHERE gamename = 'Warlock' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'Accolade, Inc.' WHERE gamename = 'WarpSpeed' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Waterworld' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = 'Time Warner Interactive' WHERE gamename = 'Wayne Gretzky and the NHLPA All-Stars' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Wayne\'s World' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'FCI, Inc.' WHERE gamename = 'WCW Super Brawl Wrestling' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Hi Tech Expressions' WHERE gamename = 'We\'re Back! - A Dinosaur\'s Story' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1995', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Weapon Lord' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'GameTek, Inc.' WHERE gamename = 'Wheel of Fortune' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'GameTek' WHERE gamename = 'Wheel of Fortune - Deluxe Edition' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Educational', year = '1993', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Where in the World is Carmen Sandiego' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, Educational', year = '1992', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Where in Time is Carmen Sandiego' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Namco Ltd.' WHERE gamename = 'Whirlo' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1996', publisher = 'Titus Interactive S.A.' WHERE gamename = 'Whizz' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Bullet-Proof Software' WHERE gamename = 'Wicked 18 Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Natsume, Inc.' WHERE gamename = 'Wild Guns' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1994', publisher = 'Bullet-Proof Software' WHERE gamename = 'WildSnake' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'Mindscape, Inc.' WHERE gamename = 'Wing Commander' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Mindscape, Inc.' WHERE gamename = 'Wing Commander - The Secret Missions' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1992', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Wings 2 - Aces High' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'Winter Extreme Skiing and Snowboarding' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1996', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Winter Gold' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = 'U.S. Gold Ltd.' WHERE gamename = 'Winter Olympic Games - Lillehammer \'94' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Wizard of Oz, The' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1992', publisher = 'ASCII Corporation, Capcom Entertainment, Inc.' WHERE gamename = 'Wizardry V - Heart of the Maelstrom' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Wolf Child' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Wolfenstein 3D' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'LJN, Ltd.' WHERE gamename = 'Wolverine - Adamantium Rage' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Wordtris' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'World Class Rugby' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1994', publisher = '' WHERE gamename = 'World Cup Striker' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'SunSoft, U.S. Gold Ltd.' WHERE gamename = 'World Cup USA 94' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'SunSoft' WHERE gamename = 'World Heroes' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1994', publisher = 'Takara Co., Ltd.' WHERE gamename = 'World Heroes 2' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Mindscape Inc.' WHERE gamename = 'World League Soccer' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1995', publisher = '' WHERE gamename = 'World Masters Golf' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'World Soccer 94 - Road to Glory' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1996', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Worms' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1994', publisher = 'LJN, Ltd.' WHERE gamename = 'WWF Raw' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'LJN, Ltd.' WHERE gamename = 'WWF Royal Rumble' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'LJN, Ltd.' WHERE gamename = 'WWF Super WrestleMania' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1995', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF WrestleMania - The Arcade Game' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Kemco' WHERE gamename = 'X Zone' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'X-Kaliber 2097' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'X-Men - Mutant Apocalypse' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Asmik Corporation of America' WHERE gamename = 'Xardion' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Yogi Bear' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Bullet-Proof Software, Inc., Nintendo of America Inc.' WHERE gamename = 'Yoshi\'s Cookie' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1993', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Yoshi\'s Safari' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Young Merlin' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1991', publisher = 'Tonkin House' WHERE gamename = 'Ys III - Wanderers from Ys' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'SunSoft' WHERE gamename = 'Zero the Kamikaze Squirrel' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Zombies' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Zombies Ate My Neighbors' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Gremlin Graphics Software Ltd.' WHERE gamename = 'Zool' AND gametype = 'SNES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1996', publisher = 'Viacom New Media' WHERE gamename = 'Zoop' AND gametype = 'SNES';