Футбольная статистика

Grbalj



Черногория
1970
Radanovici bb, Grbalj 81318 Radanovici

Последние матчи

Дата Д/Г Т команда счет ПТ ВТ У Ж К
19.09.2018 Д Ч Sutjeska 0 - 1 - 0-1 - 0-0 0-0
15.09.2018 Д Ч Будучност 0 - 1 0-0 0-1 - 1-1 0-0
01.09.2018 Г Ч Zeta 0 - 0 0-0 0-0 - 1-1 0-0
25.08.2018 Д Ч Mladost 0 - 1 0-0 0-1 - 2-2 0-0
18.08.2018 Г Ч Iskra 0 - 0 0-0 0-0 - 1-5 0-0
15.08.2018 Д Ч Rudar 0 - 1 0-1 0-0 - 2-5 0-1
11.08.2018 Г Ч Petrovac 1 - 0 0-0 1-0 - 3-2 0-0
04.08.2018 Д Ч Lovćen 0 - 1 0-0 0-1 - 2-1 0-0
27.05.2017 Д Ч Petrovac 1 - 0 0-0 1-0 - 0-1 0-0
20.05.2017 Г Ч Rudar 0 - 0 0-0 0-0 - 4-6 0-0
13.05.2017 Д Ч Iskra 2 - 3 1-2 1-1 - 2-2 0-0
10.05.2017 Г Ч Bokelj 0 - 0 0-0 0-0 - 3-2 0-0
06.05.2017 Д Ч Lovćen 0 - 3 0-2 0-1 - 4-6 0-0
30.04.2017 Г Ч Будучност 2 - 0 1-0 1-0 - 2-1 0-0
22.04.2017 Д Ч Mladost 0 - 0 0-0 0-0 - 0-2 0-0
15.04.2017 Г Ч Zeta 1 - 0 1-0 0-0 - 2-2 0-0
08.04.2017 Д Ч Dečić 0 - 1 0-0 0-1 - 1-1 0-0
01.04.2017 Г Ч Sutjeska 0 - 0 0-0 0-0 - 3-0 0-0
28.03.2017 Д Ч Jedinstvo 1 - 0 0-0 1-0 - 0-3 0-0
18.03.2017 Д Ч Будучност 1 - 1 - 1-1 - 0-0 0-0

Состав

M. Kordić вратарь 630 7 7 0 0 0 0 1 0 0
P. Kašćelan защитник 270 4 3 1 0 0 0 0 0 0
A. Milić защитник 356 4 4 0 1 0 0 0 0 0
Ć. Manojlović защитник 540 6 6 0 0 0 0 3 0 0
P. Jović защитник 630 7 7 0 0 0 0 3 0 0
P. Kašćelan защитник 270 4 3 1 0 0 0 0 0 0
S. Đorđević полузащитник 193 3 2 1 1 0 0 0 0 0
P. Vukčević полузащитник 584 7 7 0 2 0 0 1 0 0
I. Racković полузащитник 212 6 1 5 1 0 0 0 0 0
L. Pajović полузащитник 16 2 0 2 0 0 0 0 0 0
S. Bošković полузащитник 28 2 0 2 0 0 0 0 0 0
I. Mijušković полузащитник 629 7 7 0 1 0 0 2 0 0
J. Montenegro полузащитник 570 7 7 0 3 0 0 1 0 0
M. Merdović полузащитник 378 5 4 1 0 0 0 0 0 0
D. Kotorac полузащитник 553 7 6 1 1 0 0 0 0 0
N. Stanišić полузащитник 22 2 0 2 0 0 0 1 0 0
N. Vlahović полузащитник 243 5 3 2 3 0 0 0 0 0
Z. Dragićević нападающий 407 6 5 1 3 0 1 0 0 0
M. Džugurdić нападающий 43 1 1 0 1 0 0 0 0 0
N. Popović нападающий 528 6 6 0 1 0 0 1 0 0
A. Gavrilovich
Notice (8): Undefined index:  [APP/View/Elements/Football/_team_roster_table.ctp, line 23]
22 2 0 2 0 0 0 1 0 0

