Venue: Urheilukeskus, Uusikaupunki
Event
Time
Scorer
Assist
Code
0-1 07:12 Joona Vettenranta 0-2 14:57 Ville Pirhonen
Event
Time
Scorer
Assist
Code
0-3 17:37 Riku Prokki Toni Westerholm 0-4 19:21 Ville Pirhonen Riku Malminen 1-4 19:58 Peter Söderlund Emil Sandberg 1-5 24:26 Jukka Palenius 1-6 24:43 Ville Pirhonen Joona Vettenranta 1-7 26:34 Jere Tuovila Samu Lamminen 2 min 27:32 Robert Lindell Mailan lyöminen 1-8 28:36 Jere Tuovila Samu Lamminen
Event
Time
Scorer
Assist
Code
2 min 34:06 Peter Söderlund Mailan lyöminen 34:41 SC Saragoza Aikalisä 1-9 37:59 Timo Mäenpää Jere Tuovila 1-10 41:30 Riku Malminen Riku Prokki
DEBUG: GET=array(1) {
["id"]=>
string(3) "897"
}
DEBUG: POST=array(0) {
}
DEBUG: matchid = int(897)
DEBUG: WP DB Name: scsarago
DEBUG: WP Table Prefix: avc8_
DEBUG: Använder tabell: scsarago_za.spelare (quoted: `scsarago_za`.`spelare`) DEBUG INFO:
MatchID: 897
Lag A: SC Saragoza
Lag B: Karhut
RAW QUERY A:
SELECT * FROM `scsarago_za`.`spelare` WHERE `MatchID` = 897 AND `lag` LIKE '{a23f5c9636c1cb967aeefa55edf1814ece6c801f3da1c83e968063651d2413f0}SC Saragoza{a23f5c9636c1cb967aeefa55edf1814ece6c801f3da1c83e968063651d2413f0}' ORDER BY `nummer` ASC
RAW QUERY B:
SELECT * FROM `scsarago_za`.`spelare` WHERE `MatchID` = 897 AND `lag` LIKE '{a23f5c9636c1cb967aeefa55edf1814ece6c801f3da1c83e968063651d2413f0}Karhut{a23f5c9636c1cb967aeefa55edf1814ece6c801f3da1c83e968063651d2413f0}' ORDER BY `nummer` ASC DEBUG: Resultat Lag A (rows): 14
array(14) {
[0]=>
object(stdClass)#5744 (12) {
["spelare"]=>
string(5) "21703"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "1"
["namn"]=>
string(18) "Christoffer Hedman"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[1]=>
object(stdClass)#5745 (12) {
["spelare"]=>
string(5) "21704"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "5"
["namn"]=>
string(14) "Björn Lindell"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[2]=>
object(stdClass)#5746 (12) {
["spelare"]=>
string(5) "21705"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "6"
["namn"]=>
string(13) "Emil Sandberg"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[3]=>
object(stdClass)#5747 (12) {
["spelare"]=>
string(5) "21706"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "10"
["namn"]=>
string(14) "Jesse Palmberg"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[4]=>
object(stdClass)#5748 (12) {
["spelare"]=>
string(5) "21707"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "12"
["namn"]=>
string(16) "Mikko Lauhaluoma"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[5]=>
object(stdClass)#5749 (12) {
["spelare"]=>
string(5) "21708"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "15"
["namn"]=>
string(15) "Pekka Karjanmaa"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[6]=>
object(stdClass)#5507 (12) {
["spelare"]=>
string(5) "21709"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "19"
["namn"]=>
string(10) "Niko Laine"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[7]=>
object(stdClass)#7540 (12) {
["spelare"]=>
string(5) "21710"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "21"
["namn"]=>
string(10) "Puja Heino"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[8]=>
object(stdClass)#5741 (12) {
["spelare"]=>
string(5) "21711"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "22"
["namn"]=>
string(14) "Robert Lindell"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "2"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[9]=>
object(stdClass)#5740 (12) {
["spelare"]=>
string(5) "21712"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "23"
["namn"]=>
string(12) "Timmy Rehula"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[10]=>
object(stdClass)#5739 (12) {
["spelare"]=>
string(5) "21713"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "27"
["namn"]=>
string(14) "Jens Granqvist"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[11]=>
object(stdClass)#5738 (12) {
["spelare"]=>
string(5) "21714"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "66"
["namn"]=>
string(16) "Peter Söderlund"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "2"
["kapten"]=>
string(1) "C"
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[12]=>
object(stdClass)#5737 (12) {
["spelare"]=>
string(5) "21715"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "92"
["namn"]=>
string(22) "Hans-Henrik Nordström"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[13]=>
object(stdClass)#5736 (12) {
["spelare"]=>
string(5) "21716"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "99"
["namn"]=>
string(14) "Tommy Dahlgren"
["lag"]=>
string(11) "SC Saragoza"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
}
DEBUG: Resultat Lag B (rows): 19
array(19) {
[0]=>
object(stdClass)#5735 (12) {
["spelare"]=>
string(5) "21717"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "1"
["namn"]=>
string(10) "Otto Valin"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(1) "M"
["malvakt"]=>
string(1) "1"
["raddningar"]=>
string(1) "0"
}
[1]=>
object(stdClass)#5734 (12) {
["spelare"]=>
string(5) "21718"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "3"
["namn"]=>
string(16) "Kristian Mattila"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[2]=>
object(stdClass)#5733 (12) {
["spelare"]=>
string(5) "21719"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "4"
["namn"]=>
string(17) "Joona Vettenranta"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[3]=>
object(stdClass)#5732 (12) {
["spelare"]=>
string(5) "21720"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "5"
["namn"]=>
string(15) "Jussi Taipalmaa"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[4]=>
object(stdClass)#5731 (12) {
["spelare"]=>
string(5) "21721"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(1) "7"
["namn"]=>
string(13) "Tatu Ruohonen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(1) "C"
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[5]=>
object(stdClass)#5730 (12) {
["spelare"]=>
string(5) "21722"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "15"
["namn"]=>
string(13) "Samu Lamminen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "2"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[6]=>
object(stdClass)#5729 (12) {
["spelare"]=>
string(5) "21723"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "17"
["namn"]=>
string(13) "Tino Lamminen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[7]=>
object(stdClass)#5728 (12) {
["spelare"]=>
string(5) "21724"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "20"
["namn"]=>
string(15) "Miikka Virtanen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[8]=>
object(stdClass)#5727 (12) {
["spelare"]=>
string(5) "21725"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "21"
["namn"]=>
string(14) "Mikko Kyytinen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[9]=>
object(stdClass)#5726 (12) {
["spelare"]=>
string(5) "21726"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "23"
["namn"]=>
string(14) "Jukka Palenius"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[10]=>
object(stdClass)#5725 (12) {
["spelare"]=>
string(5) "21727"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "27"
["namn"]=>
string(19) "Juha-Pekka Kaukonen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[11]=>
object(stdClass)#5724 (12) {
["spelare"]=>
string(5) "21728"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "32"
["namn"]=>
string(14) "Eero Puistonen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[12]=>
object(stdClass)#5723 (12) {
["spelare"]=>
string(5) "21729"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "42"
["namn"]=>
string(11) "Riku Prokki"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[13]=>
object(stdClass)#5722 (12) {
["spelare"]=>
string(5) "21730"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "69"
["namn"]=>
string(15) "Toni Westerholm"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[14]=>
object(stdClass)#5721 (12) {
["spelare"]=>
string(5) "21731"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "77"
["namn"]=>
string(12) "Teemu Kallio"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "0"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[15]=>
object(stdClass)#5720 (12) {
["spelare"]=>
string(5) "21732"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "88"
["namn"]=>
string(14) "Ville Pirhonen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "3"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[16]=>
object(stdClass)#5719 (12) {
["spelare"]=>
string(5) "21733"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "89"
["namn"]=>
string(12) "Jere Tuovila"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "2"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[17]=>
object(stdClass)#5718 (12) {
["spelare"]=>
string(5) "21734"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "96"
["namn"]=>
string(15) "Timo Mäenpää"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "0"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
[18]=>
object(stdClass)#5717 (12) {
["spelare"]=>
string(5) "21735"
["MatchID"]=>
string(3) "897"
["kategori"]=>
string(3) "C88"
["nummer"]=>
string(2) "99"
["namn"]=>
string(13) "Riku Malminen"
["lag"]=>
string(6) "Karhut"
["mal"]=>
string(1) "1"
["assist"]=>
string(1) "1"
["utvisningar"]=>
string(1) "0"
["kapten"]=>
string(0) ""
["malvakt"]=>
string(1) "0"
["raddningar"]=>
string(1) "0"
}
}
DEBUG: WPDB last_query after A: string(112) "SELECT * FROM `scsarago_za`.`spelare` WHERE `MatchID` = 897 AND `lag` LIKE '%SC Saragoza%' ORDER BY `nummer` ASC"
DEBUG: WPDB last_error A: string(0) ""
DEBUG: WPDB last_query after B: string(107) "SELECT * FROM `scsarago_za`.`spelare` WHERE `MatchID` = 897 AND `lag` LIKE '%Karhut%' ORDER BY `nummer` ASC"
DEBUG: WPDB last_error B: string(0) ""
Lineups SC Saragoza No. Name Goals Assists 1 Christoffer Hedman 0 0 5 Björn Lindell 0 0 6 Emil Sandberg 0 1 10 Jesse Palmberg 0 0 12 Mikko Lauhaluoma 0 0 15 Pekka Karjanmaa 0 0 19 Niko Laine 0 0 21 Puja Heino 0 0 22 Robert Lindell 0 0 23 Timmy Rehula 0 0 27 Jens Granqvist 0 0 66 Peter Söderlund 1 0 92 Hans-Henrik Nordström 0 0 99 Tommy Dahlgren 0 0
Karhut No. Name Goals Assists 1 Otto Valin 0 0 3 Kristian Mattila 0 0 4 Joona Vettenranta 1 1 5 Jussi Taipalmaa 0 0 7 Tatu Ruohonen 0 0 15 Samu Lamminen 0 2 17 Tino Lamminen 0 0 20 Miikka Virtanen 0 0 21 Mikko Kyytinen 0 0 23 Jukka Palenius 1 0 27 Juha-Pekka Kaukonen 0 0 32 Eero Puistonen 0 0 42 Riku Prokki 1 1 69 Toni Westerholm 0 1 77 Teemu Kallio 0 0 88 Ville Pirhonen 3 0 89 Jere Tuovila 2 1 96 Timo Mäenpää 1 0 99 Riku Malminen 1 1
Rosters
Statistics
Player leaderboard
88
Ville Pirhonen
3+0=3
89
Jere Tuovila
2+1=3
4
Joona Vettenranta
1+1=2
42
Riku Prokki
1+1=2
99
Riku Malminen
1+1=2
15
Samu Lamminen
0+2=2
66
Peter Söderlund 1+0=1
23
Jukka Palenius
1+0=1
96
Timo Mäenpää
1+0=1
6
Emil Sandberg 0+1=1
69
Toni Westerholm
0+1=1
Penalized players
Goals against
Saves
Save percentage
Referees
Mikko Heikkilä and Tero Pietilä
Match pictures
The scoresheet contains the registered stats for the games that the teams have played in the series facilitated by the Finnish Floorball Federation. In addition to that you’ll find the players personal statistics and pictures from the game. If you would happen to have pictures or videoclips from this particular game or any other games, please contact us.
Like this: Like Loading...
