Team Zaanstad

← Terug naar het competitieoverzicht

← Terug naar het competitieoverzicht

← Terug naar het competitieoverzicht

← Terug naar het competitieoverzicht

Competities

Competitie	Plaats	Wedstrijdverloop	Wedstrijden (voor–tegen)
Eredivisie Heren	6		18	6—12
Eredivisie Heren - Kampioenspoule	6		10	1—9
Nationale Beker Heren Voorronde B	60		0	0—0
Nationale Beker Heren 1/8 Finale	16		1	0—1

Spelers

	Rueben Schoones Libero		David Bes		Daniel Homburg
	Daniel Hoonhout Middenblokkeerder		Erik Kerp		Lesley Kef Passer/loper
	Jannes van der Ham Passer/loper		Joris Berkhout Spelverdeler		Kjeld Broekema Passer/loper
	Ferdy Wever Spelverdeler		Joris Burger		Erwin Huinen Diagonaalspeler
	Bas Roosendaal		Kían Macnack

Nieuws

Er zijn momenteel geen nieuwsberichten.

→ meer nieuws op de nieuwspagina

Teamstatistieken

Eredivisie Heren

	Totaal	Punt
Service	1284	60
Pass	1002
Aanval	1370	557
Blok		101
Totaal

Eredivisie Heren - Kampioenspoule

	Totaal	Punt
Service	491	23
Pass	409
Aanval	608	237
Blok		51
Totaal

Nationale Beker Heren Voorronde B

Totaal

Punt

Service

Pass

Aanval

Blok

Totaal

Nationale Beker Heren 1/8 Finale

Totaal

Punt

Service

Pass

Aanval

Blok

Totaal

© 2011 ORTEC

Total execution time: 0,17 seconds

18 queries executed:

