4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Balatonfüredi
TEMPORADA 2023/2024
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Tatabánya Tatabánya 27 55 26 59
2 Veszprém Veszprém 27 57 32 56
3 Bicskei Bicskei 27 45 25 56
4 III. Kerületi TVE III. 27 51 27 54
5 Gyirmót II Gyirmót II 27 52 50 41
6 Dorogi FC Dorogi FC 27 39 33 40
7 Komaromi Komaromi 27 34 31 39
8 Budaörsi Budaörsi 27 45 51 38
9 Sopron Sopron 27 36 35 34
10 Puskás Akadémia II Puskás 27 41 35 33
11 Balatonfüredi Balatonfüre 27 32 40 32
12 Kelen Kelen 27 32 51 32
13 Győri ETO II Győri 27 41 41 31
14 Haladas / Zanati Haladas 27 35 58 22
15 Zalaegerszegi TE II Zalaegerszeg 27 27 52 20
16 Csornai SE Csornai SE 27 28 63 12
TEMPORADA 2022/2023
TERCERA HUNGRÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Veszprém Veszprém 38 82 24 92
2 Tatabánya Tatabánya 38 77 35 90
3 Nagykanizsai ULE Nagykanizsai 38 105 41 87
4 Puskás Akadémia II Puskás 38 77 35 70
5 III. Kerületi TVE III. 38 82 40 68
6 Erdi VSE Erdi VSE 38 55 33 65
7 Bicskei Bicskei 38 59 41 63
8 Kaposvari Rakoczi Kaposvari 38 58 44 60
9 Budaörsi Budaörsi 38 56 43 60
10 Balatonfüredi Balatonfüre 38 50 52 56
11 Fehérvár II Fehérvár 38 48 56 55
12 Komaromi Komaromi 38 57 53 53
13 Győri ETO II Győri 38 61 60 52
14 Gyirmót II Gyirmót II 38 65 83 39
15 Zalaegerszegi TE II Zalaegerszeg 38 45 83 38
16 Kelen Kelen 38 42 60 32
17 Csornai SE Csornai SE 38 42 85 27
18 Teskánd Teskánd 38 50 111 25
19 Móri SE Móri SE 38 35 93 21
20 Zsámbéki Zsámbéki 38 33 107 13
TEMPORADA 2021/2022
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Mosonmagyaróvári TE Mosonmagyar 38 114 20 100
2 Budapest BVSC Budapest 38 93 32 88
3 Veszprém Veszprém 38 69 29 80
4 Győri ETO II Győri 38 68 45 67
5 Puskás Akadémia II Puskás 38 65 39 66
6 Bicskei Bicskei 38 50 44 62
7 Pápai Perutz Pápai 38 49 41 59
8 Tatabánya Tatabánya 38 52 43 57
9 Kaposvari Rakoczi Kaposvari 38 50 46 53
10 Nagykanizsai ULE Nagykanizsai 38 60 67 53
11 Fehérvár II Fehérvár 38 47 54 52
12 Zalaegerszegi TE II Zalaegerszeg 38 59 63 48
13 Balatonfüredi Balatonfüre 38 54 67 47
14 Erdi VSE Erdi VSE 38 56 69 46
15 Kelen Kelen 38 43 52 42
16 Gyirmót II Gyirmót II 38 61 71 40
17 Komaromi Komaromi 38 55 73 35
18 Sopron Sopron 38 37 81 28
19 Gárdony Gárdony 38 35 72 22
20 Andráshida Andráshida 38 26 135 11
TEMPORADA 2020/2021
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 III. Kerületi TVE III. 38 91 22 88
2 Mosonmagyaróvári TE Mosonmagyar 38 79 35 74
3 Veszprém Veszprém 37 61 44 67
4 Nagykanizsai ULE Nagykanizsai 38 77 50 66
5 Tatabánya Tatabánya 37 56 39 61
6 Lipot SK Lipot SK 38 66 58 60
7 Sopron Sopron 38 56 50 60
8 Puskás Akadémia II Puskás 38 67 51 58
9 Komaromi Komaromi 38 52 59 56
10 Erdi VSE Erdi VSE 38 51 54 54
11 Balatonfüredi Balatonfüre 38 69 58 52
12 Bicskei Bicskei 38 42 50 50
13 Zalaegerszegi TE II Zalaegerszeg 38 56 64 49
14 Lombard Pápa TFC Lombard 38 48 56 48
15 Fehérvár II Fehérvár 38 52 58 47
16 BKV Előre BKV Előre 38 46 60 44
17 Gárdony Gárdony 38 58 82 44
18 Szabadkikoto Szabadkikoto 38 63 82 37
19 Ménfőcsanak Ménfőcsana 38 37 72 29
20 Nagyatádi FC Nagyatádi 38 32 115 12
TEMPORADA 2015/2016
TERCERA HUNGRÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Ferencváros II Ferencváros 32 65 26 72
2 Mosonmagyaróvári TE Mosonmagyar 32 72 34 69
3 Dorogi FC Dorogi FC 32 44 16 68
4 Györi ETO Györi ETO 32 60 33 57
5 Tatabánya Tatabánya 32 55 40 55
6 Videoton II Videoton II 32 70 50 53
7 Andráshida Andráshida 32 49 38 50
8 BKV Előre BKV Előre 32 49 39 47
9 MTK Budapest II Budapest 32 44 46 46
10 Erdi VSE Erdi VSE 32 47 47 44
11 Puskás Akadémia II Puskás 32 56 53 39
12 III. Kerületi TVE III. 32 47 55 39
13 Diósdi TC Diósdi TC 32 39 48 39
14 Csepel FC Csepel FC 32 27 71 26
15 Csornai SE Csornai SE 32 26 62 21
16 Sárvári FC Sárvári 32 28 76 20
17 Balatonfüredi Balatonfüre 32 26 70 17
TEMPORADA 2014/2015
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Budaörsi Budaörsi 28 63 19 64
2 Dorogi FC Dorogi FC 28 36 18 57
3 Győri ETO II Győri 28 50 26 54
4 Diósdi TC Diósdi TC 28 37 35 47
5 Tatabánya Tatabánya 28 53 35 45
6 Rákosmenti KSK Rákosmenti 28 44 30 45
7 Újbuda TC Újbuda TC 28 34 33 44
8 BKV Előre BKV Előre 28 41 38 40
9 Sárvári FC Sárvári 28 33 43 35
10 III. Kerületi TVE III. 28 39 48 34
11 Balatonfüredi Balatonfüre 28 37 42 30
12 Mosonmagyaróvári TE Mosonmagyar 28 32 43 29
13 Csepel FC Csepel FC 28 25 34 28
14 Nagyatádi FC Nagyatádi 28 22 49 24
15 Tököl Tököl 28 13 66 7
16 Veszprém Veszprém 0 0 0 0
TEMPORADA 2013/2014
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Csákvári TK Csákvári 28 70 32 64
2 Budaörsi Budaörsi 28 69 30 54
3 Andráshida Andráshida 28 49 26 52
4 BKV Előre BKV Előre 28 45 22 52
5 Győri ETO II Győri 28 59 44 51
6 Csepel FC Csepel FC 28 43 27 44
7 Balatonfüredi Balatonfüre 28 39 28 43
8 Újbuda TC Újbuda TC 28 42 40 39
9 Mosonmagyaróvári TE Mosonmagyar 28 38 39 39
10 Nagyatádi FC Nagyatádi 28 32 37 36
11 Dorogi FC Dorogi FC 28 41 45 34
12 Szombathelyi Haladás II Szombathelyi 28 35 43 31
13 Diósdi TC Diósdi TC 28 30 48 27
14 Veszprém Veszprém 28 34 62 27
15 Tököl Tököl 28 22 65 23
16 Körmendi FC Körmendi 28 27 87 16
TEMPORADA 2012/2013
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Dorogi FC Dorogi FC 26 57 21 58
2 Andráshida Andráshida 26 44 24 56
3 Mosonmagyaróvári TE Mosonmagyar 26 51 20 54
4 Balatonfüredi Balatonfüre 26 51 24 50
5 Újbuda TC Újbuda TC 26 55 37 49
6 Körmendi FC Körmendi 26 57 38 45
7 Répcelaki Répcelaki 26 43 42 35
8 Sárvári FC Sárvári 26 36 45 35
9 Csornai SE Csornai SE 26 37 37 31
10 Héviz FC Héviz FC 26 34 45 30
11 Nagykanizsai TE Nagykanizsai 26 29 54 25
12 Móri SE Móri SE 26 29 54 19
13 Lombard Pápa II Lombard 26 21 40 18
14 Komaromi Komaromi 26 21 84 10
TEMPORADA 2011/2012
TERCERA HUNGRÍA GRUPO 6
Equipo PJ GF GC Puntos
1 Csákvári TK Csákvári 28 81 18 75
2 Szombathelyi Haladás II Szombathelyi 28 78 15 71
3 Csornai SE Csornai SE 28 56 26 60
4 Balatonfüredi Balatonfüre 28 51 34 50
5 Héviz FC Héviz FC 28 34 32 43
6 Répcelaki Répcelaki 28 35 33 42
7 Zalaegerszegi TE II Zalaegerszeg 28 50 51 39
8 Móri SE Móri SE 28 43 44 38
9 Mosonmagyaróvári TE Mosonmagyar 28 48 38 37
10 Lombard Pápa II Lombard 28 47 37 37
11 Körmendi FC Körmendi 28 46 58 35
12 Nagykanizsai TE Nagykanizsai 28 44 55 32
13 Sárvári FC Sárvári 28 31 45 25
14 Várpalotai BSK Várpalotai 28 27 90 19
15 Badacsonytomaj Badacsonytom 28 8 103 0
TEMPORADA 2010/2011
TERCERA HUNGRÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Soproni Vasutas SE Soproni 30 80 19 71
2 Lombard Pápa II Lombard 30 58 21 65
3 Héviz FC Héviz FC 30 55 22 63
4 Mosonmagyaróvári TE Mosonmagyar 30 51 45 53
5 Szombathelyi Haladás II Szombathelyi 30 63 24 52
6 Balatonfüredi Balatonfüre 30 42 21 50
7 Sárvári FC Sárvári 30 47 36 48
8 Zalaegerszegi TE II Zalaegerszeg 30 52 43 45
9 Csornai SE Csornai SE 30 37 49 37
10 Lipot SK Lipot SK 30 39 45 34
11 Répcelaki Répcelaki 30 41 50 34
12 Buk TK Buk TK 30 24 41 32
13 Badacsonytomaj Badacsonytom 30 42 62 32
14 Celldömölk VSE Celldömölk 30 41 52 31
15 Várpalotai BSK Várpalotai 30 23 71 14
16 Köszegi Köszegi 30 21 115 10

  USO DE MEMORIA  
