UPDATE gamemetadata SET genre = 'Sports', year = '1985', publisher = 'Irem Corp., Nintendo of America Inc.' WHERE gamename = '10-Yard Fight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Capcom Co., Ltd.' WHERE gamename = '1942' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'Capcom USA, Inc.' WHERE gamename = '1943 - The Battle of Midway' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Acclaim Entertainment, Inc., Square Co., Ltd.' WHERE gamename = '3-D Battles of World Runner, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Mindscape, Inc.' WHERE gamename = '720' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'SETA Corporation, Taxan' WHERE gamename = '8 Eyes' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Milton Bradley Co.' WHERE gamename = 'Abadox - The Deadly Inner War' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Active Enterprises, Ltd.' WHERE gamename = 'Action 52' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Addams Family, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Addams Family, The - Pugsley\'s Scavenger Hunt' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'FCI, Inc.' WHERE gamename = 'Advanced Dungeons & Dragons - Dragon Strike' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'FCI, Inc.' WHERE gamename = 'Advanced Dungeons & Dragons - Heroes of the Lance' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = 'FCI, Inc.' WHERE gamename = 'Advanced Dungeons & Dragons - Hillsfar' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'FCI, Inc.' WHERE gamename = 'Advanced Dungeons & Dragons - Pool of Radiance' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Adventures in the Magic Kingdom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Konami Corporation' WHERE gamename = 'Adventures of Bayou Billy, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Color Dreams, Inc.' WHERE gamename = 'Adventures of Captain Comic, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1989', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Adventures of Dino Riki, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1990', publisher = 'Bandai America, Inc.' WHERE gamename = 'Adventures of Gilligan\'s Island, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1988', publisher = 'HAL America, Inc.' WHERE gamename = 'Adventures of Lolo' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'HAL America, Inc.' WHERE gamename = 'Adventures of Lolo 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1990', publisher = 'HAL America Inc., HAL Laboratory, Inc' WHERE gamename = 'Adventures of Lolo 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Activision, Inc.' WHERE gamename = 'Adventures of Rad Gravity, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Adventures of Rocky and Bullwinkle and Friends, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'Adventures of Tom Sawyer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'HAL America Inc., HAL Laboratory, Inc' WHERE gamename = 'Air Fortress' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Kyugo Boueki' WHERE gamename = 'Airwolf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation, Sports', year = '1989', publisher = 'Data East Corporation' WHERE gamename = 'Al Unser Jr. Turbo Racing' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Aladdin' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Mindscape, Inc.' WHERE gamename = 'Alfred Chicken' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1993', publisher = 'LJN Ltd.' WHERE gamename = 'Alien 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'All-Pro Basketball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'SNK Electronics Corp., SNK Corporation' WHERE gamename = 'Alpha Mission' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'American Sammy Corporation, Vic Tokai, Inc.' WHERE gamename = 'Amagon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1991', publisher = 'GameTek, Inc.' WHERE gamename = 'American Gladiators' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1988', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Anticipation' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = '' WHERE gamename = 'Arch Rivals - A Basketbrawl!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1989', publisher = 'Activision, Inc.' WHERE gamename = 'Archon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Taito Corporation' WHERE gamename = 'Arkanoid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1990', publisher = 'American Sammy Corporation' WHERE gamename = 'Arkista\'s Ring' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Infogrames' WHERE gamename = 'Asterix' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Jaleco Ltd., Jaleco USA, Inc.' WHERE gamename = 'Astyanax' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SNK Corporation' WHERE gamename = 'Athena' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = 'Bandai Co., Ltd.' WHERE gamename = 'Athletic World' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Attack of the Killer Tomatoes' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'LJN Ltd.' WHERE gamename = 'Back to the Future' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'LJN Ltd.' WHERE gamename = 'Back to the Future II & III' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Data East Corporation' WHERE gamename = 'Bad Dudes' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1988', publisher = '' WHERE gamename = 'Bad Dudes Vs Dragon Ninja' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Tecmo, Ltd.' WHERE gamename = 'Bad News Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Mattel Electronics' WHERE gamename = 'Bad Street Brawler' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Balloon Fight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Bandai America, Inc.' WHERE gamename = 'Bandai Golf - Challenge Pebble Beach' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1990', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Bandit Kings of Ancient China' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'Barbie' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = '' WHERE gamename = 'Bard\'s Tale, The - Tales of the Unknown' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Barker Bill\'s Trick Shooting' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Ultra Games' WHERE gamename = 'Base Wars' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1983', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Culture Brain Inc., Culture Brain USA, Inc.' WHERE gamename = 'Baseball Simulator 1.000' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'SNK Corporation, SNK NEOGEO USA Consumer Corporation' WHERE gamename = 'Baseball Stars' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Romstar Incorporated' WHERE gamename = 'Baseball Stars II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Jaleco Entertainment, Inc., Jaleco USA, Inc.' WHERE gamename = 'Bases Loaded' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Bases Loaded 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Bases Loaded 4' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Bases Loaded II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SunSoft' WHERE gamename = 'Batman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SunSoft' WHERE gamename = 'Batman - Return of the Joker' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Batman Returns' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Data East Corporation' WHERE gamename = 'Battle Chess' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1989', publisher = 'Brøderbund Software, Inc., Imagineer Co., Ltd., Nintendo of Europe GmbH' WHERE gamename = 'Battle of Olympus, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1990', publisher = '' WHERE gamename = 'Battle Tank' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game SImulator', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Battleship' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tradewest, Inc.' WHERE gamename = 'Battletoads' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Tradewest, Inc.' WHERE gamename = 'Battletoads & Double Dragon - The Ultimate Team' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Beauty and the Beast' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'LJN Ltd.' WHERE gamename = 'Beetlejuice' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = 'Electro Brain Corp.' WHERE gamename = 'Best of the Best - Championship Karate' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Educational', year = '1990', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'Big Bird\'s Hide & Speak' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Bigfoot' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'LJN Ltd.' WHERE gamename = 'Bill & Ted\'s Excellent Video Game Adventure' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation', year = '1991', publisher = 'Konami Corporation' WHERE gamename = 'Bill Elliott\'s NASCAR Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Capcom U.S.A., Inc.' WHERE gamename = 'Bionic Commando' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1989', publisher = 'HOT-B USA Inc.' WHERE gamename = 'Black Bass USA, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1988', publisher = 'Konami Corporation' WHERE gamename = 'Blades of Steel' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SunSoft' WHERE gamename = 'Blaster Master' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'HOT-B USA, Inc.' WHERE gamename = 'Blue Marlin, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Titus Interactive S.A.' WHERE gamename = 'Blues Brothers, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Data East USA, Inc.' WHERE gamename = 'Bo Jackson Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Bomberman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Bomberman II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Bonk\'s Adventure' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Boulder Dash' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Absolute Entertainment, Inc., Jaleco Entertainment, Inc.' WHERE gamename = 'Boy and His Blob, A - Trouble on Blobolonia' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Bram Stoker\'s Dracula' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'FCI, Inc.' WHERE gamename = 'Break Time - The National Pool Tour' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1987', publisher = 'Data East USA, Inc.' WHERE gamename = 'BreakThru' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Taito America Corp.' WHERE gamename = 'Bubble Bobble' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Bubble Bobble Part 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Co., Ltd., Konami Corporation' WHERE gamename = 'Bucky O\'Hare' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Bugs Bunny Birthday Blowout, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Kemco-Seika' WHERE gamename = 'Bugs Bunny Crazy Castle, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1988', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Bump\'n\'Jump' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Disco, Taito Corporation, Taxan USA Corp.' WHERE gamename = 'Burai Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Data East Corporation' WHERE gamename = 'BurgerTime' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Milton Bradley Co.' WHERE gamename = 'Cabal' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Caesars Palace' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Milton Bradley Co.' WHERE gamename = 'California Games' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Data East USA, Inc.' WHERE gamename = 'Captain America and The Avengers' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Mindscape Inc.' WHERE gamename = 'Captain Planet and The Planeteers' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Milton Bradley Co., Nintendo of Europe GmbH' WHERE gamename = 'Captain Skyhawk' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'SOFEL Co., Ltd.' WHERE gamename = 'Casino Kid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'SOFEL Co., Ltd., SOFEL Corp.' WHERE gamename = 'Casino Kid 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Triffix Entertainment Inc.' WHERE gamename = 'Castelian' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'Castle of Dragon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Nexoft Corporation' WHERE gamename = 'Castlequest' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Konami Industry Co. Ltd., Konami Corporation' WHERE gamename = 'Castlevania' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1987', publisher = 'Konami Industry Co. Ltd., Konami Corporation' WHERE gamename = 'Castlevania II - Simon\'s Quest' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Konami Corporation, Palcom Software Ltd.' WHERE gamename = 'Castlevania III - Dracula\'s Curse' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Data East USA, Inc.' WHERE gamename = 'Caveman Games' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Romstar Incorporated' WHERE gamename = 'Championship Bowling' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Championship Pool' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Active Enterprises Ltd.' WHERE gamename = 'Cheetah Men II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'Hi Tech Expressions' WHERE gamename = 'Chessmaster, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Chip \'n Dale Rescue Rangers' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Chip \'n Dale Rescue Rangers 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'Bandai America, Inc.' WHERE gamename = 'Chubby Cherub' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'ToHo Co. Ltd.' WHERE gamename = 'Circus Caper' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1988', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'City Connection' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Vic Tokai Corporation, Vic Tokai, Inc.' WHERE gamename = 'Clash at Demonhead' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'GameTek, Inc.' WHERE gamename = 'Classic Concentration' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Sony Imagesoft Inc.' WHERE gamename = 'Cliffhanger' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Clu Clu Land' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Data East Corporation' WHERE gamename = 'Cobra Command' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1989', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Cobra Triangle' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Code Name - Viper' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Educational', year = '1993', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Color A Dinosaur' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Commando' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Mindscape Inc.' WHERE gamename = 'Conan - The Mysteries of Time' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Conflict' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Asmik Ace Entertainment, Inc.' WHERE gamename = 'Conquest of the Crystal Palace' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Konami Corporation' WHERE gamename = 'Contra' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Konami Corporation' WHERE gamename = 'Contra Force' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Cool World' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Romstar Incorporated' WHERE gamename = 'Cowboy Kid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = '' WHERE gamename = 'Crackout' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = 'American Technos Inc., Technos Japan Corp.' WHERE gamename = 'Crash \'n the Boys - Street Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1990', publisher = 'SNK Corporation' WHERE gamename = 'Crystalis' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports, Strategy', year = '1991', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Cyberball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Cybernoid - The Fighting Machine' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Unique', year = '1989', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Dance Aerobics' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1991', publisher = 'Tradewest, Inc.' WHERE gamename = 'Danny Sullivan\'s Indy Heat' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Darkman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Darkwing Duck' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Data East Corporation' WHERE gamename = 'Dash Galaxy in the Alien Asylum' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'HAL America, Inc.' WHERE gamename = 'Day Dreamin\' Davey' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving, Simulation', year = '1990', publisher = 'Mindscape, Inc.' WHERE gamename = 'Days of Thunder' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1986', publisher = 'Brøderbund Software, Inc.' WHERE gamename = 'Deadly Towers' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'HAL America, Inc.' WHERE gamename = 'Defender II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'Ultra Games' WHERE gamename = 'Defender of the Crown' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'JVC Musical Industries, Inc., LucasArts' WHERE gamename = 'Defenders of Dynatron City' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1990', publisher = 'Seika Corporation' WHERE gamename = 'Deja Vu' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Taito America Corp.' WHERE gamename = 'Demon Sword' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Desert Commander' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Destination Earthstar' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1990', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc.' WHERE gamename = 'Destiny of an Emperor' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = '' WHERE gamename = 'Devil World' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Bandai America, Inc.' WHERE gamename = 'Dick Tracy' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Activision Publishing, Inc.' WHERE gamename = 'Die Hard' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Bandai America, Inc.' WHERE gamename = 'Dig Dug II - Trouble in Paradise' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Milton Bradley Ltd.' WHERE gamename = 'Digger - The Legend of the Lost City' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = '' WHERE gamename = 'Dirty Harry - The War Against Drugs' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1983', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Donkey Kong' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Donkey Kong 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Donkey Kong Classics' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1983', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Donkey Kong Jr.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Educational', year = '1985', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Donkey Kong Jr. Math' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'GameTek, Inc.' WHERE gamename = 'Double Dare' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Technos Japan Corp., Tradewest, Inc.' WHERE gamename = 'Double Dragon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Acclaim Entertainment, Inc., Technos Japan Corp.' WHERE gamename = 'Double Dragon II - The Revenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Acclaim Entertainment, Inc., Technos Japan Corp.' WHERE gamename = 'Double Dragon III - The Sacred Stones' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1987', publisher = 'Konami Corporation' WHERE gamename = 'Double Dribble' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'FCI, Inc.' WHERE gamename = 'Dr. Chaos' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Bandai America, Inc.' WHERE gamename = 'Dr. Jekyll and Mr. Hyde' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Dr. Mario' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Sofel' WHERE gamename = 'Dragon Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Bandai Co., Ltd.' WHERE gamename = 'Dragon Power' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Bandai America, Inc.' WHERE gamename = 'Dragon Spirit - The New Legend' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1986', publisher = 'Enix Corporation, Nintendo of America Inc.' WHERE gamename = 'Dragon Warrior' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1987', publisher = 'Enix America Corporation, Enix Corporation' WHERE gamename = 'Dragon Warrior II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1988', publisher = 'Enix America Corporation, Enix Corporation' WHERE gamename = 'Dragon Warrior III' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1990', publisher = 'Enix Corporation' WHERE gamename = 'Dragon Warrior IV' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'CSG Imagesoft Inc.' WHERE gamename = 'Dragon\'s Lair' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Mindscape, Inc.' WHERE gamename = 'Drop Zone' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Duck Tales' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Duck Tales 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1989', publisher = 'Taito Corporation' WHERE gamename = 'Dungeon Magic - Sword of the Elements' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Brøderbund Software, Inc.' WHERE gamename = 'Dusty Diamond\'s All-Star Softball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Bandai America, Inc.' WHERE gamename = 'Dynowarz - The Destruction of Spondylus' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Elevator Action' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Electro Brain Corp.' WHERE gamename = 'Eliminator Boat Duel' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation, Strategy', year = '1991', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Elite' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving, Sports', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Excitebike' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1992', publisher = 'MicroProse Software, Inc.' WHERE gamename = 'F-117A Stealth Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1992', publisher = 'MicroProse Software, Inc.' WHERE gamename = 'F-15 Strike Eagle' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1987', publisher = 'ShareData, Inc.' WHERE gamename = 'Family Feud' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1989', publisher = 'Hi-Score Media Work, NEXOFT Corporation' WHERE gamename = 'Faria - A World of Mystery & Danger!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1989', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Faxanadu' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Felix the Cat' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Ferrari - Grand Prix Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Sunsoft' WHERE gamename = 'Fester\'s Quest' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1987', publisher = 'Nintendo of America Inc., Square Co., Ltd.' WHERE gamename = 'Final Fantasy' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1993', publisher = 'Tecmo, Inc.' WHERE gamename = 'Fire \'n Ice' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Firehouse Rescue' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Taxan' WHERE gamename = 'Fist of the North Star' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'Mindscape, Inc.' WHERE gamename = 'Flight of the Intruder' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1991', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Flintstones, The - The Rescue of Dino & Hoppy' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Taito America Corp.' WHERE gamename = 'Flintstones, The - The Surprise at Dinosaur Peak!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Flying Dragon - The Secret Scroll' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Flying Warriors' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1993', publisher = 'Konami Co., Ltd.' WHERE gamename = 'Formula 1 Sensation' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1990', publisher = 'SETA U.S.A., Inc.' WHERE gamename = 'Formula One - Built To Win' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Bandai America, Inc.' WHERE gamename = 'Frankenstein - The Monster Returns' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'Sunsoft' WHERE gamename = 'Freedom Force' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'LJN Ltd.' WHERE gamename = 'Friday the 13th' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1991', publisher = 'Hi Tech Expressions' WHERE gamename = 'Fun House' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'G.I. Joe' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Capcom USA, Inc.' WHERE gamename = 'G.I. Joe - The Atlantis Factor' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = '' WHERE gamename = 'Galaga - Demons of Death' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Activision, Inc.' WHERE gamename = 'Galaxy 5000' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Gargoyle\'s Quest II - The Demon Darkness' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Tengen' WHERE gamename = 'Gauntlet' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Mindscape, Inc.' WHERE gamename = 'Gauntlet II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1992', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Gemfire' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Genghis Khan' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'George Foreman\'s KO Boxing' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Activision, Inc.' WHERE gamename = 'Ghostbusters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1990', publisher = 'Activision, Inc.' WHERE gamename = 'Ghostbusters II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc.' WHERE gamename = 'Ghosts \'N Goblins' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Electro-Brain' WHERE gamename = 'Ghoul School' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Jaleco Ltd., Jaleco USA, Inc.' WHERE gamename = 'Goal!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Goal! Two' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'ToHo Co. Ltd.' WHERE gamename = 'Godzilla - Monster of Monsters!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'Toho Company Ltd.' WHERE gamename = 'Godzilla 2 - War of the Monsters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Gold Medal Challenge \'92' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Golf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Golf Grand Slam' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Golgo 13 - Top Secret Episode' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Konami Industry Co. Ltd.' WHERE gamename = 'Goonies II, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1987', publisher = '' WHERE gamename = 'Gotcha! - The Sport!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Konami Corporation' WHERE gamename = 'Gradius' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Unique', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Great Waldo Search, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Virgin Interactive Entertainment' WHERE gamename = 'Greg Norman\'s Golf Power' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Sunsoft' WHERE gamename = 'Gremlins 2 - The New Batch' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Brøderbund Software, Inc., Irem Software Engineering, Inc.' WHERE gamename = 'Guardian Legend, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'SNK Corporation of America' WHERE gamename = 'Guerrilla War' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Gumshoe' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'NEXOFT Corporation, Tonkin House' WHERE gamename = 'Gun-Nac' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Gun.Smoke' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1985', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Gyromite' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Ultra Games' WHERE gamename = 'Gyruss' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Irem Corp.' WHERE gamename = 'Hammerin\' Harry' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'GameTek' WHERE gamename = 'Harlem Globetrotters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1992', publisher = 'Bullet-Proof Software' WHERE gamename = 'Hatris' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Data East Corporation' WHERE gamename = 'Heavy Barrel' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Parker Brothers' WHERE gamename = 'Heavy Shreddin\'' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1991', publisher = 'Tradewest, Inc.' WHERE gamename = 'High Speed' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Hogan\'s Alley' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1989', publisher = 'GameTek, Inc.' WHERE gamename = 'Hollywood Squares' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Home Alone' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Home Alone 2 - Lost in New York' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Sony Imagesoft' WHERE gamename = 'Hook' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1989', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Hoops' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Sony Imagesoft' WHERE gamename = 'Hudson Hawk' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Hudson\'s Adventure Island' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Hudson\'s Adventure Island II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Hudson\'s Adventure Island III' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'Hunt for Red October, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1989', publisher = 'FCI, Inc.' WHERE gamename = 'Hydlide' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1990', publisher = '' WHERE gamename = 'I Can Remember' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Ice Climber' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1988', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Ice Hockey' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'SNK Corporation' WHERE gamename = 'Ikari III - The Rescue' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'SNK Corporation' WHERE gamename = 'Ikari Warriors' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SNK Corporation' WHERE gamename = 'Ikari Warriors II - Victory Road' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Irem America Corp.' WHERE gamename = 'Image Fight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Immortal, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'American Video Entertainment' WHERE gamename = 'Impossible Mission II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'LJN Ltd.' WHERE gamename = 'Incredible Crash Dummies, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, Racing/Driving', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Indiana Jones and the Last Crusade (Taito)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, Racing/Driving', year = '1991', publisher = 'Ubisoft Entertainment' WHERE gamename = 'Indiana Jones and the Last Crusade (UBI Soft)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Mindscape, Inc., Tengen' WHERE gamename = 'Indiana Jones and the Temple of Doom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Mindscape Inc.' WHERE gamename = 'Infiltrator' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Laser Beam Entertainment Pty. Ltd.' WHERE gamename = 'International Cricket' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'SNK Corporation of America' WHERE gamename = 'Iron Tank' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1988', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Ironsword - Wizards & Warriors II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'NTVIC' WHERE gamename = 'Isolated Warrior' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1990', publisher = '' WHERE gamename = 'Ivan Ironman Stewart\'s Super Off-Road' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Konami Corporation' WHERE gamename = 'Jack Nicklaus\' Greatest 18 Holes of Major Championship Golf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1988', publisher = 'Konami Industry Co. Ltd.' WHERE gamename = 'Jackal' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Jackie Chan\'s Action Kung Fu' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'James Bond Jr' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'LJN Ltd.' WHERE gamename = 'Jaws' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1988', publisher = 'GameTek' WHERE gamename = 'Jeopardy!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'GameTek' WHERE gamename = 'Jeopardy! 25th Anniversary Edition' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1989', publisher = 'GameTek' WHERE gamename = 'Jeopardy! Junior Edition' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Jetsons, The - Cogswell\'s Caper!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Hi Tech Expressions' WHERE gamename = 'Jim Henson\'s Muppet Adventure - Chaos at the Carnival' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Ubisoft Entertainment' WHERE gamename = 'Jimmy Connor\'s Tennis' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Data East USA, Inc.' WHERE gamename = 'Joe & Mac - Caveman Ninja' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1989', publisher = 'Tradewest, Inc.' WHERE gamename = 'John Elway\'s Quarterback' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Milton Bradley Company' WHERE gamename = 'Jordan Vs Bird - One On One' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'SunSoft' WHERE gamename = 'Journey to Silius' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'HAL America Inc., HAL Laboratory, Inc' WHERE gamename = 'Joust' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Jungle Book, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Jurassic Park' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'HAL America Inc., HAL Laboratory, Inc, Pack-In-Video Co., Ltd' WHERE gamename = 'Kabuki - Quantum Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Data East USA, Inc.' WHERE gamename = 'Karate Champ' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1987', publisher = 'LJN Ltd.' WHERE gamename = 'Karate Kid, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Data East Corporation' WHERE gamename = 'Karnov' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Kick Master' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Imagineer Co., Ltd.' WHERE gamename = 'Kick Off' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'Irem America Corp.' WHERE gamename = 'Kickle Cubicle' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Kid Icarus' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Kid Klown' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = '' WHERE gamename = 'Kid Kool and the Quest for the 7 Wonder Herbs' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = '' WHERE gamename = 'Kid Niki - Radical Ninja' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Square Co., Ltd., Square Soft, Inc.' WHERE gamename = 'King\'s Knight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = 'Konami of America, Inc.' WHERE gamename = 'King\'s Quest V' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1990', publisher = 'Ultra Games' WHERE gamename = 'Kings of the Beach' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Kirby\'s Adventure' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'Kiwi Kraze - A Bird-Brained Adventure!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Sofel' WHERE gamename = 'Klash Ball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1988', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Knight Rider' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1992', publisher = 'Konami Co., Ltd.' WHERE gamename = 'Konami Hyper Soccer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Krion Conquest, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Krusty\'s Fun House' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1985', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Kung Fu' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Kung-Fu Heroes' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1991', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'L\'Empereur' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Ultra Games' WHERE gamename = 'Laser Invasion' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Sony Imagesoft' WHERE gamename = 'Last Action Hero' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Last Ninja, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Mindscape Inc.' WHERE gamename = 'Last Starfighter, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'SNK Corporation of America' WHERE gamename = 'Lee Trevino\'s Fighting Golf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1989', publisher = 'Brøderbund Software, Inc.' WHERE gamename = 'Legacy of the Wizard' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Taito America Corp.' WHERE gamename = 'Legend of Kage, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = '' WHERE gamename = 'Legend of Prince Valiant, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1989', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Legend of the Ghost Lion' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1987', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Legend of Zelda, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Legendary Wings' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Bandai America, Inc.' WHERE gamename = 'Legends of the Diamond' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Ocean Europe Limited, SunSoft' WHERE gamename = 'Lemmings' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Lethal Weapon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Konami Corporation' WHERE gamename = 'Life Force' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = '' WHERE gamename = 'Lion King, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'SNK Corporation of America' WHERE gamename = 'Little League Baseball - Championship Series' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = '' WHERE gamename = 'Little Mermaid, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Little Nemo - The Dream Master' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'Culture Brain USA, Inc.' WHERE gamename = 'Little Ninja Brothers' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Little Samson' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Brøderbund Software, Inc., Hudson Soft Company, Ltd.' WHERE gamename = 'Lode Runner' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Konami of America, Inc.' WHERE gamename = 'Lone Ranger, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Mindscape, Inc.' WHERE gamename = 'Loopz' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'TAXAN USA Corporation' WHERE gamename = 'Low G Man - The Low Gravity Man' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1985', publisher = 'FCI, Pony Canyon, Inc.' WHERE gamename = 'Lunar Pool' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean Europe Limited, Virgin Games, Inc.' WHERE gamename = 'M.C Kids' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1990', publisher = 'Mindscape Entertainment' WHERE gamename = 'M.U.L.E.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = 'Bandai America, Inc.' WHERE gamename = 'M.U.S.C.L.E.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1985', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Mach Rider' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1990', publisher = 'Mindscape, Inc.' WHERE gamename = 'Mad Max' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Vic Tokai, Inc.' WHERE gamename = 'Mafat Conspiracy - Golgo 13' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Romstar Incorporated' WHERE gamename = 'Magic Darts' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Tradewest, Inc.' WHERE gamename = 'Magic Johnson\'s Fast Break' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1990', publisher = 'Culture Brain Inc.' WHERE gamename = 'Magic of Scheherazade, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1990', publisher = 'Taxan' WHERE gamename = 'Magician' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1988', publisher = 'FCI, Inc.' WHERE gamename = 'Magmax' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'LJN Ltd.' WHERE gamename = 'Major League Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1988', publisher = 'Jaleco Ltd., Jaleco USA, Inc.' WHERE gamename = 'Maniac Mansion' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'TAXAN USA Corporation' WHERE gamename = 'Mappy-Land' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Milton Bradley Co.' WHERE gamename = 'Marble Madness' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1983', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Mario Bros.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Educational', year = '1993', publisher = 'Mindscape Inc.' WHERE gamename = 'Mario is Missing!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, Educational', year = '1994', publisher = 'Mindscape Inc.' WHERE gamename = 'Mario\'s Time Machine!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'SNK Corporation of America' WHERE gamename = 'Mechanized Attack' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Megaman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Megaman II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Entertainment, Inc., Capcom U.S.A., Inc.' WHERE gamename = 'Megaman III' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc.' WHERE gamename = 'Megaman IV' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Capcom Co., Ltd., Capcom Entertainment, Inc.' WHERE gamename = 'Megaman V' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Megaman VI' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1989', publisher = 'Hudson Soft Company, Ltd., Namco Limited' WHERE gamename = 'Mendel Palace' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Konami Corporation, Ultra Software Corporation' WHERE gamename = 'Metal Gear' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Metal Mech - Man & Machine' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Irem America Corp.' WHERE gamename = 'Metal Storm' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Metroid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1990', publisher = 'American Sammy Corporation' WHERE gamename = 'Michael Andretti\'s World Grand Prix' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Capcom U.S.A., Inc., Hudson Soft Company, Ltd.' WHERE gamename = 'Mickey Mousecapade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1994', publisher = 'Hi Tech Expressions' WHERE gamename = 'Mickey\'s Adventures in Numberland' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1993', publisher = 'Hi Tech Expressions' WHERE gamename = 'Mickey\'s Safari in Letterland' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1992', publisher = '' WHERE gamename = 'Might and Magic' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Tecmo, Inc.' WHERE gamename = 'Mighty Bomb Jack' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Capcom Co., Ltd., Capcom U.S.A., Inc.' WHERE gamename = 'Mighty Final Fight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Mike Tyson\'s Punch-Out!!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'HAL Laboratory, Inc' WHERE gamename = 'Millipede' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1986', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Milon\'s Secret Castle' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1990', publisher = 'Software Toolworks, Inc., The' WHERE gamename = 'Miracle Piano Teaching System, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Ultra Games' WHERE gamename = 'Mission - Impossible' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'Parker Brothers' WHERE gamename = 'Monopoly' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Konami of America, Inc.' WHERE gamename = 'Monster In My Pocket' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Bandai America, Inc.' WHERE gamename = 'Monster Party' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'INTV Corporation' WHERE gamename = 'Monster Truck Rally' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1992', publisher = 'Matchbox' WHERE gamename = 'Motor City Patrol' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'SunSoft' WHERE gamename = 'Mr. Gimmick' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Namco Hometek Inc., Tengen' WHERE gamename = 'Ms. Pac-Man' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'American Softworks Corporation' WHERE gamename = 'Mutant Virus, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Taxan' WHERE gamename = 'Mystery Quest' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'NARC' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'NES Open Tournament Golf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'NES Play Action Football' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'HAL Laboratory, Inc' WHERE gamename = 'New Ghostbusters II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'LJN Ltd.' WHERE gamename = 'NFL Football' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1993', publisher = 'GameTek' WHERE gamename = 'Nigel Mansell\'s World Championship Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'LJN Ltd.' WHERE gamename = 'Nightmare on Elm Street, A' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1992', publisher = 'Ultra Games' WHERE gamename = 'Nightshade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'American Sammy Corporation' WHERE gamename = 'Ninja Crusaders' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Tecmo, Inc.' WHERE gamename = 'Ninja Gaiden' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Tecmo, Inc.' WHERE gamename = 'Ninja Gaiden II - The Dark Sword of Chaos' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Tecmo, Inc.' WHERE gamename = 'Ninja Gaiden III - The Ancient Ship of Doom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1986', publisher = 'Bandai America, Inc.' WHERE gamename = 'Ninja Kid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, Racing/Driving, Strategy', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Nintendo World Championships 1990' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Nintendo World Cup' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = '' WHERE gamename = 'Noah\'s Ark' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Simulation, Strategy', year = '1989', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Nobunaga\'s Ambition' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Nobunaga\'s Ambition 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1990', publisher = 'Kemco/Seika' WHERE gamename = 'North & South' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Taito America Corp.' WHERE gamename = 'Operation Wolf' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1990', publisher = 'Hi Tech Expressions' WHERE gamename = 'Orb 3D' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1988', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Othello' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = '' WHERE gamename = 'Over Horizon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Overlord' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1989', publisher = 'SNK Playmore USA Corp.' WHERE gamename = 'P.O.W. - Prisoners of War' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Namco Hometek, Inc.' WHERE gamename = 'Pac-Man (Namco)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Tengen' WHERE gamename = 'Pac-Man (Tengen)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'HOT-B USA Inc.' WHERE gamename = 'Palamedes' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Panic Restaurant' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Mindscape, Inc.' WHERE gamename = 'Paperboy' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Mindscape Entertainment' WHERE gamename = 'Paperboy 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean Software Ltd.' WHERE gamename = 'Parasol Stars - The Story of Bubble Bobble 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Konami Co., Ltd., Konami Corporation' WHERE gamename = 'Parodius' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = '' WHERE gamename = 'Perfect Fit' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'Peter Pan & The Pirates' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'FCI, Inc.' WHERE gamename = 'Phantom Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = '' WHERE gamename = 'Pictionary' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Pin Bot' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Pinball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1990', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Pinball Quest' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1990', publisher = 'Bullet-Proof Software' WHERE gamename = 'Pipe Dream' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'Ultra Games' WHERE gamename = 'Pirates!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SunSoft' WHERE gamename = 'Platoon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1983', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Popeye' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Taito Corporation' WHERE gamename = 'Power Blade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Taito America Corp.' WHERE gamename = 'Power Blade 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'American Softworks Corporation' WHERE gamename = 'Power Punch 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Activision, Inc.' WHERE gamename = 'Predator' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Prince of Persia' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1988', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Princess Tomato in Salad Kingdom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Pro Sport Hockey' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1986', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Pro Wrestling' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Punch-Out!!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'LJN, Ltd.' WHERE gamename = 'Punisher, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Electro Brain Corp.' WHERE gamename = 'Puss \'n Boots - Pero\'s Great Adventure' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Puzznic' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Ultra Games' WHERE gamename = 'Q-bert' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Qix' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Tengen' WHERE gamename = 'R.B.I. Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1988', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'R.C. Pro-Am' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1992', publisher = 'Rare, Ltd.' WHERE gamename = 'R.C. Pro-Am 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Race America' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Racket Attack' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1987', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Rad Racer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1990', publisher = 'Square Soft, Inc.' WHERE gamename = 'Rad Racer 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Brøderbund Software, Inc.' WHERE gamename = 'Raid on Bungeling Bay' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'Rainbow Islands - The Story of Bubble Bobble 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1990', publisher = 'Romstar Incorporated' WHERE gamename = 'Rally Bike' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1988', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Rambo' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Data East USA, Inc.' WHERE gamename = 'Rampage' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1991', publisher = 'Jaleco USA, Inc., Konami Co., Ltd.' WHERE gamename = 'Rampart' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Hi-Tech Expressions, Inc.' WHERE gamename = 'Remote Control' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Ren & Stimpy Show, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Taito Corporation' WHERE gamename = 'Renegade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Rescue - The Embassy Mission' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Data East Corporation' WHERE gamename = 'Ring King' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'American Technos Inc.' WHERE gamename = 'River City Ransom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing/Driving', year = '1985', publisher = 'Konami Industry Co. Ltd.' WHERE gamename = 'Road Fighter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1990', publisher = 'Mindscape, Inc.' WHERE gamename = 'RoadBlasters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'Virgin Games, Inc.' WHERE gamename = 'Robin Hood - Prince of Thieves' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Hudson Soft Company, Ltd., Jaleco Entertainment, Inc.' WHERE gamename = 'Robo Warrior' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Data East Corporation' WHERE gamename = 'RoboCop' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Data East Corporation' WHERE gamename = 'RoboCop 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Ocean of America, Inc.' WHERE gamename = 'RoboCop 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'NTVIC' WHERE gamename = 'Rock \'n\' Ball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Kemco/Seika' WHERE gamename = 'Rocket Ranger' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Bandai America, Inc.' WHERE gamename = 'Rocketeer, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Atlus Software, Inc.' WHERE gamename = 'Rockin\' Kats' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Jaleco Ltd.' WHERE gamename = 'Rod Land' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'LJN Ltd.' WHERE gamename = 'Roger Clemens\' MVP Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1988', publisher = 'HAL America Inc., HAL Laboratory, Inc' WHERE gamename = 'Rollerball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1993', publisher = 'Hi Tech Expressions' WHERE gamename = 'Rollerblade Racer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Ultra Games' WHERE gamename = 'Rollergames' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1988', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Romance of The Three Kingdoms' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1991', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Romance of The Three Kingdoms II' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Roundball - 2-on-2 Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Konami Corporation' WHERE gamename = 'Rush\'n Attack' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Tecmo, Inc.' WHERE gamename = 'Rygar' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1991', publisher = 'Infogrames, Natsume, Inc.' WHERE gamename = 'S.C.A.T. - Special Cybernetic Attack Team' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1987', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Section Z' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'FCI, Inc.' WHERE gamename = 'Seicross' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1988', publisher = 'Hi Tech Expressions' WHERE gamename = 'Sesame Street 123' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1991', publisher = 'Hi Tech Expressions' WHERE gamename = 'Sesame Street 123 - ABC' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1989', publisher = 'Hi Tech Expressions' WHERE gamename = 'Sesame Street ABC' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Edutainment', year = '1992', publisher = 'Hi Tech Expressions' WHERE gamename = 'Sesame Street Countdown' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Natsume, Inc., Taito Corporation' WHERE gamename = 'Shadow of the Ninja' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1989', publisher = 'Kemco/Seika' WHERE gamename = 'Shadowgate' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Jaleco Entertainment, Inc.' WHERE gamename = 'Shatterhand' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG, Strategy', year = '1990', publisher = 'HOT-B USA, Inc.' WHERE gamename = 'Shingen The Ruler' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1989', publisher = 'Bandai America, Inc.' WHERE gamename = 'Shooting Range' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1989', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Short Order - Eggsplode' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation, Sports', year = '1987', publisher = 'Data East USA, Inc.' WHERE gamename = 'Side Pocket' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1989', publisher = 'Ultra Games' WHERE gamename = 'Silent Service' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'American Sammy Corporation' WHERE gamename = 'Silkworm' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Arcadia Systems, Inc.' WHERE gamename = 'Silver Surfer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Acclaim Entertainment, Inc., Acclaim Entertainment Ltd.' WHERE gamename = 'Simpsons, The - Bart Vs. the Space Mutants' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation, Sports, Strategy', year = '1991', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Simpsons, The - Bart Vs. the World' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Simpsons, The - Bartman Meets Radioactive Man' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1990', publisher = 'Electronic Arts, Inc.' WHERE gamename = 'Skate or Die 2 - The Search for Double Trouble' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Palcom Software Ltd., Ultra Games' WHERE gamename = 'Skate or Die!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Ultra Games' WHERE gamename = 'Ski or Die' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Namco Limited, SunSoft' WHERE gamename = 'Sky Kid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Taito America Corp.' WHERE gamename = 'Sky Shark' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1987', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Slalom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Smash T.V.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1995', publisher = 'Infogrames' WHERE gamename = 'Smurfs, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Nintendo Co., Ltd.' WHERE gamename = 'Snake Rattle N Roll' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Ultra Games' WHERE gamename = 'Snake\'s Revenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Kotobuki System Co., Ltd.' WHERE gamename = 'Snoopy\'s Silly Sports Spectacular' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Capcom USA, Inc.' WHERE gamename = 'Snow Bros.' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1985', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Soccer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Tradewest, Inc.' WHERE gamename = 'Solar Jetman - Hunt for the Golden Warpship' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1987', publisher = 'Tecmo, Inc.' WHERE gamename = 'Solomon\'s Key' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'CSG Imagesoft Inc.' WHERE gamename = 'Solstice' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'CBS/Sony Group Inc., CSG Imagesoft Inc., Nintendo of Europe GmbH' WHERE gamename = 'Solstice - The Quest for the Staff of Demnos' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1991', publisher = 'Absolute Entertainment Inc.' WHERE gamename = 'Space Shuttle Project' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Brøderbund Software, Inc.' WHERE gamename = 'Spelunker' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'LJN Ltd.' WHERE gamename = 'Spider-Man - Return of the Sinister Six' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1990', publisher = 'Arcadia Systems, Inc., Bullet-Proof Software, Inc.' WHERE gamename = 'Spot' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1987', publisher = 'SunSoft' WHERE gamename = 'Spy Hunter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Strategy', year = '1986', publisher = 'Kemco, Kotobuki System Co., Ltd.' WHERE gamename = 'Spy Vs Spy' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1987', publisher = 'Irem America Corp.' WHERE gamename = 'Sqoon' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Puzzle', year = '1985', publisher = '' WHERE gamename = 'Stack Up (Robot Block)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Bandai America, Inc.' WHERE gamename = 'Stadium Events' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Electro-Brain' WHERE gamename = 'Stanley - The Search for Dr. Livingston' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Tecmo, Inc.' WHERE gamename = 'Star Force' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Hudson Soft Company, Ltd., Taxan USA Corp.' WHERE gamename = 'Star Soldier' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Ultra Games' WHERE gamename = 'Star Trek - 25th Anniversary' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1993', publisher = 'Absolute Entertainment, Inc.' WHERE gamename = 'Star Trek - The Next Generation' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1987', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Star Voyager' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Star Wars' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'JVC Musical Industries, Inc.' WHERE gamename = 'Star Wars - The Empire Strikes Back' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Hudson Soft USA, Inc.' WHERE gamename = 'Starship Hector' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Startropics' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1994', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Startropics II - Zoda\'s Revenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1989', publisher = 'Activision, Inc.' WHERE gamename = 'Stealth ATF' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1986', publisher = 'Konami Industry Co. Ltd., Konami Corporation' WHERE gamename = 'Stinger' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Bandai America, Inc.' WHERE gamename = 'Street Cop' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Street Fighter 2010 - The Final Fight' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, RPG', year = '1989', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Strider' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Konami, Inc.' WHERE gamename = 'Super C' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1991', publisher = 'Electro Brain Corp.' WHERE gamename = 'Super Cars' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1989', publisher = 'CSG Imagesoft Inc.' WHERE gamename = 'Super Dodge Ball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Mattel Electronics' WHERE gamename = 'Super Glove Ball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1991', publisher = 'GameTek' WHERE gamename = 'Super Jeopardy!' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Misc.', year = '1988', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Super Mario Bros. + Duck Hunt' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Misc.', year = '1988', publisher = 'Nintendo of America Inc.' WHERE gamename = 'Super Mario Bros. + Duck Hunt + World Class Track Meet' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1988', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Super Mario Bros. 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Super Mario Bros. 3' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Activision, Inc.' WHERE gamename = 'Super Pitfall' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Spike V\'Ball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Spike V\'Ball + Nintendo World Cup' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Sunsoft' WHERE gamename = 'Super Spy Hunter' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Super Team Games' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = '' WHERE gamename = 'Super Turrican' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'KEMCO U.S.A., Inc.' WHERE gamename = 'Superman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'THQ, Inc.' WHERE gamename = 'Swamp Thing' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Activision, Inc.' WHERE gamename = 'Sword Master' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Swords and Serpents' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'LJN Ltd.' WHERE gamename = 'T&C 2 - Thrilla\'s Surfari' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = '' WHERE gamename = 'T&C Surf Design' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1989', publisher = 'Tradewest, Inc.' WHERE gamename = 'Taboo - The Sixth Sense' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = 'Data East USA, Inc.' WHERE gamename = 'Tag Team Wrestling' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = '' WHERE gamename = 'TaleSpin' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Taito America Corp.' WHERE gamename = 'Target - Renegade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Tecmo, Ltd.' WHERE gamename = 'Tecmo Baseball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1989', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Bowl' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Cup - Soccer Game' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo NBA Basketball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo Super Bowl' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Tecmo, Inc.' WHERE gamename = 'Tecmo World Wrestling' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Konami Industry Co. Ltd., Ultra Software Corporation' WHERE gamename = 'Teenage Mutant Ninja Turtles' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami Corporation' WHERE gamename = 'Teenage Mutant Ninja Turtles - Tournament Fighters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Ultra Games' WHERE gamename = 'Teenage Mutant Ninja Turtles II - The Arcade Game' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Konami Corporation, Konami of America, Inc.' WHERE gamename = 'Teenage Mutant Ninja Turtles III - The Manhattan Project' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Tennis' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1991', publisher = 'LJN, Ltd.' WHERE gamename = 'Terminator 2 - Judgment Day' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1992', publisher = 'Mindscape Inc.' WHERE gamename = 'Terminator, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Vic Tokai Inc.' WHERE gamename = 'Terra Cresta' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1988', publisher = 'Nintendo of America Inc., Tengen' WHERE gamename = 'Tetris' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1993', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'Tetris 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Activision, Inc.' WHERE gamename = 'Three Stooges' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Romstar Incorporated' WHERE gamename = 'Thunder & Lightning' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1990', publisher = 'Activision, Inc.' WHERE gamename = 'Thunderbirds' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1989', publisher = 'American Sammy Corporation' WHERE gamename = 'Thundercade' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Tiger-Heli' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Milton Bradley Company' WHERE gamename = 'Time Lord' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure, RPG', year = '1990', publisher = 'Toho Company Ltd.' WHERE gamename = 'Times of Lore' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Konami Corporation' WHERE gamename = 'Tiny Toon Adventures' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'Tiny Toon Adventures 2 - Trouble in Wackyland' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Unique', year = '1992', publisher = 'Konami of America, Inc.' WHERE gamename = 'Tiny Toon Adventures Cartoon Workshop' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Nintendo of America Inc.' WHERE gamename = 'To The Earth' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Taito America Corp.' WHERE gamename = 'Toki' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Hi Tech Expressions' WHERE gamename = 'Tom & Jerry (and Tuffy)' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1991', publisher = 'Infocom, Inc.' WHERE gamename = 'Tombs & Treasure' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1987', publisher = 'Konami Corporation' WHERE gamename = 'Top Gun' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Simulation', year = '1990', publisher = 'Konami Corporation' WHERE gamename = 'Top Gun - The Second Mission' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Asmik Corporation of America' WHERE gamename = 'Top Players\' Tennis - Featuring Chris Evert & Ivan Lendl' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Total Recall' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1990', publisher = 'Jaleco Ltd.' WHERE gamename = 'Totally Rad' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'K. Amusement Leasing Co., SNK Corporation' WHERE gamename = 'Touch Down Fever' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1992', publisher = 'Bandai America, Inc.' WHERE gamename = 'Toxic Crusaders' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1987', publisher = 'Konami of America, Inc.' WHERE gamename = 'Track & Field' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Konami Industry Co. Ltd.' WHERE gamename = 'Track & Field 2' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'American Softworks Corporation' WHERE gamename = 'Treasure Master' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Trog' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1987', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Trojan' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = '' WHERE gamename = 'Trolls in Crazyland, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1990', publisher = '' WHERE gamename = 'Turbo Racing' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'American Sammy Corporation' WHERE gamename = 'Twin Cobra' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1989', publisher = '' WHERE gamename = 'Twin Eagle - Revenge Joe\'s Brother' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'SunSoft' WHERE gamename = 'U-four-ia - The Saga' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1989', publisher = 'FCI, Inc.' WHERE gamename = 'Ultima - Exodus' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1991', publisher = 'FCI, Inc.' WHERE gamename = 'Ultima - Quest of the Avatar' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'RPG', year = '1993', publisher = 'FCI, Inc.' WHERE gamename = 'Ultima - Warriors of Destiny' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulator', year = '1992', publisher = '' WHERE gamename = 'Ultimate Air Combat' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = '' WHERE gamename = 'Ultimate Basketball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1992', publisher = 'American Video Entertainment, Inc.' WHERE gamename = 'Ultimate League Soccer' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1989', publisher = 'LJN Toys, Ltd.' WHERE gamename = 'Uncanny X-Men, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG, Strategy', year = '1991', publisher = 'KOEI Co., Ltd.' WHERE gamename = 'Uncharted Waters' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1991', publisher = 'Kemco/Seika' WHERE gamename = 'Uninvited' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Ocean of America, Inc.' WHERE gamename = 'Untouchables, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Urban Champion' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1990', publisher = 'HAL America, Inc.' WHERE gamename = 'Vegas Dream' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Racing/Driving', year = '1991', publisher = 'American Sammy Corporation' WHERE gamename = 'Vice - Project Doom' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Unique', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Videomation' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1986', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Volleyball' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Racing', year = '1992', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Wacky Races' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Simulation', year = '1990', publisher = 'SOFEL Co., Ltd.' WHERE gamename = 'Wall Street Kid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1994', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Wario\'s Woods' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Wayne Gretzky Hockey' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1993', publisher = 'THQ, Inc.' WHERE gamename = 'Wayne\'s World' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1990', publisher = 'FCI, Inc.' WHERE gamename = 'WCW World Championship Wrestling' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Data East Corporation' WHERE gamename = 'Werewolf - The Last Warrior' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1988', publisher = 'GameTek, Inc.' WHERE gamename = 'Wheel of Fortune' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1992', publisher = 'GameTek' WHERE gamename = 'Wheel of Fortune - Starring Vanna White' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'GameTek' WHERE gamename = 'Wheel of Fortune Family Edition' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1989', publisher = 'GameTek' WHERE gamename = 'Wheel of Fortune Junior Edition' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, Educational', year = '1991', publisher = 'Konami Corporation' WHERE gamename = 'Where in Time is Carmen Sandiego' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1991', publisher = 'THQ, Inc.' WHERE gamename = 'Where\'s Waldo' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure', year = '1989', publisher = 'LJN Ltd.' WHERE gamename = 'Who Framed Roger Rabbit' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Whomp\'Em' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Atlus U.S.A., Inc.' WHERE gamename = 'Widget' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1984', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Wild Gunman' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1989', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Willow' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Game Simulator', year = '1990', publisher = 'Hi Tech Expressions' WHERE gamename = 'Win, Lose or Draw' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action, Sports', year = '1987', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Winter Games' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1987', publisher = 'ASCII Corporation, NEXOFT Corporation' WHERE gamename = 'Wizardry - Proving Grounds of the Mad Overlord' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1990', publisher = 'ASCII Corporation, ASCII Entertainment Software, Inc.' WHERE gamename = 'Wizardry - The Knight of Diamonds' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Adventure, RPG', year = '1987', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Wizards & Warriors' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'Wizards & Warriors III - Kuros - Visions of Power' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'LJN Ltd.' WHERE gamename = 'Wolverine' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'Romstar Incorporated' WHERE gamename = 'World Champ' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Nintendo of America, Inc.' WHERE gamename = 'World Class Track Meet' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1989', publisher = 'Milton Bradley Company' WHERE gamename = 'World Games' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Taito America Corp.' WHERE gamename = 'Wrath of the Black Manta' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1985', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Wrecking Crew' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1991', publisher = 'Asmik Corporation of America' WHERE gamename = 'WURM - Journey to the Center of the Earth' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1993', publisher = 'LJN Ltd.' WHERE gamename = 'WWF King of the Ring' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1988', publisher = 'Acclaim Entertainment, Inc.' WHERE gamename = 'WWF WrestleMania' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Fighting', year = '1992', publisher = 'LJN Ltd.' WHERE gamename = 'WWF WrestleMania - Steel Cage Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Sports', year = '1990', publisher = 'LJN, Ltd.' WHERE gamename = 'WWF WrestleMania Challenge' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'SunSoft' WHERE gamename = 'Xenophobe' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1988', publisher = 'Bandai America, Inc.' WHERE gamename = 'Xevious' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1989', publisher = 'Hudson Soft Company, Ltd.' WHERE gamename = 'Xexyz' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Capcom Co., Ltd.' WHERE gamename = 'Yo! Noid' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1991', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Yoshi' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Strategy', year = '1992', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc., Nintendo of Europe GmbH' WHERE gamename = 'Yoshi\'s Cookie' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1992', publisher = 'Jaleco USA, Inc.' WHERE gamename = 'Young Indiana Jones Chronicles, The' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Shooter', year = '1987', publisher = 'FCI, Inc.' WHERE gamename = 'Zanac' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1987', publisher = 'Nintendo Co., Ltd., Nintendo of America Inc.' WHERE gamename = 'Zelda II - The Adventure of Link' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action/Adventure', year = '1993', publisher = 'Konami of America, Inc.' WHERE gamename = 'Zen Intergalactic Ninja' AND gametype = 'NES';
UPDATE gamemetadata SET genre = 'Action', year = '1990', publisher = 'Meldac of America Inc.' WHERE gamename = 'Zombie Nation' AND gametype = 'NES';