• 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
6 GF 12
13 GA 8
51W 43D 60L HEAD-TO-HEAD 60W 43D 51L
1W 2D 2L Last 5 games 3W 1D 1L
4 Last 5 GAMES GF 9
9 Last 5 GAMES GA 6
Past Meetings
2017-03-04
ULSAN 2 : 1 POHANG

Best 11

Man of the Match

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

Team Line Ups & Ratings

Home
ULSAN
Name P A G A L P
KIM Yongdae (No.1) GK 6 0 0 0 7
KIM Changsoo (No.27) DF 5 0 3 0 6.5
JEONG Seunghyeon (No.15) DF 7 0 8 0 6.5
LEE Kije (No.3) DF 4 0 2 1 6
Richard (No.40) DF 4 0 1 0 6
ORSIC Mislav (No.9) MF 7 1 25 0 6.5
LEE Yeongjae (No.32) MF 7 1 8 0 6.5
JEONG Jaeyong (No.6) MF 4 2 4 0 7.5
KIM Inseong (No.7) MF 6 1 10 0 6
PETRATOS Dimitrios (No.70) FW 4 0 5 1 6
KOVACEC (No.44) FW 5 0 6 2 6.5
HAN SEUNG GYU (No.42) SUB 1 0 0 1 5
LEE Myungjae (No.13) SUB 3 0 3 0 0
KIM Seungjoon (No.19) SUB 5 0 3 0 6.5
KANG Minsoo (No.4) SUB 2 0 0 0 5
JO Suhuk (No.21) SUB 1 0 0 0 0
HAN Sangwun (No.20) SUB 4 0 6 1 0
LEE Jongho (No.10) SUB 4 0 4 0 0
Away
POHANG
Name P A G A L P
NO Donggeon (No.21) GK 2 0 0 0 6.5
GWON Wangyu (No.13) DF 7 0 3 3 6
CHO MINWOO (No.20) DF 2 0 0 0 6
BAE Seulgi (No.24) DF 7 0 2 1 6
KANG Sangwoo (No.17) DF 6 0 3 0 6
SON Junho (No.8) MF 7 1 12 1 6
HWANG Jisoo (No.9) MF 1 0 0 0 5
Lulinha (No.10) MF 6 3 11 1 6
SHIM Dongwoon (No.11) FW 7 1 6 0 6
YANG Donghyen (No.18) FW 7 5 25 1 6.5
LEE Gwanghyeok (No.12) FW 3 0 5 0 6
KANG Hyeonmu (No.31) SUB 5 0 0 0 0
LEE, SEUNGHEE (No.6) SUB 7 0 6 0 5
D.G.KIM (No.15) SUB 0 0 0 0 5
SEO Bomin (No.7) SUB 7 1 10 1 0
MARCUS NILSSON (No.25) SUB 0 0 0 0 0
JANG CHULYONG (No.16) SUB 2 0 0 0 0
LEE SANGGI (No.19) SUB 6 0 1 0 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 SEUNG GYU
10
3 LEE Kije
26
26
18 YANG Donghyen
(A.42) 6 JEONG Jaeyong
29
31
19 LEE SANGGI (12)
32
19 LEE SANGGI
37
18 YANG Donghyen (A.24)
(A.44) 6 JEONG Jaeyong
41
(7) 19 KIM Seungjoon
41
41
7 SEO Bomin (11)
(9) 4 KANG Minsoo
46