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= 16625 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= 16625 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= 16625 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 " Jackass: The Game PSP Image 7 | Review Any Game


Jackass: The Game PSP

Release Date:

27 September 2007

Also on:

Sony PSP DS

People who liked this also liked...

Command up to 7 characters at a time and embark on a crusade in a 15th century fantasy setting of ogres, dragons and magical powers Explore ransacked villages and battlefields with visuals an...
by Sony
Release Date: 08/21/2007

Description

Johnny Knoxville and the Jackass crew are knee deep in their latest series of ill-conceived stunts, pranks and acts of indecency, and this time you`re in the director`s seat. Take control of your favourite degenerates through a massive range of all-new challenges. An onslaught of absurd situations lower the bar and up the ante for the self-inflicted injury, degradation and low moral caliber you`ve come to love and expect from this special group of idiots.

  • Over 30 crazy stunts let you take the cast of jackass through humanly impossible levels of danger.
  • All characters are voiced by the original cast and mo-capped by Weta Digital (King Kong, Lord of the Rings).
  • Diverse gameplay mechanics - shoot, drive, flail, roll and injure yourself and others across 30 different stunts.
  • Win BIG or lose BIGGER - wether you perfect a stunt to show your skill or break a bone in your body trying, it`s all about entertainment.
  • Detailed injury system tracks every impact. From broken femurs to ruptured spleens, dish out maximum punishment to crank up your high score.
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:

Red Mile Entertainment

Release Date:

09/27/2007

Review This Game

Find Us On