(default) 9 queries took 238 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662662
2SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662662
3SELECT `FootballTeam`.`id`, `FootballTeam`.`title`, `FootballTeam`.`title_ru`, `FootballTeam`.`country`, `FootballTeam`.`external_main_id`, `FootballTeam`.`founded`, `FootballTeam`.`address`, `FootballTeam`.`img`, `FootballTeam`.`date_updated` FROM `user9368_football`.`football_teams` AS `FootballTeam` WHERE `FootballTeam`.`id` = 836 LIMIT 1112
4SELECT `Country`.`code`, `Country`.`code2`, `Country`.`title_ru`, `Country`.`title_en`, `Country`.`title_ru_full`, `Country`.`code_num`, `Country`.`code3` FROM `user9368_football`.`countries` AS `Country` WHERE ((`code` = 'MNE') OR (`code3` = 'MNE')) LIMIT 1113
5SELECT * FROM `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` LEFT JOIN `user9368_football`.`competition_titles` AS `CompetitionTitle` ON (`FootballPlayerTeamsStat`.`competition_title_id` = `CompetitionTitle`.`id`) WHERE `FootballPlayerTeamsStat`.`team_id` = 836 GROUP BY competition_title_id, season ORDER BY FIELD(competition_type, 'liga','cup','international','nation'), season DESC151563
6SELECT * FROM `user9368_football`.`football_player_teams_stats` AS `FootballPlayerTeamsStat` INNER JOIN `user9368_football`.`football_players` AS `FootballPlayer` ON (`FootballPlayer`.`id` = `FootballPlayerTeamsStat`.`player_id`) LEFT JOIN `user9368_football`.`countries` AS `Country` ON (`FootballPlayer`.`country` = `Country`.`code`) WHERE `FootballPlayerTeamsStat`.`team_id` = 836 AND `FootballPlayerTeamsStat`.`competition_title_id` = 437 AND `FootballPlayerTeamsStat`.`season` = '2018/2019' GROUP BY player_id ORDER BY FIELD(position, 'attacker','midfielder','defender','goalkeeper') DESC212123
7SELECT `FootballMatch`.`id`, `FootballMatch`.`football_competition_id`, `FootballMatch`.`round`, `FootballMatch`.`team1_id`, `FootballMatch`.`team2_id`, `FootballMatch`.`score_titile`, `FootballMatch`.`score1`, `FootballMatch`.`score2`, `FootballMatch`.`half_score1`, `FootballMatch`.`half_score2`, `FootballMatch`.`external_main_id`, `FootballMatch`.`match_date`, `FootballMatch`.`stadium_id`, `FootballMatch`.`attendance`, `FootballMatch`.`main_referee_id`, `FootballMatch`.`assistant_referee1_id`, `FootballMatch`.`assistant_referee2_id`, `FootballMatch`.`fourth_referee_id`, `FootballMatch`.`corner1`, `FootballMatch`.`corner2`, `FootballMatch`.`shots_target1`, `FootballMatch`.`shots_target2`, `FootballMatch`.`shots_wide1`, `FootballMatch`.`shots_wide2`, `FootballMatch`.`fouls1`, `FootballMatch`.`fouls2`, `FootballMatch`.`offsides1`, `FootballMatch`.`offsides2`, `FootballMatch`.`ready`, `FootballMatch`.`extra_score1`, `FootballMatch`.`extra_score2`, `FootballMatch`.`penalty_score1`, `FootballMatch`.`penalty_score2`, `FootballMatch`.`possession1`, `FootballMatch`.`possession2`, `FootballMatch`.`date_updated`, `FootballMatch`.`date_created`, `FootballTeam1`.`id`, `FootballTeam1`.`title`, `FootballTeam1`.`title_ru`, `FootballTeam1`.`country`, `FootballTeam1`.`external_main_id`, `FootballTeam1`.`founded`, `FootballTeam1`.`address`, `FootballTeam1`.`img`, `FootballTeam1`.`date_updated`, `FootballTeam2`.`id`, `FootballTeam2`.`title`, `FootballTeam2`.`title_ru`, `FootballTeam2`.`country`, `FootballTeam2`.`external_main_id`, `FootballTeam2`.`founded`, `FootballTeam2`.`address`, `FootballTeam2`.`img`, `FootballTeam2`.`date_updated`, `FootballCompetition`.`id`, `FootballCompetition`.`title`, `FootballCompetition`.`title_ru`, `FootballCompetition`.`year_from`, `FootballCompetition`.`year_to`, `FootballCompetition`.`country`, `FootballCompetition`.`type`, `FootballCompetition`.`subtype`, `FootballCompetition`.`external_main_id`, `FootballCompetition`.`image`, `FootballCompetition`.`country_order`, `FootballCompetition`.`main_order`, `FootballCompetition`.`parent_id`, `FootballCompetition`.`child_order` FROM `user9368_football`.`football_matches` AS `FootballMatch` LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam1` ON (`FootballMatch`.`team1_id` = `FootballTeam1`.`id`) LEFT JOIN `user9368_football`.`football_teams` AS `FootballTeam2` ON (`FootballMatch`.`team2_id` = `FootballTeam2`.`id`) LEFT JOIN `user9368_football`.`football_competitions` AS `FootballCompetition` ON (`FootballMatch`.`football_competition_id` = `FootballCompetition`.`id`) WHERE `ready` = 1 AND ((`FootballMatch`.`team1_id` = 836) OR (`FootballMatch`.`team2_id` = 836)) ORDER BY `match_date` desc LIMIT 202020125
8SELECT `FootballMatchCard`.`id`, `FootballMatchCard`.`football_match_id`, `FootballMatchCard`.`team_id`, `FootballMatchCard`.`player_id`, `FootballMatchCard`.`type`, `FootballMatchCard`.`minute`, `FootballMatchCard`.`extra_minute` FROM `user9368_football`.`football_match_cards` AS `FootballMatchCard` WHERE `FootballMatchCard`.`football_match_id` IN (88200, 88191, 88190, 88182, 88179, 88173, 88168, 88164, 57518, 57508, 57505, 57497, 57492, 57486, 57479, 57475, 57466, 57464, 57453, 56038)777713
9SELECT `Video`.`id`, `Video`.`title`, `Video`.`title_ru`, `Video`.`url`, `Video`.`image`, `Video`.`country`, `Video`.`match_id`, `Video`.`date_created` FROM `user9368_football`.`videos` AS `Video` WHERE `Video`.`match_id` IN (88200, 88191, 88190, 88182, 88179, 88173, 88168, 88164, 57518, 57508, 57505, 57497, 57492, 57486, 57479, 57475, 57466, 57464, 57453, 56038)005