Jornada 1
15 Ago 21 Liverpool Sub 23Liverpool 0 - 0 Man. City Sub 23Man. City ...
16 Ago 21 Blackburn Rovers Sub 23Blackburn 2 - 2 Everton Sub 23Everton ...
16 Ago 21 Crystal Palace Sub 23Crystal 1 - 3 Leeds United Sub 23Leeds ...
16 Ago 21 Derby County Sub 23Derby 0 - 2 Brighton & Hove Sub 23Brighton ...
15 Ago 21 Man. Utd Sub 23Man. 2 - 2 Leicester Sub 23Leicester ...
16 Ago 21 Tottenham Hotspur Sub 23Tottenham 2 - 2 Chelsea Sub 23Chelsea ...
16 Ago 21 West Ham Sub 23West 6 - 1 Arsenal Sub 23Arsenal ...
20 Ago 21 Arsenal Sub 23Arsenal 4 - 2 Crystal Palace Sub 23Crystal ...
20 Ago 21 Brighton & Hove Sub 23Brighton 4 - 2 West Ham Sub 23West ...
20 Ago 21 Chelsea Sub 23Chelsea 1 - 1 Man. Utd Sub 23Man. ...
Jornada 2
20 Ago 21 Man. City Sub 23Man. City 4 - 2 Blackburn Rovers Sub 23Blackburn ...
23 Ago 21 Leeds United Sub 23Leeds 2 - 4 Tottenham Hotspur Sub 23Tottenham 4
23 Ago 21 Everton Sub 23Everton 1 - 3 Liverpool Sub 23Liverpool ...
15 Abr 22 Leicester Sub 23Leicester 2 - 1 Derby County Sub 23Derby 1
27 Ago 21 Tottenham Hotspur Sub 23Tottenham 1 - 2 Arsenal Sub 23Arsenal ...
27 Ago 21 Blackburn Rovers Sub 23Blackburn 1 - 1 Leicester Sub 23Leicester ...
27 Ago 21 Crystal Palace Sub 23Crystal 3 - 1 Everton Sub 23Everton ...
27 Ago 21 Derby County Sub 23Derby 2 - 3 Leeds United Sub 23Leeds ...
28 Ago 21 Man. Utd Sub 23Man. 2 - 4 Man. City Sub 23Man. City ...
28 Ago 21 Liverpool Sub 23Liverpool 1 - 1 Brighton & Hove Sub 23Brighton ...
Jornada 3
29 Ago 21 West Ham Sub 23West 2 - 1 Chelsea Sub 23Chelsea ...
10 Sep 21 Brighton & Hove Sub 23Brighton 4 - 1 Blackburn Rovers Sub 23Blackburn ...
10 Sep 21 Everton Sub 23Everton 1 - 0 Derby County Sub 23Derby ...
11 Sep 21 Arsenal Sub 23Arsenal 3 - 1 Man. Utd Sub 23Man. ...
11 Sep 21 Leeds United Sub 23Leeds 2 - 2 West Ham Sub 23West ...
11 Sep 21 Man. City Sub 23Man. City 4 - 1 Chelsea Sub 23Chelsea ...
11 Sep 21 Tottenham Hotspur Sub 23Tottenham 2 - 1 Liverpool Sub 23Liverpool ...
13 Sep 21 Leicester Sub 23Leicester 1 - 6 Crystal Palace Sub 23Crystal ...
17 Sep 21 Blackburn Rovers Sub 23Blackburn 3 - 3 Tottenham Hotspur Sub 23Tottenham ...
18 Sep 21 Man. Utd Sub 23Man. 2 - 1 Brighton & Hove Sub 23Brighton ...
Jornada 4
18 Sep 21 Man. City Sub 23Man. City 4 - 2 Crystal Palace Sub 23Crystal ...
19 Sep 21 Chelsea Sub 23Chelsea 1 - 6 Arsenal Sub 23Arsenal ...
19 Sep 21 Liverpool Sub 23Liverpool 0 - 4 Leeds United Sub 23Leeds ...
20 Sep 21 Derby County Sub 23Derby 3 - 1 West Ham Sub 23West ...
20 Sep 21 Leicester Sub 23Leicester 3 - 1 Everton Sub 23Everton ...
24 Sep 21 Brighton & Hove Sub 23Brighton 2 - 1 Leicester Sub 23Leicester ...
24 Sep 21 Chelsea Sub 23Chelsea 4 - 3 Liverpool Sub 23Liverpool ...
24 Sep 21 Everton Sub 23Everton 0 - 1 Man. Utd Sub 23Man. ...
24 Sep 21 Leeds United Sub 23Leeds 4 - 4 Blackburn Rovers Sub 23Blackburn ...
24 Sep 21 West Ham Sub 23West 1 - 0 Crystal Palace Sub 23Crystal ...
Jornada 5
25 Sep 21 Man. City Sub 23Man. City 2 - 2 Arsenal Sub 23Arsenal ...
27 Sep 21 Tottenham Hotspur Sub 23Tottenham 3 - 1 Derby County Sub 23Derby ...
01 Oct 21 Crystal Palace Sub 23Crystal 4 - 3 Tottenham Hotspur Sub 23Tottenham ...
01 Oct 21 Arsenal Sub 23Arsenal 3 - 0 Brighton & Hove Sub 23Brighton ...
03 Oct 21 Chelsea Sub 23Chelsea 0 - 1 Blackburn Rovers Sub 23Blackburn ...
01 Oct 21 Leicester Sub 23Leicester 1 - 0 Leeds United Sub 23Leeds ...
02 Oct 21 Man. Utd Sub 23Man. 3 - 0 Liverpool Sub 23Liverpool ...
02 Oct 21 Man. City Sub 23Man. City 1 - 0 Derby County Sub 23Derby ...
02 Oct 21 West Ham Sub 23West 3 - 1 Everton Sub 23Everton ...
16 Oct 21 Brighton & Hove Sub 23Brighton 2 - 1 Crystal Palace Sub 23Crystal ...
Jornada 6
16 Oct 21 Man. Utd Sub 23Man. 3 - 0 Blackburn Rovers Sub 23Blackburn ...
16 Oct 21 Chelsea Sub 23Chelsea 2 - 0 Derby County Sub 23Derby ...
16 Oct 21 Liverpool Sub 23Liverpool 3 - 0 Arsenal Sub 23Arsenal ...
16 Oct 21 Man. City Sub 23Man. City 5 - 0 Leicester Sub 23Leicester ...
18 Oct 21 Everton Sub 23Everton 4 - 2 Leeds United Sub 23Leeds ...
18 Oct 21 Tottenham Hotspur Sub 23Tottenham 3 - 4 West Ham Sub 23West ...
22 Oct 21 Arsenal Sub 23Arsenal 4 - 0 Everton Sub 23Everton ...
22 Oct 21 Derby County Sub 23Derby 2 - 3 Crystal Palace Sub 23Crystal ...
23 Oct 21 Leicester Sub 23Leicester 1 - 1 Chelsea Sub 23Chelsea ...
23 Oct 21 West Ham Sub 23West 6 - 0 Man. Utd Sub 23Man. ...
Jornada 7
23 Oct 21 Man. City Sub 23Man. City 1 - 3 Tottenham Hotspur Sub 23Tottenham ...
25 Oct 21 Blackburn Rovers Sub 23Blackburn 2 - 2 Liverpool Sub 23Liverpool 1
22 Oct 21 Leeds United Sub 23Leeds 1 - 1 Brighton & Hove Sub 23Brighton ...
29 Oct 21 Brighton & Hove Sub 23Brighton 1 - 1 Man. City Sub 23Man. City ...
29 Oct 21 Leeds United Sub 23Leeds 2 - 4 Arsenal Sub 23Arsenal 5
30 Oct 21 Chelsea Sub 23Chelsea 1 - 1 Everton Sub 23Everton ...
30 Oct 21 Liverpool Sub 23Liverpool 3 - 1 Derby County Sub 23Derby 1
01 Nov 21 Crystal Palace Sub 23Crystal 1 - 2 Blackburn Rovers Sub 23Blackburn 1
01 Nov 21 Leicester Sub 23Leicester 2 - 1 West Ham Sub 23West ...
30 Oct 21 Tottenham Hotspur Sub 23Tottenham 1 - 0 Man. Utd Sub 23Man. ...
Jornada 8
06 Nov 21 Arsenal Sub 23Arsenal 3 - 3 Leicester Sub 23Leicester 1
05 Nov 21 Brighton & Hove Sub 23Brighton 1 - 1 Tottenham Hotspur Sub 23Tottenham 1
05 Nov 21 Derby County Sub 23Derby 6 - 0 Blackburn Rovers Sub 23Blackburn ...
06 Nov 21 Man. Utd Sub 23Man. 3 - 2 Leeds United Sub 23Leeds ...
06 Nov 21 West Ham Sub 23West 3 - 0 Liverpool Sub 23Liverpool ...
06 Nov 21 Chelsea Sub 23Chelsea 1 - 2 Crystal Palace Sub 23Crystal ...
06 Nov 21 Everton Sub 23Everton 3 - 2 Man. City Sub 23Man. City ...
19 Nov 21 Leeds United Sub 23Leeds 1 - 3 Chelsea Sub 23Chelsea ...
20 Nov 21 Liverpool Sub 23Liverpool 0 - 3 Crystal Palace Sub 23Crystal ...
20 Nov 21 West Ham Sub 23West 1 - 0 Man. City Sub 23Man. City ...
Jornada 9
22 Nov 21 Blackburn Rovers Sub 23Blackburn 2 - 3 Arsenal Sub 23Arsenal ...
19 Nov 21 Derby County Sub 23Derby 1 - 1 Man. Utd Sub 23Man. ...
22 Nov 21 Everton Sub 23Everton 2 - 1 Brighton & Hove Sub 23Brighton ...
22 Nov 21 Leicester Sub 23Leicester 1 - 4 Tottenham Hotspur Sub 23Tottenham ...
26 Nov 21 Arsenal Sub 23Arsenal 3 - 5 Derby County Sub 23Derby 1
27 Nov 21 Man. Utd Sub 23Man. 1 - 2 Crystal Palace Sub 23Crystal ...
26 Nov 21 Tottenham Hotspur Sub 23Tottenham 4 - 0 Everton Sub 23Everton ...
26 Nov 21 West Ham Sub 23West 1 - 0 Blackburn Rovers Sub 23Blackburn ...
29 Nov 21 Man. City Sub 23Man. City 3 - 2 Leeds United Sub 23Leeds 1
28 Nov 21 Liverpool Sub 23Liverpool 3 - 0 Leicester Sub 23Leicester ...
Jornada 10
26 Nov 21 Chelsea Sub 23Chelsea 1 - 1 Brighton & Hove Sub 23Brighton ...
03 Dic 21 Brighton & Hove Sub 23Brighton 3 - 0 Liverpool Sub 23Liverpool 3
03 Dic 21 Derby County Sub 23Derby 3 - 1 Chelsea Sub 23Chelsea ...
04 Dic 21 Tottenham Hotspur Sub 23Tottenham 3 - 0 Man. City Sub 23Man. City ...
06 Dic 21 Crystal Palace Sub 23Crystal 2 - 4 West Ham Sub 23West ...
05 Dic 21 Blackburn Rovers Sub 23Blackburn 0 - 4 Man. Utd Sub 23Man. ...
06 Dic 21 Everton Sub 23Everton 2 - 0 Arsenal Sub 23Arsenal ...
03 Dic 21 Leeds United Sub 23Leeds 1 - 3 Leicester Sub 23Leicester ...
04 Mar 22 Arsenal Sub 23Arsenal 2 - 1 Tottenham Hotspur Sub 23Tottenham 1
17 Dic 21 Man. City Sub 23Man. City 3 - 1 Brighton & Hove Sub 23Brighton ...
Jornada 11
08 Abr 22 Man. Utd Sub 23Man. 1 - 0 Chelsea Sub 23Chelsea 2
17 Abr 22 Liverpool Sub 23Liverpool 3 - 0 West Ham Sub 23West ...
09 May 22 Crystal Palace Sub 23Crystal 3 - 1 Derby County Sub 23Derby 1
20 Dic 21 Leeds United Sub 23Leeds 0 - 0 Everton Sub 23Everton ...
18 Abr 22 Leicester Sub 23Leicester 4 - 1 Blackburn Rovers Sub 23Blackburn ...
09 Ene 22 Blackburn Rovers Sub 23Blackburn 3 - 5 Man. City Sub 23Man. City ...
07 Ene 22 Brighton & Hove Sub 23Brighton 1 - 1 Arsenal Sub 23Arsenal 2
08 Ene 22 Chelsea Sub 23Chelsea 5 - 0 Leicester Sub 23Leicester ...
10 Ene 22 Derby County Sub 23Derby 0 - 1 Liverpool Sub 23Liverpool 1
10 Ene 22 Everton Sub 23Everton 2 - 2 Crystal Palace Sub 23Crystal 1
Jornada 12
10 Ene 22 Man. Utd Sub 23Man. 1 - 1 Tottenham Hotspur Sub 23Tottenham ...
10 Ene 22 West Ham Sub 23West 3 - 0 Leeds United Sub 23Leeds ...
14 Ene 22 Arsenal Sub 23Arsenal 1 - 1 West Ham Sub 23West 1
15 Ene 22 Man. City Sub 23Man. City 3 - 1 Man. Utd Sub 23Man. ...
15 Ene 22 Liverpool Sub 23Liverpool 1 - 1 Everton Sub 23Everton 2
17 Ene 22 Crystal Palace Sub 23Crystal 3 - 2 Chelsea Sub 23Chelsea 3
17 Ene 22 Leicester Sub 23Leicester 2 - 1 Brighton & Hove Sub 23Brighton ...
17 Ene 22 Tottenham Hotspur Sub 23Tottenham 1 - 1 Blackburn Rovers Sub 23Blackburn 1
17 Ene 22 Leeds United Sub 23Leeds 2 - 0 Derby County Sub 23Derby ...
21 Ene 22 Brighton & Hove Sub 23Brighton 1 - 2 Man. Utd Sub 23Man. ...
Jornada 13
21 Ene 22 Derby County Sub 23Derby 1 - 1 Arsenal Sub 23Arsenal 1
24 Ene 22 West Ham Sub 23West 1 - 2 Leicester Sub 23Leicester ...
24 Ene 22 Blackburn Rovers Sub 23Blackburn 4 - 0 Leeds United Sub 23Leeds ...
24 Ene 22 Chelsea Sub 23Chelsea 0 - 1 Man. City Sub 23Man. City 2
24 Ene 22 Crystal Palace Sub 23Crystal 0 - 2 Liverpool Sub 23Liverpool ...
24 Ene 22 Everton Sub 23Everton 1 - 0 Tottenham Hotspur Sub 23Tottenham ...
04 Feb 22 Arsenal Sub 23Arsenal 3 - 1 Chelsea Sub 23Chelsea ...
04 Feb 22 Blackburn Rovers Sub 23Blackburn 6 - 0 Brighton & Hove Sub 23Brighton ...
05 Feb 22 Man. Utd Sub 23Man. 3 - 1 West Ham Sub 23West ...
04 Feb 22 Everton Sub 23Everton 1 - 2 Leicester Sub 23Leicester ...
Jornada 14
07 Feb 22 Tottenham Hotspur Sub 23Tottenham 1 - 4 Crystal Palace Sub 23Crystal 1
07 Feb 22 Derby County Sub 23Derby 0 - 5 Man. City Sub 23Man. City ...
07 Feb 22 Leeds United Sub 23Leeds 3 - 0 Liverpool Sub 23Liverpool ...
15 Abr 22 Brighton & Hove Sub 23Brighton 1 - 0 Leeds United Sub 23Leeds 3
08 May 22 Chelsea Sub 23Chelsea 2 - 1 Tottenham Hotspur Sub 23Tottenham ...
20 Feb 22 Man. City Sub 23Man. City 2 - 0 West Ham Sub 23West ...
20 Feb 22 Liverpool Sub 23Liverpool 1 - 1 Blackburn Rovers Sub 23Blackburn ...
20 Feb 22 Crystal Palace Sub 23Crystal 2 - 2 Man. Utd Sub 23Man. ...
21 Feb 22 Derby County Sub 23Derby 0 - 2 Everton Sub 23Everton 3
21 Feb 22 Leicester Sub 23Leicester 1 - 1 Arsenal Sub 23Arsenal 2
Jornada 15
25 Feb 22 Arsenal Sub 23Arsenal 1 - 4 Liverpool Sub 23Liverpool 1
25 Feb 22 Man. Utd Sub 23Man. 5 - 2 Derby County Sub 23Derby ...
08 Abr 22 Blackburn Rovers Sub 23Blackburn 2 - 0 West Ham Sub 23West 1
28 Feb 22 Crystal Palace Sub 23Crystal 2 - 0 Brighton & Hove Sub 23Brighton 27
15 Abr 22 Everton Sub 23Everton 2 - 0 Chelsea Sub 23Chelsea ...
28 Feb 22 Leicester Sub 23Leicester 0 - 0 Man. City Sub 23Man. City 19
28 Feb 22 Tottenham Hotspur Sub 23Tottenham 1 - 1 Leeds United Sub 23Leeds 4
14 Mar 22 Arsenal Sub 23Arsenal 2 - 2 Blackburn Rovers Sub 23Blackburn 2
11 Mar 22 Brighton & Hove Sub 23Brighton 4 - 2 Everton Sub 23Everton ...
11 Mar 22 Chelsea Sub 23Chelsea 1 - 1 West Ham Sub 23West 2
Jornada 16
12 Mar 22 Liverpool Sub 23Liverpool 7 - 1 Tottenham Hotspur Sub 23Tottenham ...
12 Mar 22 Crystal Palace Sub 23Crystal 1 - 2 Man. City Sub 23Man. City ...
13 Mar 22 Derby County Sub 23Derby 0 - 0 Leicester Sub 23Leicester ...
15 Mar 22 Leeds United Sub 23Leeds 3 - 0 Man. Utd Sub 23Man. 1
20 Mar 22 Chelsea Sub 23Chelsea 1 - 0 Leeds United Sub 23Leeds ...
18 Mar 22 Man. Utd Sub 23Man. 3 - 0 Everton Sub 23Everton ...
18 Mar 22 Tottenham Hotspur Sub 23Tottenham 3 - 1 Leicester Sub 23Leicester ...
20 Mar 22 Man. City Sub 23Man. City 0 - 0 Liverpool Sub 23Liverpool ...
21 Mar 22 Blackburn Rovers Sub 23Blackburn 2 - 1 Derby County Sub 23Derby 5
19 Mar 22 Crystal Palace Sub 23Crystal 1 - 1 Arsenal Sub 23Arsenal ...
Jornada 17
18 Mar 22 West Ham Sub 23West 3 - 2 Brighton & Hove Sub 23Brighton ...
02 Abr 22 Liverpool Sub 23Liverpool 2 - 2 Chelsea Sub 23Chelsea 2
04 Abr 22 Arsenal Sub 23Arsenal 3 - 3 Man. City Sub 23Man. City 8
04 Abr 22 Brighton & Hove Sub 23Brighton 5 - 1 Derby County Sub 23Derby 1
04 Abr 22 Everton Sub 23Everton 0 - 2 Blackburn Rovers Sub 23Blackburn 1
04 Abr 22 Leeds United Sub 23Leeds 4 - 0 Crystal Palace Sub 23Crystal 2
04 Abr 22 Leicester Sub 23Leicester 3 - 2 Man. Utd Sub 23Man. 4
04 Abr 22 West Ham Sub 23West 3 - 1 Tottenham Hotspur Sub 23Tottenham 6
22 Abr 22 Man. Utd Sub 23Man. 1 - 1 Arsenal Sub 23Arsenal 14
25 Abr 22 Blackburn Rovers Sub 23Blackburn 2 - 1 Crystal Palace Sub 23Crystal 4
Jornada 18
25 Abr 22 Brighton & Hove Sub 23Brighton 1 - 2 Chelsea Sub 23Chelsea 1
25 Abr 22 Derby County Sub 23Derby 0 - 1 Tottenham Hotspur Sub 23Tottenham 1
25 Abr 22 Everton Sub 23Everton 3 - 4 West Ham Sub 23West 4
22 Abr 22 Leeds United Sub 23Leeds 1 - 3 Man. City Sub 23Man. City 2
25 Abr 22 Leicester Sub 23Leicester 0 - 4 Liverpool Sub 23Liverpool 2
29 Abr 22 Arsenal Sub 23Arsenal 1 - 1 Leeds United Sub 23Leeds 4
29 Abr 22 Man. City Sub 23Man. City 7 - 0 Everton Sub 23Everton ...
01 May 22 Liverpool Sub 23Liverpool 3 - 1 Man. Utd Sub 23Man. ...
02 May 22 Tottenham Hotspur Sub 23Tottenham 0 - 0 Brighton & Hove Sub 23Brighton 11
01 May 22 Blackburn Rovers Sub 23Blackburn 4 - 3 Chelsea Sub 23Chelsea 2
Jornada 19
02 May 22 Crystal Palace Sub 23Crystal 3 - 2 Leicester Sub 23Leicester 16
02 May 22 West Ham Sub 23West 5 - 0 Derby County Sub 23Derby 6
Clasificación
Equipo PJ GF GC Puntos
1 Man. City Sub 23 Man. City 26 65 32 54
2 West Ham Sub 23 West 26 59 39 48
3 Arsenal Sub 23 Arsenal 26 56 48 41
4 Liverpool Sub 23 Liverpool 26 47 37 40
5 Crystal Palace Sub 23 Crystal 26 54 50 39
6 Man. Utd Sub 23 Man. 26 46 43 39
7 Tottenham Hotspur Sub 23 Tottenham 26 49 45 37
8 Leicester Sub 23 Leicester 26 38 53 37
9 Blackburn Rovers Sub 23 Blackburn 26 50 56 35
10 Brighton & Hove Sub 23 Brighton 26 41 41 34
11 Everton Sub 23 Everton 26 33 54 29
12 Chelsea Sub 23 Chelsea 26 39 47 28
13 Leeds United Sub 23 Leeds United 26 44 49 27
14 Derby County Sub 23 Derby County 26 31 58 15
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
6,206,184 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1407
Total Execution Time  0.1426
  CADENA URL  
/premier_league_2_division_one2022/grupo1/calendario
  GET DATOS  
$_GET['/premier_league_2_division_one2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0017  SELECT type FROM routes WHERE alias = 'premier_league_2_division_one2022'
0.0041  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_one' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1977 AND type_rel = 3
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1977 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1268809,1235957,1235428,1230545,1228001) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1977 ORDER BY order_id ASC
0.0019  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 = 63583 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0043  SELECT 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, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63583 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 10:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 10:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 10:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 10:18:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_2_division_one' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0133  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63583 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63583 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0123  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63583 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63583 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0026  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63583 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63583 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2022` 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 = 63583 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC