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= 41523 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= 41523 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= 41523 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 " Super Mario All-Stars Limited Edition Wii Image 0 | Review Any Game


Super Mario All-Stars Limited Edition Wii

Summary:

  • Enjoy this collectible reissue of 1993's Super Mario All-Stars for SNES, now for Wii
  • Collection includes four classic games for Wii: Super Mario Bros., Super Mario Bros.: The Lost Levels, Super Mario Bros. 2 and Super Mario Bros. 3
  • CD soundtrack containing themes and sound effects pulled from Mario games ranging from the original Super Mario Bros. through Super Mario Galaxy 2, as well the "Super Mario Bros. Ground Theme"
  • 32-page Super Mario History booklet featuring interviews, concept art and interviews
  • All games support multiple controllers, including: Wii Remote controller, Wii Remote Plus controller, Classic Controller, Classic Controller Pro or the Nintendo GameCube controller

People who liked this also liked...

8.4 / 10
Super Mario Galaxy sets an incredibly high bar for other games that come out on the Wii, and I certainly hope that they are able to match it, because if they can, the Wii will be able to truly gi...
by Nintendo
Release Date: 11/12/2007

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

Review This Game

Find Us On