List of Entrants - St Albans 2015

28th & 29th March 2015

{jumi [jumicode/count_all_players.php]}

Open Tournament

{artdatatable bInfo="false" bFilter="false" bPaginate="false" iDisplayLength="10" sort="3,'desc'"}{artsqltable query="SELECT surname, firstname, club_or_school, ecf_grade, CONCAT('',ecf_code,'') FROM tsn_congress_entrants_current WHERE tournament='1-Open'" headerNames="Surname,First Name,Club, Grade,ECF Code"}{/artsqltable}{/artdatatable}

{jumi [jumicode/count_open_players.php]}

Challengers Tournament - Graded 180 and Below

{artdatatable bInfo="false" bFilter="false" bPaginate="false" iDisplayLength="10" sort="3,'desc'"}{artsqltable query="SELECT surname, firstname, club_or_school, ecf_grade, CONCAT('',ecf_code,'') FROM tsn_congress_entrants_current WHERE tournament='2-Challengers'" headerNames="Surname,First Name,Club, Grade,ECF Code"}{/artsqltable}{/artdatatable}

{jumi [jumicode/count_challengers_players.php]}

Major Tournament - Graded 160 and Below

{artdatatable bInfo="false" bFilter="false" bPaginate="false" iDisplayLength="10" sort="3,'desc'"}{artsqltable query="SELECT surname, firstname, club_or_school, ecf_grade, CONCAT('',ecf_code,'') FROM tsn_congress_entrants_current WHERE tournament='3-Major'" headerNames="Surname,First Name,Club, Grade,ECF Code"}{/artsqltable}{/artdatatable}

{jumi [jumicode/count_major_players.php]}

Intermediate Tournament - Graded 140 and Below

{artdatatable bInfo="false" bFilter="false" bPaginate="false" iDisplayLength="10" sort="3,'desc'"}{artsqltable query="SELECT surname, firstname, club_or_school, ecf_grade, CONCAT('',ecf_code,'') FROM tsn_congress_entrants_current WHERE tournament='4-Intermediate'" headerNames="Surname,First Name,Club, Grade,ECF Code"}{/artsqltable}{/artdatatable}

{jumi [jumicode/count_intermediate_players.php]}

Minor Tournament - Graded 120 and Below

{artdatatable bInfo="false" bFilter="false" bPaginate="false" iDisplayLength="10" sort="3,'desc'"}{artsqltable query="SELECT surname, firstname, club_or_school, ecf_grade, CONCAT('',ecf_code,'') FROM tsn_congress_entrants_current WHERE tournament='5-Minor'" headerNames="Surname,First Name,Club, Grade,ECF Code"}{/artsqltable}{/artdatatable}