displaying Query

1
2
3
4
5
6

SELECT DISTINCT g_v_full_games.*, g_favorites.game_id as Is_Favorite, g_favorites.entry_id
FROM g_v_full_games
LEFT JOIN g_favorites ON g_v_full_games.game_id = g_favorites.game_id
WHERE g_v_full_games.game_id > 0
AND g_v_full_games.game_id = 19
ORDER BY name

Games

Showing single game: gameid = 19

Amoeba Tag

Detail

Origin Alona Two-Trees, e-sam Entered by Azus

2 votes

breakdown of votes:
   0 stars:
   1 star :
   2 stars:
   3 stars: 2


Created on 2010-02-07 14:19:01	Modified 2010-02-07 14:19:01	Class Militia
Lives See rules	Count No count

Reeves

Materials

Setup

Rules Divide everybody into 2-man teams. Teammates must remain in contact the entire time! Teams run around trying to beat the other
teams. Every time a team defeats another team, the defeated team joins the victorious team. If this is done as a class battle, the class
abilities are only usable by the person playing that class and level. Abilities do not become shared. The game ends when everyone is
on the same team!

Victory

Misc

Variations

Current images:

page generated in 0.04 seconds.

Class:	Lives:
Count:	Players:
Text contains the words or phrases: Put each word or phrase on a seperate line Do not enclose with quotes! use "+" to require in results Otherwise will search for any terms
Has at least this rating	Origin:

Show Created On	Show Modified On

Show Class	Show Lives	Show Count

Show Players	Show Reeves	Show Keywords

Show Materials	Preview In Full	Show Setup	Preview In Full	Show Rules	Preview In Full

Show Victory	Preview In Full	Show Misc	Preview In Full	Show Variations	Preview In Full
Show Images	Preview In Full
Preview characters