string(1564) "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= 369 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= 369 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= 369 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 " Phoenix Wright Ace Attorney: Trials and Tribulations DS Image 3 | Review Any Game


Phoenix Wright Ace Attorney: Trials and Tribulations DS

Release Date:

23 October 2007

People who liked this also liked...

7.7 / 10
This is a new age adventure-genre games and the Nintendo DS touch-screen functionality. It combines enthralling stories with very interesting characters that you will definitely love interacting ...
by Nintendo
Release Date: 09/01/2006

Description

  • Play from the first person perspective through five intriguing new cases. Play as two lawyers - relive Mia`s rookie days from the past and Phoenix`s current cases in the present.
  • Colorful cast of characters: Phoenix Wright - the game`s main character who is an accomplished defense lawyer with a keen sense for discerning fact from fiction. Maya Fey - a bright young girl; Mia Fey - an ace attorney.
  • Two distinct gameplay segments: Investigation phase - survey crime scenes, interview witnesses and gather evidence. Court phase - present findings from the investigation to support your case, listen to testimonies and examine witnesses.
  • Psyche-Lock system: Break down tough witnesses with a series of correct questions or catch them on inconsistencies.
  • Microphone can be used to yell Objection! and Hold it! as you cross examine witnesses.
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:

Nintendo

Release Date:

10/23/2007

Review This Game

Find Us On