4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Resultados
« Jornada Anterior
Jornada 38
 
 
28 Abr 24
Sin comenzar 		AlbinoLeffe AlbinoLeffe
16:30
 		Lumezzane Lumezzane más información ...
 
28 Abr 24
Sin comenzar 		US Alessandria US Alessandria
16:30
 		Vicenza Vicenza más información ...
 
28 Abr 24
Sin comenzar 		Arzignano Valchiampo Arzignano Valchiampo
16:30
 		Atalanta Sub 23 Atalanta Sub 23 más información ...
 
28 Abr 24
Sin comenzar 		Giana Erminio Giana Erminio
16:30
 		Pergolettese Pergolettese más información ...
 
28 Abr 24
Sin comenzar 		Mantova Mantova
16:30
 		Legnago Salus Legnago Salus más información ...
 
28 Abr 24
Sin comenzar 		Novara Novara
16:30
 		Fiorenzuola Fiorenzuola más información ...
28 Abr 24
Sin comenzar 		Padova Padova
16:30
 		Triestina Triestina más información ...
 
28 Abr 24
Sin comenzar 		Pro Sesto Pro Sesto
16:30
 		Pro Patria Pro Patria más información ...
 
28 Abr 24
Sin comenzar 		Trento Trento
16:30
 		Renate Renate más información ...
 
28 Abr 24
Sin comenzar 		Virtus Verona Virtus Verona
16:30
 		Pro Vercelli Pro Vercelli más información ...
Clasificación
« Jornada Anterior
Jornada 38
 
Equipos Puntos J. G. E. P. F. C. Forma
1 Mantova Mantova 79 37 24 7 6 71 30
  • EMPATE
  • Trento 1
  • Mantova 1
  • EMPATE
  • Mantova 1
  • Atalanta Sub 23 1
  • DERROTA
  • Renate 2
  • Mantova 0
  • DERROTA
  • Mantova 1
  • Vicenza 2
  • DERROTA
  • Lumezzane 4
  • Mantova 3
2 Padova Padova 74 37 20 14 3 52 26
  • DERROTA
  • Pro Vercelli 2
  • Padova 0
  • VICTORIA
  • Padova 2
  • Pergolettese 1
  • EMPATE
  • Lumezzane 1
  • Padova 1
  • VICTORIA
  • Padova 2
  • Atalanta Sub 23 0
  • EMPATE
  • Fiorenzuola 1
  • Padova 1
3 Vicenza Vicenza 68 37 19 11 7 50 29
  • EMPATE
  • Vicenza 1
  • Legnago Salus 1
  • VICTORIA
  • Vicenza 2
  • Novara 1
  • EMPATE
  • Pro Sesto 1
  • Vicenza 1
  • VICTORIA
  • Mantova 1
  • Vicenza 2
  • VICTORIA
  • Vicenza 2
  • Trento 0
4 Triestina Triestina 64 37 19 7 11 59 41
  • VICTORIA
  • Arzignano Valchiam. 1
  • Triestina 2
  • EMPATE
  • Triestina 1
  • Atalanta Sub 23 1
  • DERROTA
  • Triestina 0
  • Virtus Verona 1
  • VICTORIA
  • Giana Erminio 0
  • Triestina 1
  • EMPATE
  • Triestina 2
  • Novara 2
5 Atalanta Sub 23 Atalanta Sub 23 58 37 16 10 11 42 35
  • EMPATE
  • Mantova 1
  • Atalanta Sub 23 1
  • EMPATE
  • Triestina 1
  • Atalanta Sub 23 1
  • VICTORIA
  • Atalanta Sub 23 4
  • Pro Patria 1
  • DERROTA
  • Padova 2
  • Atalanta Sub 23 0
  • VICTORIA
  • Atalanta Sub 23 3
  • Pro Sesto 0
6 Legnago Salus Legnago Salus 55 37 13 16 8 45 38
  • EMPATE
  • Vicenza 1
  • Legnago Salus 1
  • EMPATE
  • Pro Patria 1
  • Legnago Salus 1
  • EMPATE
  • Legnago Salus 2
  • Pro Sesto 2
  • DERROTA
  • Novara 2
  • Legnago Salus 0
  • EMPATE
  • Legnago Salus 0
  • US Alessandria 0
7 Giana Erminio Giana Erminio 53 37 15 8 14 46 43
  • VICTORIA
  • Giana Erminio 3
  • US Alessandria 0
  • VICTORIA
  • Giana Erminio 2
  • Fiorenzuola 0
  • EMPATE
  • Trento 0
  • Giana Erminio 0
  • DERROTA
  • Giana Erminio 0
  • Triestina 1
  • VICTORIA
  • Renate 0
  • Giana Erminio 2
