4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Transición Tercera Georgia 2017  G 1
2016/2017

Temporada Regular

Transición Tercera Georgia 2017 G 1

  • Chiatura
  • Imereti
  • Kolkheti Khobi
  • Betlemi
  • Samegrelo
  • FC Sulori Vani
  • Margveti
  • FC Skuri Tsalenjikha
  • Lazika
  • Sapovnela
  • Shevardeni 1906
  • FC Telavi
  • Merani Tbilisi
  • Mark Stars
  • Gardabani
  • Gori FC
  • Borjomi
  • Algeti
  • Chkherimela
  • Liakhvi Tskhinvali
Jornada 1
19 Mar 17 SapovnelaSapovnela 0 - 1 FC Sulori VaniSulori Vani ...
19 Mar 17 Kolkheti KhobiKolkheti 2 - 1 FC Skuri TsalenjikhaSkuri ...
19 Mar 17 ImeretiImereti 3 - 0 LazikaLazika ...
19 Mar 17 ChiaturaChiatura 1 - 0 BetlemiBetlemi ...
19 Mar 17 Shevardeni 1906Shevardeni 2 - 0 BorjomiBorjomi ...
19 Mar 17 ChkherimelaChkherimela 0 - 1 FC TelaviFC Telavi ...
19 Mar 17 GardabaniGardabani 1 - 1 Merani TbilisiMerani ...
19 Mar 17 Gori FCGori FC 0 - 1 Mark StarsMark Stars ...
20 Mar 17 Liakhvi TskhinvaliLiakhvi 0 - 3 AlgetiAlgeti ...
20 Mar 17 MargvetiMargveti 1 - 1 SamegreloSamegrelo ...
Jornada 2
25 Mar 17 LazikaLazika 1 - 2 ChiaturaChiatura ...
25 Mar 17 SamegreloSamegrelo 0 - 2 SapovnelaSapovnela ...
25 Mar 17 BetlemiBetlemi 3 - 0 MargvetiMargveti ...
25 Mar 17 Kolkheti KhobiKolkheti 0 - 0 ImeretiImereti ...
25 Mar 17 Mark StarsMark Stars 3 - 0 Liakhvi TskhinvaliLiakhvi ...
25 Mar 17 FC Skuri TsalenjikhaSkuri 1 - 2 FC Sulori VaniSulori Vani ...
26 Mar 17 FC TelaviFC Telavi 1 - 1 GardabaniGardabani ...
26 Mar 17 Shevardeni 1906Shevardeni 0 - 3 ChkherimelaChkherimela ...
26 Mar 17 Merani TbilisiMerani 0 - 2 Gori FCGori FC ...
26 Mar 17 BorjomiBorjomi 1 - 0 AlgetiAlgeti ...
Jornada 3
02 Abr 17 ImeretiImereti 0 - 0 FC Skuri TsalenjikhaSkuri ...
02 Abr 17 SapovnelaSapovnela 0 - 0 BetlemiBetlemi ...
02 Abr 17 FC Sulori VaniSulori Vani 0 - 2 SamegreloSamegrelo ...
02 Abr 17 AlgetiAlgeti 0 - 0 Mark StarsMark Stars ...
02 Abr 17 Liakhvi TskhinvaliLiakhvi 1 - 1 Merani TbilisiMerani ...
02 Abr 17 ChiaturaChiatura 2 - 0 Kolkheti KhobiKolkheti ...
03 Abr 17 MargvetiMargveti 2 - 1 LazikaLazika ...
03 Abr 17 Gori FCGori FC 0 - 1 FC TelaviFC Telavi ...
03 Abr 17 ChkherimelaChkherimela 0 - 1 BorjomiBorjomi ...
03 Abr 17 GardabaniGardabani 0 - 1 Shevardeni 1906Shevardeni ...
Jornada 4
10 Abr 17 BetlemiBetlemi 2 - 1 FC Sulori VaniSulori Vani ...
10 Abr 17 Kolkheti KhobiKolkheti 4 - 1 MargvetiMargveti ...
10 Abr 17 LazikaLazika 0 - 0 SapovnelaSapovnela ...
10 Abr 17 ImeretiImereti 1 - 0 ChiaturaChiatura ...
10 Abr 17 FC Skuri TsalenjikhaSkuri 0 - 0 SamegreloSamegrelo ...
11 Abr 17 Shevardeni 1906Shevardeni 4 - 2 Gori FCGori FC ...
11 Abr 17 BorjomiBorjomi 0 - 1 Mark StarsMark Stars ...
11 Abr 17 Merani TbilisiMerani 6 - 1 AlgetiAlgeti ...
11 Abr 17 ChkherimelaChkherimela 2 - 2 GardabaniGardabani ...
11 Abr 17 FC TelaviFC Telavi 1 - 0 Liakhvi TskhinvaliLiakhvi ...
Jornada 5
20 Abr 17 SamegreloSamegrelo 2 - 2 BetlemiBetlemi ...
20 Abr 17 SapovnelaSapovnela 0 - 3 Kolkheti KhobiKolkheti ...
20 Abr 17 FC Sulori VaniSulori Vani 0 - 1 LazikaLazika ...
20 Abr 17 ChiaturaChiatura 3 - 2 FC Skuri TsalenjikhaSkuri ...
20 Abr 17 MargvetiMargveti 2 - 2 ImeretiImereti ...
20 Abr 17 AlgetiAlgeti 1 - 2 FC TelaviFC Telavi ...
20 Abr 17 Liakhvi TskhinvaliLiakhvi 4 - 2 Shevardeni 1906Shevardeni ...
21 Abr 17 Gori FCGori FC 4 - 0 ChkherimelaChkherimela ...
21 Abr 17 GardabaniGardabani 2 - 0 BorjomiBorjomi ...
21 Abr 17 Mark StarsMark Stars 1 - 3 Merani TbilisiMerani ...
Jornada 6
01 May 17 ChiaturaChiatura 1 - 0 MargvetiMargveti ...
01 May 17 LazikaLazika 0 - 1 SamegreloSamegrelo ...
01 May 17 FC Skuri TsalenjikhaSkuri 2 - 2 BetlemiBetlemi ...
01 May 17 Kolkheti KhobiKolkheti 0 - 2 FC Sulori VaniSulori Vani ...
01 May 17 ImeretiImereti 0 - 0 SapovnelaSapovnela ...
02 May 17 Shevardeni 1906Shevardeni 2 - 0 AlgetiAlgeti ...
02 May 17 BorjomiBorjomi 2 - 1 Merani TbilisiMerani ...
02 May 17 GardabaniGardabani 0 - 0 Gori FCGori FC ...
02 May 17 FC TelaviFC Telavi 3 - 3 Mark StarsMark Stars ...
02 May 17 ChkherimelaChkherimela 1 - 1 Liakhvi TskhinvaliLiakhvi ...
Jornada 7
08 May 17 SamegreloSamegrelo 1 - 2 Kolkheti KhobiKolkheti ...
08 May 17 FC Sulori VaniSulori Vani 1 - 2 ImeretiImereti ...
08 May 17 SapovnelaSapovnela 1 - 1 ChiaturaChiatura ...
08 May 17 BetlemiBetlemi 4 - 1 LazikaLazika ...
08 May 17 MargvetiMargveti 3 - 1 FC Skuri TsalenjikhaSkuri ...
08 May 17 AlgetiAlgeti 0 - 1 ChkherimelaChkherimela ...
08 May 17 Gori FCGori FC 0 - 0 BorjomiBorjomi ...
09 May 17 Liakhvi TskhinvaliLiakhvi 0 - 4 GardabaniGardabani ...
09 May 17 Merani TbilisiMerani 1 - 0 FC TelaviFC Telavi ...
10 May 17 Mark StarsMark Stars 1 - 2 Shevardeni 1906Shevardeni ...
Jornada 8
16 May 17 MargvetiMargveti 3 - 2 SapovnelaSapovnela ...
16 May 17 Kolkheti KhobiKolkheti 1 - 0 BetlemiBetlemi ...
16 May 17 ImeretiImereti 0 - 0 SamegreloSamegrelo ...
16 May 17 FC Skuri TsalenjikhaSkuri 1 - 1 LazikaLazika ...
16 May 17 ChiaturaChiatura 2 - 1 FC Sulori VaniSulori Vani ...
17 May 17 Gori FCGori FC 1 - 0 Liakhvi TskhinvaliLiakhvi ...
17 May 17 BorjomiBorjomi 1 - 1 FC TelaviFC Telavi ...
17 May 17 Shevardeni 1906Shevardeni 1 - 1 Merani TbilisiMerani ...
17 May 17 GardabaniGardabani 0 - 3 AlgetiAlgeti ...
17 May 17 ChkherimelaChkherimela 2 - 2 Mark StarsMark Stars ...
Jornada 9
22 May 17 SamegreloSamegrelo 0 - 0 ChiaturaChiatura ...
22 May 17 FC Sulori VaniSulori Vani 1 - 0 MargvetiMargveti ...
22 May 17 BetlemiBetlemi 0 - 3 ImeretiImereti ...
22 May 17 SapovnelaSapovnela 1 - 2 FC Skuri TsalenjikhaSkuri ...
22 May 17 LazikaLazika 2 - 3 Kolkheti KhobiKolkheti ...
22 May 17 AlgetiAlgeti 3 - 3 Gori FCGori FC ...
23 May 17 Liakhvi TskhinvaliLiakhvi 3 - 2 BorjomiBorjomi ...
23 May 17 FC TelaviFC Telavi 1 - 0 Shevardeni 1906Shevardeni ...
23 May 17 Merani TbilisiMerani 4 - 0 ChkherimelaChkherimela ...
24 May 17 Mark StarsMark Stars 1 - 1 GardabaniGardabani ...
Jornada 10
30 May 17 SamegreloSamegrelo 2 - 2 MargvetiMargveti ...
30 May 17 BetlemiBetlemi 2 - 1 ChiaturaChiatura ...
30 May 17 FC Sulori VaniSulori Vani 2 - 0 SapovnelaSapovnela ...
30 May 17 FC Skuri TsalenjikhaSkuri 2 - 1 Kolkheti KhobiKolkheti ...
30 May 17 LazikaLazika 0 - 0 ImeretiImereti ...
30 May 17 Mark StarsMark Stars 3 - 2 Gori FCGori FC ...
31 May 17 BorjomiBorjomi 0 - 2 Shevardeni 1906Shevardeni ...
31 May 17 Merani TbilisiMerani 3 - 2 GardabaniGardabani ...
31 May 17 FC TelaviFC Telavi 3 - 2 ChkherimelaChkherimela ...
01 Jun 17 AlgetiAlgeti 2 - 1 Liakhvi TskhinvaliLiakhvi ...
Jornada 11
05 Jun 17 FC Sulori VaniSulori Vani 2 - 0 FC Skuri TsalenjikhaSkuri ...
05 Jun 17 SapovnelaSapovnela 0 - 1 SamegreloSamegrelo ...
05 Jun 17 ChiaturaChiatura 2 - 0 LazikaLazika ...
05 Jun 17 ImeretiImereti 1 - 0 Kolkheti KhobiKolkheti ...
05 Jun 17 GardabaniGardabani 1 - 3 FC TelaviFC Telavi ...
06 Jun 17 MargvetiMargveti 1 - 0 BetlemiBetlemi ...
06 Jun 17 ChkherimelaChkherimela 0 - 2 Shevardeni 1906Shevardeni ...
06 Jun 17 AlgetiAlgeti 3 - 0 BorjomiBorjomi ...
06 Jun 17 Gori FCGori FC 2 - 6 Merani TbilisiMerani ...
06 Jun 17 Liakhvi TskhinvaliLiakhvi 2 - 5 Mark StarsMark Stars ...
Jornada 12
12 Jun 17 BetlemiBetlemi 9 - 0 SapovnelaSapovnela ...
12 Jun 17 FC Skuri TsalenjikhaSkuri 0 - 2 ImeretiImereti ...
12 Jun 17 Kolkheti KhobiKolkheti 0 - 0 ChiaturaChiatura ...
12 Jun 17 LazikaLazika 0 - 2 MargvetiMargveti ...
12 Jun 17 Mark StarsMark Stars 2 - 2 AlgetiAlgeti ...
13 Jun 17 Shevardeni 1906Shevardeni 2 - 1 GardabaniGardabani ...
13 Jun 17 BorjomiBorjomi 3 - 1 ChkherimelaChkherimela ...
13 Jun 17 FC TelaviFC Telavi 2 - 0 Gori FCGori FC ...
13 Jun 17 Merani TbilisiMerani 2 - 1 Liakhvi TskhinvaliLiakhvi ...
14 Jun 17 SamegreloSamegrelo 2 - 0 FC Sulori VaniSulori Vani ...
Jornada 13
19 Jun 17 SamegreloSamegrelo 2 - 0 FC Skuri TsalenjikhaSkuri ...
19 Jun 17 SapovnelaSapovnela 0 - 1 LazikaLazika ...
19 Jun 17 FC Sulori VaniSulori Vani 1 - 1 BetlemiBetlemi ...
19 Jun 17 ChiaturaChiatura 1 - 0 ImeretiImereti ...
19 Jun 17 Liakhvi TskhinvaliLiakhvi 0 - 0 FC TelaviFC Telavi ...
19 Jun 17 Mark StarsMark Stars 1 - 1 BorjomiBorjomi ...
20 Jun 17 MargvetiMargveti 1 - 1 Kolkheti KhobiKolkheti ...
20 Jun 17 Gori FCGori FC 1 - 0 Shevardeni 1906Shevardeni ...
20 Jun 17 GardabaniGardabani 2 - 1 ChkherimelaChkherimela ...
20 Jun 17 AlgetiAlgeti 3 - 1 Merani TbilisiMerani ...
Jornada 14
25 Jun 17 BetlemiBetlemi 1 - 1 SamegreloSamegrelo ...
25 Jun 17 Kolkheti KhobiKolkheti 3 - 0 SapovnelaSapovnela ...
25 Jun 17 LazikaLazika 0 - 2 FC Sulori VaniSulori Vani ...
25 Jun 17 ImeretiImereti 1 - 0 MargvetiMargveti ...
25 Jun 17 FC Skuri TsalenjikhaSkuri 0 - 3 ChiaturaChiatura ...
26 Jun 17 Merani TbilisiMerani 0 - 2 Mark StarsMark Stars ...
26 Jun 17 FC TelaviFC Telavi 2 - 2 AlgetiAlgeti ...
26 Jun 17 ChkherimelaChkherimela 0 - 0 Gori FCGori FC ...
26 Jun 17 BorjomiBorjomi 2 - 0 GardabaniGardabani ...
26 Jun 17 Shevardeni 1906Shevardeni 7 - 1 Liakhvi TskhinvaliLiakhvi ...
Jornada 15
01 Jul 17 BetlemiBetlemi 2 - 1 FC Skuri TsalenjikhaSkuri ...
01 Jul 17 SapovnelaSapovnela 0 - 3 ImeretiImereti ...
01 Jul 17 FC Sulori VaniSulori Vani 1 - 2 Kolkheti KhobiKolkheti ...
01 Jul 17 SamegreloSamegrelo 0 - 0 LazikaLazika ...
01 Jul 17 Mark StarsMark Stars 2 - 6 FC TelaviFC Telavi ...
02 Jul 17 MargvetiMargveti 2 - 6 ChiaturaChiatura ...
02 Jul 17 Liakhvi TskhinvaliLiakhvi 0 - 1 ChkherimelaChkherimela ...
02 Jul 17 Merani TbilisiMerani 1 - 0 BorjomiBorjomi ...
03 Jul 17 Gori FCGori FC 2 - 3 GardabaniGardabani ...
03 Jul 17 AlgetiAlgeti 0 - 2 Shevardeni 1906Shevardeni ...
Jornada 16
08 Jul 17 Kolkheti KhobiKolkheti 1 - 1 SamegreloSamegrelo ...
08 Jul 17 FC Skuri TsalenjikhaSkuri 1 - 0 MargvetiMargveti ...
08 Jul 17 ImeretiImereti 1 - 0 FC Sulori VaniSulori Vani ...
08 Jul 17 LazikaLazika 2 - 2 BetlemiBetlemi ...
08 Jul 17 ChiaturaChiatura 1 - 0 SapovnelaSapovnela ...
09 Jul 17 GardabaniGardabani 4 - 1 Liakhvi TskhinvaliLiakhvi ...
09 Jul 17 ChkherimelaChkherimela 1 - 1 AlgetiAlgeti ...
09 Jul 17 FC TelaviFC Telavi 1 - 2 Merani TbilisiMerani ...
09 Jul 17 Shevardeni 1906Shevardeni 3 - 2 Mark StarsMark Stars ...
09 Jul 17 BorjomiBorjomi 0 - 0 Gori FCGori FC ...
Jornada 17
16 Jul 17 LazikaLazika 1 - 2 FC Skuri TsalenjikhaSkuri ...
16 Jul 17 FC Sulori VaniSulori Vani 3 - 3 ChiaturaChiatura ...
16 Jul 17 SapovnelaSapovnela 1 - 1 MargvetiMargveti ...
16 Jul 17 BetlemiBetlemi 1 - 1 Kolkheti KhobiKolkheti ...
16 Jul 17 SamegreloSamegrelo 3 - 0 ImeretiImereti ...
16 Jul 17 Mark StarsMark Stars 1 - 1 ChkherimelaChkherimela ...
17 Jul 17 Liakhvi TskhinvaliLiakhvi 1 - 5 Gori FCGori FC ...
17 Jul 17 FC TelaviFC Telavi 2 - 0 BorjomiBorjomi ...
17 Jul 17 Merani TbilisiMerani 2 - 2 Shevardeni 1906Shevardeni ...
18 Jul 17 AlgetiAlgeti 1 - 1 GardabaniGardabani ...
Jornada 18
24 Jul 17 Kolkheti KhobiKolkheti 1 - 2 LazikaLazika ...
24 Jul 17 ImeretiImereti 1 - 3 BetlemiBetlemi ...
24 Jul 17 FC Skuri TsalenjikhaSkuri 0 - 0 SapovnelaSapovnela ...
24 Jul 17 ChiaturaChiatura 3 - 1 SamegreloSamegrelo ...
24 Jul 17 MargvetiMargveti 0 - 0 FC Sulori VaniSulori Vani ...
24 Jul 17 Gori FCGori FC 2 - 0 AlgetiAlgeti ...
24 Jul 17 GardabaniGardabani 1 - 0 Mark StarsMark Stars ...
24 Jul 17 ChkherimelaChkherimela 2 - 4 Merani TbilisiMerani ...
24 Jul 17 BorjomiBorjomi 3 - 1 Liakhvi TskhinvaliLiakhvi ...
24 Jul 17 Shevardeni 1906Shevardeni 2 - 0 FC TelaviFC Telavi ...

