4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 33 75 30 75
2 Panathinaikos Panathinaiko 33 79 30 71
3 Olympiacos Piraeus Olympiacos 33 74 32 70
4 PAOK PAOK 32 76 30 68
5 Aris Thessaloniki Aris 33 45 40 49
6 Lamia Lamia 34 41 72 35
TEMPORADA 2022/2023
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 36 69 17 83
2 Panathinaikos Panathinaiko 36 47 16 78
3 Olympiacos Piraeus Olympiacos 36 70 24 73
4 PAOK PAOK 36 57 32 67
5 Aris Thessaloniki Aris 36 55 41 51
6 Volos New Football Volos 36 35 66 40
TEMPORADA 2021/2022
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 36 62 26 83
2 PAOK PAOK 36 58 33 64
3 Aris Thessaloniki Aris 36 39 28 62
4 Panathinaikos Panathinaiko 36 52 26 61
5 AEK Athens AEK Athens 36 56 42 56
6 PAS Giannina Giannina 36 34 42 46
TEMPORADA 2020/2021
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 26 64 13 67
2 Aris Thessaloniki Aris 26 34 16 51
3 AEK Athens AEK Athens 26 41 29 48
4 PAOK PAOK 26 49 26 47
5 Panathinaikos Panathinaiko 26 30 19 45
6 Asteras Tripolis Asteras 26 27 25 42
7 Volos New Football Volos 26 26 32 33
8 PAS Giannina Giannina 26 23 26 31
9 Apollon Smyrnis Apollon 26 26 35 28
10 Atromitos Atromitos 26 24 35 28
11 Lamia Lamia 26 14 38 23
12 Panaitolikos Panaitolikos 26 13 32 20
13 OFI OFI 26 22 43 19
14 AE Larisa AE Larisa 26 18 42 16
TEMPORADA 2019/2020
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 10 21 7 91
2 PAOK PAOK 10 8 6 73
3 AEK Athens AEK Athens 10 17 10 69
4 Panathinaikos Panathinaiko 10 8 9 58
5 Aris Thessaloniki Aris 10 10 19 42
6 OFI OFI 10 8 21 36
TEMPORADA 2018/2019
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 PAOK PAOK 30 66 14 80
2 Olympiacos Piraeus Olympiacos 30 71 17 75
3 AEK Athens AEK Athens 30 50 19 57
4 Atromitos Atromitos 30 41 28 52
5 Aris Thessaloniki Aris 30 46 33 49
6 Panionios Panionios 30 27 45 38
7 Lamia Lamia 30 28 37 37
8 Panathinaikos Panathinaiko 30 38 30 36
9 Panaitolikos Panaitolikos 30 34 48 36
10 AE Larisa AE Larisa 30 26 34 34
11 Asteras Tripolis Asteras 30 25 30 33
12 Xanthi Xanthi 30 22 34 32
13 OFI OFI 30 30 42 32
14 PAS Giannina Giannina 30 19 38 27
15 Levadiakos Levadiakos 30 15 45 21
16 Apollon Smyrnis Apollon 30 11 55 10
TEMPORADA 2017/2018
SUPER LEAGUE GRIEGA
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 30 50 12 70
2 PAOK PAOK 30 59 19 64
3 Olympiacos Piraeus Olympiacos 30 63 28 57
4 Atromitos Atromitos 30 43 21 56
5 Asteras Tripolis Asteras 30 39 24 45
6 Xanthi Xanthi 30 31 30 45
7 Panionios Panionios 30 32 31 40
8 Panaitolikos Panaitolikos 30 31 40 35
9 PAS Giannina Giannina 30 31 34 34
10 Levadiakos Levadiakos 30 23 34 34
11 Panathinaikos Panathinaiko 30 30 30 32
12 AE Larisa AE Larisa 30 22 41 31
13 Lamia Lamia 30 20 34 30
14 Apollon Smyrnis Apollon 30 23 36 29
15 Kerkyra Kerkyra 30 19 51 22
16 Platanias Platanias 30 14 65 10
TEMPORADA 2016/2017
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 6 5 3 12
2 PAOK PAOK 6 7 5 11
3 Panathinaikos Panathinaiko 6 6 7 7
4 Panionios Panionios 6 3 6 4
TEMPORADA 2015/2016
SUPER LEAGUE GRIEGA GRUPO 2
Equipo PJ GF GC Puntos
1 PAOK PAOK 6 8 3 12
2 Panathinaikos Panathinaiko 6 8 6 11
3 AEK Athens AEK Athens 6 5 7 9
4 Panionios Panionios 6 2 7 4
TEMPORADA 2014/2015
FOOTBALL LEAGUE GRECIA GRUPO 5
Equipo PJ GF GC Puntos
1 Apollon Smyrnis Apollon 10 16 10 20
2 Iraklis Thessaloniki Iraklis 10 10 5 19
3 AEK Athens AEK Athens 10 14 9 18
4 AE Larisa AE Larisa 10 10 11 13
5 Olympiakos Volos Olympiakos 10 8 12 10
6 Panachaiki Panachaiki 10 12 23 5
TEMPORADA 2013/2014
TERCERA GRECIA GRUPO 6
Equipo PJ GF GC Puntos
1 AEK Athens AEK Athens 28 80 14 75
2 Kifisia Kifisia 28 59 31 54
3 Irodotos Irodotos 28 40 33 45
4 Triglia Rafinas Triglia 28 42 26 44
5 Kyanos Asteras Vari Kyanos 28 39 29 42
6 Ilysiakos AO Ilysiakos 28 39 42 42
7 Kroussonas Kroussonas 28 42 48 40
8 Aigaleo FC Athens Aigaleo 28 26 25 39
9 Ermis Zoniana Ermis 28 34 32 38
10 Mandraikos Mandraikos 28 31 38 38
11 Thyella D Rafina Thyella 28 27 27 35
12 Ifaistos Peristeri Ifaistos 28 33 55 30
13 Peramaikos Peramaikos 28 25 48 28
14 Pannaxiakos Pannaxiakos 28 22 49 17
15 Agios Nikolaos Agios 28 24 66 13
TEMPORADA 2012/2013
SUPER LEAGUE GRIEGA GRUPO 1
Equipo PJ GF GC Puntos
1 Olympiacos Piraeus Olympiacos 30 64 16 77
2 PAOK PAOK 30 46 19 62
3 Asteras Tripolis Asteras 30 41 25 56
4 Atromitos Atromitos 30 26 22 46
5 PAS Giannina Giannina 30 28 24 44
6 Panathinaikos Panathinaiko 30 32 30 40
7 Xanthi Xanthi 30 28 26 40
8 Panionios Panionios 30 35 42 36
9 Platanias Platanias 30 29 42 36
10 Panthrakikos Panthrakikos 30 30 33 36
11 Levadiakos Levadiakos 30 21 35 34
12 Veria NPS Veria NPS 30 30 35 33
13 Aris Thessaloniki Aris 30 32 40 33
14 OFI OFI 30 33 46 32
15 AEK Athens AEK Athens 30 21 36 27
16 Kerkyra Kerkyra 30 16 41 20

  USO DE MEMORIA  
