4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2020/2021
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Spaeri Spaeri 26 79 20 64
2 Kolkheti Poti Kolkheti 26 54 28 49
3 Tbilisi City FC Tbilisi City 26 46 30 45
4 Varketili Varketili 26 43 37 41
5 Aragvi Dusheti Aragvi 26 37 32 40
6 Gori FC Gori FC 26 33 33 38
7 Saburtalo II Saburtalo 26 53 36 38
8 Bakhmaro Bakhmaro 26 26 33 33
9 Kolkheti Khobi Kolkheti 26 32 39 31
10 Meshakhte Meshakhte 26 31 42 30
11 Guria Lanchkhuti Guria 26 33 44 29
12 Merani Tbilisi II Merani 26 33 50 28
13 Chiatura Chiatura 26 23 46 21
14 Didube 2014 Didube 2014 26 25 78 14
TEMPORADA 2019/2020
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Gareji Gareji 18 33 17 43
2 Kolkheti Poti Kolkheti 18 47 18 38
3 Gori FC Gori FC 18 22 18 32
4 Spaeri Spaeri 18 31 20 30
5 Guria Lanchkhuti Guria 18 26 30 26
6 Kolkheti Khobi Kolkheti 18 27 24 22
7 Tbilisi City FC Tbilisi City 18 21 23 21
8 Saburtalo II Saburtalo 18 22 31 19
9 Bakhmaro Bakhmaro 18 20 33 18
10 Meshakhte Meshakhte 18 10 45 6
TEMPORADA 2018/2019
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Merani Tbilisi Merani 36 87 35 81
2 Samtredia Samtredia 36 63 28 77
3 FC Telavi FC Telavi 36 70 36 63
4 Shevardeni 1906 Shevardeni 36 47 48 52
5 Gagra Gagra 36 46 42 47
6 Shukura Shukura 36 36 46 46
7 Zugdidi Zugdidi 36 38 54 40
8 Guria Lanchkhuti Guria 36 39 64 36
9 Kolkheti Poti Kolkheti 36 31 80 34
10 Spartaki Tskhinvali Spartaki 36 38 62 32
TEMPORADA 2017/2018
TERCERA GEORGIA
Equipo PJ GF GC Puntos
1 Zugdidi Zugdidi 38 65 31 84
2 Bakhmaro Bakhmaro 38 78 40 79
3 Guria Lanchkhuti Guria 38 59 31 73
4 Saburtalo II Saburtalo 38 60 50 67
5 Kolkheti Khobi Kolkheti 38 54 35 61
6 Aragvi Dusheti Aragvi 38 64 55 61
7 Borjomi Borjomi 38 66 56 61
8 Meshakhte Meshakhte 38 59 54 57
9 Gori FC Gori FC 38 58 48 53
10 Betlemi Betlemi 38 52 58 51
11 Samegrelo Samegrelo 38 63 55 48
12 Chiatura Chiatura 38 39 47 47
13 Varketili Varketili 38 58 58 47
14 Algeti Algeti 38 54 64 46
15 Mark Stars Mark Stars 38 59 65 46
16 Imereti Imereti 38 44 52 45
17 Gardabani Gardabani 38 39 63 39
18 FC Sulori Vani Sulori Vani 38 38 77 36
19 Samgurali II Samgurali 38 40 82 31
20 Matchakhela Matchakhela 38 35 63 28
TEMPORADA 2016/2017
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Rustavi FC Rustavi 36 72 25 83
2 Merani Martvili Merani 36 67 16 80
3 Sioni Sioni 36 52 48 59
4 Gagra Gagra 36 46 38 53
5 Samgurali Samgurali 36 46 46 53
6 WIT Georgia WIT Georgia 36 42 40 52
7 Spartaki Tskhinvali Spartaki 36 62 75 40
8 Guria Lanchkhuti Guria 36 47 68 37
9 Meshakhte Meshakhte 36 33 75 27
10 Zugdidi Zugdidi 36 32 68 25
TEMPORADA 2015/2016
TRANSICIÓN LIGA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Samtredia Samtredia 12 27 9 27
2 Dinamo Batumi Dinamo 12 20 5 20
3 FC Iberia 1999 Iberia 1999 12 17 12 19
4 Kolkheti Poti Kolkheti 12 10 18 18
5 Dila Gori Dila Gori 12 13 12 17
6 Sioni Sioni 12 13 19 11
7 Zugdidi Zugdidi 12 5 30 6
8 Chikhura Chikhura 12 27 11 29
9 Dinamo Tbilisi Dinamo 12 17 5 23
10 Torpedo Kutaisi Torpedo 12 16 12 15
11 Locomotive Tbilisi Locomotive 12 11 18 15
12 Shukura Shukura 12 10 13 12
13 Guria Lanchkhuti Guria 12 8 21 11
14 Spartaki Tskhinvali Spartaki 12 12 21 9
TEMPORADA 2014/2015
LIGA GEORGIA
Equipo PJ GF GC Puntos
1 Dila Gori Dila Gori 30 50 21 64
2 Dinamo Batumi Dinamo 30 40 24 58
3 Dinamo Tbilisi Dinamo 30 56 28 58
4 Spartaki Tskhinvali Spartaki 30 47 37 53
5 Chikhura Chikhura 30 39 36 46
6 Samtredia Samtredia 30 40 31 45
7 Torpedo Kutaisi Torpedo 30 39 33 41
8 Shukura Shukura 30 36 38 41
9 Guria Lanchkhuti Guria 30 38 43 39
10 Kolkheti Poti Kolkheti 30 31 31 37
11 Merani Martvili Merani 30 29 33 36
12 Zugdidi Zugdidi 30 24 45 33
13 Sioni Sioni 30 32 46 32
14 FC Rustavi FC Rustavi 30 25 46 26
15 WIT Georgia WIT Georgia 30 27 40 26
16 Zestafoni Zestafoni 30 40 61 26
TEMPORADA 2013/2014
LIGA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dinamo Tbilisi Dinamo 22 51 17 48
2 Zestafoni Zestafoni 22 30 15 40
3 Chikhura Chikhura 22 40 33 38
4 Sioni Sioni 22 27 23 33
5 FC Rustavi FC Rustavi 22 26 25 33
6 Guria Lanchkhuti Guria 22 25 29 33
7 Dila Gori Dila Gori 22 28 22 32
8 WIT Georgia WIT Georgia 22 28 29 29
9 Torpedo Kutaisi Torpedo 22 24 30 29
10 Spartaki Tskhinvali Spartaki 22 19 32 20
11 Zugdidi Zugdidi 22 12 30 20
12 Merani Martvili Merani 22 16 41 15
TEMPORADA 2012/2013
SEGUNDA GEORGIA GRUPO 1
Equipo PJ GF GC Puntos
1 Guria Lanchkhuti Guria 33 86 20 85
2 Dinamo Tbilisi II Dinamo 33 100 42 69
3 Sasco Tiblisi Sasco 33 84 38 64
4 Gagra Gagra 33 63 46 53
5 Meshakhte Meshakhte 33 42 66 45
6 Chiatura Chiatura 33 39 47 43
7 Imereti Imereti 33 37 46 43
8 Sakartvelos TU Sakartvelos 33 63 75 39
9 FC Skuri Tsalenjikha Skuri 33 33 51 38
10 Betlemi Betlemi 33 40 76 35
11 FC Sulori Vani Sulori Vani 33 30 72 25
12 Racha Ambrolauri Racha 33 39 77 24
TEMPORADA 2011/2012
SEGUNDA GEORGIA GRUPO 2
Equipo PJ GF GC Puntos
1 Chikhura Chikhura 18 40 6 49
2 Guria Lanchkhuti Guria 18 41 15 39
3 Imereti Imereti 18 31 25 29
4 FC Skuri Tsalenjikha Skuri 18 25 26 27
5 Zooveti Tbilisi Zooveti 18 23 29 27
6 Merani Tbilisi Merani 18 30 24 26
7 Samgurali Samgurali 18 27 23 23
8 Adeli Adeli 18 19 36 13
9 FC Sulori Vani Sulori Vani 18 11 35 12
10 Aeti Sokhumi Aeti Sokhumi 18 13 41 11
TEMPORADA 2010/2011
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Gagra Gagra 32 73 19 75
2 Merani Martvili Merani 32 60 15 73
3 Dila Gori Dila Gori 32 58 21 69
4 Chikhura Chikhura 32 58 25 66
5 Dinamo Batumi Dinamo 32 66 18 63
6 Kolkheti Khobi Kolkheti 32 28 34 46
7 Guria Lanchkhuti Guria 32 50 59 46
8 Imereti Imereti 32 36 43 37
9 Chkherimela Chkherimela 32 35 45 35
10 Meshakhte Meshakhte 32 32 48 35
11 Merani Tbilisi Merani 32 39 58 35
12 Adeli Adeli 32 38 54 32
13 Mertskhali Mertskhali 32 41 68 32
14 Samgurali Samgurali 32 38 64 30
15 FC Skuri Tsalenjikha Skuri 32 28 52 29
16 Chiatura Chiatura 32 28 69 29
17 Locomotive Tbilisi Locomotive 32 30 46 28
TEMPORADA 2009/2010
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Torpedo Kutaisi Torpedo 28 70 12 70
2 Kolkheti Poti Kolkheti 28 63 21 61
3 Dinamo Batumi Dinamo 28 44 17 53
4 Guria Lanchkhuti Guria 28 53 32 53
5 Merani Martvili Merani 28 44 31 53
6 Chikhura Chikhura 28 41 28 49
7 IBSU FC IBSU FC 28 45 40 34
8 Merani Tbilisi Merani 28 38 57 32
9 Mertskhali Mertskhali 28 29 45 31
10 Kolkheti Khobi Kolkheti 28 36 52 30
11 Chiatura Chiatura 28 36 58 30
12 Meshakhte Meshakhte 28 36 68 25
13 35-e Skola 35-e Skola 28 30 49 24
14 Lagodekhi FC Lagodekhi 28 27 60 23
15 Meskheti Akhaltsikhe Meskheti 28 26 48 22
TEMPORADA 2008/2009
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Samtredia Samtredia 30 56 23 66
2 Mglebi Zugdidi Mglebi 30 58 20 63
3 Merani Martvili Merani 30 45 24 60
4 Torpedo Kutaisi Torpedo 30 32 22 45
5 Kolkheti Poti Kolkheti 30 45 38 45
6 Chiatura Chiatura 30 38 48 39
7 Dinamo Batumi Dinamo 30 33 42 36
8 Kolkheti Khobi Kolkheti 30 30 47 36
9 Guria Lanchkhuti Guria 30 38 49 35
10 Zestafoni II Zestafoni 30 26 47 27
11 Meshakhte Meshakhte 30 20 61 16
12 FC Ameri FC Ameri 30 57 16 68
13 Chikhura Chikhura 30 56 21 64
14 Dinamo Tbilisi II Dinamo 30 59 25 60
15 WIT Georgia II Georgia 30 50 18 60
16 Dila Gori Dila Gori 30 48 31 45
17 FC Tbilisi FC Tbilisi 30 55 46 42
18 Lagodekhi FC Lagodekhi 30 34 55 32
19 Sioni II Sioni II 30 35 64 30
20 Gagra II Gagra II 30 38 58 27
21 Merani Tbilisi Merani 30 28 72 16
22 Kakheti Telavi Kakheti 30 20 74 15
TEMPORADA 2006/2007
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Mglebi Zugdidi Mglebi 34 58 24 76
2 Meskheti Akhaltsikhe Meskheti 34 69 19 72
3 Gagra Gagra 34 52 36 60
4 WIT Georgia II Georgia 34 60 29 58
5 FC Ameri II FC Ameri II 34 58 36 57
6 Chiatura Chiatura 34 49 32 57
7 Meshakre Agara Meshakre 34 45 36 55
8 Merani Tbilisi Merani 34 50 49 52
9 Meshakhte Meshakhte 34 53 40 51
10 FC Tbilisi FC Tbilisi 34 52 47 50
11 Samtredia Samtredia 34 35 43 47
12 Zestafoni II Zestafoni 34 34 40 40
13 Racha Ambrolauri Racha 34 41 49 39
14 Dinamo Tbilisi II Dinamo 34 49 40 36
15 Guria Lanchkhuti Guria 34 36 76 31
16 Chikhura II Chikhura II 34 28 67 29
17 Spartaki Tbilisi Spartaki 34 19 51 27
18 Mertskhali Mertskhali 34 21 95 14
TEMPORADA 2005/2006
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Chikhura Chikhura 34 87 34 78
2 Merani Tbilisi Merani 34 59 27 74
3 Gagra Gagra 34 49 22 68
4 Dinamo Tbilisi II Dinamo 34 57 27 62
5 Meshakre Agara Meshakre 34 46 32 59
6 Meskheti Akhaltsikhe Meskheti 34 50 30 57
7 FC Ameri II FC Ameri II 34 40 29 51
8 FC Rustavi FC Rustavi 34 50 37 49
9 Guria Lanchkhuti Guria 34 50 47 47
10 WIT Georgia II Georgia 34 43 45 45
11 FC Tbilisi II Tbilisi 34 34 40 44
12 Meshakhte Meshakhte 34 38 40 42
13 Zugdidi Zugdidi 34 23 33 41
14 Chiatura Chiatura 34 38 56 37
15 Zestafoni II Zestafoni 34 23 44 36
16 Gareji Gareji 34 28 44 31
17 Locomotive Tbilisi II Locomotive 34 22 84 21
18 Liakhvi Achabeti Liakhvi 34 24 90 13
TEMPORADA 2004/2005
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 FC Ameri FC Ameri 30 93 18 72
2 Borjomi Borjomi 30 74 36 69
3 Spartaki Tbilisi Spartaki 30 52 36 57
4 WIT Georgia II Georgia 30 49 28 55
5 Kakheti Telavi Kakheti 30 57 41 55
6 Dinamo Tbilisi II Dinamo 30 64 50 49
7 Spartaki Tskhinvali Spartaki 30 39 36 46
8 Chikhura Chikhura 30 38 35 43
9 Locomotive Tbilisi II Locomotive 30 33 40 38
10 Guria Lanchkhuti Guria 30 30 45 38
11 FC Rustavi FC Rustavi 30 39 43 37
12 FC Tbilisi II Tbilisi 30 35 44 35
13 Iveria Iveria 30 31 45 35
14 Merani Tbilisi Merani 30 35 53 28
15 Gareji Gareji 30 26 70 17
16 Chiatura Chiatura 30 17 92 4
TEMPORADA 2003/2004
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Shukura Shukura 30 54 28 61
2 Samgurali Samgurali 30 39 19 58
3 FC Milani Tsnori Milani 30 38 26 52
4 FC Rustavi FC Rustavi 30 46 31 51
5 Dinamo Tbilisi II Dinamo 30 68 36 50
6 Chikhura Chikhura 30 41 29 50
7 FC Tbilisi II Tbilisi 30 38 31 50
8 TSU Tbilisi TSU Tbilisi 30 59 30 47
9 Spartaki Tskhinvali Spartaki 30 45 25 46
10 Guria Lanchkhuti Guria 30 38 37 45
11 WIT Georgia Mtskheta Georgia 30 31 22 44
12 FC Ameri FC Ameri 30 34 24 43
13 Iveria Iveria 30 29 42 39
14 Samtredia Samtredia 30 22 77 19
15 Luka Batumi Luka Batumi 30 29 85 16
16 FC Metalurgi Zestafoni Metalurgi 30 18 87 7
TEMPORADA 2002/2003
SEGUNDA GEORGIA
Equipo PJ GF GC Puntos
1 Lazika Lazika 30 64 30 64
2 Mertskhali Mertskhali 30 62 29 64
3 FK Mtskheta FK Mtskheta 30 50 23 58
4 Samgurali Samgurali 30 42 26 53
5 Spartaki Tbilisi Spartaki 30 49 31 49
6 Spartaki Tskhinvali Spartaki 30 37 26 48
7 Shukura Shukura 30 27 23 48
8 Dinamo Tbilisi II Dinamo 30 37 29 45
9 Locomotive Tbilisi II Locomotive 30 32 25 44
10 TSU Tbilisi TSU Tbilisi 30 28 33 38
11 Iveria Iveria 30 39 41 37
12 Guria Lanchkhuti Guria 30 32 44 34
13 FC Tbilisi II Tbilisi 30 38 46 32
14 Kolkheti Khobi Kolkheti 30 17 44 23
15 Alazani Alazani 30 30 77 21
16 Samtredia Samtredia 30 24 81 11

  USO DE MEMORIA  
