% = 1
% = 1,2
SETNO:1
ASKTITLE: 
GETCODE:tm_id
DISPLAY:tm_name_en
AUTOTAG:T
SQL:Select tm_id, tm_name_en from teams,matches where (tm_id=ma_home_team_id or tm_id=ma_away_team_id) and ma_id={@GAMEID}
SETNO:2
ASKTITLE: 
GETCODE:pl_id
DISPLAY:pl_FULLNAME
AUTOTAG:P
SQL:Select pl_id, convert( concat(pl_shirt_number,'. ', pl_last_name_en, ' ' , pl_first_name_en) USING 'greek') as pl_FULLNAME from players where pl_team_id={@TEAMID} and pl_in_roster='1' order by pl_shirt_number
SETNO:3
ASKTITLE:  (IN)
GETCODE:pl_id
DISPLAY:pl_FULLNAME
AUTOTAG:P
SQL:Select pl_id, convert( concat(pl_shirt_number,'. ', pl_last_name_en, ' ' , pl_first_name_en) USING 'greek') as pl_FULLNAME from players where pl_team_id={@TEAMID} and pl_in_roster='1' order by pl_shirt_number
SETNO:4
ASKTITLE:  (OUT)
GETCODE:pl_id
DISPLAY:pl_FULLNAME
AUTOTAG:O
SQL:Select pl_id, convert( concat(pl_shirt_number,'. ', pl_last_name_en, ' ' , pl_first_name_en) USING 'greek') as pl_FULLNAME from players where pl_team_id={@TEAMID} and pl_in_roster='1' order by pl_shirt_number
SETNO:9
ASKTITLE: 
GETCODE:ma_id
DISPLAY:maGameTitle
AUTOTAG:G
SQL:Select ma_id,concat(t1.tm_name_en,' - ',t2.tm_name_en, ' - ' , date_format(ma_date,'%d/%m/%Y')) as maGameTitle from matches,teams t1, teams t2 where t1.tm_id=ma_home_team_id and t2.tm_id=ma_away_team_id and ma_status<2 order by ma_date