4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Kolomna
TEMPORADA 2023/2024
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Kompositum Kompositum 5 13 7 15
2 Khimki II Khimki II 5 7 3 13
3 Arsenal Tula II Arsenal Tula 5 11 4 12
4 Kosmos Dolgoprudny Kosmos 5 8 5 10
5 Dinamo Vladivostok Dinamo 4 7 5 9
6 Spartak Tambov Spartak 5 7 7 7
7 FK Ryazan FK Ryazan 5 5 5 7
8 Strogino Strogino 4 10 6 6
9 FK Orel FK Orel 5 5 6 6
10 Sakhalin Yuzhno-Sakhalinsk Sakhalin 4 3 4 6
11 Zenit Penza Zenit Penza 5 5 5 5
12 SKA Khabarovsk II Khabarovsk 5 7 8 3
13 Salyut Belgorod Salyut 5 4 10 2
14 Kolomna Kolomna 4 2 9 0
15 Kvant Kvant 4 3 13 0
TEMPORADA 2022/2023
SEGUNDA B RUSIA - TRANSICIÓN GRUPO 3
Equipo PJ GF GC Puntos
1 Kaluga Kaluga 17 50 6 39
2 Sakhalinets Sakhalinets 17 38 21 36
3 Spartak Tambov Spartak 17 26 22 33
4 Dinamo Vladivostok Dinamo 17 30 21 30
5 Arsenal Tula II Arsenal Tula 17 24 16 30
6 Kompositum Kompositum 17 28 20 29
7 FC Saturn FC Saturn 17 30 18 29
8 SKA Khabarovsk II Khabarovsk 17 30 29 25
9 Zenit Penza Zenit Penza 17 22 26 25
10 Sakhalin Yuzhno-Sakhalinsk Sakhalin 17 16 19 23
11 Kosmos Dolgoprudny Kosmos 17 24 28 23
12 Kvant Kvant 17 19 27 23
13 Znamya Noginsk Znamya 17 18 26 22
14 Khimki II Khimki II 17 20 28 19
15 FK Ryazan FK Ryazan 17 24 27 15
16 Strogino Strogino 17 28 36 14
17 Kolomna Kolomna 17 17 41 8
18 Peresvet Podolsk Peresvet 17 21 54 7
TEMPORADA 2021/2022
SEGUNDA B RUSIA GRUPO 8
Equipo PJ GF GC Puntos
1 Zenit Penza Zenit Penza 10 18 7 36
2 Sakhalin Yuzhno-Sakhalinsk Sakhalin 10 18 13 32
3 Kaluga Kaluga 10 23 7 31
4 Arsenal Tula II Arsenal Tula 10 14 20 30
5 Znamya Noginsk Znamya 10 13 10 27
6 Kvant Kvant 10 10 9 27
7 FC Saturn FC Saturn 10 15 19 25
8 Fakel II Fakel II 10 15 13 18
9 Metallurg Vidnoye Metallurg 10 15 22 17
10 Kolomna Kolomna 10 7 28 15
TEMPORADA 2020/2021
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 FSC Dolgoprudniy Dolgoprudniy 30 45 18 68
2 Zenit II Zenit II 30 56 26 59
3 Dinamo Moskva II Dinamo 30 63 37 58
4 Tver Tver 29 53 27 56
5 Leningradets Leningradets 30 51 29 54
6 Kazanka Kazanka 30 52 39 48
7 Rodina Moskva Rodina 30 59 46 45
8 Zvezda St. Petersburg Zvezda 30 41 29 43
9 Torpedo Vladimir Torpedo 30 40 40 39
10 Znamya Znamya 30 31 39 33
11 Smolensk Smolensk 30 26 46 31
12 Luki-Energiya Luki-Energiy 30 31 53 31
13 Murom Murom 30 32 42 30
14 FK Chita FK Chita 29 26 60 26
15 Kolomna Kolomna 30 38 63 22
16 Zenit Irkutsk Zenit 30 15 65 18
TEMPORADA 2019/2020
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Veles Veles 16 34 13 36
2 FSC Dolgoprudniy Dolgoprudniy 17 29 16 35
3 Zenit II Zenit II 17 30 14 32
4 Torpedo Vladimir Torpedo 17 23 17 30
5 Leningradets Leningradets 17 27 20 28
6 Olimp Khimki Olimp Khimki 16 18 15 26
7 Murom Murom 16 31 23 24
8 Rodina Moskva Rodina 17 27 31 22
9 Pskov 747 Pskov 747 16 15 26 21
10 Kazanka Kazanka 16 26 27 17
11 Kolomna Kolomna 17 15 24 15
12 Znamya Znamya 17 14 23 15
13 Luki-Energiya Luki-Energiy 16 15 29 13
14 Zvezda St. Petersburg Zvezda 17 9 35 6
TEMPORADA 2018/2019
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Kazanka Kazanka 24 53 27 52
2 Tekstilshchik Tekstilshchi 23 39 20 52
3 Veles Veles 24 44 18 49
4 FSC Dolgoprudniy Dolgoprudniy 24 43 21 40
5 Leningradets Leningradets 24 32 28 37
6 Murom Murom 24 39 37 36
7 Znamya Znamya 24 29 27 34
8 Torpedo Vladimir Torpedo 23 28 27 30
9 Luki-Energiya Luki-Energiy 24 22 24 29
10 Pskov 747 Pskov 747 24 34 42 29
11 Kolomna Kolomna 24 26 56 21
12 Dnepr Smolensk Dnepr 22 16 53 14
13 Chertanovo II Chertanovo 24 26 51 13
TEMPORADA 2017/2018
SEGUNDA B RUSIA GRUPO 4
Equipo PJ GF GC Puntos
1 Chertanovo Chertanovo 26 52 15 61
2 Tekstilshchik Tekstilshchi 26 49 20 54
3 Kazanka Kazanka 26 50 23 52
4 Veles Veles 26 46 32 46
5 Spartak Kostroma Spartak 26 34 26 43
6 FSC Dolgoprudniy Dolgoprudniy 26 49 27 43
7 Pskov 747 Pskov 747 26 30 36 37
8 Torpedo Vladimir Torpedo 26 38 34 36
9 Murom Murom 26 24 28 32
10 Dynamo St Petersburg II Dynamo 26 29 35 32
11 Luki-Energiya Luki-Energiy 26 19 23 28
12 Dnepr Smolensk Dnepr 26 26 40 25
13 Kolomna Kolomna 26 18 59 16
14 Znamya Znamya 26 12 78 4
TEMPORADA 2016/2017
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Dynamo St Petersburg Dynamo 26 63 19 64
2 FSC Dolgoprudniy Dolgoprudniy 26 53 20 56
3 Tekstilshchik Tekstilshchi 26 49 23 52
4 Dinamo Moskva II Dinamo 26 38 25 43
5 Spartak Kostroma Spartak 26 39 22 43
6 Solaris Solaris 26 50 40 37
7 Torpedo Vladimir Torpedo 26 30 31 35
8 Domodedovo Domodedovo 26 21 32 33
9 Dnepr Smolensk Dnepr 26 35 37 29
10 Pskov 747 Pskov 747 26 18 31 28
11 Strogino Strogino 26 18 42 23
12 Kolomna Kolomna 26 19 43 21
13 Znamya Znamya 26 15 47 16
14 Volga Tver Volga Tver 26 14 50 16
TEMPORADA 2015/2016
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 FK Khimki FK Khimki 28 53 14 69
2 FSC Dolgoprudniy Dolgoprudniy 28 49 30 55
3 Solaris Solaris 28 50 24 55
4 Tekstilshchik Tekstilshchi 28 49 23 53
5 Torpedo Vladimir Torpedo 28 37 24 51
6 Dynamo St Petersburg Dynamo 28 44 31 47
7 Spartak Kostroma Spartak 28 42 33 47
8 Pskov 747 Pskov 747 28 38 38 38
9 Strogino Strogino 28 35 32 33
10 Dnepr Smolensk Dnepr 28 26 32 31
11 Volga Tver Volga Tver 28 26 43 28
12 Znamya Znamya 28 28 54 25
13 Domodedovo Domodedovo 28 30 52 22
14 Karelia Karelia 28 26 58 20
15 Kolomna Kolomna 28 20 65 10
TEMPORADA 2014/2015
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Spartak Moskva II Spartak 30 65 26 65
2 Zenit II Zenit II 30 78 41 57
3 FK Khimki FK Khimki 30 42 26 54
4 Strogino Strogino 30 39 29 54
5 Tekstilshchik Tekstilshchi 30 51 29 53
6 FSC Dolgoprudniy Dolgoprudniy 30 45 39 51
7 FC Saturn FC Saturn 30 42 31 50
8 Torpedo Vladimir Torpedo 30 41 36 48
9 Pskov 747 Pskov 747 30 39 38 42
10 Domodedovo Domodedovo 30 48 50 38
11 Volga Tver Volga Tver 30 36 54 32
12 Spartak Kostroma Spartak 30 26 39 28
13 Dnepr Smolensk Dnepr 30 32 49 28
14 Solaris Solaris 30 39 59 28
15 Kolomna Kolomna 30 28 67 23
16 Znamya Znamya 30 21 59 18
TEMPORADA 2013/2014
SEGUNDA B RUSIA GRUPO 3
Equipo PJ GF GC Puntos
1 Tosno Tosno 32 51 16 71
2 Tekstilshchik Tekstilshchi 32 58 32 67
3 FK Khimki FK Khimki 32 67 37 58
4 Pskov 747 Pskov 747 32 44 31 56
5 Dnepr Smolensk Dnepr 32 48 43 52
6 Torpedo Vladimir Torpedo 32 48 38 49
7 Sever Murmansk Sever 32 39 34 48
8 Lokomotiv Moskva II Lokomotiv 32 49 40 45
9 FSC Dolgoprudniy Dolgoprudniy 32 40 32 45
10 Zenit II Zenit II 32 43 43 43
11 Strogino Strogino 32 37 39 39
12 Spartak Kostroma Spartak 32 31 33 36
13 Kolomna Kolomna 32 32 56 35
14 Znamya Znamya 32 19 52 30
15 FC Vologda FC Vologda 32 34 49 29
16 Volga Tver Volga Tver 32 28 52 26
17 FC Rus Saint Petersburg Saint 32 16 57 20
TEMPORADA 2001/2002
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Metallurg Lipetsk Metallurg 38 74 18 92
2 Vityaz Podolsk Vityaz 38 69 29 82
3 Salyut Belgorod Salyut 38 52 32 73
4 Dinamo Bryansk Dinamo 38 50 28 72
5 FC Oryol FC Oryol 38 41 28 71
6 Spartak Tambov Spartak 38 53 51 57
7 FK Ryazan FK Ryazan 38 42 34 53
8 Don Novomoskovsk Novomoskovsk 38 42 36 53
9 FK Yelyets FK Yelyets 38 46 46 53
10 Lukhovitsy Lukhovitsy 38 31 36 53
11 Saturn-2 Saturn-2 38 33 34 49
12 Lokomotiv Kaluga Lokomotiv 38 41 50 47
13 Titan Moskva Titan Moskva 38 47 57 46
14 Mostransgaz Gazoprovod Mostransgaz 38 35 43 43
15 Avangard Kursk Avangard 38 40 55 41
16 Znamya Znamya 38 24 35 40
17 Dynamo Tula Dynamo Tula 38 34 52 40
18 Kolomna Kolomna 38 35 51 36
19 Fabus Bronnitsy Fabus 38 25 46 30
20 Lokomotiv Liski Lokomotiv 38 22 75 17
TEMPORADA 2000/2001
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 Metallurg Lipetsk Metallurg 38 82 19 87
2 Salyut Belgorod Salyut 38 78 29 85
3 Dinamo Bryansk Dinamo 38 64 23 82
4 Vityaz Podolsk Vityaz 38 73 34 75
5 FC Oryol FC Oryol 38 48 28 67
6 Spartak Tambov Spartak 38 58 46 65
7 Lokomotiv Kaluga Lokomotiv 38 60 53 62
8 Avangard Kursk Avangard 38 47 41 58
9 FK Ryazan FK Ryazan 38 36 35 46
10 Lukhovitsy Lukhovitsy 38 35 42 46
11 Znamya Znamya 38 41 50 46
12 Saturn-2 Saturn-2 38 44 51 45
13 Titan Moskva Titan Moskva 38 44 59 43
14 Krasnoznamensk Krasnoznamen 38 47 80 41
15 FK Yelyets FK Yelyets 38 36 56 40
16 Dynamo Tula Dynamo Tula 38 41 58 38
17 Fabus Bronnitsy Fabus 38 45 63 36
18 Lokomotiv Liski Lokomotiv 38 35 53 35
19 Kolomna Kolomna 38 25 68 30
20 Don Novomoskovsk Novomoskovsk 38 16 67 24
TEMPORADA 1999/2000
SEGUNDA B RUSIA GRUPO 2
Equipo PJ GF GC Puntos
1 FK Khimki FK Khimki 38 68 22 88
2 Dinamo Bryansk Dinamo 38 60 23 86
3 FC Oryol FC Oryol 38 57 31 77
4 Spartak Tambov Spartak 38 49 31 65
5 Uralan-Plus Uralan-Plus 38 48 33 62
6 Krasnoznamensk Krasnoznamen 40 43 36 60
7 Saturn-2 Saturn-2 38 41 27 55
8 Spartak-Telekom Spartak-Tele 38 38 30 54
9 Avangard Kursk Avangard 38 36 41 54
10 Lokomotiv Kaluga Lokomotiv 38 41 39 51
11 Lokomotiv Liski Lokomotiv 38 33 40 46
12 Kolomna Kolomna 38 36 63 45
13 FK Ryazan FK Ryazan 36 24 31 43
14 Znamya Znamya 38 34 46 43
15 Don Novomoskovsk Novomoskovsk 38 27 38 42
16 FK Yelyets FK Yelyets 38 25 44 42
17 Fabus Bronnitsy Fabus 38 35 50 41
18 Titan Moskva Titan Moskva 38 34 46 39
19 Lukhovitsy Lukhovitsy 38 23 44 34
20 Dynamo Tula Dynamo Tula 38 28 65 22

  USO DE MEMORIA  
