select tournament_code, tournament_name_en, tournament_city_en, tournament_date, tournament_enddate,tournament_invite, tournament_regdate, tournament_level,tournament_regtype from sgostu_tournaments where tournament_active=1 and tournament_visible =1 and tournament_date>='2018-10-31' and tournament_date<='2018-11-07' order by tournament_date, tournament_code, tournament_primary desc
