Please click on top 100 parent site,and find the time to vote for us, you can vote on this site every 30 minutes,by clicking on our name on the site
Online now
14 Guests, 0 Users
Games
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
SELECT game.ID_GAME, game.gameName, game.description, game.gameRating, game.numPlays, game.gameFile,
game.gameDirectory, game.gameType, game.internalName, game.gameWidth, game.gameHeight,
game.gameBackgroundColor AS bgcolor, game.scoreType, game.maxScores, game.thumbnail, game.thumbnailSmall,
game.help, game.enabled, game.memberGroups,
IFNULL(score.ID_SCORE,0) AS ID_SCORE, IFNULL(score.score,0) AS champScore, IFNULL(score.startTime, 0) AS champTime,
IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, IFNULL(mem.realName, '') AS realName, IFNULL(score.endTime, 0) AS championTime,
IFNULL(favorite.ID_FAVORITE, 0) AS isFavorite, IFNULL(category.ID_CAT, 0) AS ID_CAT,
IFNULL(category.catName, '') As catName, IFNULL(pb.ID_PB, 0) AS ID_PB, IFNULL(pb.score, 0) AS personalBest
FROM babieswings_arcade_games AS game
LEFT JOIN babieswings_arcade_scores AS score ON (score.ID_SCORE = game.ID_CHAMPION_SCORE)
LEFT JOIN babieswings_members AS mem ON (mem.ID_MEMBER = game.ID_MEMBER_CHAMPION)
LEFT JOIN babieswings_arcade_personalbest AS pb ON (pb.ID_GAME = game.ID_GAME AND pb.ID_MEMBER = 0)
LEFT JOIN babieswings_arcade_favorite AS favorite ON (favorite.ID_GAME = game.ID_GAME AND favorite.ID_MEMBER = 0)
LEFT JOIN babieswings_arcade_categories AS category ON (category.ID_CAT = game.ID_CAT)
WHERE FIND_IN_SET(-1, category.memberGroups) AND enabled = 1
ORDER BY RAND()
LIMIT 0,1