Clasificación

Equipo PJ GF GC Puntos
1 Chiatura Chiatura 18 32 14 40
2 Imereti Imereti 18 20 10 33
3 Kolkheti Khobi Kolkheti 18 25 18 29
4 Betlemi Betlemi 18 34 20 28
5 Samegrelo Samegrelo 18 20 14 27
6 FC Sulori Vani Sulori Vani 18 20 19 24
7 Margveti Margveti 18 21 28 21
8 FC Skuri Tsalenjikha Skuri 18 16 27 17
9 Lazika Lazika 18 13 27 14
10 Sapovnela Sapovnela 18 7 31 9
11 Shevardeni 1906 Shevardeni 18 36 19 38
12 FC Telavi FC Telavi 18 30 18 35
13 Merani Tbilisi Merani 18 39 24 34
14 Mark Stars Mark Stars 18 31 29 25
15 Gardabani Gardabani 18 26 24 24
16 Gori FC Gori FC 18 26 24 23
17 Borjomi Borjomi 18 16 21 22
18 Algeti Algeti 18 25 27 21
19 Chkherimela Chkherimela 18 18 31 15
20 Liakhvi Tskhinvali Liakhvi 18 17 47 9

  USO DE MEMORIA  
6,177,800 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1092
Total Execution Time  0.1113
  CADENA URL  
/transicion_tercera_georgia2017/grupo1/calendario
  GET DATOS  
$_GET['/transicion_tercera_georgia2017/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0018  SELECT type FROM routes WHERE alias = 'transicion_tercera_georgia2017'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'transicion_tercera_georgia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1980 AND type_rel = 3
0.0020  SELECT id,name,alias,stepParent FROM categories WHERE parentId=1980 ORDER BY order_id ASC
0.0019  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 1980 GROUP BY l.categoryId
0.0019  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=1980 GROUP BY l.year ORDER BY l.year DESC
0.0023  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 = 39923 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028  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 calendars2017 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 39923 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-05-06 22:07:16' 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-05-06 22:07:16' 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-05-06 22:07:16' 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-05-06 22:07:16' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'transicion_tercera_georgia' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0020  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 events2017 e ON e.player_id = p.id AND e.league_id = 39923 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39923 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.0019  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 events2017 e ON e.player_id = p.id AND e.league_id = 39923 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39923 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2017 e ON e.player_id = p.id AND e.league_id = 39923 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 39923 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0044  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2017` 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 = 39923 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC