• Home
  • Korean
  • K LEAGUE CLASSIC
  • K LEAGUE CHALLENGE
  • AFC Champions League
//final_margin="width:188px; margin-right:0px;"
  • CLASSIC
  • CHALLENGE
  • ACL
  • NEWS & MEDIA
  • CLUBS & PLAYERS
  • K LEAGUE
Select * From ( Select Top 3 A.game_id, A.game_date, A.game_time, A.home_team, (Select team_eng_name From t_tb_team Where team_id = A.home_team) As home_team_name, IsNull((Select Gain_Goal From g_tb_game_rec Where meet_year = A.meet_year And meet_seq = A.meet_seq And game_id = A.game_id And team_id = A.home_team), '') As home_gain_goal, A.away_team, (Select team_eng_name From t_tb_team Where team_id = A.away_team) As away_team_name, IsNull((Select Gain_Goal From g_tb_game_rec Where meet_year = A.meet_year And meet_seq = A.meet_seq And game_id = A.game_id And team_id = A.away_team), '') As away_gain_goal, A.MEET_YEAR, A.MEET_SEQ From l_Tb_Meet_Schedule A Where ((home_team = 'K01' And away_team = 'K03') Or (home_team = 'K03' And away_team = 'K01')) And meet_year = '2017' and a.game_date < replace(CONVERT(varchar(10), GETDATE(), 23), '-','/') Order By game_date Desc ) T1 Order By T1.game_date Select Top 1 T1.* From ( Select a.meet_year, a.meet_seq, a.game_id, a.player_Id, b.name_eng_s, a.back_no, a.position_code, (Select code_e_name From c_tb_com_code Where code_type = '42' And com_code = a.position_code) position_name, ISNULL((SELECT AVG(player_point) FROM dbo.g_tb_Player_rec_point WHERE (meet_year = A.meet_year) AND (Team_Id = A.team_id) AND (player_id = A.player_id) AND (game_id = A.game_id) AND (Gubun = 9)), 0) player_point, (Select SUM(Work_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) work_qty, (Select SUM(change_i_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) change_i_qty, (Select SUM(goal_a_qty + goal_b_qty + goal_e_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) goal_qty, (Select SUM(assist_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) assist_qty, (Select SUM(loss_point) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) loss_point, (Select SUM(st_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) st_qty, (Select SUM(st_valid_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) st_valid_qty, (Select SUM(fo_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) fo_qty, (Select SUM(fs_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) fs_qty, (Select SUM(os_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) os_qty, (Select SUM(ck_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) ck_qty, (Select SUM(warn_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) warn_qty, (Select SUM(exit_qty) From g_tb_player_rec Where meet_year = a.meet_year And meet_seq = a.meet_seq And player_id = a.player_id) exit_qty, b.corp_cd,G.team_eng_name From g_tb_game_entry a INNER JOIN p_tb_profile_info B ON B.Player_id = A.Player_id INNER JOIN t_tb_team G ON G.Team_id = B.corp_cd Where a.meet_year = '2017' And a.meet_seq = '1' And a.game_id = '1' ) T1 Inner Join g_tb_Player_rec_point_MOM C On C.meet_year = T1.meet_year And C.meet_seq = T1.meet_seq And C.game_id = T1.game_id And C.player_id = T1.player_Id Order By T1.player_point Desc select MOVIE,CHKINFO from BOARD_ENG where meet_year ='2017' and meet_seq ='1' and game_id ='1' order by I_NO desc

1st Division


K League
Classic

  • Match Schedule
  • Results
  • Stats

Match Result

2017-03-04 15:00 Ulsan Munsu JEONG Jaeyong 12,388
ULSAN
2
:
1
POHANG
Full time

Team Stats

ULSAN VS POHANG
1 Rank 4
16 GF 25
18 GA 22
52W 43D 60L HEAD-TO-HEAD 60W 43D 52L
3W 1D 1L Last 5 games 2W 0D 3L
5 Last 5 GAMES GF 7
3 Last 5 GAMES GA 8
Past Meetings
2017-03-04
ULSAN 2 : 1 POHANG
2017-06-17
POHANG 1 : 2 ULSAN

Best 11

Man of the Match

JEONG Jaeyong
MF / No.6
POINTS 7.5 APPEARANCES 13 SUBSTITUTION 1 GOALS 2
GOALS AGAINST 0 Shots 8 SHOTS ON GOAL 3 FOULS COMMITTED 18
FOULS SUFFERED 3 OFFSIDES 0 YELLOW CARDS 2 RED CARDS 0

Team Line Ups & Ratings

Home
ULSAN
Name P A G A L P
KIM Yongdae (No.1) GK 10 0 0 0 7
KIM Changsoo (No.27) DF 14 0 6 1 6.5
JEONG Seunghyeon (No.15) DF 12 0 8 0 6.5
LEE Kije (No.3) DF 4 0 2 1 6
Richard (No.40) DF 9 1 2 0 6
ORSIC Mislav (No.9) MF 16 4 62 0 6.5
LEE Yeongjae (No.32) MF 15 1 16 0 6.5
JEONG Jaeyong (No.6) MF 13 2 8 0 7.5
KIM Insung (No.7) MF 15 2 25 1 6
PETRATOS Dimitrios (No.70) FW 4 0 5 1 6
KOVACEC (No.44) FW 7 0 10 2 6.5
HAN Seunggyu (No.42) SUB 3 1 1 1 5
LEE Myeongjae (No.13) SUB 12 0 5 1 0
KIM Seungjoon (No.19) SUB 14 2 12 1 6.5
KANG Minsoo (No.4) SUB 11 0 1 0 5
JO Suhuk (No.21) SUB 6 0 0 0 0
HAN Sangwun (No.20) SUB 11 0 8 1 0
LEE Jongho (No.10) SUB 13 2 18 2 0
Away
POHANG
Name P A G A L P
NO Donggeon (No.21) GK 4 0 0 0 6.5
GWON Wangyu (No.13) DF 15 0 4 3 6
CHO Minwoo (No.20) DF 4 0 0 0 6
BAE Seulgi (No.24) DF 15 0 6 1 6
KANG Sangwoo (No.17) DF 14 0 6 0 6
SON Junho (No.8) MF 15 1 18 4 6
HWANG Jisoo (No.9) MF 8 0 0 0 5
Lulinha (No.10) MF 13 5 24 2 6
SHIM Dongwoon (No.11) FW 16 3 19 1 6
YANG Donghyeon (No.18) FW 15 11 43 2 6.5
LEE Gwanghyeok (No.12) FW 12 0 13 2 6
KANG Hyeonmu (No.31) SUB 12 0 0 0 0
LEE Seunghee (No.6) SUB 10 1 10 0 5
KIM Donggi (No.15) SUB 2 0 3 1 5
SEO Bomin (No.7) SUB 13 1 13 2 0
MARCUS NILSSON (No.25) SUB 0 0 0 0 0
JANG Chulyong (No.16) SUB 3 0 0 0 0
LEE Sanggi (No.19) SUB 15 1 6 1 5.5

Headlines

[1R] ULSAN 2 vs 1 POHANG

KEB HANABANK K LEAGUE 2017 1RULSAN 2 vs 1 POHANG

2017-03-17

Match Summary

6 JEONG Jaeyong
25
29
6 LEE Seunghee (9)
27 KIM Changsoo
34
1st Relax
(70) 42 HAN Seunggyu
10
3 LEE Kije
26
26
18 YANG Donghyeon
(A.42) 6 JEONG Jaeyong
29
31
19 LEE Sanggi (12)
32
19 LEE Sanggi
37
18 YANG Donghyeon (A.24)
(A.44) 6 JEONG Jaeyong
41
(7) 19 KIM Seungjoon
41
41
7 SEO Bomin (11)
(9) 4 KANG Minsoo
46