SELECT * FROM spillere WHERE TurnID = 37 AND SpillerID NOT IN (-1) ORDER BY Rating DESC, ELORating DESC

array(4) { [0]=> array(6) { ["file"]=> string(89) "/customers/5/9/2/fredericia-skakforening.dk/httpd.www/IM2016/phpclass/class.turnering.php" ["line"]=> int(1305) ["function"]=> string(6) "SQLdie" ["class"]=> string(2) "DB" ["type"]=> string(2) "::" ["args"]=> array(2) { [0]=> string(103) "SELECT * FROM spillere WHERE TurnID = 37 AND SpillerID NOT IN (-1) ORDER BY Rating DESC, ELORating DESC" [1]=> NULL } } [1]=> array(7) { ["file"]=> string(89) "/customers/5/9/2/fredericia-skakforening.dk/httpd.www/IM2016/phpclass/class.turnering.php" ["line"]=> int(1411) ["function"]=> string(21) "DeltagereSpecialListe" ["class"]=> string(9) "Turnering" ["object"]=> object(Turnering)#1 (41) { ["TurnID"]=> string(2) "37" ["HeaderTitel"]=> string(27) "Fredericia Rapid Chess 2016" ["HeaderTitel2"]=> string(34) "Følg IM-gruppen medens du spiller" ["Turneringsnavn"]=> string(27) "Fredericia Rapid Chess 2016" ["Turneringsnavn2"]=> string(34) "Følg IM-gruppen medens du spiller" ["Grupper"]=> array(6) { [0]=> object(Gruppe)#11 (27) { ["GruppeID"]=> string(3) "137" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(14) "Mesterklasse 1" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [1]=> object(Gruppe)#12 (27) { ["GruppeID"]=> string(3) "138" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(14) "Mesterklasse 2" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [2]=> object(Gruppe)#13 (27) { ["GruppeID"]=> string(3) "139" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 1" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [3]=> object(Gruppe)#14 (27) { ["GruppeID"]=> string(3) "140" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 2" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [4]=> object(Gruppe)#15 (27) { ["GruppeID"]=> string(3) "141" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 3" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [5]=> object(Gruppe)#16 (27) { ["GruppeID"]=> string(3) "142" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 4" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(2) "10" ["Turneringsform"]=> string(1) "3" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } } ["Spilledage"]=> string(39) "Kr. Himmelfartsdag, torsdag 5. maj 2016" ["Spillested"]=> string(85) "Erritsø Fællesskole, klynge 5, Erritsø Bygade 15, 7000 Fredericia Handicapvenligt" ["Spilletid"]=> string(21) "kl. 11.00 - ca. 19.00" ["Betaenktid"]=> string(26) "20 min. + 5 sek. pr. træk" ["TurnForm"]=> string(214) "8 mands alle-mod-alle, nederste gruppe evt. Monrad. Turneringen HURTIGSKAK RATES. Da kun få turneringer er blevet dette tidligere, så inddeler vi efter nærskak rating grundet uaktuelle tal hos mange spillere." ["Indskud"]=> string(18) "Kr. 100,- for alle" ["Praemie"]=> string(35) "100 % af indskud går til præmier." ["MaxDelt"]=> string(2) "80" ["Tilmelding"]=> string(162) "Senest tirsdag d. 3/5 2016 til Claus Marcussen, tlf. 75 94 15 20 Email: formand@fredericia-skakforening.dk eller online på : www.fredericia-skakforening.dk/" ["FoersteRunde"]=> string(10) "2016-05-05" ["SidsteRunde"]=> string(10) "2016-05-05" ["TurneringslederFIDEId"]=> string(0) "" ["international"]=> string(1) "0" ["sponsorIncludeID"]=> string(1) "5" ["SaesonID"]=> string(1) "7" ["Kommentar"]=> string(1) "0" ["TilmeldFrist"]=> string(10) "2016-05-03" ["TilmeldEmail"]=> string(34) "formand@fredericia-skakforening.dk" ["TilmeldEmail2"]=> string(0) "" ["Bemaerk"]=> NULL ["Afsluttet"]=> string(1) "1" ["GruppeInddelt"]=> string(1) "1" ["Rates"]=> string(1) "0" ["InternTurn"]=> string(1) "0" ["AntalRunder"]=> string(1) "7" ["VisIMenu"]=> string(1) "1" ["Link"]=> NULL ["LinkTxt"]=> NULL ["EgenHjemmeside"]=> string(7) "/IM2016" ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" ["Deltagere":"Turnering":private]=> NULL ["LastID"]=> NULL ["SpillerAntalTurn"]=> string(2) "50" ["SpillerAntalTurnEjSpeciel"]=> string(2) "50" } ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> int(12) [1]=> int(2000) } } [2]=> array(7) { ["file"]=> string(76) "/customers/5/9/2/fredericia-skakforening.dk/httpd.www/turneringdeltagere.php" ["line"]=> int(23) ["function"]=> string(13) "Deltagerliste" ["class"]=> string(9) "Turnering" ["object"]=> object(Turnering)#1 (41) { ["TurnID"]=> string(2) "37" ["HeaderTitel"]=> string(27) "Fredericia Rapid Chess 2016" ["HeaderTitel2"]=> string(34) "Følg IM-gruppen medens du spiller" ["Turneringsnavn"]=> string(27) "Fredericia Rapid Chess 2016" ["Turneringsnavn2"]=> string(34) "Følg IM-gruppen medens du spiller" ["Grupper"]=> array(6) { [0]=> object(Gruppe)#11 (27) { ["GruppeID"]=> string(3) "137" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(14) "Mesterklasse 1" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [1]=> object(Gruppe)#12 (27) { ["GruppeID"]=> string(3) "138" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(14) "Mesterklasse 2" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [2]=> object(Gruppe)#13 (27) { ["GruppeID"]=> string(3) "139" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 1" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [3]=> object(Gruppe)#14 (27) { ["GruppeID"]=> string(3) "140" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 2" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [4]=> object(Gruppe)#15 (27) { ["GruppeID"]=> string(3) "141" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 3" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(1) "8" ["Turneringsform"]=> string(1) "2" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } [5]=> object(Gruppe)#16 (27) { ["GruppeID"]=> string(3) "142" ["TurnID"]=> string(2) "37" ["GruppeNavn"]=> string(13) "Basisklasse 4" ["AntalRunder"]=> string(1) "7" ["AntalDeltagere"]=> string(2) "10" ["Turneringsform"]=> string(1) "3" ["AnvendPramieGruppe"]=> string(1) "0" ["FoersteRunde"]=> string(10) "2016-05-05" ["Bemaerkning"]=> string(0) "" ["RatingGennemsnit"]=> int(0) ["SpillereUdenELO"]=> bool(false) ["RatingLav"]=> int(9999) ["RatingHoej"]=> int(0) ["MaxRundelagt"]=> int(0) ["RaekkeFolge"]=> NULL ["RatingForm"]=> NULL ["Spiller"]=> NULL ["Resultater"]=> NULL ["AllePartierRates"]=> NULL ["ResEjSpillet"]=> int(0) ["ResHvidVandt"]=> int(0) ["ResSortVandt"]=> int(0) ["ResRemis"]=> int(0) ["ResAndet"]=> int(0) ["Turnering"]=> int(0) ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" } } ["Spilledage"]=> string(39) "Kr. Himmelfartsdag, torsdag 5. maj 2016" ["Spillested"]=> string(85) "Erritsø Fællesskole, klynge 5, Erritsø Bygade 15, 7000 Fredericia Handicapvenligt" ["Spilletid"]=> string(21) "kl. 11.00 - ca. 19.00" ["Betaenktid"]=> string(26) "20 min. + 5 sek. pr. træk" ["TurnForm"]=> string(214) "8 mands alle-mod-alle, nederste gruppe evt. Monrad. Turneringen HURTIGSKAK RATES. Da kun få turneringer er blevet dette tidligere, så inddeler vi efter nærskak rating grundet uaktuelle tal hos mange spillere." ["Indskud"]=> string(18) "Kr. 100,- for alle" ["Praemie"]=> string(35) "100 % af indskud går til præmier." ["MaxDelt"]=> string(2) "80" ["Tilmelding"]=> string(162) "Senest tirsdag d. 3/5 2016 til Claus Marcussen, tlf. 75 94 15 20 Email: formand@fredericia-skakforening.dk eller online på : www.fredericia-skakforening.dk/" ["FoersteRunde"]=> string(10) "2016-05-05" ["SidsteRunde"]=> string(10) "2016-05-05" ["TurneringslederFIDEId"]=> string(0) "" ["international"]=> string(1) "0" ["sponsorIncludeID"]=> string(1) "5" ["SaesonID"]=> string(1) "7" ["Kommentar"]=> string(1) "0" ["TilmeldFrist"]=> string(10) "2016-05-03" ["TilmeldEmail"]=> string(34) "formand@fredericia-skakforening.dk" ["TilmeldEmail2"]=> string(0) "" ["Bemaerk"]=> NULL ["Afsluttet"]=> string(1) "1" ["GruppeInddelt"]=> string(1) "1" ["Rates"]=> string(1) "0" ["InternTurn"]=> string(1) "0" ["AntalRunder"]=> string(1) "7" ["VisIMenu"]=> string(1) "1" ["Link"]=> NULL ["LinkTxt"]=> NULL ["EgenHjemmeside"]=> string(7) "/IM2016" ["ValiderStatus"]=> string(0) "" ["ValiderFelt"]=> string(0) "" ["Deltagere":"Turnering":private]=> NULL ["LastID"]=> NULL ["SpillerAntalTurn"]=> string(2) "50" ["SpillerAntalTurnEjSpeciel"]=> string(2) "50" } ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(4) { ["file"]=> string(83) "/customers/5/9/2/fredericia-skakforening.dk/httpd.www/IM2016/turneringdeltagere.php" ["line"]=> int(2) ["args"]=> array(1) { [0]=> string(76) "/customers/5/9/2/fredericia-skakforening.dk/httpd.www/turneringdeltagere.php" } ["function"]=> string(7) "include" } }