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= 42359 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= 42359 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= 42359 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 " Mario Hoops 3 On 3 DS Image 8 | Review Any Game


Mario Hoops 3 On 3 DS

Release Date:

11 September 2006

Summary:

  • Includes Square Enix characters: White Mage, Cactuar, Moogle
  • White Mage - a character from the first Final Fantasy game, she uses restorative and support magic
  • Cactuar - a small mobile cactus, Cactuars are known for high speed and evasiveness.
  • Moogle - Essentially a small white teddy bear with a single antenne, Moogles generally serve as merchants and postmen in Final Fantasy games

People who liked this also liked...

8.2 / 10
Mario Kart delivers what most games only wish they could do. It can be considered as one of the best hand-held games out there. It is easily accessible and you can play with it for hours without ...
by Nintendo
Release Date: 11/14/2005

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:

Nintendo

Release Date:

09/11/2006

Review This Game

Find Us On