8 Pro Vercelli Pro Vercelli 50 37 13 11 13 49 47
  • VICTORIA
  • Pro Vercelli 2
  • Padova 0
  • EMPATE
  • US Alessandria 1
  • Pro Vercelli 1
  • VICTORIA
  • Pro Vercelli 3
  • AlbinoLeffe 1
  • DERROTA
  • Trento 1
  • Pro Vercelli 0
  • VICTORIA
  • Pro Vercelli 2
  • Arzignano Valchiam. 0
9 Lumezzane Lumezzane 50 37 14 8 15 46 46
  • VICTORIA
  • Lumezzane 3
  • Virtus Verona 1
  • EMPATE
  • Novara 1
  • Lumezzane 1
  • EMPATE
  • Lumezzane 1
  • Padova 1
  • DERROTA
  • Pro Sesto 2
  • Lumezzane 1
  • VICTORIA
  • Lumezzane 4
  • Mantova 3
10 Trento Trento 48 37 12 12 13 33 37
  • EMPATE
  • Trento 1
  • Mantova 1
  • EMPATE
  • AlbinoLeffe 2
  • Trento 2
  • EMPATE
  • Trento 0
  • Giana Erminio 0
  • VICTORIA
  • Trento 1
  • Pro Vercelli 0
  • DERROTA
  • Vicenza 2
  • Trento 0
11 Virtus Verona Virtus Verona 47 37 12 11 14 35 42
  • DERROTA
  • Lumezzane 3
  • Virtus Verona 1
  • EMPATE
  • Virtus Verona 0
  • Renate 0
  • VICTORIA
  • Triestina 0
  • Virtus Verona 1
  • DERROTA
  • Virtus Verona 1
  • Pergolettese 2
  • VICTORIA
  • Pro Patria 1
  • Virtus Verona 3
12 Pro Patria Pro Patria 46 37 12 10 15 37 50
  • DERROTA
  • Fiorenzuola 3
  • Pro Patria 1
  • EMPATE
  • Pro Patria 1
  • Legnago Salus 1
  • DERROTA
  • Atalanta Sub 23 4
  • Pro Patria 1
  • VICTORIA
  • US Alessandria 1
  • Pro Patria 2
  • DERROTA
  • Pro Patria 1
  • Virtus Verona 3
13 AlbinoLeffe AlbinoLeffe 45 37 10 15 12 32 34
  • EMPATE
  • AlbinoLeffe 1
  • Pro Sesto 1
  • EMPATE
  • AlbinoLeffe 2
  • Trento 2
  • DERROTA
  • Pro Vercelli 3
  • AlbinoLeffe 1
  • EMPATE
  • AlbinoLeffe 0
  • Renate 0
  • EMPATE
  • Pergolettese 1
  • AlbinoLeffe 1
14 Renate Renate 45 37 11 12 14 35 45
  • DERROTA
  • Renate 0
  • Arzignano Valchiam. 3
  • EMPATE
  • Virtus Verona 0
  • Renate 0
  • VICTORIA
  • Renate 2
  • Mantova 0
  • EMPATE
  • AlbinoLeffe 0
  • Renate 0
  • DERROTA
  • Renate 0
  • Giana Erminio 2
15 Arzignano Valchiampo Arzignano 43 37 10 13 14 31 36
  • VICTORIA
  • Renate 0
  • Arzignano Valchiam. 3
  • DERROTA
  • Arzignano Valchiam. 1
  • Triestina 2
  • EMPATE
  • Pergolettese 1
  • Arzignano Valchiam. 1
  • VICTORIA
  • Arzignano Valchiam. 3
  • Fiorenzuola 0
  • DERROTA
  • Pro Vercelli 2
  • Arzignano Valchiam. 0
16 Pergolettese Pergolettese 42 37 12 6 19 43 50
  • EMPATE
  • Pergolettese 1
  • Novara 1
  • DERROTA
  • Padova 2
  • Pergolettese 1
  • EMPATE
  • Pergolettese 1
  • Arzignano Valchiam. 1
  • VICTORIA
  • Virtus Verona 1
  • Pergolettese 2
  • EMPATE
  • Pergolettese 1
  • AlbinoLeffe 1
17 Novara Novara 40 37 7 19 11 37 49
  • EMPATE
  • Pergolettese 1
  • Novara 1
  • EMPATE
  • Novara 1
  • Lumezzane 1
  • DERROTA
  • Vicenza 2
  • Novara 1
  • VICTORIA
  • Novara 2
  • Legnago Salus 0
  • EMPATE
  • Triestina 2
  • Novara 2
18 Fiorenzuola Fiorenzuola 38 37 10 8 19 38 60
  • VICTORIA
  • Fiorenzuola 3
  • Pro Patria 1
  • DERROTA
  • Giana Erminio 2
  • Fiorenzuola 0
  • VICTORIA
  • Fiorenzuola 2
  • US Alessandria 0
  • DERROTA
  • Arzignano Valchiam. 3
  • Fiorenzuola 0
  • EMPATE
  • Fiorenzuola 1
  • Padova 1
19 Pro Sesto Pro Sesto 32 37 6 14 17 24 40
  • EMPATE
  • AlbinoLeffe 1
  • Pro Sesto 1
  • EMPATE
  • Legnago Salus 2
  • Pro Sesto 2
  • EMPATE
  • Pro Sesto 1
  • Vicenza 1
  • VICTORIA
  • Pro Sesto 2
  • Lumezzane 1
  • DERROTA
  • Atalanta Sub 23 3
  • Pro Sesto 0
20 US Alessandria US Alessandria 23 37 5 8 24 19 46
  • DERROTA
  • Triestina 3
  • US Alessandria 1
  • EMPATE
  • US Alessandria 1
  • Pro Vercelli 1
  • DERROTA
  • Fiorenzuola 2
  • US Alessandria 0
  • DERROTA
  • US Alessandria 1
  • Pro Patria 2
  • EMPATE
  • Legnago Salus 0
  • US Alessandria 0
Ascenso : Mantova
Playoff Ascenso : Padova, Vicenza
Siguiente Ronda : Triestina, Atalanta Sub 23, Legnago Salus, Giana Erminio, Pro Vercelli, Lumezzane, Trento
Posible siguiente ronda : Virtus Verona
Playoff Descenso : Pergolettese, Novara, Fiorenzuola, Pro Sesto
Descenso : US Alessandria
JUGADORES DESTACADOS

INFORMACIÓN


Lega Pro Prima Divisione (Serie C1)
1º Asciende
2º Playoff
3º Playoff
4º Playoff
5º Playoff
14º Playout
15º Playout
16º Playout
17º Playout
18º Descenso.

Serie C

28 Abr 24 16:30
Stadio Comunale Euganeo
28 Abr 24 16:30
Stadio Danilo Martelli
28 Abr 24 16:30
Stadio Tommaso Dal Molin
28 Abr 24 16:30
Centro Sportivo Mario Gavagnin-Sinibaldo Nocini
28 Abr 24 16:30
AlbinoLeffe Stadium

  USO DE MEMORIA  
6,382,072 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1382
Total Execution Time  0.1401
  CADENA URL  
/serie_c1
  GET DATOS  
$_GET['/serie_c1']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'serie_c1' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-25 10:25:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-25 10:25:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-25 10:25:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-25 10:25:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0029  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72299) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0029  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72299) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (207914,207470,681744,878351,977510,115777,735843,874714,3210745,583365,359087,343332,364410,875904,884819,3174163,3293995,1203,203680,217694) ORDER BY rp.in_squad = 1 DESC
0.0038  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72299) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0028  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72299) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (281802,347676,141521,735843,772467,778634,120762,203691,413748,582398,582699,693210,206533,207980,239953,340344,472420,583365,827172,11768) ORDER BY rp.in_squad = 1 DESC
0.0020  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72299) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0026  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72299) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (429739,583991,826651,826676,880919,1203,11768,44217,51512,119317,120762,149493,192123,201188,203680,203691,206533,206646,207980,207995) ORDER BY rp.in_squad = 1 DESC
0.0024  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72299) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0031  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (72299) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (11731,274814,138800,583951,3210745,203691,681924,693397,98905,201481,480515,697137,772467,125335,207403,207914,291105,398101,692805,884819) ORDER BY rp.in_squad = 1 DESC
0.0023  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72299 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0167  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72299 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0020  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72299 AND rel.round=38
0.0018  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 72299 AND esl.points > 0
0.0032  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 72299 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0020  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72299 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (482307,482308,482309,482310,482311,482312,482313,482314,482315,482316) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0035  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 38 AND e.real_date IS NOT NULL AND e.league_id = 72299 ORDER BY total DESC LIMIT 40
0.0144  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 72299 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0025  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 `tables2024` 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 = 72299 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0048  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 72299 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72299 AND shedule >= '2024/04/01' AND shedule < '2024/05/01' ORDER BY shedule ASC
0.0018  SELECT data1, data2 FROM services_tags WHERE categoryId=90
0.0025  SELECT group_code, extraName from `leagues` WHERE categoryId=90 AND year=2024