6,378,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7549
Total Execution Time  0.7562
  CADENA URL  
/historico/Aek-Athens
  GET DATOS  
$_GET['/historico/Aek-Athens']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0254  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 = 73551
0.0132  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 = 72095
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=77 AND type_rel = 2
0.0131  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 77 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (492,5508,5541,5560,6387) ORDER BY n.cover_points DESC, update_date DESC
0.0138  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 = '77' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0220  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 = '77' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0164  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 = 73551 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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 = 73872 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 75536 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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=77 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75536,73872,73551,72097,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.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 75536 AND teamId = 77
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 73872 AND teamId = 77
0.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 72097 AND teamId = 77
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 77
0.0513  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 77
0.0129  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 = 73872 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0131  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 = '77' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '77' and rp.type = 4
0.0128  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 = '77' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0145  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 = 73872 WHERE rp.league_id = 73872 AND rp.teamId = 77 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.0143  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 = 73872 WHERE rp.league_id = 73872 AND rp.teamId = 77 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 73872 WHERE rp.league_id = 73872 AND rp.teamId = 77 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 77 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129  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 = 75536 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 67777 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.0130  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 = 71244 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.0135  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 = 63207 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.0136  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 = 66928 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.0139  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 = 61824 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.0219  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 = 58673 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.0143  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 = 49866 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.0139  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 = 55620 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.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 `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 = 33417 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 38412 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 15431 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 26596 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 4428 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138  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 = 13425 AND t.round = 10 ORDER BY team.conference 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 `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 = 12267 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 73872 ORDER BY nameShow LIMIT 100