Liga Escocia 2022  G 1
2021/2022

Temporada Regular

Liga Escocia 2022 G 1

  • Celtic
  • Rangers FC
  • Heart of Midlothian
  • Dundee United
  • Ross County FC
  • Motherwell
  • Hibernian FC
  • Livingston
  • Aberdeen
  • St. Mirren
  • St. Johnstone
  • Dundee
Jornada 1
31 Jul 21 Rangers FCRangers FC 3 - 0 LivingstonLivingston 16
31 Jul 21 DundeeDundee 2 - 2 St. MirrenSt. Mirren 6
31 Jul 21 Ross County FCRoss County 0 - 0 St. JohnstoneJohnstone 13
31 Jul 21 Heart of MidlothianHeart 2 - 1 CelticCeltic 73
01 Ago 21 AberdeenAberdeen 2 - 0 Dundee UnitedDundee 6
01 Ago 21 MotherwellMotherwell 2 - 3 Hibernian FCHibernian 5
Jornada 2
08 Ago 21 CelticCeltic 6 - 0 DundeeDundee 8
07 Ago 21 Dundee UnitedDundee 1 - 0 Rangers FCRangers FC 24
08 Ago 21 Hibernian FCHibernian 3 - 0 Ross County FCRoss County 1
08 Ago 21 LivingstonLivingston 1 - 2 AberdeenAberdeen 1
07 Ago 21 St. MirrenSt. Mirren 1 - 2 Heart of MidlothianHeart 2
08 Ago 21 St. JohnstoneJohnstone 1 - 1 MotherwellMotherwell 2
Jornada 3
21 Ago 21 CelticCeltic 6 - 0 St. MirrenSt. Mirren 5
22 Ago 21 DundeeDundee 2 - 2 Hibernian FCHibernian 5
22 Ago 21 Heart of MidlothianHeart 1 - 1 AberdeenAberdeen ...
21 Ago 21 LivingstonLivingston 1 - 2 MotherwellMotherwell ...
22 Ago 21 Ross County FCRoss County 2 - 4 Rangers FCRangers FC 2
22 Ago 21 St. JohnstoneJohnstone 0 - 1 Dundee UnitedDundee 1
Jornada 4
29 Ago 21 AberdeenAberdeen 1 - 1 Ross County FCRoss County 11
28 Ago 21 Dundee UnitedDundee 0 - 2 Heart of MidlothianHeart 3
28 Ago 21 Hibernian FCHibernian 2 - 0 LivingstonLivingston 10
28 Ago 21 MotherwellMotherwell 1 - 0 DundeeDundee ...
29 Ago 21 Rangers FCRangers FC 1 - 0 CelticCeltic 58
29 Ago 21 St. MirrenSt. Mirren 0 - 0 St. JohnstoneJohnstone 1
Jornada 5
11 Sep 21 CelticCeltic 3 - 0 Ross County FCRoss County 7
11 Sep 21 DundeeDundee 0 - 0 LivingstonLivingston ...
12 Sep 21 Heart of MidlothianHeart 0 - 0 Hibernian FCHibernian 6
11 Sep 21 MotherwellMotherwell 2 - 0 AberdeenAberdeen 1
11 Sep 21 St. JohnstoneJohnstone 1 - 2 Rangers FCRangers FC 27
11 Sep 21 St. MirrenSt. Mirren 0 - 0 Dundee UnitedDundee ...
Jornada 6
18 Sep 21 AberdeenAberdeen 0 - 1 St. JohnstoneJohnstone 3
19 Sep 21 Dundee UnitedDundee 1 - 0 DundeeDundee 3
18 Sep 21 Hibernian FCHibernian 2 - 2 St. MirrenSt. Mirren 2
19 Sep 21 LivingstonLivingston 1 - 0 CelticCeltic 25
19 Sep 21 Rangers FCRangers FC 1 - 1 MotherwellMotherwell 22
18 Sep 21 Ross County FCRoss County 2 - 2 Heart of MidlothianHeart ...
Jornada 7
26 Sep 21 CelticCeltic 1 - 1 Dundee UnitedDundee 50
25 Sep 21 DundeeDundee 0 - 1 Rangers FCRangers FC 10
25 Sep 21 Heart of MidlothianHeart 3 - 0 LivingstonLivingston ...
26 Sep 21 Hibernian FCHibernian 1 - 0 St. JohnstoneJohnstone 1
25 Sep 21 MotherwellMotherwell 2 - 1 Ross County FCRoss County 10
26 Sep 21 St. MirrenSt. Mirren 3 - 2 AberdeenAberdeen 1
Jornada 8
03 Oct 21 AberdeenAberdeen 1 - 2 CelticCeltic 1
02 Oct 21 Dundee UnitedDundee 1 - 0 Ross County FCRoss County 1
02 Oct 21 Heart of MidlothianHeart 2 - 0 MotherwellMotherwell 1
02 Oct 21 LivingstonLivingston 0 - 1 St. MirrenSt. Mirren ...
03 Oct 21 Rangers FCRangers FC 2 - 1 Hibernian FCHibernian 16
02 Oct 21 St. JohnstoneJohnstone 3 - 1 DundeeDundee ...
Jornada 9
16 Oct 21 DundeeDundee 2 - 1 AberdeenAberdeen 6
16 Oct 21 Hibernian FCHibernian 0 - 3 Dundee UnitedDundee 4
16 Oct 21 MotherwellMotherwell 0 - 2 CelticCeltic 6
16 Oct 21 Rangers FCRangers FC 1 - 1 Heart of MidlothianHeart 14
16 Oct 21 Ross County FCRoss County 2 - 3 St. MirrenSt. Mirren ...
16 Oct 21 St. JohnstoneJohnstone 0 - 3 LivingstonLivingston ...
Jornada 10
23 Oct 21 AberdeenAberdeen 1 - 0 Hibernian FCHibernian 5
23 Oct 21 CelticCeltic 2 - 0 St. JohnstoneJohnstone 37
23 Oct 21 Dundee UnitedDundee 2 - 1 MotherwellMotherwell ...
23 Oct 21 Heart of MidlothianHeart 1 - 1 DundeeDundee 22
23 Oct 21 Ross County FCRoss County 2 - 3 LivingstonLivingston 3
24 Oct 21 St. MirrenSt. Mirren 1 - 2 Rangers FCRangers FC 22
Jornada 11
27 Oct 21 DundeeDundee 0 - 5 Ross County FCRoss County 4
27 Oct 21 Hibernian FCHibernian 1 - 3 CelticCeltic 6
27 Oct 21 LivingstonLivingston 1 - 1 Dundee UnitedDundee 3
27 Oct 21 MotherwellMotherwell 2 - 2 St. MirrenSt. Mirren 4
27 Oct 21 Rangers FCRangers FC 2 - 2 AberdeenAberdeen 40
27 Oct 21 St. JohnstoneJohnstone 1 - 1 Heart of MidlothianHeart ...
Jornada 12
30 Oct 21 AberdeenAberdeen 2 - 1 Heart of MidlothianHeart 1
30 Oct 21 CelticCeltic 0 - 0 LivingstonLivingston 34
30 Oct 21 Dundee UnitedDundee 0 - 1 St. JohnstoneJohnstone 1
31 Oct 21 MotherwellMotherwell 1 - 6 Rangers FCRangers FC 16
24 Nov 21 Ross County FCRoss County 1 - 0 Hibernian FCHibernian 2
30 Oct 21 St. MirrenSt. Mirren 0 - 1 DundeeDundee ...
Jornada 13
06 Nov 21 AberdeenAberdeen 0 - 2 MotherwellMotherwell ...
07 Nov 21 DundeeDundee 2 - 4 CelticCeltic 3
06 Nov 21 Heart of MidlothianHeart 5 - 2 Dundee UnitedDundee ...
08 Dic 21 LivingstonLivingston 1 - 0 Hibernian FCHibernian 29
07 Nov 21 Rangers FCRangers FC 4 - 2 Ross County FCRoss County 21
06 Nov 21 St. JohnstoneJohnstone 0 - 0 St. MirrenSt. Mirren ...
Jornada 14
20 Nov 21 Dundee UnitedDundee 1 - 0 AberdeenAberdeen 1
14 Dic 21 Hibernian FCHibernian 1 - 0 DundeeDundee 13
20 Nov 21 MotherwellMotherwell 2 - 0 Heart of MidlothianHeart ...
15 Dic 21 Rangers FCRangers FC 2 - 0 St. JohnstoneJohnstone 49
15 Dic 21 Ross County FCRoss County 1 - 2 CelticCeltic 137
20 Nov 21 St. MirrenSt. Mirren 1 - 1 LivingstonLivingston ...
Jornada 15
28 Nov 21 CelticCeltic 2 - 1 AberdeenAberdeen 25
27 Nov 21 DundeeDundee 3 - 0 MotherwellMotherwell ...
27 Nov 21 Heart of MidlothianHeart 2 - 0 St. MirrenSt. Mirren 1
28 Nov 21 LivingstonLivingston 1 - 3 Rangers FCRangers FC 2
27 Nov 21 Ross County FCRoss County 1 - 1 Dundee UnitedDundee ...
27 Nov 21 St. JohnstoneJohnstone 1 - 2 Hibernian FCHibernian 1
Jornada 16
01 Dic 21 AberdeenAberdeen 2 - 0 LivingstonLivingston 1
02 Dic 21 CelticCeltic 1 - 0 Heart of MidlothianHeart 166
01 Dic 21 DundeeDundee 1 - 0 St. JohnstoneJohnstone ...
01 Dic 21 Hibernian FCHibernian 0 - 1 Rangers FCRangers FC 42
30 Nov 21 MotherwellMotherwell 1 - 0 Dundee UnitedDundee 17
01 Dic 21 St. MirrenSt. Mirren 0 - 0 Ross County FCRoss County 7
Jornada 17
04 Dic 21 AberdeenAberdeen 4 - 1 St. MirrenSt. Mirren 3
05 Dic 21 Dundee UnitedDundee 0 - 3 CelticCeltic 8
04 Dic 21 Hibernian FCHibernian 1 - 1 MotherwellMotherwell 1
05 Dic 21 LivingstonLivingston 0 - 1 Heart of MidlothianHeart 1
04 Dic 21 Rangers FCRangers FC 3 - 0 DundeeDundee 17
22 Dic 21 St. JohnstoneJohnstone 1 - 2 Ross County FCRoss County 2
Jornada 18
12 Dic 21 CelticCeltic 1 - 0 MotherwellMotherwell 42
11 Dic 21 Dundee UnitedDundee 0 - 1 LivingstonLivingston ...
12 Dic 21 Heart of MidlothianHeart 0 - 2 Rangers FCRangers FC 12
11 Dic 21 Ross County FCRoss County 3 - 2 DundeeDundee ...
11 Dic 21 St. JohnstoneJohnstone 0 - 1 AberdeenAberdeen 1
11 Dic 21 St. MirrenSt. Mirren 1 - 1 Hibernian FCHibernian 8
Jornada 19
18 Dic 21 DundeeDundee 0 - 1 Heart of MidlothianHeart 1
22 Dic 21 Hibernian FCHibernian 1 - 0 AberdeenAberdeen 8
18 Dic 21 LivingstonLivingston 1 - 1 Ross County FCRoss County 3
18 Dic 21 MotherwellMotherwell 2 - 0 St. JohnstoneJohnstone 2
18 Dic 21 Rangers FCRangers FC 1 - 0 Dundee UnitedDundee 30
22 Dic 21 St. MirrenSt. Mirren 0 - 0 CelticCeltic 43
Jornada 20
26 Dic 21 AberdeenAberdeen 2 - 1 DundeeDundee 26
26 Dic 21 Dundee UnitedDundee 1 - 3 Hibernian FCHibernian 18
26 Dic 21 Heart of MidlothianHeart 2 - 1 Ross County FCRoss County 11
26 Dic 21 MotherwellMotherwell 2 - 1 LivingstonLivingston 19
26 Dic 21 Rangers FCRangers FC 2 - 0 St. MirrenSt. Mirren 22
26 Dic 21 St. JohnstoneJohnstone 1 - 3 CelticCeltic 34
Jornada 21
18 Ene 22 AberdeenAberdeen 1 - 1 Rangers FCRangers FC 56
17 Ene 22 CelticCeltic 2 - 0 Hibernian FCHibernian 206
18 Ene 22 Dundee UnitedDundee 1 - 2 St. MirrenSt. Mirren 8
18 Ene 22 Heart of MidlothianHeart 2 - 0 St. JohnstoneJohnstone 38
18 Ene 22 LivingstonLivingston 2 - 0 DundeeDundee 3
18 Ene 22 Ross County FCRoss County 3 - 1 MotherwellMotherwell 17
Jornada 22
02 Feb 22 CelticCeltic 3 - 0 Rangers FCRangers FC 220
01 Feb 22 DundeeDundee 0 - 0 Dundee UnitedDundee 13
01 Feb 22 Hibernian FCHibernian 0 - 0 Heart of MidlothianHeart 39
01 Feb 22 LivingstonLivingston 1 - 2 St. JohnstoneJohnstone 53
01 Feb 22 Ross County FCRoss County 1 - 1 AberdeenAberdeen 18
01 Feb 22 St. MirrenSt. Mirren 1 - 1 MotherwellMotherwell 14
Jornada 23
26 Ene 22 Dundee UnitedDundee 2 - 1 Ross County FCRoss County 34
26 Ene 22 Heart of MidlothianHeart 1 - 2 CelticCeltic 69
26 Ene 22 MotherwellMotherwell 0 - 0 Hibernian FCHibernian 25
26 Ene 22 Rangers FCRangers FC 1 - 0 LivingstonLivingston 110
26 Ene 22 St. JohnstoneJohnstone 0 - 0 DundeeDundee 32
25 Ene 22 St. MirrenSt. Mirren 1 - 0 AberdeenAberdeen 80
Jornada 24
15 Feb 22 AberdeenAberdeen 1 - 1 St. JohnstoneJohnstone 41
29 Ene 22 CelticCeltic 1 - 0 Dundee UnitedDundee 83
09 Mar 22 DundeeDundee 0 - 1 St. MirrenSt. Mirren 25
29 Ene 22 Heart of MidlothianHeart 2 - 0 MotherwellMotherwell 3
29 Ene 22 Hibernian FCHibernian 2 - 3 LivingstonLivingston 15
29 Ene 22 Ross County FCRoss County 3 - 3 Rangers FCRangers FC 179
Jornada 25
05 Feb 22 DundeeDundee 1 - 2 Ross County FCRoss County ...
05 Feb 22 Hibernian FCHibernian 0 - 1 St. MirrenSt. Mirren 1
05 Feb 22 LivingstonLivingston 2 - 1 AberdeenAberdeen 1
06 Feb 22 MotherwellMotherwell 0 - 4 CelticCeltic 21
06 Feb 22 Rangers FCRangers FC 5 - 0 Heart of MidlothianHeart 40
05 Feb 22 St. JohnstoneJohnstone 0 - 0 Dundee UnitedDundee ...
Jornada 26
09 Feb 22 AberdeenAberdeen 2 - 3 CelticCeltic 72
09 Feb 22 Dundee UnitedDundee 2 - 0 MotherwellMotherwell 10
09 Feb 22 Heart of MidlothianHeart 1 - 2 DundeeDundee 46
09 Feb 22 Rangers FCRangers FC 2 - 0 Hibernian FCHibernian 47
09 Feb 22 Ross County FCRoss County 1 - 1 LivingstonLivingston 23
09 Feb 22 St. MirrenSt. Mirren 2 - 1 St. JohnstoneJohnstone 3
Jornada 27
20 Feb 22 CelticCeltic 3 - 2 DundeeDundee 100
20 Feb 22 Dundee UnitedDundee 1 - 1 Rangers FCRangers FC 77
19 Feb 22 Hibernian FCHibernian 2 - 0 Ross County FCRoss County ...
19 Feb 22 LivingstonLivingston 1 - 1 St. MirrenSt. Mirren ...
19 Feb 22 MotherwellMotherwell 1 - 1 AberdeenAberdeen 4
19 Feb 22 St. JohnstoneJohnstone 2 - 1 Heart of MidlothianHeart 1
Jornada 28
26 Feb 22 AberdeenAberdeen 1 - 1 Dundee UnitedDundee 1
26 Feb 22 DundeeDundee 0 - 4 LivingstonLivingston ...
27 Feb 22 Hibernian FCHibernian 0 - 0 CelticCeltic 63
27 Feb 22 Rangers FCRangers FC 2 - 2 MotherwellMotherwell 34
26 Feb 22 Ross County FCRoss County 3 - 1 St. JohnstoneJohnstone ...
26 Feb 22 St. MirrenSt. Mirren 0 - 2 Heart of MidlothianHeart ...
Jornada 29
02 Mar 22 CelticCeltic 2 - 0 St. MirrenSt. Mirren 81
02 Mar 22 DundeeDundee 0 - 0 Hibernian FCHibernian 19
02 Mar 22 Heart of MidlothianHeart 2 - 0 AberdeenAberdeen 4
02 Mar 22 LivingstonLivingston 2 - 1 Dundee UnitedDundee 13
02 Mar 22 MotherwellMotherwell 0 - 1 Ross County FCRoss County 19
02 Mar 22 St. JohnstoneJohnstone 0 - 1 Rangers FCRangers FC 39
Jornada 30
05 Mar 22 Dundee UnitedDundee 2 - 2 Heart of MidlothianHeart ...
05 Mar 22 Hibernian FCHibernian 0 - 0 St. JohnstoneJohnstone 9
06 Mar 22 LivingstonLivingston 1 - 3 CelticCeltic 12
05 Mar 22 MotherwellMotherwell 1 - 1 DundeeDundee 1
05 Mar 22 Rangers FCRangers FC 1 - 0 AberdeenAberdeen 86
05 Mar 22 Ross County FCRoss County 1 - 0 St. MirrenSt. Mirren ...
Jornada 31
19 Mar 22 AberdeenAberdeen 3 - 1 Hibernian FCHibernian ...
19 Mar 22 CelticCeltic 4 - 0 Ross County FCRoss County 9
20 Mar 22 DundeeDundee 1 - 2 Rangers FCRangers FC 81
19 Mar 22 Heart of MidlothianHeart 2 - 0 LivingstonLivingston 2
19 Mar 22 St. JohnstoneJohnstone 2 - 1 MotherwellMotherwell ...
19 Mar 22 St. MirrenSt. Mirren 1 - 2 Dundee UnitedDundee ...
Jornada 32
02 Abr 22 DundeeDundee 2 - 2 AberdeenAberdeen 4
02 Abr 22 Hibernian FCHibernian 1 - 1 Dundee UnitedDundee 1
02 Abr 22 MotherwellMotherwell 4 - 2 St. MirrenSt. Mirren 4
03 Abr 22 Rangers FCRangers FC 1 - 2 CelticCeltic 42
02 Abr 22 Ross County FCRoss County 1 - 1 Heart of MidlothianHeart 1
02 Abr 22 St. JohnstoneJohnstone 1 - 0 LivingstonLivingston 5
Jornada 33
09 Abr 22 AberdeenAberdeen 0 - 1 Ross County FCRoss County 2
09 Abr 22 CelticCeltic 7 - 0 St. JohnstoneJohnstone 8
09 Abr 22 Dundee UnitedDundee 2 - 2 DundeeDundee 6
09 Abr 22 Heart of MidlothianHeart 3 - 1 Hibernian FCHibernian 3
09 Abr 22 LivingstonLivingston 2 - 2 MotherwellMotherwell ...
10 Abr 22 St. MirrenSt. Mirren 0 - 4 Rangers FCRangers FC 9
Clasificación
Equipo PJ GF GC Puntos
1 Celtic Celtic 33 78 19 82
2 Rangers FC Rangers FC 33 67 27 76
3 Heart of Midlothian Heart 33 48 33 57
4 Dundee United Dundee 33 31 37 41
5 Ross County FC Ross County 33 45 52 40
6 Motherwell Motherwell 33 38 50 40
7 Hibernian FC Hibernian 33 31 37 38
8 Livingston Livingston 33 35 43 38
9 Aberdeen Aberdeen 33 38 42 36
10 St. Mirren St. Mirren 33 30 50 36
11 St. Johnstone Johnstone 33 21 44 30
12 Dundee Dundee 33 29 57 25
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,327,360 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.1867
Total Execution Time  0.1896
  CADENA URL  
/escocia2022/grupo1/calendario
  GET DATOS  
$_GET['/escocia2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (14)  
0.0034  SELECT type FROM routes WHERE alias = 'escocia2022'
0.0071  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'escocia' 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.0035  SELECT id,name,alias,stepParent FROM categories WHERE parentId=14 ORDER BY order_id ASC
0.0036  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 = 62929 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0074  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 = 62929 ORDER BY round ASC
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-28 20:43:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-28 20:43:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0034  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-28 20:43:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0035  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-28 20:43:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'escocia' 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.0163  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 = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 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.0211  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 = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0048  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 = 62929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 62929 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0081  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 = 62929 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC