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= 35710 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= 35710 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= 35710 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 " CSI: Crime Scene Investigation: Fatal Conspiracy Wii Image 6 | Review Any Game


CSI: Crime Scene Investigation: Fatal Conspiracy Wii

Release Date:

26 October 2010

Summary:

This game needs a total overhaul and I hope the developers see that for this has a lot of potential and should have been a keeper. Crossing my fingers here.

People who liked this also liked...

6.3 / 10
Even though the graphics for this game are low in quality, and the gameplay is somewhat lacking in exciting play, there are elements to this game that make it worth playing.
by Mazoom
Release Date: 01/16/2008

Submitted by Cheat Title Rating
profile yabber Awards.
Nov 27, 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:

10/26/2010

Review This Game

Find Us On