string(1570) "select s.*,sr.site_rating_total,ur.user_rating_total,(sr.site_rating_total + ur.user_rating_total) as rating_total,ca.Access_Level as submitter_level from game_submission s left join game_submission_rating r on s.Game_submission_ID = r.Game_submission_ID left join customer_roles cr on s.Submitter_ID = cr.Customer_ID left join customer_access ca on cr.Access_ID = ca.Access_ID join ( SELECT count(*) as site_rating_total from game_submission s left join customer_roles cr on s.Submitter_ID = cr.Customer_ID left join customer_access ca on cr.Access_ID = ca.Access_ID where s.Game_ID= 43027 and s.Approved = "Y" and (s.Country_ID = 223 or s.Country_ID = 0) and s.Submission_Type = "R" and ca.Access_Level like "Writer" ) AS sr join ( SELECT count(*) as user_rating_total from game_submission s left join customer_roles cr on s.Submitter_ID = cr.Customer_ID left join customer_access ca on cr.Access_ID = ca.Access_ID where s.Game_ID= 43027 and s.Approved = "Y" and (s.Country_ID = 223 or s.Country_ID = 0) and s.Submission_Type = "R" and ( ca.Access_Level not like "Writer" or ca.Access_Level is null ) ) AS ur where s.Game_ID= 43027 and s.Approved = "Y" and (s.Country_ID = 223 or s.Country_ID = 0) and s.Submission_Type = "R" group by s.Game_Submission_ID order by ca.Access_Level DESC " Crimson Gem Saga PSP Image 9 | Review Any Game


Crimson Gem Saga PSP

Release Date:

26 May 2009

Summary:

With beautiful, high-resolution 2-D artwork, novel battle mechanics, and a classic tale of fantasy, adventure, and heroism, Crimson Gem Saga delivers the pure, classic Japanese RPG play experience PSP owners have been clamoring for since the hardware's launch. Taking full advantage of the crisp, clear PSP screen and boasting a colorful, catchy musical score, Crimson Gem Saga is a blast from the past presented just as you'd expect a modern RPG to be.

  • Ambushes and chained critical hits add additional layers of complexity to what gamers will immediately find to be a solid, tried-and-true combat engine
  • Featuring artwork and a beautiful presentation designed to take full advantage of the PSP's high-resolution screen
  • Delivers the crisp character designs, sweeping background art, and stunning special effects gamers have come to expect from elite JRPGs
  • 30+ hours of gameplay
  • Stunning 2-D art design

People who liked this also liked...

by Konami
Release Date: 09/08/2006

Submitted by Cheat Title Rating

Discuss this game with other users on the Forum below.
Sign up or Login to post a thread.

Message Title Author Replies Last Updated
Rate this game:

By:

Atlus

Release Date:

05/26/2009

Review This Game

Find Us On