% = 1
% = 1,2
SETNO:1
ASKTITLE: 
GETCODE:tm_id
DISPLAY:tm_LongName
AUTOTAG:T
SQL:Select tm_id, tm_LongName from teams,games where (tm_id=gm_hteam_id or tm_id=gm_ateam_id) and gm_id={@GAMEID}
SETNO:2
ASKTITLE: 
GETCODE:pl_id
DISPLAY:pl_FULLNAME
AUTOTAG:P
SQL:Select pl_id, convert( concat(pl_ShirtNo,'. ', pl_LName, ' ' , pl_fName) USING 'greek') as pl_FULLNAME from players, roster where pl_id=ro_player_id and pl_TEAM_id={@TEAMID} and ro_game_id={@GAMEID} order by pl_shirtNo
SETNO:9
ASKTITLE: 
GETCODE:gm_ID
DISPLAY:gmGameTitle
AUTOTAG:G
SQL:Select gm_ID,concat(t1.tm_longName,' - ',t2.tm_longName, ' - ' , date_format(gm_datetime,'%d/%m/%Y')) as gmGameTitle from games,teams t1, teams t2 where t1.tm_id=gm_hteam_id and t2.tm_id=gm_ateam_id