¿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
Cosmos - Pennarossa
FINALIZADO
20
10
879 Pts. Elo

121 Pts. Elo
16º

6-2
Martes, 12 Marzo 2024, 21:15
M. Prandelli 2'
1 - 0
Lorenzo Pastorelli 8'
2 - 0
M. Ben Kacem 13'
3 - 0
M. Ben Kacem 23'
4 - 0
Sergio Di Stasio 61'
5 - 0
5 - 1
77' G. Strologo
5 - 2
90' Davide Montalti
A. Isaraj 93'
6 - 2

Eventos del partido

Goles

M. PrandelliGol de
M. Prandelli
minuto 2'
Lorenzo PastorelliGol de
Lorenzo Pastorelli
minuto 8'
M. Ben KacemGol de
M. Ben Kacem
minuto 13'
M. Ben KacemGol de
M. Ben Kacem
minuto 23'
Sergio Di StasioGol de
Sergio Di Stasio
minuto 61'
minuto 77'G. StrologoGol de G. Strologo
minuto 90'Davide MontaltiGol de Davide Montalti
A. Isaraj Gol de (p.p)
A. Isaraj
minuto93'

Tarjetas

minuto 36'A. IsarajT. Amarilla A. Isaraj
A. D'addarioT. Amarilla
A. D'addario
minuto 51'
Brando SamiT. Amarilla
Brando Sami
minuto 89'

Cambios

minuto 36'Manuel MarroneEntra en el partido Manuel Marrone
minuto 36'Daniel VolunniSale del partido Daniel Volunni
R. Di MaioSale del partido
R. Di Maio
minuto 46'
M. PalazziEntra en el partido
M. Palazzi
minuto 46'
Lorenzo PastorelliSale del partido
Lorenzo Pastorelli
minuto 46'
E. MolinasEntra en el partido
E. Molinas
minuto 46'
S. SantiEntra en el partido
S. Santi
minuto 58'
M. Ben KacemSale del partido
M. Ben Kacem
minuto 58'
Marco BarbiniEntra en el partido
Marco Barbini
minuto 58'
A. D'addarioSale del partido
A. D'addario
minuto 58'
minuto 68'R. SpagnolettiEntra en el partido R. Spagnoletti
minuto 68'D. SalahSale del partido D. Salah
minuto 68'Andre RuggeriSale del partido Andre Ruggeri
minuto 68'A. BoschiEntra en el partido A. Boschi
R. ZulliSale del partido
R. Zulli
minuto 73'
F. RighiniEntra en el partido
F. Righini
minuto 73'

Alineaciones




  USO DE MEMORIA  
6,757,960 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.5721
Total Execution Time  0.5731
  CADENA URL  
/partido/Cosmos/Pennarossa/2021?section=legal
  GET DATOS  
$_GET['/partido/Cosmos/Pennarossa/2021']  
$_GET['section']   legal
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0254  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73483
0.0127  SELECT data1 FROM stats2024 t WHERE league_id = 73483 AND teamId = 6602908 and type = 33
0.0125  SELECT data1 FROM stats2024 t WHERE league_id = 73483 AND teamId = 6602916 and type = 33
0.0127  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '549989' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 549989 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0126  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 549989 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0130  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73483 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='549989' AND `active` = 1 AND year = 2024
0.0169  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='73483' AND relp.team_id=6602908 WHERE relp.in_squad=1 and mp.`match_id` = '549989' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0156  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='73483' AND relp.team_id=6602916 WHERE relp.in_squad=1 and mp.`match_id` = '549989' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=549989 AND extraId = 73483 AND type_rel = 4
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=305 AND type_rel = 3
0.0132  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 305 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0135  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1294805,1002860,835971,501177,353759) ORDER BY n.cover_points DESC, update_date DESC
0.0130  SELECT * FROM futbol.calendars_lineups WHERE id = 549989 AND league_id = 73483 AND year = 2024