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= 39427 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= 39427 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= 39427 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 " L.A. Noire PC | Review Any Game


L.A. Noire PC

Release Date:

08 November 2011

Also on:

PC PS3 Xbox 360

Submitted by Cheat Title Rating
profile spa77k Vehicle locations
Oct 30, 2014
00
profile spa77k Hidden vehicles
Oct 30, 2014
00
profile spa77k Steam Achievements.
Oct 30, 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:

Rockstar

Release Date:

11/08/2011

Review This Game

Find Us On