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>='2019-10-02' and tournament_date<='2019-10-09' order by tournament_date, tournament_code, tournament_primary desc