6,265,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.6027
Total Execution Time  0.6039
  CADENA URL  
/historico/Balatonfuredi
  GET DATOS  
$_GET['/historico/Balatonfuredi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0161  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 = 'Balatonfuredi' 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=17475 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  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=17475 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=17475 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=17475 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17475 AND type_rel = 2
0.0166  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 = '17475' ORDER BY l.year DESC,cat.coefficient 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 = '17475' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149  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 = '17475' 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=17475 AND l.year in (2023,2024,2025) 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 (73256,72644,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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 72644 AND teamId = 17475
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73256 AND teamId = 17475
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17475
0.0148  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 = '17475' 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 = '17475' and rp.type = 4
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 = '17475' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 17475 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 events2024 e ON e.player_id = p.id AND e.league_id = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 17475 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 72644 WHERE rp.league_id = 72644 AND rp.teamId = 17475 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 17475 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 = 72644 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 68427 AND t.round = 38 ORDER BY team.conference ASC,t.position 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 `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 = 63556 AND t.round = 38 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 `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 = 57111 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 15968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 4411 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 3581 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 24519 AND t.round = 26 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 `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 = 24618 AND t.round = 30 ORDER BY team.conference 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 `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 = 24625 AND t.round = 30 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 = 72644 ORDER BY nameShow LIMIT 100