4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sandecja Nowy Sacz
TEMPORADA 2023/2024
TERCERA POLONIA
Equipo PJ GF GC Puntos
1 Pogon Siedlce Pogon 30 47 38 52
2 Kalisz Kalisz 30 42 28 48
3 Kotwica Kołobrzeg Kotwica 30 54 42 47
4 Radunia Stężyca Radunia 30 42 36 46
5 Hutnik Krakow Hutnik 30 43 39 45
6 Chojniczanka Chojnice Chojniczanka 30 38 35 45
7 LKS Lodz II LKS Lodz II 29 43 39 43
8 Zagłębie Lubin II Zagłębie 30 44 41 42
9 Stal Stalowa Wola Stal Stalowa 30 34 35 42
10 TS Polonia Bytom Polonia 30 43 44 41
11 Olimpia Elblag Olimpia 30 33 40 38
12 Lech Poznań II Lech Poznań 29 33 41 38
13 Wisla Pulawy Wisla Pulawy 30 43 44 36
14 SKRA Częstochowa SKRA 30 33 34 36
15 Jastrzębie Jastrzębie 30 34 41 36
16 Olimpia Grudziadz Olimpia 29 30 36 33
17 Stomil Olsztyn Stomil 29 25 34 30
18 Sandecja Nowy Sacz Sandecja 30 29 43 28
TEMPORADA 2022/2023
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 58 36 66
2 Ruch Chorzów Ruch 34 48 33 62
3 Termalica Nieciecza Termalica 34 55 37 61
4 Wisla Kraków Wisla 34 61 38 60
5 Puszcza Niepolomice Puszcza 34 49 36 58
6 Stal Rzeszow Stal Rzeszow 34 57 44 51
7 Podbeskidzie Podbeskidzie 34 56 47 49
8 Arka Gdynia Arka Gdynia 34 56 45 48
9 Chrobry Głogów Chrobry 34 44 53 46
10 GKS Katowice Katowice 34 41 39 44
11 Zagłębie Sosnowiec Zagłębie 34 33 43 42
12 Górnik Łęczna Górnik 34 40 45 40
13 GKS Tychy GKS Tychy 34 46 52 39
14 Resovia Rzeszów Resovia 34 43 51 38
15 Odra Opole Odra Opole 34 39 48 37
16 SKRA Częstochowa SKRA 34 19 50 31
17 Chojniczanka Chojnice Chojniczanka 34 35 57 27
18 Sandecja Nowy Sacz Sandecja 34 28 54 27
TEMPORADA 2021/2022
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Miedz Legnica Miedz 34 56 22 77
2 Widzew Łódź Widzew 34 53 38 62
3 Arka Gdynia Arka Gdynia 34 62 39 61
4 Korona Kielce Korona 34 46 37 56
5 Odra Opole Odra Opole 34 51 46 51
6 Chrobry Głogów Chrobry 34 43 34 50
7 Sandecja Nowy Sacz Sandecja 34 39 36 47
8 GKS Katowice Katowice 34 44 47 46
9 Podbeskidzie Podbeskidzie 34 48 41 45
10 LKS Lódz LKS Lódz 34 33 37 45
11 Resovia Rzeszów Resovia 34 42 39 44
12 GKS Tychy GKS Tychy 34 37 41 44
13 SKRA Częstochowa SKRA 34 28 41 38
14 Puszcza Niepolomice Puszcza 34 41 50 37
15 Zagłębie Sosnowiec Zagłębie 34 41 48 36
16 Stomil Olsztyn Stomil 34 32 52 35
17 Gornik Polkowice Gornik 34 32 54 29
18 Jastrzębie Jastrzębie 34 32 58 25
TEMPORADA 2020/2021
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Radomiak Radom Radomiak 34 49 20 68
2 Termalica Nieciecza Termalica 34 56 28 65
3 GKS Tychy GKS Tychy 34 49 27 63
4 Arka Gdynia Arka Gdynia 34 51 32 60
5 LKS Lódz LKS Lódz 34 59 41 58
6 Górnik Łęczna Górnik 34 47 30 56
7 Miedz Legnica Miedz 34 49 36 51
8 Odra Opole Odra Opole 34 35 41 49
9 Widzew Łódź Widzew 34 30 36 46
10 Sandecja Nowy Sacz Sandecja 34 42 50 45
11 Chrobry Głogów Chrobry 34 34 45 44
12 Korona Kielce Korona 34 31 46 41
13 Puszcza Niepolomice Puszcza 34 32 46 37
14 Jastrzębie Jastrzębie 34 32 48 35
15 Stomil Olsztyn Stomil 34 31 48 35
16 Resovia Rzeszów Resovia 34 27 45 32
17 Zagłębie Sosnowiec Zagłębie 34 35 43 30
18 GKS Bełchatów Bełchatów 34 24 51 23
TEMPORADA 2019/2020
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Stal Mielec Stal Mielec 34 57 31 67
2 Podbeskidzie Podbeskidzie 34 64 35 65
3 Warta Poznan Warta Poznan 34 52 35 60
4 Radomiak Radom Radomiak 34 52 45 57
5 Miedz Legnica Miedz 34 49 44 51
6 Termalica Nieciecza Termalica 34 47 34 50
7 Chrobry Głogów Chrobry 34 41 44 49
8 Puszcza Niepolomice Puszcza 34 36 37 48
9 GKS Tychy GKS Tychy 34 60 53 47
10 Stomil Olsztyn Stomil 34 30 38 46
11 Sandecja Nowy Sacz Sandecja 34 45 49 44
12 Zagłębie Sosnowiec Zagłębie 34 49 55 44
13 Odra Opole Odra Opole 34 33 39 42
14 Jastrzębie Jastrzębie 34 41 46 41
15 GKS Bełchatów Bełchatów 34 36 45 40
16 Olimpia Grudziadz Olimpia 34 45 56 40
17 Chojniczanka Chojnice Chojniczanka 34 46 67 30
18 Wigry Suwalki Wigry 34 27 57 26
TEMPORADA 2018/2019
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Raków Częstochowa Raków 34 54 22 70
2 LKS Lódz LKS Lódz 34 58 23 69
3 Stal Mielec Stal Mielec 34 59 28 64
4 Sandecja Nowy Sacz Sandecja 34 35 29 55
5 Jastrzębie Jastrzębie 34 43 38 48
6 Podbeskidzie Podbeskidzie 34 52 46 48
7 GKS Tychy GKS Tychy 34 48 41 47
8 Termalica Nieciecza Termalica 34 45 46 46
9 Puszcza Niepolomice Puszcza 34 37 45 44
10 Stomil Olsztyn Stomil 34 38 43 43
11 Chojniczanka Chojnice Chojniczanka 34 49 49 42
12 Odra Opole Odra Opole 34 47 58 40
13 Warta Poznan Warta Poznan 34 31 43 39
14 Chrobry Głogów Chrobry 34 29 39 39
15 Wigry Suwalki Wigry 34 40 56 37
16 Bytovia Bytow Bytovia 34 45 50 37
17 GKS Katowice Katowice 34 34 45 37
18 Garbarnia Kraków Garbarnia 34 21 64 21
TEMPORADA 2017/2018
LIGA POLACA GRUPO 3
Equipo PJ GF GC Puntos
1 Śląsk Wrocław Śląsk 7 15 6 50
2 KS Cracovia KS Cracovia 7 11 12 50
3 Pogon Szczecin Pogon 7 12 6 45
4 Arka Gdynia Arka Gdynia 7 8 16 43
5 Lechia Gdansk Lechia 7 7 7 39
6 Piast Gliwice Piast 7 12 10 37
7 Termalica Nieciecza Termalica 7 7 14 36
8 Sandecja Nowy Sacz Sandecja 7 7 8 33
TEMPORADA 2016/2017
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Sandecja Nowy Sacz Sandecja 34 50 29 61
2 Górnik Zabrze Górnik 34 53 34 58
3 Miedz Legnica Miedz 34 49 27 57
4 Zagłębie Sosnowiec Zagłębie 34 53 44 57
5 Olimpia Grudziadz Olimpia 34 48 35 56
6 Chojniczanka Chojnice Chojniczanka 34 54 48 56
7 GKS Katowice Katowice 34 47 32 54
8 Podbeskidzie Podbeskidzie 34 40 39 53
9 Wigry Suwalki Wigry 34 51 45 52
10 Stal Mielec Stal Mielec 34 38 42 45
11 Pogon Siedlce Pogon 34 34 46 44
12 Chrobry Głogów Chrobry 34 50 50 43
13 Stomil Olsztyn Stomil 34 48 50 37
14 GKS Tychy GKS Tychy 34 42 51 37
15 Bytovia Bytow Bytovia 34 38 47 35
16 Wisla Pulawy Wisla Pulawy 34 33 49 33
17 Znicz Pruszkow Znicz 34 35 64 30
18 Kluczbork Kluczbork 34 35 66 25
TEMPORADA 2015/2016
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Arka Gdynia Arka Gdynia 34 60 29 69
2 Wisła Płock Wisła 34 51 28 63
3 Zawisza Bydgoszcz Zawisza 34 57 51 52
4 GKS Katowice Katowice 34 42 36 52
5 Zagłębie Sosnowiec Zagłębie 34 53 53 52
6 Chrobry Głogów Chrobry 34 47 33 51
7 Miedz Legnica Miedz 34 41 34 51
8 Bytovia Bytow Bytovia 34 46 44 48
9 Sandecja Nowy Sacz Sandecja 34 51 43 47
10 Wigry Suwalki Wigry 34 41 35 45
11 Stomil Olsztyn Stomil 34 34 42 44
12 Chojniczanka Chojnice Chojniczanka 34 40 45 43
13 Olimpia Grudziadz Olimpia 34 39 43 42
14 Kluczbork Kluczbork 34 40 55 41
15 Pogon Siedlce Pogon 34 31 46 41
16 GKS Bełchatów Bełchatów 34 35 40 38
17 Rozwoj Katowice Rozwoj 34 35 56 35
18 Dolcan Zabki Dolcan Zabki 34 37 67 30
TEMPORADA 2014/2015
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zaglebie Lubin Zaglebie 34 57 20 77
2 Termalica Nieciecza Termalica 34 60 26 73
3 Wisła Płock Wisła 34 50 25 69
4 Olimpia Grudziadz Olimpia 34 46 37 53
5 Chojniczanka Chojnice Chojniczanka 34 50 37 50
6 Dolcan Zabki Dolcan Zabki 34 43 39 50
7 Stomil Olsztyn Stomil 34 47 47 49
8 GKS Katowice Katowice 34 44 41 48
9 Wigry Suwalki Wigry 34 36 37 47
10 Arka Gdynia Arka Gdynia 34 38 39 43
11 Chrobry Głogów Chrobry 34 41 45 41
12 Miedz Legnica Miedz 34 44 45 40
13 Bytovia Bytow Bytovia 34 39 45 40
14 Swinoujscie Swinoujscie 34 26 46 36
15 Sandecja Nowy Sacz Sandecja 34 40 55 35
16 Pogon Siedlce Pogon 34 34 53 30
17 GKS Tychy GKS Tychy 34 31 56 28
18 Widzew Łódź Widzew 34 25 58 22
TEMPORADA 2013/2014
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 GKS Bełchatów Bełchatów 34 50 27 63
2 Górnik Łęczna Górnik 34 45 27 61
3 Dolcan Zabki Dolcan Zabki 34 60 39 55
4 Arka Gdynia Arka Gdynia 34 53 40 54
5 Termalica Nieciecza Termalica 34 42 33 53
6 Olimpia Grudziadz Olimpia 34 38 39 53
7 Wisła Płock Wisła 34 37 33 52
8 GKS Katowice Katowice 34 44 45 46
9 Miedz Legnica Miedz 34 42 37 44
10 Kolejarz Stroze Kolejarz 34 36 38 44
11 Sandecja Nowy Sacz Sandecja 34 29 40 44
12 Swinoujscie Swinoujscie 34 29 34 42
13 Chojniczanka Chojnice Chojniczanka 34 35 33 41
14 Stomil Olsztyn Stomil 34 38 42 41
15 GKS Tychy GKS Tychy 34 39 48 41
16 Energetyk ROW Rybnik Energetyk 34 42 52 33
17 Puszcza Niepolomice Puszcza 34 37 56 33
18 Brzesko Brzesko 34 18 51 23
TEMPORADA 2012/2013
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Zawisza Bydgoszcz Zawisza 34 69 26 66
2 KS Cracovia KS Cracovia 34 48 35 64
3 Termalica Nieciecza Termalica 34 54 28 63
4 Swinoujscie Swinoujscie 34 57 33 63
5 Arka Gdynia Arka Gdynia 34 46 29 57
6 GKS Tychy GKS Tychy 34 44 28 55
7 Dolcan Zabki Dolcan Zabki 34 52 41 54
8 Miedz Legnica Miedz 34 49 42 53
9 Olimpia Grudziadz Olimpia 34 39 34 51
10 GKS Katowice Katowice 34 43 36 50
11 Kolejarz Stroze Kolejarz 34 47 45 50
12 Górnik Łęczna Górnik 34 37 42 46
13 Stomil Olsztyn Stomil 34 37 45 38
14 Sandecja Nowy Sacz Sandecja 34 35 54 37
15 Brzesko Brzesko 34 38 54 32
16 Warta Poznan Warta Poznan 34 34 57 28
17 TS Polonia Bytom Polonia 34 29 64 22
18 LKS Lódz LKS Lódz 34 17 82 14
TEMPORADA 2011/2012
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Piast Gliwice Piast 34 57 40 64
2 Pogon Szczecin Pogon 34 54 30 61
3 Zawisza Bydgoszcz Zawisza 34 47 39 59
4 Kolejarz Stroze Kolejarz 34 40 34 57
5 Termalica Nieciecza Termalica 34 42 26 56
6 Górnik Łęczna Górnik 34 50 37 54
7 Arka Gdynia Arka Gdynia 34 50 41 51
8 Swinoujscie Swinoujscie 34 46 43 49
9 Ruch Radzionków Ruch 34 46 51 48
10 Warta Poznan Warta Poznan 34 44 36 46
11 Olimpia Grudziadz Olimpia 34 46 41 43
12 Sandecja Nowy Sacz Sandecja 34 42 46 40
13 GKS Katowice Katowice 34 33 38 39
14 Dolcan Zabki Dolcan Zabki 34 40 53 39
15 TS Polonia Bytom Polonia 34 37 51 36
16 Wisła Płock Wisła 34 39 50 35
17 Gornik Polkowice Gornik 34 40 64 30
18 Olimpia Elblag Olimpia 34 33 66 22
TEMPORADA 2010/2011
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 LKS Lódz LKS Lódz 34 59 34 71
2 Podbeskidzie Podbeskidzie 34 53 23 69
3 Swinoujscie Swinoujscie 34 58 34 66
4 Sandecja Nowy Sacz Sandecja 34 52 34 56
5 Piast Gliwice Piast 34 45 31 52
6 Pogon Szczecin Pogon 34 55 42 51
7 Górnik Łęczna Górnik 34 44 39 50
8 Warta Poznan Warta Poznan 34 44 43 50
9 Ruch Radzionków Ruch 34 34 32 46
10 Gornik Polkowice Gornik 34 31 39 42
11 GKS Katowice Katowice 34 47 57 41
12 Kolejarz Stroze Kolejarz 34 30 43 38
13 Dolcan Zabki Dolcan Zabki 34 33 39 37
14 Termalica Nieciecza Termalica 34 40 53 37
15 Kluczbork Kluczbork 34 36 44 36
16 KSZO Ostrowiec KSZO 34 32 43 36
17 Odra Wodzislaw Slaski Odra 34 29 58 32
18 Warta Gorzów Warta 34 28 62 29
TEMPORADA 2009/2010
SEGUNDA POLONIA
Equipo PJ GF GC Puntos
1 Widzew Łódź Widzew 34 62 17 77
2 Górnik Zabrze Górnik 34 47 30 61
3 Sandecja Nowy Sacz Sandecja 34 55 42 59
4 LKS Lódz LKS Lódz 34 51 45 55
5 Pogon Szczecin Pogon 34 46 35 51
6 Kluczbork Kluczbork 34 43 37 46
7 Swinoujscie Swinoujscie 34 33 36 46
8 KSZO Ostrowiec KSZO 34 37 46 46
9 Warta Gorzów Warta 34 34 33 45
10 Podbeskidzie Podbeskidzie 34 45 38 44
11 Warta Poznan Warta Poznan 34 49 45 44
12 Górnik Łęczna Górnik 34 38 45 44
13 GKS Katowice Katowice 34 41 41 43
14 Dolcan Zabki Dolcan Zabki 34 37 43 42
15 Wisła Płock Wisła 34 43 51 40
16 Znicz Pruszkow Znicz 34 32 48 39
17 Stal Stalowa Wola Stal Stalowa 34 32 58 25
18 Motor Lublin Motor Lublin 34 27 62 23

  USO DE MEMORIA  