7,055,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.8428
Total Execution Time  0.8440
  CADENA URL  
/historico/Fc-Guria-Lanchkhuti/2021
  GET DATOS  
$_GET['/historico/Fc-Guria-Lanchkhuti/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0158  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Fc-Guria-Lanchkhuti' AND l.year = 2021 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=13613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0292  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 = 61980
0.0150  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 = 61879
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13613 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1618 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1618 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149  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 (894718,566283) ORDER BY n.cover_points DESC, update_date DESC
0.0156  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '13613' ORDER BY l.year DESC,cat.coefficient DESC
0.0160  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '13613' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0169  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '13613' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0158  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61879 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 61980 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0154  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=13613 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0146  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (67540,67095,62807) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 67095 AND teamId = 13613
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 67540 AND teamId = 13613
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 13613
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2021` 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 = 61980 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '13613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '13613' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61980 WHERE rp.league_id = 61980 AND rp.teamId = 13613 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61980 WHERE rp.league_id = 61980 AND rp.teamId = 13613 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2021 e ON e.player_id = p.id AND e.league_id = 61980 WHERE rp.league_id = 61980 AND rp.teamId = 13613 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 13613 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 `tables2021` 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 = 61980 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2020` 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 = 55370 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `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 = 48700 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `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 = 39909 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2016` 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 = 15498 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2016` 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 = 33343 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2015` 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 = 4149 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2014` 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 = 10403 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2014` 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 = 2882 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2013` 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 = 15182 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 `tables2012` 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 = 15185 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2011` 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 = 15187 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 `tables2010` 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 = 15188 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2009` 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 = 15189 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2007` 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 = 15191 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 `tables2006` 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 = 15192 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2005` 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 = 15193 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2004` 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 = 15194 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables2003` 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 = 15195 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 61980 ORDER BY nameShow LIMIT 100