Heren 9

Team foto Heren 9

Speelt in:
-
Positie:
-
Coach:
-

Teamleden

Chris

Foto Chris

Positie:
Diagonaal
Leeftijd:
23
Lengte:
1.86
Rugnummer:
78

Roelof

Geen foto van  Roelof beschikbaar

Positie:
Diagonaal
Leeftijd:
19
Lengte:
1.80
Rugnummer:
36

Bjorn

Foto Bjorn

Positie:
Spelverdeler
Leeftijd:
20
Lengte:
1.75
Rugnummer:
85

Wout (Aanvoerder)

Foto Wout

Positie:
Hoofdaanvaller
Leeftijd:
23
Lengte:
1.87
Rugnummer:
83

Emeraldo

Foto Emeraldo

Positie:
Hoofdblokkeerder
Leeftijd:
24
Lengte:
1.86
Rugnummer:
2

Oleksandr

Foto Oleksandr

Positie:
Hoofdblokkeerder
Leeftijd:
24
Lengte:
1.82
Rugnummer:
84

Martijn

Foto Martijn

Positie:
Hoofdblokkeerder
Leeftijd:
20
Lengte:
2.02
Rugnummer:
80

Jasper

Geen foto van  Jasper beschikbaar

Leeftijd:
22
Lengte:
0.00

Simon

Geen foto van  Simon  beschikbaar

Leeftijd:
21
Lengte:
0.00

Chris

Foto Chris

Positie:
Hoofdaanvaller
Leeftijd:
20
Lengte:
1.85
Rugnummer:
81

Tim

Geen foto van  Tim beschikbaar

Positie:
Hoofdaanvaller
Leeftijd:
18
Lengte:
1.86

Dion

Foto Dion

Leeftijd:
21
Lengte:
1.75

Werner

Geen foto van  Werner beschikbaar

Leeftijd:
20
Lengte:
0.00

Trainingen

DagTijdLocatieTrainer
Woe 18:30
20:00
Kamerlingh Onnes Majoke

Stand Heren 9

Stand H4A
#TeamWPSetsPuntenOpm.
1 Veracles H5 16 48 48 - 16 1526 - 1268 KampioenPromotie
2 Doles H2 18 46 46 - 26 1623 - 1476 Promotiewedstrijd(en)
3 DIO / Bedum H6 18 42 42 - 30 1583 - 1519
4 Lycurgus H7 18 41 41 - 31 1578 - 1519
5 LSV H3 18 37 37 - 35 1589 - 1603
6 Rovoc H4 18 36 36 - 36 1605 - 1553
7 Donitas H9 18 33 33 - 39 1521 - 1574
8 Sivoc H2 17 30 34 - 34 1519 - 1500 1x Max punten in mindering
9 Actief H2 18 18 18 - 54 1438 - 1676
10 De Meeuwen H6 17 9 17 - 51 1324 - 1618 2x Max punten in mindering

Wedstrijden

