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= 4479 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= 4479 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= 4479 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 " Haze PS3 | Review Any Game


Haze PS3

Release Date:

20 May 2008

Summary:

Set in the year 2048 in a world where governments have outsourced military operations to private military corporations (PMCs), you play as Shane Carpenter, a newly enlisted soldier seeking fulfillment and thrills by fighting for a good cause. As the leading PMC, Mantel Global Industries offers an array of cutting-edge military equipment, including a high-tech arsenal of vehicles, deadly weaponry, and the performance-enhancing drug Nectar. 

People who liked this also liked...

6.8 / 10
It is nice in its own right but I wish there was more to it than just shooting people in the face and falling billboards for an attraction. But the action that it offers can spice up that borin...
by Midway Games Ltd
Release Date: 10/29/2007

Submitted by Cheat Title Rating
profile prial Mode.
Nov 28, 2014
00

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:

Ubisoft

Release Date:

05/20/2008

Review This Game

Find Us On