Ilvars pārtrauc Žaņa uzvaru sēriju

– tika aizvadīts 2019. gada sezonas get_results(‘select count(*) as skaits from (SELECT * FROM `result` WHERE date <= "' . $t_date . '" and YEAR(date) = ' . strftime("%G", strtotime($t_date)) . ' group by date) a'); echo($tournaments[0]->skaits); ?>. posms kurā piedalījās get_results(‘
SELECT count(*) as players
FROM result
WHERE date = “‘ . $t_date . ‘”‘);
echo($players[0]->players);
?> dalībnieki.

Izslēgšanas spēles

Fināls
Žanis Buklovskis	71,51	2:4	69,71	Ilvars Draulis (109)
Par 3. vietu
Valters Melderis (13., 180)	71,39	3:1	57,69	Uldis Zeitmanis
Pusfināli
Žanis Buklovskis	66,92	3:1	67,94	Valters Melderis
Ilvars Draulis (17.)	65,78	3:1	66,94	Uldis Zeitmanis
Ceturtdaļfināli
Žanis Buklovskis	60,12	3:1	52,96	Jurijs Botvinko
Valters Melderis (15., 104, 180)	71,57	3:0	70,32	Jānis Pinka (180 x3)
Ilvars Draulis	62,63	3:0	52,87	Edgars Ziemulis
Arnis Kupčs	53,66	1:3	55,96	Uldis Zeitmanis
Astotdaļfināli
Denijs Nērings	46,43	0:3	64,41	Edgars Ziemulis (180)

Apakšgrupu spēles

1. grupa
Spēlētājs	1	2	3	4	P-ti	Legi	Vieta	Statistika
Žanis Buklovskis		2:1	2:0	2:0	3	6:1	1	16., 100, 180
Edgars Ziemulis	1:2		0:2	2:0	1	3:4	3
Uldis Zeitmanis	0:2	2:0		2:0	2	4:2	2
Kirils Staruhins	0:2	0:2	0:2		0	0:6	4
2. grupa
Spēlētājs	1	2	3	4	P-ti	Legi	Vieta	Statistika
Ilvars Draulis		3:2	3:0		2	6:2	1
Jānis Pinka	2:3		3:0		1	5:3	2	15., 100, 102
Rihards Vosulis-Grigulis	0:3	0:3			0	0:6	3
3. grupa
Spēlētājs	1	2	3	4	P-ti	Legi	Vieta	Statistika
Juris Straubergs		3:1	1:3		1	4:4	3
Arnis Kupčs	1:3		3:1		1	4:4	1
Jurijs Botvinko	3:1	1:3			1	4:4	2
4. grupa
Spēlētājs	1	2	3	4	P-ti	Legi	Vieta	Statistika
Valters Melderis		3:0	3:0		2	6:0	1	14., 17., 180
Adrians Djačuks	0:3		1:3		0	1:6	3
Denijs Nērings	0:3	3:1			1	3:4	2

Gandarījuma turnīrs

Fināls:
Juris Straubergs 0:2 Kirils Staruhins

Pusfināli:
Adrians Djačuks 0:2 Juris Straubergs
Rihards Vosulis – Grigulis 0:2 Kirils Staruhins

Fināla video

Statistikas apkopojums:

get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”F”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”F” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>

name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>

ach : ‘,’ . $player->ach);
$i++;
}
?>

Fināla statistika

get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”P”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”P” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>

name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>

ach : ‘,’ . $player->ach);
$i++;
}
?>

Izslēgšanas spēļu statistika

get_results(‘SELECT players.name as name, players.surname as surname, s1.achivement as ach, (select count(1) from statistika s2 where s2.player_id = s1.player_id and s2.date = “‘ . $t_date . ‘” and s2.stype=”G”) as ach_c FROM players, statistika s1 where players.id = s1.player_id and s1.date = “‘ . $t_date . ‘” and s1.stype=”G” order by ach_c desc, players.surname’);
$len = count($players);
$i = 0;
foreach( $players as $player){
$player_name = ($player_name == ” ? $player->name . ‘ ‘ . $player->surname : $player_name);
$new_player_name = $player->name . ‘ ‘ . $player->surname;
if($player_name != $new_player_name){
?>

name . ‘ ‘ . $player->surname;
}
if($i == $len-1){
$achiv .= ($achiv == ” ? $player->ach : ‘,’ . $player->ach);
?>

ach : ‘,’ . $player->ach);
$i++;
}
?>

Apakšgrupu spēļu statistika

Papildus informācija

Paddy Whelans . gada sezonas reitinga darts reitinga kopvērtējums” href=”http://www.paddydarts.lv/reitings/#“> kopvērtējums..

Paddy Whelans . gada sezonas darts statistika” href=”http://www.paddydarts.lv/statistika/#“>statistika.

Sacensības katru ceturtdienu no 19:30 notiek Vecrīgas krodziņa Paddy Whelan`s Irish Pub telpās. Dāmām šajā turnīrā tiek piedāvāts handikaps 100 punkti katrā legā.

Laipni aicināts ikviens interesents, kurš vēlas iemācīties šo lielisko spēli vai arī parādīt uz ko ir spējīgs.

Nākamā get_results(‘select count(*) as skaits from (SELECT * FROM `result` WHERE date <= "' . $t_date . '" and YEAR(date) = ' . strftime("%G", strtotime($t_date)) . ' group by date) a'); echo($tournaments[0]->skaits + 1); ?>. posma norises laiks: pulksten 19:30.