Datum Tijd Wedstrijd Uitslag Setstanden
Datum Tijd Wedstrijd Uitslag Setstanden
24 september 2011 00:00 H9 - Actief H2 2-225-19, 20-25, 27-25, 21-25
1 oktober 2011 00:00 H9 - Doles H2 0-415-25, 20-25, 18-25, 18-25
6 oktober 2011 00:00 DIO / Bedum H6 - H9 1-312-25, 25-22, 9-25, 18-25
27 oktober 2011 21:00 De Meeuwen H6 - H9 2-221-25, 25-20, 25-21, 20-25
5 november 2011 18:30 H9 - LSV H3 2-225-14, 10-25, 25-23, 21-25
10 november 2011 21:00 Lycurgus H7 - H9 2-219-25, 26-28, 25-21, 25-16
19 november 2011 18:30 H9 - Sivoc H2 1-318-25, 18-25, 25-23, 11-25
26 november 2011 15:00 Veracles H5 - H9 1-322-25, 25-17, 19-25, 23-25
17 december 2011 20:00 Sivoc H2 - H9 2-221-25, 25-21, 25-16, 20-25
12 januari 2012 20:30 Rovoc H4 - H9 1-316-25, 27-25, 17-25, 26-28
21 januari 2012 18:00 Doles H2 - H9 4-025-18, 25-11, 25-14, 25-20
28 januari 2012 20:00 H9 - DIO / Bedum H6 1-311-25, 14-25, 15-25, 25-20
11 februari 2012 20:00 H9 - De Meeuwen H6 4-025-13, 25-11, 25-9, 25-21
3 maart 2012 13:30 LSV H3 - H9 2-221-25, 25-15, 13-25, 25-23
10 maart 2012 20:00 H9 - Veracles H5 0-412-25, 22-25, 16-25, 21-25
24 maart 2012 18:30 H9 - Lycurgus H7 1-320-25, 15-25, 17-25, 25-12
14 april 2012 20:00 H9 - Rovoc H4 1-325-23, 18-25, 18-25, 19-25
21 april 2012 17:00 Actief H2 - H9 0-417-25, 20-25, 17-25, 7-25
(default) 36 queries took 274 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `donitasusers`414110
2DESCRIBE `groups_users`4410
3DESCRIBE `groups`8810
4DESCRIBE `metagroups`5510
5DESCRIBE `groupfunctions`3310
6SET NAMES 'UTF8'00
7DESCRIBE `messageboards_metagroups`4410
8DESCRIBE `messageboards`4410
9DESCRIBE `notes`5510
10DESCRIBE `notes_metagroups`4410
11DESCRIBE `comments`111110
12DESCRIBE `calendars_metagroups`4410
13DESCRIBE `calendars`2210
14DESCRIBE `calendaritems`101010
15DESCRIBE `trainings`101010
16DESCRIBE `logins`4410
17DESCRIBE `logs`101010
18SELECT `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo` FROM `groups` AS `Group` WHERE teamtype = "Heren" AND teamnumber = "9" LIMIT 1111
19SELECT Donitasuser.name,Donitasuser.firstname,Donitasuser.id,Donitasuser.nevobonumber,Donitasuser.position,Donitasuser.birthday, Donitasuser.length ,Donitasuser.shirtnumber,GroupsUser.groupfunction_id,Groupfunction.name FROM groups_users as GroupsUser LEFT JOIN donitasusers as Donitasuser ON (GroupsUser.user_id = Donitasuser.id) LEFT JOIN groupfunctions as Groupfunction on (GroupsUser.groupfunction_id = Groupfunction.id) WHERE GroupsUser.group_id = 25 AND GroupsUser.groupfunction_id not in (3,4)13131
20SELECT `Training`.`id`, `Training`.`starttime`, `Training`.`endtime`, `Training`.`day`, `Training`.`location`, `Training`.`field`, `Training`.`trainer_id`, `Training`.`trainertext`, `Training`.`group_id`, `Training`.`trainer2_id`, `Group`.`id`, `Group`.`alias_id`, `Group`.`type`, `Group`.`name`, `Group`.`email`, `Group`.`teamtype`, `Group`.`teamnumber`, `Group`.`photo`, `Trainer`.`id`, `Trainer`.`username`, `Trainer`.`password`, `Trainer`.`displayname`, `Trainer`.`email`, `Trainer`.`website`, `Trainer`.`created`, `Trainer`.`modified`, `Trainer`.`address`, `Trainer`.`streetnumber`, `Trainer`.`zipcode`, `Trainer`.`city`, `Trainer`.`phonenumber`, `Trainer`.`mobilenumber`, `Trainer`.`name`, `Trainer`.`firstname`, `Trainer`.`tussenvoegsel`, `Trainer`.`lastname`, `Trainer`.`msn`, `Trainer`.`birthday`, `Trainer`.`length`, `Trainer`.`nevobonumber`, `Trainer`.`registrationtype`, `Trainer`.`registrationnumber`, `Trainer`.`position`, `Trainer`.`quote`, `Trainer`.`aboutuser`, `Trainer`.`userstatus`, `Trainer`.`receivenewsletter`, `Trainer`.`gg_check`, `Trainer`.`showsmileys`, `Trainer`.`showimages`, `Trainer`.`shirtnumber`, `Trainer`.`numberofpostsperpage`, `Trainer`.`mijndonitas`, `Trainer`.`old_user_id`, `Trainer`.`study`, `Trainer`.`civilstatus`, `Trainer`.`lastlogin`, `Trainer`.`logins`, `Trainer`.`rsskey`, `Trainer2`.`id`, `Trainer2`.`username`, `Trainer2`.`password`, `Trainer2`.`displayname`, `Trainer2`.`email`, `Trainer2`.`website`, `Trainer2`.`created`, `Trainer2`.`modified`, `Trainer2`.`address`, `Trainer2`.`streetnumber`, `Trainer2`.`zipcode`, `Trainer2`.`city`, `Trainer2`.`phonenumber`, `Trainer2`.`mobilenumber`, `Trainer2`.`name`, `Trainer2`.`firstname`, `Trainer2`.`tussenvoegsel`, `Trainer2`.`lastname`, `Trainer2`.`msn`, `Trainer2`.`birthday`, `Trainer2`.`length`, `Trainer2`.`nevobonumber`, `Trainer2`.`registrationtype`, `Trainer2`.`registrationnumber`, `Trainer2`.`position`, `Trainer2`.`quote`, `Trainer2`.`aboutuser`, `Trainer2`.`userstatus`, `Trainer2`.`receivenewsletter`, `Trainer2`.`gg_check`, `Trainer2`.`showsmileys`, `Trainer2`.`showimages`, `Trainer2`.`shirtnumber`, `Trainer2`.`numberofpostsperpage`, `Trainer2`.`mijndonitas`, `Trainer2`.`old_user_id`, `Trainer2`.`study`, `Trainer2`.`civilstatus`, `Trainer2`.`lastlogin`, `Trainer2`.`logins`, `Trainer2`.`rsskey` FROM `trainings` AS `Training` LEFT JOIN `groups` AS `Group` ON (`Training`.`group_id` = `Group`.`id`) LEFT JOIN `donitasusers` AS `Trainer` ON (type="Team" AND `Training`.`trainer_id` = `Trainer`.`id`) LEFT JOIN `donitasusers` AS `Trainer2` ON (type="Team" AND `Training`.`trainer2_id` = `Trainer2`.`id`) WHERE `group_id` = 25 ORDER BY `day` ASC, `starttime` ASC 111
21DESCRIBE `nevobo_tables`15159
22DESCRIBE `clubs`4410
23DESCRIBE `nevobo_regions`4410
24SELECT `NevoboRegion`.`id`, `NevoboRegion`.`region`, `NevoboRegion`.`donitasid`, `NevoboRegion`.`url` FROM `nevobo_regions` AS `NevoboRegion` WHERE 1 = 1 220
25SELECT `NevoboTable`.`id`, `NevoboTable`.`region`, `NevoboTable`.`club_id`, `NevoboTable`.`team`, `NevoboTable`.`pos`, `NevoboTable`.`code`, `NevoboTable`.`points`, `NevoboTable`.`matches`, `NevoboTable`.`sets`, `NevoboTable`.`setsagainst`, `NevoboTable`.`setpoints`, `NevoboTable`.`setpointsagainst`, `NevoboTable`.`comments`, `NevoboTable`.`created`, `NevoboTable`.`modified`, `Club`.`id`, `Club`.`name`, `Club`.`region2`, `Club`.`checked` FROM `nevobo_tables` AS `NevoboTable` LEFT JOIN `clubs` AS `Club` ON (`NevoboTable`.`club_id` = `Club`.`id`) WHERE ((`NevoboTable`.`region` = "Noord-Oost" AND `NevoboTable`.`club_id` = 1157) OR (`NevoboTable`.`region` = "Nationaal" AND `NevoboTable`.`club_id` = 1157)) AND team = "h9" ORDER BY `NevoboTable`.`region` desc LIMIT 1111
26SELECT `NevoboTable`.`id`, `NevoboTable`.`region`, `NevoboTable`.`club_id`, `NevoboTable`.`team`, `NevoboTable`.`pos`, `NevoboTable`.`code`, `NevoboTable`.`points`, `NevoboTable`.`matches`, `NevoboTable`.`sets`, `NevoboTable`.`setsagainst`, `NevoboTable`.`setpoints`, `NevoboTable`.`setpointsagainst`, `NevoboTable`.`comments`, `NevoboTable`.`created`, `NevoboTable`.`modified`, `Club`.`id`, `Club`.`name`, `Club`.`region2`, `Club`.`checked` FROM `nevobo_tables` AS `NevoboTable` LEFT JOIN `clubs` AS `Club` ON (`NevoboTable`.`club_id` = `Club`.`id`) WHERE code = "H4A" and `NevoboTable`.`region` = "Noord-oost" ORDER BY `pos` ASC 101019
27DESCRIBE `matches`272711
28DESCRIBE `sportshalls`9910
29SELECT `Match`.`id`, `Match`.`code`, `Match`.`teama`, `Match`.`teamb`, `Match`.`startingtime`, `Match`.`pointsa`, `Match`.`pointsb`, `Match`.`sportshall`, `Match`.`field`, `Match`.`set1a`, `Match`.`set1b`, `Match`.`set2a`, `Match`.`set2b`, `Match`.`set3a`, `Match`.`set3b`, `Match`.`set4a`, `Match`.`set4b`, `Match`.`set5a`, `Match`.`set5b`, `ClubA`.`name`, `ClubB`.`name`, `Sporthall`.`name` FROM `matches` AS `Match` LEFT JOIN `clubs` AS `ClubA` ON (`Match`.`cluba` = `ClubA`.`id`) LEFT JOIN `clubs` AS `ClubB` ON (`Match`.`clubb` = `ClubB`.`id`) LEFT JOIN `sportshalls` AS `Sporthall` ON (`Match`.`sportshall` = `Sporthall`.`id`) WHERE FIND_IN_SET("H9",donitasteam) ORDER BY `startingtime` ASC 18182
30DESCRIBE `newsitems`999
31DESCRIBE `attachments`12129
32DESCRIBE `attachments_newsitems`3310
33DESCRIBE `smileys`3310
34SELECT `Newsitem`.`id`, `Newsitem`.`title`, `Newsitem`.`message`, `Newsitem`.`preview` FROM `newsitems` AS `Newsitem` LEFT JOIN `metagroups` AS `Metagroup` ON (`Newsitem`.`metagroup_id` = `Metagroup`.`id`) WHERE isledenonly = 0 AND (metagroup_id = 31 OR metagroup_id = 3 OR metagroup_id = 45 OR metagroup_id = 35 OR metagroup_id = 34 OR metagroup_id = 33 OR metagroup_id = 32 OR metagroup_id = 36 OR metagroup_id = 42 OR metagroup_id = 40 OR metagroup_id = 39 OR metagroup_id = 43 OR metagroup_id = 15 OR metagroup_id = 14 OR metagroup_id = 50 OR metagroup_id = 51 OR metagroup_id = 41 ) AND (enddate > now() OR enddate = "0000-00-00 00:00:00" or enddate is null or enddate < date) AND date < now() ORDER BY `date` desc LIMIT 4441
35SELECT `Attachment`.`internalfilename`, `Attachment`.`showafter`, `Attachment`.`id`, `Attachment`.`size`, `Attachment`.`filename`, `Attachment`.`title`, `Attachment`.`categorie`, `Attachment`.`isloginrequired`, `Attachment`.`isdownload`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`user_id`, `AttachmentsNewsitem`.`id`, `AttachmentsNewsitem`.`attachment_id`, `AttachmentsNewsitem`.`newsitem_id` FROM `attachments` AS `Attachment` JOIN `attachments_newsitems` AS `AttachmentsNewsitem` ON (`AttachmentsNewsitem`.`newsitem_id` IN (424, 396, 392, 388) AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
36SELECT `Calendaritem`.`id`, `Calendaritem`.`calendar_id`, `Calendaritem`.`startdate`, `Calendaritem`.`enddate`, `Calendaritem`.`title`, `Calendaritem`.`info`, `Calendaritem`.`location`, `Calendaritem`.`url`, `Calendaritem`.`modified`, `Calendaritem`.`created`, `Calendar`.`id`, `Calendar`.`name` FROM `calendaritems` AS `Calendaritem` LEFT JOIN `calendars` AS `Calendar` ON (`Calendaritem`.`calendar_id` = `Calendar`.`id`) WHERE calendar_id = 1 AND ((enddate > now() or enddate = "0000-00-00 00:00:00" or enddate is null or enddate < startdate) OR (enddate is null OR enddate < now())) AND startdate > now() ORDER BY `startdate` ASC 000