6,751,040 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.8804
Total Execution Time  0.8815
  CADENA URL  
/historico/Kolomna
  GET DATOS  
$_GET['/historico/Kolomna']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0154  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 = 'Kolomna' AND l.year = 2024 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=13414 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=13414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=13414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=13414 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0294  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 = 75690
0.0153  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 = 73402
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13414 AND type_rel = 2
0.0147  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=382 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 382 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 (1268221,1267675,1162132,1037410,1031092) ORDER BY n.cover_points DESC, update_date 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 = '13414' ORDER BY l.year DESC,cat.coefficient DESC
0.0170  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 = '13414' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152  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 = '13414' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0149  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 = 73402 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 75690 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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=13414 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0147  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 (75690,73402,72436,71432) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 75690 AND teamId = 13414
0.0164  SELECT count(id) as num_players from rel_players WHERE league_id = 72436 AND teamId = 13414
0.0180  SELECT count(id) as num_players from rel_players WHERE league_id = 73402 AND teamId = 13414
0.0174  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13414
0.0162  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2024` 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 = 75690 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0158  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 = '13414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13414' and rp.type = 4
0.0150  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 = '13414' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158  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 events2024 e ON e.player_id = p.id AND e.league_id = 75690 WHERE rp.league_id = 75690 AND rp.teamId = 13414 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.0158  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 events2024 e ON e.player_id = p.id AND e.league_id = 75690 WHERE rp.league_id = 75690 AND rp.teamId = 13414 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 events2024 e ON e.player_id = p.id AND e.league_id = 75690 WHERE rp.league_id = 75690 AND rp.teamId = 13414 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 13414 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `tables2024` 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 = 75690 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 `tables2023` 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 = 68282 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2023` 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 = 71396 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 `tables2023` 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 = 72436 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 `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 = 63369 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 `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 = 67130 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 57804 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 50435 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 44474 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0160  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 `tables2018` 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 = 39158 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159  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 = 33933 AND t.round = 26 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 `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 = 15685 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 `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 = 4366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 2866 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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 `tables2002` 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 = 26804 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168  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 `tables2001` 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 = 26811 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2000` 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 = 26822 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 75690 ORDER BY nameShow LIMIT 100