SELECT `team`.`id`, `team`.`sid`, `team`.`club_id`, `team`.`name`, `team`.`short_name`, `team`.`code`, `team`.`sex`, `team`.`extra_info`, `team`.`dv_code`, `team`.`external_sid`, `team`.`external_id`, `team`.`city` FROM `team` WHERE `sid` = 'Zaanstad-HS-1-2018' ORDER BY `id` ASC
SELECT `league`.`id`, `league`.`sid`, `league`.`name`, `league`.`sex`, `league`.`scoring_model`, `league`.`date_begin`, `league`.`date_end`, `league`.`active`, `league`.`external_sid`, `league`.`dv_championship`, `league`.`season_id`, `league`.`competition_id`, `league`.`dv_poulenaam` FROM `league` WHERE id IN ( SELECT tl.league_id FROM team_league tl WHERE tl.team_id = 649 ) ORDER BY `id` ASC
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE COALESCE(home_sets, guest_sets) IS NOT NULL AND date IS NOT NULL AND `league_id` = 361 ORDER BY `id` ASC
SELECT `team`.`id`, `team`.`sid`, `team`.`club_id`, `team`.`name`, `team`.`short_name`, `team`.`code`, `team`.`sex`, `team`.`extra_info`, `team`.`dv_code`, `team`.`external_sid`, `team`.`external_id`, `team`.`city` FROM `team` WHERE id IN (SELECT team_id FROM team_league WHERE league_id = 361) ORDER BY `id` ASC
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE COALESCE(home_sets, guest_sets) IS NOT NULL AND date IS NOT NULL AND `league_id` = 363 ORDER BY `id` ASC
SELECT `team`.`id`, `team`.`sid`, `team`.`club_id`, `team`.`name`, `team`.`short_name`, `team`.`code`, `team`.`sex`, `team`.`extra_info`, `team`.`dv_code`, `team`.`external_sid`, `team`.`external_id`, `team`.`city` FROM `team` WHERE id IN (SELECT team_id FROM team_league WHERE league_id = 363) ORDER BY `id` ASC
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE COALESCE(home_sets, guest_sets) IS NOT NULL AND date IS NOT NULL AND `league_id` = 369 ORDER BY `id` ASC
SELECT `team`.`id`, `team`.`sid`, `team`.`club_id`, `team`.`name`, `team`.`short_name`, `team`.`code`, `team`.`sex`, `team`.`extra_info`, `team`.`dv_code`, `team`.`external_sid`, `team`.`external_id`, `team`.`city` FROM `team` WHERE id IN (SELECT team_id FROM team_league WHERE league_id = 369) ORDER BY `id` ASC
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE COALESCE(home_sets, guest_sets) IS NOT NULL AND date IS NOT NULL AND `league_id` = 391 ORDER BY `id` ASC
SELECT `team`.`id`, `team`.`sid`, `team`.`club_id`, `team`.`name`, `team`.`short_name`, `team`.`code`, `team`.`sex`, `team`.`extra_info`, `team`.`dv_code`, `team`.`external_sid`, `team`.`external_id`, `team`.`city` FROM `team` WHERE id IN (SELECT team_id FROM team_league WHERE league_id = 391) ORDER BY `id` ASC
SELECT `person`.`id`, `person`.`code`, `person`.`sid`, `person`.`first_name`, `person`.`middle_name`, `person`.`last_name`, `person`.`sex`, `person`.`length`, `person`.`date_of_birth`, `person`.`country_code`, position.name AS position, player_team.number AS number, membership_from, membership_to, (SELECT COUNT(0) FROM player_statistics_player_in_league WHERE player_id = person.id AND team_id = player_team.team_id) AS aantal_wedstrijden FROM player_team LEFT JOIN person ON (player_team.player_id = person.id) LEFT JOIN position ON (player_team.position_id = position.id) WHERE player_team.team_id = 649 GROUP BY person.id HAVING aantal_wedstrijden > 0 ORDER BY number ASC
SELECT `news`.`id`, `news`.`sid`, `news`.`title`, `news`.`body`, `news`.`date`, `news`.`author`, `news`.`active`, `news`.`permalink` FROM `news` WHERE `news`.id IN ( SELECT `news_id` FROM `news_team` WHERE `team_id` = 649 UNION SELECT `news_id` FROM `news_player_team` LEFT JOIN `player_team` ON (`news_player_team`.`player_team_id` = `player_team`.`id`) WHERE `player_id` IN ( SELECT `player_id` FROM `player_team` WHERE `team_id` = 649) ) AND active = 1 LIMIT 5
SELECT `skill`, `n_total`, `n_perfect`, `n_error`, `mean_score` FROM `player_statistics_team_in_league` WHERE `league_id` = 361 AND `team_id` = 649
SELECT `skill`, `n_total`, `n_perfect`, `n_error`, `mean_score` FROM `player_statistics_team_in_league` WHERE `league_id` = 363 AND `team_id` = 649
SELECT `skill`, `n_total`, `n_perfect`, `n_error`, `mean_score` FROM `player_statistics_team_in_league` WHERE `league_id` = 369 AND `team_id` = 649
SELECT `skill`, `n_total`, `n_perfect`, `n_error`, `mean_score` FROM `player_statistics_team_in_league` WHERE `league_id` = 391 AND `team_id` = 649
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE 649 IN (home_team_id, guest_team_id) AND COALESCE(home_sets, guest_sets) IS NOT NULL AND league_id IN (SELECT id FROM league WHERE active = 1) ORDER BY `date` DESC LIMIT 5
SELECT `match`.`id`, `match`.`sid`, `match`.`league_id`, `match`.`home_team_id`, `match`.`guest_team_id`, `match`.`location_id`, `match`.`date`, `match`.`home_sets`, `match`.`guest_sets`, `match`.`show_live_score`, `match`.`external_sid`, `match`.`round_id`, `match`.`referee1`, `match`.`referee2`, `match`.`delegate`, `match`.`line1`, `match`.`line2`, `match`.`line3`, `match`.`line4`, `match`.`finished`, `match`.`notes` FROM `match` WHERE 649 IN (home_team_id, guest_team_id) AND COALESCE(home_sets, guest_sets) IS NULL AND date IS NOT NULL AND league_id IN (SELECT id FROM league WHERE active = 1) ORDER BY `date` ASC LIMIT 3