4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2019
Temporada Siguiente »
Liga Escocia 2019 G 1
2018/2019

Temporada Regular

Liga Escocia 2019 G 1

  • Celtic
  • Rangers FC
  • Kilmarnock
  • Aberdeen
  • Hibernian FC
  • Heart of Midlothian
  • St. Johnstone
  • Motherwell
  • Livingston
  • Hamilton Academical
  • St. Mirren
  • Dundee
Ver jornada
Jornada 1
04 Ago 18 CelticCeltic 3 - 1 LivingstonLivingston 20
04 Ago 18 Hamilton AcademicalHamilton 1 - 4 Heart of MidlothianHeart 2
05 Ago 18 Hibernian FCHibernian 3 - 0 MotherwellMotherwell 7
04 Ago 18 KilmarnockKilmarnock 2 - 0 St. JohnstoneJohnstone 6
04 Ago 18 St. MirrenSt. Mirren 2 - 1 DundeeDundee 2
05 Ago 18 AberdeenAberdeen 1 - 1 Rangers FCRangers FC 105
Ver jornada
Jornada 2
11 Ago 18 DundeeDundee 0 - 1 AberdeenAberdeen 3
11 Ago 18 Heart of MidlothianHeart 1 - 0 CelticCeltic 50
11 Ago 18 LivingstonLivingston 0 - 0 KilmarnockKilmarnock 6
11 Ago 18 MotherwellMotherwell 0 - 1 Hamilton AcademicalHamilton 2
12 Ago 18 Rangers FCRangers FC 2 - 0 St. MirrenSt. Mirren 5
12 Ago 18 St. JohnstoneJohnstone 1 - 1 Hibernian FCHibernian 2
Ver jornada
Jornada 3
26 Ago 18 CelticCeltic 1 - 0 Hamilton AcademicalHamilton 26
25 Ago 18 Hibernian FCHibernian 1 - 1 AberdeenAberdeen 3
25 Ago 18 KilmarnockKilmarnock 0 - 1 Heart of MidlothianHeart 3
26 Ago 18 MotherwellMotherwell 3 - 3 Rangers FCRangers FC 43
25 Ago 18 St. JohnstoneJohnstone 1 - 0 DundeeDundee 1
25 Ago 18 St. MirrenSt. Mirren 0 - 2 LivingstonLivingston 1
Ver jornada
Jornada 4
01 Sep 18 AberdeenAberdeen 0 - 2 KilmarnockKilmarnock 8
02 Sep 18 CelticCeltic 1 - 0 Rangers FCRangers FC 114
01 Sep 18 DundeeDundee 1 - 3 MotherwellMotherwell 1
01 Sep 18 Hamilton AcademicalHamilton 1 - 2 St. JohnstoneJohnstone 1
01 Sep 18 Heart of MidlothianHeart 4 - 1 St. MirrenSt. Mirren 4
01 Sep 18 LivingstonLivingston 2 - 1 Hibernian FCHibernian 2
Ver jornada
Jornada 5
15 Sep 18 Hibernian FCHibernian 3 - 2 KilmarnockKilmarnock 1
15 Sep 18 LivingstonLivingston 1 - 0 Hamilton AcademicalHamilton 1
15 Sep 18 MotherwellMotherwell 0 - 1 Heart of MidlothianHeart 2
15 Sep 18 Rangers FCRangers FC 4 - 0 DundeeDundee 6
15 Sep 18 St. JohnstoneJohnstone 1 - 1 AberdeenAberdeen 1
14 Sep 18 St. MirrenSt. Mirren 0 - 0 CelticCeltic 106
Ver jornada
Jornada 6
22 Sep 18 AberdeenAberdeen 1 - 0 MotherwellMotherwell 1
22 Sep 18 DundeeDundee 0 - 3 Hibernian FCHibernian 3
22 Sep 18 Hamilton AcademicalHamilton 3 - 0 St. MirrenSt. Mirren 2
22 Sep 18 Heart of MidlothianHeart 0 - 0 LivingstonLivingston 10
23 Sep 18 KilmarnockKilmarnock 2 - 1 CelticCeltic 39
23 Sep 18 Rangers FCRangers FC 5 - 1 St. JohnstoneJohnstone 6
Ver jornada
Jornada 7
29 Sep 18 CelticCeltic 1 - 0 AberdeenAberdeen 15
29 Sep 18 Hamilton AcademicalHamilton 0 - 2 DundeeDundee 2
29 Sep 18 Heart of MidlothianHeart 2 - 1 St. JohnstoneJohnstone 6
29 Sep 18 KilmarnockKilmarnock 3 - 1 MotherwellMotherwell 5
30 Sep 18 LivingstonLivingston 1 - 0 Rangers FCRangers FC 9
29 Sep 18 St. MirrenSt. Mirren 0 - 1 Hibernian FCHibernian 4
Ver jornada
Jornada 8
06 Oct 18 AberdeenAberdeen 4 - 1 St. MirrenSt. Mirren 2
06 Oct 18 DundeeDundee 1 - 2 KilmarnockKilmarnock 1
06 Oct 18 Hibernian FCHibernian 6 - 0 Hamilton AcademicalHamilton 5
06 Oct 18 MotherwellMotherwell 1 - 1 LivingstonLivingston 2
07 Oct 18 Rangers FCRangers FC 3 - 1 Heart of MidlothianHeart 27
07 Oct 18 St. JohnstoneJohnstone 0 - 6 CelticCeltic 8
Ver jornada
Jornada 9
20 Oct 18 CelticCeltic 4 - 2 Hibernian FCHibernian 9
21 Oct 18 Hamilton AcademicalHamilton 1 - 4 Rangers FCRangers FC 32
20 Oct 18 Heart of MidlothianHeart 2 - 1 AberdeenAberdeen 10
20 Oct 18 LivingstonLivingston 4 - 0 DundeeDundee 2
20 Oct 18 MotherwellMotherwell 0 - 1 St. JohnstoneJohnstone 2
20 Oct 18 St. MirrenSt. Mirren 1 - 2 KilmarnockKilmarnock 2
Ver jornada
Jornada 10
11 Dic 18 AberdeenAberdeen 3 - 2 LivingstonLivingston 17
19 Dic 18 CelticCeltic 3 - 0 MotherwellMotherwell 8
23 Oct 18 DundeeDundee 0 - 3 Heart of MidlothianHeart 3
19 Dic 18 Hibernian FCHibernian 0 - 0 Rangers FCRangers FC 42
27 Oct 18 KilmarnockKilmarnock 1 - 1 Hamilton AcademicalHamilton 16
27 Oct 18 St. JohnstoneJohnstone 2 - 0 St. MirrenSt. Mirren 1
Ver jornada
Jornada 11
31 Oct 18 AberdeenAberdeen 3 - 0 Hamilton AcademicalHamilton 5
31 Oct 18 DundeeDundee 0 - 5 CelticCeltic 5
31 Oct 18 Heart of MidlothianHeart 0 - 0 Hibernian FCHibernian 12
31 Oct 18 LivingstonLivingston 0 - 1 St. JohnstoneJohnstone 8
31 Oct 18 Rangers FCRangers FC 1 - 1 KilmarnockKilmarnock 20
31 Oct 18 St. MirrenSt. Mirren 0 - 2 MotherwellMotherwell 3
Ver jornada
Jornada 12
03 Nov 18 CelticCeltic 5 - 0 Heart of MidlothianHeart 18
03 Nov 18 Hamilton AcademicalHamilton 1 - 0 LivingstonLivingston 1
03 Nov 18 Hibernian FCHibernian 0 - 1 St. JohnstoneJohnstone 2
04 Nov 18 KilmarnockKilmarnock 1 - 2 AberdeenAberdeen 4
03 Nov 18 MotherwellMotherwell 1 - 0 DundeeDundee 1
03 Nov 18 St. MirrenSt. Mirren 0 - 2 Rangers FCRangers FC 26
Ver jornada
Jornada 13
09 Nov 18 AberdeenAberdeen 1 - 0 Hibernian FCHibernian 7
10 Nov 18 DundeeDundee 1 - 1 St. MirrenSt. Mirren 1
10 Nov 18 Heart of MidlothianHeart 0 - 1 KilmarnockKilmarnock 5
11 Nov 18 LivingstonLivingston 0 - 0 CelticCeltic 30
11 Nov 18 Rangers FCRangers FC 7 - 1 MotherwellMotherwell 7
10 Nov 18 St. JohnstoneJohnstone 4 - 0 Hamilton AcademicalHamilton 1
Ver jornada
Jornada 14
24 Nov 18 Hamilton AcademicalHamilton 0 - 3 CelticCeltic 9
24 Nov 18 Hibernian FCHibernian 2 - 2 DundeeDundee 7
24 Nov 18 MotherwellMotherwell 3 - 0 AberdeenAberdeen 1
24 Nov 18 Rangers FCRangers FC 3 - 0 LivingstonLivingston 4
24 Nov 18 St. JohnstoneJohnstone 0 - 0 KilmarnockKilmarnock 1
24 Nov 18 St. MirrenSt. Mirren 2 - 0 Heart of MidlothianHeart 4
Ver jornada
Jornada 15
18 Dic 18 AberdeenAberdeen 5 - 1 DundeeDundee 17
30 Ene 19 CelticCeltic 2 - 0 St. JohnstoneJohnstone 35
02 Dic 18 Heart of MidlothianHeart 1 - 2 Rangers FCRangers FC 11
01 Dic 18 KilmarnockKilmarnock 3 - 0 Hibernian FCHibernian 2
01 Dic 18 LivingstonLivingston 2 - 0 MotherwellMotherwell 4
01 Dic 18 St. MirrenSt. Mirren 1 - 3 Hamilton AcademicalHamilton 1
Ver jornada
Jornada 16
05 Dic 18 DundeeDundee 4 - 0 Hamilton AcademicalHamilton 4
05 Dic 18 Hibernian FCHibernian 2 - 2 St. MirrenSt. Mirren 15
05 Dic 18 KilmarnockKilmarnock 2 - 0 LivingstonLivingston 2
05 Dic 18 MotherwellMotherwell 1 - 1 CelticCeltic 8
05 Dic 18 Rangers FCRangers FC 0 - 1 AberdeenAberdeen 61
05 Dic 18 St. JohnstoneJohnstone 2 - 2 Heart of MidlothianHeart 6
Ver jornada
Jornada 17
08 Dic 18 AberdeenAberdeen 0 - 2 St. JohnstoneJohnstone 5
08 Dic 18 CelticCeltic 5 - 1 KilmarnockKilmarnock 3
09 Dic 18 DundeeDundee 1 - 1 Rangers FCRangers FC 17
08 Dic 18 Hamilton AcademicalHamilton 0 - 1 Hibernian FCHibernian 2
08 Dic 18 Heart of MidlothianHeart 1 - 0 MotherwellMotherwell 1
08 Dic 18 LivingstonLivingston 3 - 1 St. MirrenSt. Mirren ...
Ver jornada
Jornada 18
16 Dic 18 Hibernian FCHibernian 2 - 0 CelticCeltic 56
15 Dic 18 KilmarnockKilmarnock 3 - 1 DundeeDundee 3
14 Dic 18 LivingstonLivingston 5 - 0 Heart of MidlothianHeart 8
16 Dic 18 Rangers FCRangers FC 1 - 0 Hamilton AcademicalHamilton 8
15 Dic 18 St. JohnstoneJohnstone 1 - 2 MotherwellMotherwell 10
15 Dic 18 St. MirrenSt. Mirren 1 - 2 AberdeenAberdeen 2
Ver jornada
Jornada 19
22 Dic 18 AberdeenAberdeen 2 - 0 Heart of MidlothianHeart 1
22 Dic 18 CelticCeltic 3 - 0 DundeeDundee 6
22 Dic 18 Hamilton AcademicalHamilton 1 - 1 KilmarnockKilmarnock ...
22 Dic 18 Hibernian FCHibernian 1 - 1 LivingstonLivingston 4
22 Dic 18 MotherwellMotherwell 0 - 1 St. MirrenSt. Mirren ...
23 Dic 18 St. JohnstoneJohnstone 1 - 2 Rangers FCRangers FC 40
Ver jornada
Jornada 20
26 Dic 18 AberdeenAberdeen 3 - 4 CelticCeltic 11
26 Dic 18 DundeeDundee 0 - 0 LivingstonLivingston 4
26 Dic 18 Heart of MidlothianHeart 2 - 0 Hamilton AcademicalHamilton 2
26 Dic 18 MotherwellMotherwell 0 - 1 KilmarnockKilmarnock 1
26 Dic 18 Rangers FCRangers FC 1 - 1 Hibernian FCHibernian 11
26 Dic 18 St. MirrenSt. Mirren 0 - 1 St. JohnstoneJohnstone 5
Ver jornada
Jornada 21
29 Dic 18 DundeeDundee 0 - 2 St. JohnstoneJohnstone 2
29 Dic 18 Hamilton AcademicalHamilton 1 - 2 MotherwellMotherwell 1
29 Dic 18 Hibernian FCHibernian 0 - 1 Heart of MidlothianHeart 44
29 Dic 18 KilmarnockKilmarnock 2 - 1 St. MirrenSt. Mirren 2
29 Dic 18 LivingstonLivingston 1 - 2 AberdeenAberdeen 8
29 Dic 18 Rangers FCRangers FC 1 - 0 CelticCeltic 260
Ver jornada
Jornada 22
23 Ene 19 CelticCeltic 4 - 0 St. MirrenSt. Mirren 10
23 Ene 19 Hamilton AcademicalHamilton 0 - 3 AberdeenAberdeen 23
23 Ene 19 Heart of MidlothianHeart 1 - 2 DundeeDundee 46
23 Ene 19 KilmarnockKilmarnock 2 - 1 Rangers FCRangers FC 35
23 Ene 19 MotherwellMotherwell 1 - 0 Hibernian FCHibernian 15
23 Ene 19 St. JohnstoneJohnstone 1 - 0 LivingstonLivingston 29
Ver jornada
Jornada 23
26 Ene 19 AberdeenAberdeen 0 - 0 KilmarnockKilmarnock 11
26 Ene 19 CelticCeltic 3 - 0 Hamilton AcademicalHamilton 18
26 Ene 19 DundeeDundee 0 - 1 MotherwellMotherwell ...
26 Ene 19 Heart of MidlothianHeart 2 - 0 St. JohnstoneJohnstone 2
27 Ene 19 LivingstonLivingston 0 - 3 Rangers FCRangers FC 4
27 Ene 19 St. MirrenSt. Mirren 1 - 3 Hibernian FCHibernian 4
Ver jornada
Jornada 24
02 Feb 19 Hamilton AcademicalHamilton 1 - 1 DundeeDundee 1
02 Feb 19 Hibernian FCHibernian 1 - 2 AberdeenAberdeen 1
01 Feb 19 KilmarnockKilmarnock 1 - 2 Heart of MidlothianHeart 31
02 Feb 19 MotherwellMotherwell 3 - 0 LivingstonLivingston 1
02 Feb 19 Rangers FCRangers FC 4 - 0 St. MirrenSt. Mirren 7
03 Feb 19 St. JohnstoneJohnstone 0 - 2 CelticCeltic 30
Ver jornada
Jornada 25
06 Feb 19 AberdeenAberdeen 2 - 4 Rangers FCRangers FC 35
06 Feb 19 CelticCeltic 2 - 0 Hibernian FCHibernian 33
06 Feb 19 DundeeDundee 2 - 2 KilmarnockKilmarnock 23
06 Feb 19 Hamilton AcademicalHamilton 2 - 1 St. JohnstoneJohnstone 6
06 Feb 19 Heart of MidlothianHeart 0 - 0 LivingstonLivingston 48
06 Feb 19 St. MirrenSt. Mirren 1 - 2 MotherwellMotherwell 7
Ver jornada
Jornada 26
16 Feb 19 AberdeenAberdeen 2 - 2 St. MirrenSt. Mirren 35
16 Feb 19 Hibernian FCHibernian 2 - 0 Hamilton AcademicalHamilton 3
17 Feb 19 KilmarnockKilmarnock 0 - 1 CelticCeltic 21
16 Feb 19 LivingstonLivingston 1 - 2 DundeeDundee 2
17 Feb 19 MotherwellMotherwell 2 - 1 Heart of MidlothianHeart 8
16 Feb 19 Rangers FCRangers FC 0 - 0 St. JohnstoneJohnstone 24
Ver jornada
Jornada 27
24 Feb 19 CelticCeltic 4 - 1 MotherwellMotherwell 18
22 Feb 19 DundeeDundee 2 - 4 Hibernian FCHibernian 7
24 Feb 19 Hamilton AcademicalHamilton 0 - 5 Rangers FCRangers FC 6
23 Feb 19 Heart of MidlothianHeart 1 - 1 St. MirrenSt. Mirren 5
23 Feb 19 LivingstonLivingston 1 - 0 KilmarnockKilmarnock 1
23 Feb 19 St. JohnstoneJohnstone 0 - 2 AberdeenAberdeen 8
Ver jornada
Jornada 28
27 Feb 19 AberdeenAberdeen 0 - 2 Hamilton AcademicalHamilton 51
27 Feb 19 Heart of MidlothianHeart 1 - 2 CelticCeltic 62
02 Mar 19 KilmarnockKilmarnock 0 - 0 MotherwellMotherwell 33
27 Feb 19 Rangers FCRangers FC 4 - 0 DundeeDundee 10
27 Feb 19 St. JohnstoneJohnstone 1 - 2 Hibernian FCHibernian 6
02 Mar 19 St. MirrenSt. Mirren 1 - 0 LivingstonLivingston 1
Ver jornada
Jornada 29
09 Mar 19 CelticCeltic 0 - 0 AberdeenAberdeen 29
09 Mar 19 DundeeDundee 0 - 1 Heart of MidlothianHeart 3
08 Mar 19 Hibernian FCHibernian 1 - 1 Rangers FCRangers FC 31
09 Mar 19 LivingstonLivingston 3 - 1 St. JohnstoneJohnstone ...
09 Mar 19 MotherwellMotherwell 3 - 0 Hamilton AcademicalHamilton ...
11 Mar 19 St. MirrenSt. Mirren 0 - 1 KilmarnockKilmarnock 35
Ver jornada
Jornada 30
16 Mar 19 AberdeenAberdeen 1 - 1 LivingstonLivingston 1
17 Mar 19 DundeeDundee 0 - 1 CelticCeltic 26
16 Mar 19 Hamilton AcademicalHamilton 1 - 0 Heart of MidlothianHeart 1
16 Mar 19 Hibernian FCHibernian 2 - 0 MotherwellMotherwell 1
16 Mar 19 Rangers FCRangers FC 1 - 1 KilmarnockKilmarnock 15
27 Mar 19 St. JohnstoneJohnstone 1 - 0 St. MirrenSt. Mirren 2
Ver jornada
Jornada 31
31 Mar 19 CelticCeltic 2 - 1 Rangers FCRangers FC 53
30 Mar 19 Heart of MidlothianHeart 2 - 1 AberdeenAberdeen 5
30 Mar 19 KilmarnockKilmarnock 5 - 0 Hamilton AcademicalHamilton ...
29 Mar 19 LivingstonLivingston 1 - 2 Hibernian FCHibernian 7
30 Mar 19 MotherwellMotherwell 3 - 0 St. JohnstoneJohnstone ...
30 Mar 19 St. MirrenSt. Mirren 2 - 1 DundeeDundee ...
Ver jornada
Jornada 32
03 Abr 19 AberdeenAberdeen 3 - 1 MotherwellMotherwell 9
03 Abr 19 Hibernian FCHibernian 0 - 0 KilmarnockKilmarnock 8
03 Abr 19 LivingstonLivingston 2 - 0 Hamilton AcademicalHamilton 3
03 Abr 19 Rangers FCRangers FC 3 - 0 Heart of MidlothianHeart 3
03 Abr 19 St. JohnstoneJohnstone 2 - 0 DundeeDundee 2
03 Abr 19 St. MirrenSt. Mirren 0 - 2 CelticCeltic 6
Ver jornada
Jornada 33
06 Abr 19 CelticCeltic 0 - 0 LivingstonLivingston 45
06 Abr 19 DundeeDundee 0 - 2 AberdeenAberdeen ...
06 Abr 19 Hamilton AcademicalHamilton 1 - 1 St. MirrenSt. Mirren ...
06 Abr 19 Heart of MidlothianHeart 1 - 2 Hibernian FCHibernian 10
06 Abr 19 KilmarnockKilmarnock 2 - 0 St. JohnstoneJohnstone ...
07 Abr 19 MotherwellMotherwell 0 - 3 Rangers FCRangers FC 4

