4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Monte Azul Sub 20 - Coritiba Sub 20
Jornada 2
FINALIZADO
11
20
3 Pts. Elo
117º

142 Pts. Elo
10º

0-5
Lunes, 08 Enero 2024, 17:15
0 - 1
 47' J. Vinícius
0 - 2
 54' Ruan Assis
0 - 3
 60' Keder
0 - 4
 65' Leo Lima
0 - 5
 91' R. Fonseca

Eventos del partido

Goles

minuto 47'J. ViníciusGol de J. Vinícius
minuto 54'Ruan AssisGol de Ruan Assis
minuto 60'KederGol de Keder
minuto 65'Leo LimaGol de Leo Lima
minuto 91'R. FonsecaGol de R. Fonseca

Tarjetas

minuto 20'G. AquinoT. Amarilla G. Aquino
GuiottiTarjeta Roja a
Guiotti
minuto 22'
João VitorT. Amarilla
João Vitor
minuto 39'
minuto 79'R. FonsecaT. Amarilla R. Fonseca

Cambios

minuto 17'João VitorSale del partido João Vitor
minuto 17'BrayanEntra en el partido Brayan
Vitor SilvaEntra en el partido
Vitor Silva
minuto 23'
Kauan UberabaSale del partido
Kauan Uberaba
minuto 23'
minuto 46'NetoSale del partido Neto
minuto 46'Leo LimaEntra en el partido Leo Lima
V. SabinoEntra en el partido
V. Sabino
minuto 52'
NatanSale del partido
Natan
minuto 52'
LeabeSale del partido
Leabe
minuto 52'
MendonçaEntra en el partido
Mendonça
minuto 52'
YanEntra en el partido
Yan
minuto 63'
NicolasEntra en el partido
Nicolas
minuto 63'
Leonardo PinheiroEntra en el partido
Leonardo Pinheiro
minuto 63'
JuninhoSale del partido
Juninho
minuto 63'
João VitorSale del partido
João Vitor
minuto 63'
Allan ReboredoSale del partido
Allan Reboredo
minuto 63'
minuto 68'LohanEntra en el partido Lohan
minuto 68'KederSale del partido Keder
minuto 68'J. GabrielSale del partido J. Gabriel
minuto 68'BrayanSale del partido Brayan
minuto 68'WhalacyEntra en el partido Whalacy
minuto 68'R. FonsecaEntra en el partido R. Fonseca
minuto 77'KauaEntra en el partido Kaua
minuto 77'J. ViníciusSale del partido J. Vinícius

Otros

minuto 47'F. GuimarãesAsistencia F. Guimarães
minuto 54'KederAsistencia Keder
minuto 65'Lucas RonierAsistencia Lucas Ronier

Alineaciones

Monte Azul Sub 20

Monte Azul Sub 20

4-4-2
Alineación Inicial
Suplentes
Coritiba Sub 20

Coritiba Sub 20

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

Monte Azul Sub 20 Monte Azul Coritiba Sub 20 Coritiba
0
Goles
 5
1
Tarjetas Rojas
 0
0
Asistencias
 3
3
Sustituciones
 3
0 Comentarios

No hay comentarios


Clasificación | Jornada 2

1 Tanabi
2 Ponte Preta
3 Vila Nova
4 Atlético
5 Catanduva
6 Athlético
7 Portuguesa
8 Sociedade
9 Coimbra
10 Mirassol
11 Sampaio
12 ABC Sub 20
13 Grêmio
14 Serra Branca
15 Figueirense
16 Inter
17 Botafogo
18 Tiradentes
19 Francana
20 Claro
21 Chapecoense
22 Novorizontin
23 Jacuipense
24 Comercial
25 Ferroviária
26 São Paulo
27 Carajas
28 Porto
29 Ceará
30 Gama Sub 20
31 Rondoniense
32 Lemense
33 Atlético
34 Operário
35 Guarani
36 Tupã
37 Corinthians
38 Bangu
39 Marilia
40 Parana
41 Fortaleza
42 CRB Sub 20
43 Vocem
44 Castanhal
45 Internaciona
46 Jaú
47 Velo Clube
48 Santa Cruz.
49 Fluminense
50 Grêmio
51 Lagarto
52 São
53 Criciúma
54 Ituano
55 Itapirense
56 Atlético
57 Capital
58 América
59 Ivinhema
60 Comercial
61 Desportivo
62 Santa Cruz
63 Capivariano
64 Branco
65 Sfera
66 Botafogo
67 América
68 Fast Sub 20
69 Atlético
70 Brasil
71 Floresta
72 Timon
73 Flamengo
74 Osasco Audax
75 São José
76 São Bento
77 Trindade
78 Nautico
79 Piracicaba
80 Sharjah
81 Bragantino
82 Atl.
83 Bahia
84 Joinville
85 Cuiabá
86 Taubaté
87 Inter
88 Patriotas
89 Aster Brasil
90 Sport Recife
91 Santo Andre
92 Cruzeiro
93 Palmeiras
94 Oeste
95 União
96 Queimadense
97 Juventude
98 São
99 Conquista
100 Portuguesa
101 Santos
102 Água Santa
103 Remo Sub 20
104 Nova
105 Portuguesa
106 Madureira
107 Goiás
108 União
109 Nova Mutum
110 Cruzeiro
111 Capital
112 União Mogi
113 Flamengo
114 Vasco Gama
115 Macapá
116 Potyguar
117 Ibrachina
118 Vitória
119 CSA Sub 20
120 Picos
121 Coritiba
122 Juventus
123 Canaã
124 Monte Azul
125 Avaí
126 Retrô
127 Nacional
128 São Caetano

  USO DE MEMORIA  
8,154,288 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Match / Index )  0.5400
Total Execution Time  0.5411
  CADENA URL  
/partido/Monte-Azul-Sub20/Coritiba-U20-Juvenil/2024
  GET DATOS  
$_GET['/partido/Monte-Azul-Sub20/Coritiba-U20-Juvenil/2024']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (50)  
0.0010   SELECT COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`league_id` = '74740' AND c.`match_id` = '640931'
0.0055   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 = 'Monte-Azul-Sub20' AND dt2.basealias = 'Coritiba-U20-Juvenil'
0.0023  SELECT c.*, 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, dt1.id 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 datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Monte-Azul-Sub20' AND dt2.basealias = 'Coritiba-U20-Juvenil'
0.0039  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 = 74740
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=640931 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0026   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=74740 WHERE dp.id IN (989466,3227099,3199662,3371565,3343751,3227094,3219082,3405167,3371564,3439849,3402872,3482944,3321143,3514166,3516077,3284457,3400273,3408460,3482567,3226416,3274747,3394429,3480913,3141949,3343753,3160189,3227096,3227095) AND (rp.team_id=6621674 OR rp.team_id=6621666)
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2024 AS ev WHERE ev.match_id=640931 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0024   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=74740 WHERE dp.id IN (3371564,3439849,3227094,3219082,3402872,3482944,3405167,3321143,3371565,989466,3227096,3514166,3516077,3284457,3400273,3227099,3199662,3408460,3482567,3226416,3274747,3394429,3227095,3480913,3141949,3343753,3343751,3160189) AND (rp.team_id=6621674 OR rp.team_id=6621666)
0.0018  SELECT data1 FROM stats2024 t WHERE league_id = 74740 AND teamId = 6621674 and type = 33
0.0017  SELECT data1 FROM stats2024 t WHERE league_id = 74740 AND teamId = 6621666 and type = 33
0.0018  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74740 AND id_match = 640931
0.0021  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74740' AND relp.team_id = drea.team_id WHERE rel.team_number=5174174 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0021  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='74740' AND relp.team_id = drea.team_id WHERE rel.team_number=5174173 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0026  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='74740' AND relp.team_id=6621674 WHERE mp.`match_id` = '640931' AND mp.year='2024' AND p.id NOT IN (3227101,3227096,3227094,3371564,3275011,3141949,989466,3199662,3321143,3227095,3227099,3219082,3372313,3487381,3408455,3274747,3284457,3405167,3516077,3394429,3482944,3226497) ORDER BY mp.`team` ASC, p.`role` ASC
0.0034  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='74740' AND relp.team_id=6621666 WHERE mp.`match_id` = '640931' AND mp.year='2024' AND p.id NOT IN (3227101,3227096,3227094,3371564,3275011,3141949,989466,3199662,3321143,3227095,3227099,3219082,3372313,3487381,3408455,3274747,3284457,3405167,3516077,3394429,3482944,3226497) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 74740 AND id_match = 640931
0.0018  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '640931' and rp.type = 2024 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '640931' and rp.type = 2024 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 74740 AND rel.team1 = 6621674 AND rel.team2 = 6621666 ORDER BY FIELD(m.location,'es','en') DESC
0.0021  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 640931 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0017  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 640931 AND year = 2024 AND channel = 'Footters' LIMIT 1
0.0020  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 74740 AND rel.team1 = 6621674 AND rel.team2 = 6621666 ORDER BY FIELD(m.location,'es','en') DESC
0.0017  SELECT teamId FROM teams WHERE id = 6621674
0.0017  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 146333 OR c.datateam2 = 146333) ORDER BY shedule DESC LIMIT 10
0.0021  SELECT teamId FROM teams WHERE id = 6621666
0.0022  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 100374 OR c.datateam2 = 100374) ORDER BY shedule DESC LIMIT 10
0.0018  SELECT teamId FROM teams WHERE id = 6621674
0.0053  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 146333 OR c.datateam2 = 146333) ORDER BY shedule ASC LIMIT 10
0.0028  SELECT teamId FROM teams WHERE id = 6621666
0.0022  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2024 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2024 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 100374 OR c.datateam2 = 100374) ORDER BY shedule ASC LIMIT 10
0.0021  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2024` WHERE league_id = 74740 AND round >= 3 AND round <= 3 AND team = 6621674 ORDER BY round ASC
0.0069  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 = 74740 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0059  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2024 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2024 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2024 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 6621674 AND c.team2 = 6621666 AND c.league_id = 74740
0.0027  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='640931' AND `active` = 1 AND year = 2024
0.0024  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='640931' AND `active` = 1 AND year = 2024
0.0025  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='74740' AND relp.team_id=6621674 WHERE relp.in_squad=1 and mp.`match_id` = '640931' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0022  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='74740' AND relp.team_id=6621666 WHERE relp.in_squad=1 and mp.`match_id` = '640931' AND mp.year='2024' ORDER BY mp.`team` ASC, p.`role` ASC
0.0023  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '74740' AND id_match = '640931'
0.0033   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5174174' ORDER BY rating DESC LIMIT 1
0.0037   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '5174173' ORDER BY rating DESC LIMIT 1
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=640931 AND extraId = 74740 AND type_rel = 4
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1914 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1914 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0020  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 (1161390,1106893,1105863,1097896,1097878) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=640931 AND league_id=74740 AND year=2024
0.0019  SELECT avg_rating FROM elo_teams WHERE id=146333
0.0019  SELECT avg_rating FROM elo_teams WHERE id=100374
0.0019  SELECT position FROM tables2024 WHERE team=6621674 AND league_id=74740 AND round=2
0.0019  SELECT position FROM tables2024 WHERE team=6621666 AND league_id=74740 AND round=2
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 640931 AND league_id = 74740 AND year = 2024