SELECT * FROM games WHERE permalink='gate-of-doom-us-revision-4' LIMIT 1





 GATE OF DOOM (US REVISION 4)