Clasificación

Equipo PJ GF GC Puntos
1 Celtic Celtic 33 71 17 77
2 Rangers FC Rangers FC 33 73 24 66
3 Kilmarnock Kilmarnock 33 46 28 58
4 Aberdeen Aberdeen 33 52 37 58
5 Hibernian FC Hibernian 33 49 34 52
6 Heart of Midlothian Heart 33 38 41 50
7 St. Johnstone Johnstone 33 32 44 44
8 Motherwell Motherwell 33 37 47 43
9 Livingston Livingston 33 35 33 42
10 Hamilton Academical Hamilton 33 21 69 25
11 St. Mirren St. Mirren 33 24 61 21
12 Dundee Dundee 33 25 68 18

  USO DE MEMORIA  
6,291,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0024
Controller Execution Time ( Home / Category )  0.3957
Total Execution Time  0.3981
  CADENA URL  
/escocia2019/grupo1/calendario
  GET DATOS  
$_GET['/escocia2019/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0147  SELECT type FROM routes WHERE alias = 'escocia2019'
0.0298  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0147  SELECT id,name,alias,stepParent FROM categories WHERE parentId=14 ORDER BY order_id ASC
0.0163  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 calendars2019 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 43564 ORDER BY round ASC
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-09 02:56:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-09 02:56:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-09 02:56:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0150  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-09 02:56:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0154  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 = 2019 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0337  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 events2019 e ON e.player_id = p.id AND e.league_id = 43564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43564 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.0264  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 events2019 e ON e.player_id = p.id AND e.league_id = 43564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43564 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0157  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 events2019 e ON e.player_id = p.id AND e.league_id = 43564 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 43564 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0158  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 43564 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC