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= 43219 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= 43219 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= 43219 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 " Rush PSP Image 8 | Review Any Game


Rush PSP

Release Date:

16 November 2006

Summary:

  • Race more than 50 rides, including exclusive street racers, plus licensed muscle, tuner and exotic vehicles
  • Propel through the streets in convincing L.A. city recreations, surviving death-defying jumps and finding treacherous shortcuts at each turn
  • Call on the boys at West Coast Customs to trick out your car and tune its performance
  • Re-acquire 30 cars stolen from your fleet, and regain respect and street credit through three separate missions in Story mode
  • Cruise along to a bass-bumping soundtrack filled with exclusive hip-hop and rock jams, including never-released tracks from Twista and Lil' Kim

People who liked this also liked...


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:

Midway

Release Date:

11/16/2006

Review This Game

Find Us On