string(1567) "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= 2269 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= 2269 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= 2269 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 " Final Fantasy Tactics: The War of The Lions PSP Image 12 | Review Any Game


Final Fantasy Tactics: The War of The Lions PSP

Release Date:

09 October 2007

People who liked this also liked...

by Square Enix
Release Date: 07/24/2007

Description

From the creative minds behind Final Fantasy XII comes an epic combat adventure set in the hugely successful Final Fantasy universe. Imaginative artistic design sets a beautiful backdrop for a gritty, politically charged tale, in which two young men endeavour to reshape the course of history. When the Lions clash, the land of Ivalice trembles. Have you the strength to wrest a kingdom from the clutches of war or will this dark act of Ivalice's history be her last?

  • Final Fantasy turns tactical
  • Strategic, turn-based combat on 3D battlefields with breathtaking art and stunning visual effects
  • Customize your characters - with 22 jobs and over 400 abilities to choose from
  • Uncover secret truths hidden within a gripping tale of intrigue, betrayal, heresy, love and heroism
  • Recruit legendary Final Fantasy characters to your party, including Balthier and Cloud
  • Watch key scenes unfold through gorgeous, cutting-edge animation
  • Captivating audio score from the composer of Final Fantasy XII
  • Fight against your friends in wireless melee, or team up with them for co-op missions
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:

Square Enix

Release Date:

10/09/2007

Review This Game

Find Us On