¿Eres mayor de edad?

SI NO

Confirma si tienes 18 años

Faldón apuestas
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Virtus Ciserano Bergamo - Città di Varese
Jornada 2
FINALIZADO
20
20
441 Pts. Elo
2º

273 Pts. Elo
7º

4-3
Domingo, 11 Septiembre 2022, 15:00
Samuele Careccia 3'
1 - 0
1 - 1
 15' C. Ferrario
Angelo Panatti 17'
2 - 1
2 - 2
 48' D. Disabato
M. Bertoli 67'
3 - 2
Angelo Panatti 72'
4 - 2
4 - 3
 77' F. Mapelli

Eventos del partido

Goles

Samuele CarecciaGol de
Samuele Careccia
minuto 3'
minuto 15'C. FerrarioGol de C. Ferrario
Angelo PanattiGol de
Angelo Panatti
minuto 17'
minuto 48'D. DisabatoGol de falta D. Disabato
M. BertoliGol de
M. Bertoli
minuto 67'
Angelo PanattiGol de
Angelo Panatti
minuto 72'
minuto 77'F. MapelliGol de F. Mapelli

Tarjetas

minuto 46'M. PastoreT. Amarilla M. Pastore
Riccardo NessiT. Amarilla
Riccardo Nessi
minuto 46'
minuto 46'M. MonticoneT. Amarilla M. Monticone
Angelo PanattiT. Amarilla
Angelo Panatti
minuto 46'

Cambios

Giorgio VitaliEntra en el partido
Giorgio Vitali
minuto 74'
Angelo PanattiSale del partido
Angelo Panatti
minuto 74'
minuto 74'R. CappaiEntra en el partido R. Cappai
minuto 74'Luca PiracciniSale del partido Luca Piraccini
minuto 74'Andrea MalinvernoEntra en el partido Andrea Malinverno
minuto 74'D. DisabatoSale del partido D. Disabato
F. BelloliSale del partido
F. Belloli
minuto 78'
Marco MontiEntra en el partido
Marco Monti
minuto 78'
minuto 87'Gianluca ParpinelSale del partido Gianluca Parpinel
minuto 87'N. BattistellaEntra en el partido N. Battistella
minuto 87'Nicolas TruosoloSale del partido Nicolas Truosolo
minuto 87'R. GoffiEntra en el partido R. Goffi
M. BertoliSale del partido
M. Bertoli
minuto 87'
Davide CaraffaEntra en el partido
Davide Caraffa
minuto 87'
Samuele CarecciaSale del partido
Samuele Careccia
minuto 92'
A. TarascoEntra en el partido
A. Tarasco
minuto 92'

Alineaciones

Virtus Ciserano Bergamo

Virtus Ciserano Bergamo

4-4-2
Alineación Inicial
Suplentes
Città di Varese

Città di Varese

4-4-2
Alineación Inicial
Suplentes



  USO DE MEMORIA  
6,799,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2720
Total Execution Time  0.2730
  CADENA URL  
/partido/Ssd-Virtus-Ciserano-Bergamo/Asd-Citta-Di-Varese/2023?section=legal
  GET DATOS  
$_GET['/partido/Ssd-Virtus-Ciserano-Bergamo/Asd-Citta-Di-Varese/2023']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0045   SELECT c.*, c.stadium as real_stadium, 2024 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2024 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Ssd-Virtus-Ciserano-Bergamo' AND dt2.basealias = 'Asd-Citta-Di-Varese'
0.0035   SELECT c.*, c.stadium as real_stadium, 2025 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2025 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Ssd-Virtus-Ciserano-Bergamo' AND dt2.basealias = 'Asd-Citta-Di-Varese'
0.0019  SELECT data1 FROM stats2023 t WHERE league_id = 68748 AND teamId = 6535817 and type = 33
0.0019  SELECT data1 FROM stats2023 t WHERE league_id = 68748 AND teamId = 6535809 and type = 33
0.0025  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '334101' and rp.type = 2023 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 334101 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 334101 AND year = 2023 AND channel = 'Footters' LIMIT 1
0.0044  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68748 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='334101' AND `active` = 1 AND year = 2023
0.0068  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='68748' AND relp.team_id=6535817 WHERE relp.in_squad=1 and mp.`match_id` = '334101' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0067  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='68748' AND relp.team_id=6535809 WHERE relp.in_squad=1 and mp.`match_id` = '334101' AND mp.year='2023' ORDER BY mp.`team` ASC, p.`role` ASC
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=334101 AND extraId = 68748 AND type_rel = 4
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 334101 AND league_id = 68748 AND year = 2023