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

Gzira United



Мальта
1947
Gzira

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

Дата Д/Г Т команда счет ПТ ВТ У Ж К
16.09.2018 Г Ч Sliema Wanderers 2 - 0 1-0 1-0 - 2-3 0-1
25.08.2018 Д Ч Hamrun Spartans 0 - 0 0-0 0-0 - 3-1 0-0
18.08.2018 Г Ч Tarxien Rainbows 4 - 1 2-0 2-1 - 2-4 0-0
19.07.2018 Д ЛЕ Radnički Niš 0 - 1 0-1 0-0 3-5 1-1 0-0
12.07.2018 Г ЛЕ Radnički Niš 0 - 4 0-1 0-3 4-6 2-3 0-0
05.07.2018 Д ЛЕ Sant Julià 2 - 1 0-0 2-1 3-6 1-5 0-1
26.06.2018 Г ЛЕ Sant Julià 2 - 0 - 2-0 - 0-0 0-0
11.02.2017 Д Ч St. Andrews 3 - 2 1-1 2-1 - 3-2 0-0
05.02.2017 Г Ч Биркиркара 1 - 2 0-2 1-0 - 6-6 2-0
29.01.2017 Д Ч Floriana 4 - 3 0-1 4-2 - 3-3 0-0
22.01.2017 Д Ч Хибернианc 0 - 3 0-1 0-2 - 2-2 0-0
14.01.2017 Г Ч Valletta 0 - 1 0-0 0-1 - 1-3 0-0
08.01.2017 Д Ч Balzan 1 - 2 1-1 0-1 - 2-4 0-0
18.12.2016 Г Ч Pembroke Athleta 0 - 0 0-0 0-0 - 4-4 0-1
10.12.2016 Д Ч Mosta 3 - 0 3-0 0-0 - 6-8 0-2
04.12.2016 Г Ч Sliema Wanderers 0 - 1 0-1 0-0 - 4-4 0-0
26.11.2016 Д Ч Hamrun Spartans 0 - 2 0-0 0-2 - 8-2 0-0
19.11.2016 Г Ч Tarxien Rainbows 0 - 1 0-0 0-1 - 4-5 0-0
05.11.2016 Г Ч St. Andrews 0 - 1 0-1 0-0 - 0-3 0-0
28.10.2016 Г Ч Floriana 0 - 1 0-1 0-0 - 4-4 0-0

Состав

J. Haber вратарь 270 3 3 0 0 0 0 0 0 0
A. Curmi вратарь 0 0 0 0 0 2 0 0 0 0
A. Curmi вратарь 0 0 0 0 0 2 0 0 0 0
D. Mambouana защитник 180 2 2 0 0 0 1 0 0 0
J. Schembri защитник 0 0 0 0 0 2 0 0 0 0
L. Brincat защитник 18 2 0 2 0 2 0 0 0 0
T. Veronese защитник 168 2 2 0 1 0 0 0 0 0
D. Muscat защитник 0 0 0 0 0 2 0 0 0 0
C. Gatt Baldacchino защитник 191 3 2 1 0 1 0 1 0 0
Rodolfo Soares защитник 270 3 3 0 0 0 0 1 0 0
N. Borg защитник 0 0 0 0 0 1 0 0 0 0
S. Borg защитник 102 2 1 1 0 2 0 0 0 0
N. Muscat защитник 180 2 2 0 0 0 0 0 0 0
E. Bilbao полузащитник 269 3 3 0 1 0 1 2 0 0
Z. Scerri полузащитник 179 3 2 1 1 1 0 0 0 0
A. Cohen полузащитник 177 2 2 0 1 0 0 0 0 0
R. Briffa полузащитник 90 1 1 0 0 0 0 0 0 0
J. Corbalan полузащитник 270 3 3 0 0 0 0 1 0 0
M. Attard полузащитник 0 0 0 0 0 1 0 0 0 0
M. Lamlun нападающий 0 1 0 1 0 3 0 0 0 0
A. Samb нападающий 256 3 3 0 2 0 3 1 0 0

(default) 9 queries took 230 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Country`.`code`, `Country`.`title_ru` FROM `user9368_football`.`countries` AS `Country` WHERE 1 = 12662664
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 = 12662663
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` = 2279 LIMIT 1115
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` = 'MLT') OR (`code3` = 'MLT')) LIMIT 11114
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` = 2279 GROUP BY competition_title_id, season ORDER BY FIELD(competition_type, 'liga','cup','international','nation'), season DESC9929
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` = 2279 AND `FootballPlayerTeamsStat`.`competition_title_id` = 660 AND `FootballPlayerTeamsStat`.`season` = '2018/2019' GROUP BY player_id ORDER BY FIELD(position, 'attacker','midfielder','defender','goalkeeper') DESC212116
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` = 2279) OR (`FootballMatch`.`team2_id` = 2279)) ORDER BY `match_date` desc LIMIT 202020143
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 (92436, 92426, 92422, 78263, 78262, 78161, 78160, 51421, 51416, 51410, 51403, 51396, 51392, 51384, 51377, 51373, 51364, 51359, 51355, 51346)1321329
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 (92436, 92426, 92422, 78263, 78262, 78161, 78160, 51421, 51416, 51410, 51403, 51396, 51392, 51384, 51377, 51373, 51364, 51359, 51355, 51346)007