May 17, 2022, 11:50:43 am
Welcome, Guest. Please login or register.

Login with username, password and session length
   Home   Forum Help Search Arcade Gallery Links Staff List Login Register  

Beautiful sayings
We have now moved too
Vote for us

Top 100 Parenting Sites

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
0 Guests, 0 Users
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.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