4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Tatran Krásno
TEMPORADA 2023/2024
CUARTA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Tatran Krásno Tatran 17 38 8 45
2 Kysucké Nové Mesto Kysucké 18 30 15 35
3 Slávia Staškov Slávia 18 37 27 30
4 Sokol Zubrohlava Sokol 17 24 24 26
5 Bešeňová Bešeňová 17 27 24 26
6 Javorník Makov Javorník 18 25 32 25
7 Badín Badín 18 20 22 23
8 Sokol Medzibrod Sokol 17 27 22 21
9 TJ Kováčová Kováčová 18 27 24 21
10 Čadca Čadca 17 19 28 21
11 OŠK Baník Stráňavy OŠK Baník 18 19 33 19
12 Príbelce Príbelce 18 16 26 18
13 ŠK Tvrdošín Tvrdošín 18 18 29 16
14 Liptovská Štiavnica Liptovská 17 17 30 16
TEMPORADA 2022/2023
CUARTA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Lokomotiva Zvolen Lokomotiva 26 68 18 65
2 Javorník Makov Javorník 26 81 17 63
3 Slávia Staškov Slávia 26 77 29 52
4 Tatran Krásno Tatran 26 75 24 50
5 Čadca Čadca 26 36 18 45
6 Bešeňová Bešeňová 26 62 40 44
7 TJ Kováčová Kováčová 26 51 31 39
8 Badín Badín 26 45 31 37
9 Kysucké Nové Mesto Kysucké 26 40 30 34
10 OŠK Baník Stráňavy OŠK Baník 26 31 47 29
11 Šalková Šalková 26 47 50 28
12 Liptovská Štiavnica Liptovská 26 25 48 21
13 Žarnovica Žarnovica 26 27 114 9
14 Liptovský Hrádok Liptovský 26 2 170 0
TEMPORADA 2021/2022
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Dolný Kubín Dolný 30 81 31 68
2 FK Rakytovce 85 Rakytovce 30 60 25 62
3 Fomat Martin Fomat Martin 30 58 30 62
4 Oravské Veselé Oravské 30 55 27 56
5 Bánová Bánová 30 45 20 54
6 Novohrad Lučenec Novohrad 30 44 35 52
7 FTC Filakovo Filakovo 30 43 37 48
8 Podkonice Podkonice 30 60 38 46
9 Baník Kalinovo Baník 30 39 47 40
10 Sobota Sobota 30 32 58 35
11 Tatran Krásno Tatran 30 43 49 34
12 TJ Kováčová Kováčová 30 34 51 33
13 Liptovský Hrádok Liptovský 30 41 67 32
14 Žarnovica Žarnovica 30 39 73 24
15 Liptovská Štiavnica Liptovská 30 28 65 21
16 Čadca Čadca 30 31 80 13
TEMPORADA 2020/2021
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Námestovo Námestovo 15 38 10 38
2 FK Rakytovce 85 Rakytovce 15 31 13 35
3 Oravské Veselé Oravské 15 28 10 33
4 Sobota Sobota 15 32 22 28
5 Bánová Bánová 15 37 17 26
6 Fomat Martin Fomat Martin 15 28 18 26
7 Tatran Krásno Tatran 15 30 29 24
8 TJ Kováčová Kováčová 15 23 12 23
9 Baník Kalinovo Baník 15 19 19 19
10 Liptovská Štiavnica Liptovská 15 28 42 19
11 FTC Filakovo Filakovo 15 19 14 18
12 Novohrad Lučenec Novohrad 15 25 42 16
13 Liptovský Hrádok Liptovský 15 20 28 14
14 Žarnovica Žarnovica 15 15 41 11
15 Čadca Čadca 15 12 35 9
16 Lokomotiva Zvolen Lokomotiva 15 10 43 4
TEMPORADA 2019/2020
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Fomat Martin Fomat Martin 14 49 6 38
2 Oravské Veselé Oravské 14 20 9 26
3 Bánová Bánová 14 23 16 26
4 Lokomotiva Zvolen Lokomotiva 14 19 14 25
5 Baník Kalinovo Baník 14 17 15 25
6 TJ Kováčová Kováčová 14 28 14 23
7 FTC Filakovo Filakovo 14 20 14 20
8 Námestovo Námestovo 14 19 17 20
9 Novohrad Lučenec Novohrad 14 17 20 20
10 Liptovský Hrádok Liptovský 14 16 19 18
11 Tatran Krásno Tatran 14 14 19 16
12 Sobota Sobota 14 18 28 15
13 Liptovská Štiavnica Liptovská 14 20 28 14
14 Žarnovica Žarnovica 14 13 35 10
15 Čadca Čadca 14 7 30 9
16 FK Rakytovce 85 Rakytovce 14 11 27 8
TEMPORADA 2018/2019
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ružomberok II Ružomberok 30 78 23 68
2 Sobota Sobota 30 54 26 60
3 Námestovo Námestovo 30 51 28 53
4 Lokomotiva Zvolen Lokomotiva 30 37 23 53
5 FTC Filakovo Filakovo 30 45 41 50
6 Fomat Martin Fomat Martin 30 59 40 48
7 Liptovský Hrádok Liptovský 30 48 38 48
8 Oravské Veselé Oravské 30 47 37 47
9 Žarnovica Žarnovica 30 45 39 45
10 Baník Kalinovo Baník 30 38 50 41
11 Novohrad Lučenec Novohrad 30 27 43 36
12 Tatran Krásno Tatran 30 30 46 31
13 Podbrezová II Podbrezová 30 40 48 29
14 Poltár Poltár 30 40 80 22
15 Liptovská Štiavnica Liptovská 30 37 77 22
16 Čadca Čadca 30 31 68 19
TEMPORADA 2017/2018
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 MFK Dukla MFK Dukla 30 60 18 69
2 Sobota Sobota 30 84 41 58
3 Liptovský Hrádok Liptovský 30 61 44 53
4 Baník Kalinovo Baník 30 47 36 52
5 Novohrad Lučenec Novohrad 30 50 37 51
6 Námestovo Námestovo 30 51 33 48
7 Žarnovica Žarnovica 30 38 47 44
8 Liptovská Štiavnica Liptovská 30 34 45 44
9 Oravské Veselé Oravské 30 36 33 43
10 Fomat Martin Fomat Martin 30 53 42 41
11 Čadca Čadca 30 47 49 38
12 FTC Filakovo Filakovo 30 36 56 38
13 Tatran Krásno Tatran 30 41 50 35
14 Teplička nad Váhom Teplička 30 40 52 31
15 Nová Bana Nová Bana 30 35 73 22
16 MFK Detva MFK Detva 30 31 88 15
TEMPORADA 2016/2017
TERCERA ESLOVAQUIA GRUPO 1
Equipo PJ GF GC Puntos
1 Liptovský Hrádok Liptovský 29 87 18 74
2 Kremnička Kremnička 29 48 29 50
3 Baník Kalinovo Baník 29 48 37 50
4 Podbrezová II Podbrezová 29 61 48 49
5 Žarnovica Žarnovica 29 53 44 48
6 Námestovo Námestovo 29 43 30 47
7 Novohrad Lučenec Novohrad 29 44 48 42
8 Čadca Čadca 29 41 50 40
9 Teplička nad Váhom Teplička 29 49 49 37
10 Tatran Krásno Tatran 29 40 41 36
11 FTC Filakovo Filakovo 29 40 50 33
12 Liptovská Štiavnica Liptovská 29 43 63 32
13 Nová Bana Nová Bana 29 36 61 30
14 TJ Stráža TJ Stráža 15 21 12 29
15 MFK Detva MFK Detva 29 35 72 21
16 Javorník Makov Javorník 29 35 72 20
TEMPORADA 2015/2016
TERCERA ESLOVAQUIA GRUPO 2
Equipo PJ GF GC Puntos
1 Fomat Martin Fomat Martin 30 76 17 76
2 Kremnička Kremnička 30 62 28 62
3 Liptovský Hrádok Liptovský 30 62 25 60
4 Žarnovica Žarnovica 30 61 52 58
5 Námestovo Námestovo 30 52 30 53
6 Javorník Makov Javorník 30 64 58 46
7 Baník Kalinovo Baník 30 55 44 44
8 Podbrezová II Podbrezová 30 49 44 42
9 Čadca Čadca 30 45 51 42
10 Liptovská Štiavnica Liptovská 30 47 52 39
11 Tatran Krásno Tatran 30 39 42 37
12 MFK Detva MFK Detva 30 46 57 34
13 LAFC Lučenec LAFC 30 43 55 32
14 Nová Bana Nová Bana 30 43 56 31
15 Bytča Bytča 30 40 84 29
16 Pohronie II Pohronie II 30 20 109 2
TEMPORADA 2014/2015
TERCERA ESLOVAQUIA GRUPO 3
Equipo PJ GF GC Puntos
1 Teplička nad Váhom Teplička 29 69 18 74
2 Fomat Martin Fomat Martin 29 65 22 63
3 Javorník Makov Javorník 29 68 33 52
4 Námestovo Námestovo 29 42 31 49
5 Kremnička Kremnička 29 55 45 47
6 Baník Kalinovo Baník 29 50 34 44
7 Liptovský Hrádok Liptovský 29 52 55 44
8 Nová Bana Nová Bana 29 42 48 37
9 FK Rakytovce 85 Rakytovce 29 42 55 37
10 Bytča Bytča 29 49 54 35
11 LAFC Lučenec LAFC 29 35 47 35
12 Pohronie II Pohronie II 29 35 58 30
13 Čadca Čadca 29 29 40 26
14 Tatran Krásno Tatran 29 30 62 26
15 Žarnovica Žarnovica 29 39 87 23
16 Brusno-Ondrej Brusno-Ondre 15 15 28 13

  USO DE MEMORIA  
6,077,688 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1100
Total Execution Time  0.1113
  CADENA URL  
/historico/Tatran-Krasno
  GET DATOS  
$_GET['/historico/Tatran-Krasno']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0034  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 = 'Tatran-Krasno' 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.0018  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=61124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=61124 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042  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 = 72650
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61124 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2728 AND type_rel = 3
0.0022  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 = '61124' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '61124' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '61124' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0028  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 = 72674 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72650 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=61124 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (72674,72650) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72650 AND teamId = 61124
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 72674 AND teamId = 61124
0.0022  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 = 72650 AND t.round = 19 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '61124' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61124' and rp.type = 4
0.0020  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 = '61124' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 72650 WHERE rp.league_id = 72650 AND rp.teamId = 61124 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.0019  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 = 72650 WHERE rp.league_id = 72650 AND rp.teamId = 61124 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 72650 WHERE rp.league_id = 72650 AND rp.teamId = 61124 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 61124 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 72650 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 70547 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.0023  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 = 63444 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.0021  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 = 57027 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.0021  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 = 50483 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 44371 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 39126 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 33423 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 15813 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 9376 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  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 = 72650 ORDER BY nameShow LIMIT 100