Difference between revisions of "Arch Rivals"

From Sega Retro

m (Text replacement - "\| (.*)_source={{num\|([0-9])\/9([0-9])\|page=([0-9]+)\|pdf=(.*)\.pdf}}" to "| $1_source={{magref|$1|199$3-0$2|$4}}")
m (Text replacement - "\| (.*)_source={{num\|([0-9])\/9([0-9])\|page=([0-9]+)\|pdf=(.*)\.pdf\|pdfpage=([0-9]+)}}" to "| $1_source={{magref|$1|199$3-0$2|$6|printpage=$4}}")
Line 121: Line 121:
 
| sfuk_source={{magref|sfuk|6|30|printpage=30-31}}
 
| sfuk_source={{magref|sfuk|6|30|printpage=30-31}}
 
| videogames=65
 
| videogames=65
−
| videogames_source={{num|2/93|page=97|pdf=VideoGames DE 1993-02.pdf|pdfpage=95}}
+
| videogames_source={{magref|videogames|1993-02|95|printpage=97}}
 
}}
 
}}
 
{{Scanbox
 
{{Scanbox

Revision as of 16:37, 3 June 2019

n/a

<div class="bobtransform" style="transform:scale(1,Expression error: Unexpected < operator.); transform-origin:0% 0%; !important;"> <div style="width:320px; height:Expression error: Unexpected < operator.px;"> 320px

Arch Rivals
System(s): Sega Mega Drive, Sega Game Gear
Publisher: Flying Edge
Developer:
Genre: Sports

















Number of players: 1-2
Release Date RRP Code
Sega Mega Drive
US 		$49.9549.95[2] T-81056
Sega Mega Drive
EU 		T-81056-50
Sega Mega Drive
AU
Sega Game Gear
US 		$39.95
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="vgce" and `cargo__issuenames`.`num`="50" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2133.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

39.95
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="vgce" and `cargo__issuenames`.`num`="50" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2133.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[5] 		T-81118

This short article is in need of work. You can help Sega Retro by adding to it.

Arch Rivals, labeled as Arch Rivals: The Arcade Game on the packaging, is an arcade basketball game which was ported to the Sega Mega Drive and Sega Game Gear.

Gameplay

Arch Rivals marks the beginning of Midway Games' line of arcade basketball games, and is a predecessor to its most successful entry, NBA Jam. Arch Rivals features fast-paced 2-on-2 player matches and omits many of the rules of the game, such as fouls. Also unlike other basketball games, it is possible to punch opponents in the face.

History

Development

A Sega Master System version, reportedly identical to the Game Gear port, was once set to be released at the same time as the Mega Drive version[6] in June 1992[3], but was scrapped at the last minute. Some publications received review copies, however.

Production credits

Mega Drive version

  • Music composer (uncredited): Dan Forden
  • Music arranger (uncredited): Mark Cooksey


Game Gear version

Arch Rivals® ©1992 Acclaim Entertainment Inc
Arch Rivals® © 1989 1992 All Rights Reserved
Licensed from and Trademark of Midway Manufacturing Company
  • Programmed by: Byron Nilsson
  • Graphics by: Gary Tonge
  • Programming Support: Julian Scott
Source:
In-game credits (intro demo)


  • Music composer (uncredited): Dan Forden
  • Music arranger (uncredited): Mark Cooksey

Magazine articles

Main article: Arch Rivals/Magazine articles.

Promotional material

Logo-pdf.svg
Mega Drive print advert in Sega Visions (US) #8: "May/June 1992" (1992-xx-xx)
also published in:
  • Electronic Gaming Monthly (US) #36: "July 1992" (1992-xx-xx)
    A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

    Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="egm" and `cargo__issuenames`.`num`="36" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2145.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

    [7]
  • GamePro (US) #36: "July 1992" (1992-xx-xx)
    A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

    Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="36" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-214c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

    [8]
  • GamePro (US) #37: "August 1992" (1992-xx-xx)
    A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

    Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="37" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2153.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

    [9]
  • Sega Visions (US) #9: "August/September 1992" (1992-xx-xx)
    A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

    Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="sv" and `cargo__issuenames`.`num`="9" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-215a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

    [10]
Logo-pdf.svg
Logo-pdf.svg
Print advert in Mega Force (ES) #7: "Noviembre 1992" (1992-xx-xx)
also published in:
  • Hobby Consolas (ES) #14: "Noviembre 1992" (1992-xx-xx)
    A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

    Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="hobbyconsolas" and `cargo__issuenames`.`num`="14" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2165.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

    [11]
Logo-pdf.svg

Physical scans

Mega Drive version

Sega Retro Average 
Publication Score Source
40 [12]
75
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="37" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-216d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[13]
39 №10, p38-39
87
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="hobbyconsolas" and `cargo__issuenames`.`num`="14" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2171.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[14]
83
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="joypad" and `cargo__issuenames`.`num`="11" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2175.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[15]
70
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="joystick" and `cargo__issuenames`.`num`="30" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2179.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[16]
69 №5, p90
45 №7, p42-43
40
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mm" and `cargo__issuenames`.`num`="22" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-217d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[17]
50
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="playerone" and `cargo__issuenames`.`num`="24" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2181.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[18]
60 №32, p31
80
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="segapro" and `cargo__issuenames`.`num`="7" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2185.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[19]
76 №18, p64
84
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="sfsw" and `cargo__issuenames`.`num`="1993-01" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2189.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[20]
86
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="sfuk" and `cargo__issuenames`.`num`="6" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-218d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[21]
65
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="videogames" and `cargo__issuenames`.`num`="1993-02" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2191.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[22]
Sega Mega Drive
 66
Based on
16 reviews
Sega Retro Average 
Publication Version Score
1700 igr dlya Sega (RU)
50
[23]
Cool Gamer (RU)
40
[24]
Entsiklopediya igr Sega. 100000 sekrety, kody, paroli (RU)
70
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="eis05" and `cargo__issuenames`.`num`="1" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21af.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[25]
Entsiklopediya luchshikh igr Sega. Vypusk 1 (RU)
30
[26]
Mean Machines: The Essential Sega Guide (UK)
40
[12]
GamePro (US) NTSC-U
75
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="37" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21bc.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[27]
Gamer (GR)
53
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamergr" and `cargo__issuenames`.`num`="2" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21c1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[28]
Game Zone (UK)
39
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gz" and `cargo__issuenames`.`num`="10" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21c6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[29]
Hobby Consolas (ES)
87
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="hobbyconsolas" and `cargo__issuenames`.`num`="13" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21cb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[30]
Joypad (FR)
83
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="joypad" and `cargo__issuenames`.`num`="11" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21d0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[31]
Joystick (FR) NTSC-U
70
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="joystick" and `cargo__issuenames`.`num`="30" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21d5.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[16]
Sega Mega Drive Advanced Gaming (UK) PAL
69
[32]
Mega Force (FR)
75
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="megaforce" and `cargo__issuenames`.`num`="10" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21de.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[33]
MegaTech (UK) PAL
45
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="megatech" and `cargo__issuenames`.`num`="7" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21e3.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[34]
Mean Machines (UK) PAL
40
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="mm" and `cargo__issuenames`.`num`="22" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21e8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[35]
Mean Machines Sega (UK)
40
[36]
OK Consolas (ES)
81
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="okconsolas" and `cargo__issuenames`.`num`="13" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21f1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[37]
Player One (FR)
50
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="playerone" and `cargo__issuenames`.`num`="24" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21f6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[38]
Play Time (DE)
52
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="playtime" and `cargo__issuenames`.`num`="1992-0809" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-21fb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[39]
Power Up! (UK)
64
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="powerup" and `cargo__issuenames`.`num`="1992-11-21" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2200.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[40]
Power Play (DE)
64
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="pp" and `cargo__issuenames`.`num`="1993-03" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2205.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[41]
Sega Power (UK) PAL
60
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="segapower" and `cargo__issuenames`.`num`="32" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-220a.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[42]
Sega Pro (UK) PAL
80
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="segapro" and `cargo__issuenames`.`num`="7" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-220f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[43]
Sega Pro (UK) PAL
76
[44]
Sega Force (SE)
84
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="sfsw" and `cargo__issuenames`.`num`="1993-01" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2218.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[45]
Sega Force (UK) PAL
86
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="sfuk" and `cargo__issuenames`.`num`="6" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-221d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[46]
Supergame (BR) NTSC-U
75
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="supergame" and `cargo__issuenames`.`num`="13" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2222.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[47]
Tricks 16 bit (RU)
57
[48]
VideoGames & Computer Entertainment (US) NTSC-U
50
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="vgce" and `cargo__issuenames`.`num`="43" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-222b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[49]
Video Games (DE) PAL
65
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="videogames" and `cargo__issuenames`.`num`="1993-02" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2230.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[50]
Sega Mega Drive
 62
Based on
30 reviews

Arch Rivals

Mega Drive, US
ArchRivals MD US Box.jpg
Cover
ArchRivals MD US Cart.jpg
Cart
Arch Rivals MD US Manual.pdf
Manual
Mega Drive, EU
ArchRivals MD EU Box.jpg
Cover
ArchRivals MD EU Cart.jpg
Cart

Game Gear version

Sega Retro Average 
Publication Score Source
75
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="44" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2234.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[51]
Sega Game Gear
 75
Based on
1 review
Sega Retro Average 
Publication Version Score
Electronic Gaming Monthly (US) NTSC-U
60
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="egm" and `cargo__issuenames`.`num`="44" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-223b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[52]
GamePro (US) NTSC-U
73
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="gamepro" and `cargo__issuenames`.`num`="44" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2240.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[53]
Sega Game Gear
 66
Based on
2 reviews

Arch Rivals

Game Gear, US
ArchRivals GG US Box Back.jpgNospine.pngArchRivals GG US Box Front.jpg
Cover
ArchRivals GG US Cart.jpg
Cart
Arch Rivals GG US Manual.pdf
Manual

Master System version

Sega Retro Average 
Publication Score Source
83
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="segapro" and `cargo__issuenames`.`num`="7" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2244.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[54]
Sega Master System
 83
Based on
1 review
Sega Retro Average 
Publication Version Score
Mega Force (FR) PAL
60
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="megaforce" and `cargo__issuenames`.`num`="10" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2250.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[56]
Sega Pro (UK) PAL
83
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__issuenames`.`name` AS `issuename`,`cargo__issuenames`.`date` AS `date`,`cargo__issuenames`.`pdf` AS `pdf`,`cargo__magnames`.`name` AS `magname`,`cargo__magnames`.`country` AS `country` FROM `cargo__issuenames` LEFT OUTER JOIN `cargo__magnames` ON ((`cargo__issuenames`.`code`=`cargo__magnames`.`code`)) WHERE `cargo__issuenames`.`code`="segapro" and `cargo__issuenames`.`num`="7" ORDER BY `cargo__issuenames`.`name`,`cargo__issuenames`.`date`,`cargo__issuenames`.`pdf`,`cargo__magnames`.`name`,`cargo__magnames`.`country` LIMIT 1 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2255.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

[57]
Sega Pro (UK) PAL
83
[58]
Sega Master System
 75
Based on
3 reviews

Arch Rivals


Technical information

ROM dump status

System Hash Size Build Date Source Comments
Sega Mega Drive
✔
CRC32 e389d7e7
MD5 d97ddf989c558f01a1da1f23e728f935
SHA-1 2bfbe4698f13ade720dbfe10cebf02fe51e5e6ef
512kB 1992-03 Cartridge (US/EU)
Sega Game Gear
 ?
CRC32 f0204191
MD5 6ae0a492cc0427d4097a7b4336caedd2
SHA-1 9a2260a9cb9564a18f50edc8149a9e1e517bf649
256kB Cartridge (US)

References

  1. ↑ Press release: 1992-05-19: ACCLAIM BEGINS SHIPMENT OF SEGA SOFTWARE
  2. ↑ File:GamePro US 037.pdf, page 42
  3. ↑ 3.0 3.1 File:SegaForce UK 06.pdf, page 31
  4. ↑ File:SegaVisions US 10.pdf, page 93
  5. ↑ ', "" (; ), page 47
  6. ↑ File:SegaForce UK 05.pdf, page 7
  7. ↑ ', "May/June 1992" (; 1992-xx-xx), page 91
  8. ↑ ', "May/June 1992" (; 1992-xx-xx), page 69
  9. ↑ ', "May/June 1992" (; 1992-xx-xx), page 17
  10. ↑ ', "May/June 1992" (; 1992-xx-xx), page 21
  11. ↑ ', "Noviembre 1992" (; 1992-xx-xx), page 10
  12. ↑ 12.0 12.1 Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 21
  13. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 40 (42)
  14. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 126-127 (118)
  15. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 98-99 (98)
  16. ↑ 16.0 16.1 Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 165
  17. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 68-69 (68)
  18. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 142 (138)
  19. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 58-60 (58)
  20. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 9
  21. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 30-31 (30)
  22. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 97 (95)
  23. ↑ 1700 igr dlya Sega, "" (RU; 2001-xx-xx), page 37
  24. ↑ Cool Gamer, "9" (RU; 2002-10-13), page 16
  25. ↑ Cool Gamer, "9" (RU; 2002-10-13), page 20
  26. ↑ Entsiklopediya luchshikh igr Sega. Vypusk 1, "" (RU; 1999-xx-xx), page 289
  27. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 42
  28. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 1
  29. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 38
  30. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 126
  31. ↑ Mean Machines: The Essential Sega Guide, "" (UK; 1993-11-18), page 98
  32. ↑ Sega Mega Drive Advanced Gaming, "January 1993" (UK; 199x-xx-xx), page 90
  33. ↑ Sega Mega Drive Advanced Gaming, "January 1993" (UK; 199x-xx-xx), page 78
  34. ↑ Sega Mega Drive Advanced Gaming, "January 1993" (UK; 199x-xx-xx), page 42
  35. ↑ Sega Mega Drive Advanced Gaming, "January 1993" (UK; 199x-xx-xx), page 68
  36. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 137
  37. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 34
  38. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 142
  39. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 90
  40. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 1
  41. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 109
  42. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 31
  43. ↑ Mean Machines Sega, "October 1992" (UK; 1992-09-xx), page 58
  44. ↑ Sega Pro, "April 1993" (UK; 1993-03-11), page 64
  45. ↑ Sega Pro, "April 1993" (UK; 1993-03-11), page 9
  46. ↑ Sega Pro, "April 1993" (UK; 1993-03-11), page 30
  47. ↑ Sega Pro, "April 1993" (UK; 1993-03-11), page 22
  48. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 14
  49. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 48
  50. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 97
  51. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 149 (163)
  52. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 32
  53. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 149
  54. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 58 (58-60)
  55. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 30 (30/31)
  56. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 78
  57. ↑ Tricks 16 bit, "Tricks Sega Gold 800 igr" (RU; 1998-03-20), page 58
  58. ↑ Sega Pro, "April 1993" (UK; 1993-03-11), page 70


Arch Rivals

<div class="bobtransform" style="transform:scale(1,Expression error: Unexpected < operator.); transform-origin:0% 0%; !important;"> <div style="width:120px; height:Expression error: Unexpected < operator.px;"> 120px

Main page | Comparisons | Magazine articles | Reception | Region coding | Technical information | Bootlegs


Books:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Arch Rivals" and `cargo__relationships`.`relationshiptype`="book" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-225f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Music:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Arch Rivals" and `cargo__relationships`.`relationshiptype`="music" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2262.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Audiobooks:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Arch Rivals" and `cargo__relationships`.`relationshiptype`="audiobook" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2265.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Videos:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__relationships`.`name` AS `name`,`cargo__releases`.`date` AS `date` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__releases` ON ((`cargo__relationships`.`name`=`cargo__releases`.`name`)) WHERE `cargo__relationships`.`relatedto`="Arch Rivals" and `cargo__relationships`.`relationshiptype`="video" GROUP BY `cargo__releases`.`name` ORDER BY `cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2268.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
Events:
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__relationships`.`name` AS `eventname`,`cargo__events`.`startdate` AS `startdate` FROM `cargo__relationships` LEFT OUTER JOIN `cargo__events` ON ((`cargo__relationships`.`name`=`cargo__events`.`name`)) WHERE `cargo__relationships`.`relatedto`="Arch Rivals" and `cargo__relationships`.`relationshiptype`="event" GROUP BY `cargo__events`.`name` ORDER BY `cargo__events`.`startdate` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-226b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)

</di
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__demos`.`name` AS `name`,`cargo__codeformat`.`code` AS `code`,`cargo__releases`.`date` AS `date` FROM `cargo__releases` LEFT OUTER JOIN `cargo__demos` ON ((`cargo__releases`.`name`=`cargo__demos`.`name`)) LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__demos`.`format`=`cargo__codeformat`.`format`)) WHERE `cargo__demos`.`game`="Arch Rivals" GROUP BY `cargo__demos`.`name` ORDER BY `cargo__demos`.`name`,`cargo__codeformat`.`code`,`cargo__releases`.`date` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-226f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)


A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__prototypes`.`name` AS `name`,`cargo__codeformat`.`code` AS `code` FROM `cargo__prototypes` LEFT OUTER JOIN `cargo__codeformat` ON ((`cargo__prototypes`.`format`=`cargo__codeformat`.`format`)) WHERE final="Arch Rivals" GROUP BY `cargo__prototypes`.`name` ORDER BY `cargo__prototypes`.`name`,`cargo__codeformat`.`code` LIMIT 100 Function: CargoSQLQuery::run Error: 1021 Disk full (/tmp/#sql-temptable-15e6a-cd58a0-2272.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") (localhost)



NBA Jam and related games for Sega systems
Arch Rivals (1992) | NBA Jam (1994) | NBA Jam Tournament Edition (1994) | College Slam (1996) | NBA Hang Time (1996) | NBA Jam Extreme (1996) | NBA Showtime: NBA on NBC (1999) | NBA Hoopz (2001)
Retrieved from "https://segaretro.org/index.php?title=Arch_Rivals&oldid=512540"