7,280,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.7400
Total Execution Time  0.7421
  CADENA URL  
/historico/Sandecja-Nowy-Sacz
  GET DATOS  
$_GET['/historico/Sandecja-Nowy-Sacz']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0174  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 = 'Sandecja-Nowy-Sacz' 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.0146  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=12656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=12656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=12656 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=12656 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12656 AND type_rel = 2
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12656 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  SELECT /*35 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 (185786,267854) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '12656' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '12656' 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 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=12656 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 (72234,72171,71432,67920) 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.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 67920 AND teamId = 12656
0.0161  SELECT count(id) as num_players from rel_players WHERE league_id = 72234 AND teamId = 12656
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 12656
0.0171  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12656
0.0147  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 = '12656' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12656' and rp.type = 4
0.0147  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 = '12656' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0159  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 12656 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.0157  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 12656 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 72234 WHERE rp.league_id = 72234 AND rp.teamId = 12656 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 12656 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0296  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 = 67920 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 63249 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0175  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 = 58338 AND t.round = 34 ORDER BY team.conference ASC,t.position 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 `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 = 49994 AND t.round = 34 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 `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 = 44126 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 38694 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 43272 AND t.round = 7 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 `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 = 33387 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 `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 = 15593 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 `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 = 3876 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 `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 = 2863 AND t.round = 34 ORDER BY team.conference 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 `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 = 8850 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 `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 = 8848 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 `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 = 8845 AND t.round = 34 ORDER BY team.conference 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 `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 = 8842 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC