4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Montequinto Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Balompie B Real Betis. 13 119 7 39
2 Atletico Oromana Sub 8 Atletico 13 73 22 36
3 Sevilla Sub 8 B Sevilla 13 56 25 30
4 Asociación Nervion Sub 8 Asociación 13 66 38 27
5 Doctor Fleming Sub 8 Doctor 13 60 28 26
6 Montequinto Sub 8 Montequinto 14 53 45 25
7 San Roque Balompie Sub 8 B Roque 11 55 14 24
8 Pablo VI Sub 8 Pablo 13 52 41 22
9 Utrera Sub 8 Utrera 13 46 44 20
10 Osuna Bote Club Sub 8 Osuna Bote. 13 42 48 13
11 Aficionado Écija Sub 8 Aficionado 14 20 59 12
12 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 13 27 49 11
13 Sededos Sub 8 Sededos 13 14 65 8
14 Estepa Industrial Sub 8 Estepa 13 35 88 8
15 David Castedo 3 (DC 3) David 13 16 83 3
16 Bellavista Sub 8 Bellavista 13 13 91 0
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 11 90
2 UD Tomares Sub 8 Tomares 29 156 80 70
3 Sevilla Sub 8 B Sevilla 30 136 74 63
4 San Roque Balompie Sub 8 Roque 30 143 69 57
5 Umbrete Sub 8 Umbrete 30 107 82 57
6 Camas Sub 8 Camas Sub 8 30 114 77 55
7 Loreto Sub 8 Loreto 30 92 70 51
8 Coria CF Sub 8 Coria 30 137 102 49
9 David Castedo 3 (DC 3) David 30 110 128 43
10 Lora CF Sub 8 Lora 30 89 128 37
11 Montequinto Sub 8 Montequinto 30 98 104 36
12 Castilleja Sub 8 Castilleja 30 82 128 28
13 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 30 84 145 26
14 Cud Santiponce Sub 10 Santiponce 29 69 182 13
15 Municipal de Gerena Sub 10 Municipal 30 49 230 9
16 CD Esfubasa Sub 10 Esfubasa 30 52 203 7
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 32 234 9 96
2 Real Betis Balompie Sub 8 Real Betis. 32 226 35 85
3 San Roque Balompie Sub 8 Roque 32 159 47 80
4 Loreto Sub 8 Loreto 32 139 75 70
5 Tomares A Tomares A 32 115 76 61
6 Camas Sub 8 Camas Sub 8 32 146 102 56
7 Castilleja Sub 8 Castilleja 32 107 113 48
8 David Castedo 3 (DC 3) David 32 96 105 44
9 Coria CF Sub 8 Coria 32 92 122 42
10 Sededos Sub 8 Sededos 32 92 132 40
11 San Alberto Magno Alberto 32 93 117 39
12 Montequinto Sub 8 Montequinto 32 92 135 38
13 Club Polideportivo Bormujos Club 32 54 95 33
14 Lora CF Sub 8 Lora 32 71 150 33
15 Salteras A Salteras A 32 76 142 24
16 La Liara Balompie Liara 32 36 216 6
17 Mairena del Aljarafe Sub 10 Mairena 32 31 188 4
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 8
Equipo PJ GF GC Puntos
1 Montequinto Sub 8 Montequinto 8 23 8 19
2 Aficionado Écija Sub 8 Aficionado 8 33 20 18
3 Andalucia Este CF A Andalucia 8 39 26 15
4 La Barrera La Barrera 8 35 23 15
5 Sededos Sub 8 Sededos 8 31 21 14
6 Ciudad de Moron Ciudad Moron 8 21 32 6
7 Alcala Alcala 8 11 22 6
8 Mairena Mairena 8 8 49 0
TEMPORADA 2019/2020
2ª SEVILLA BENJAMIN (2ª FASE) GRUPO 3
Equipo PJ GF GC Puntos
1 Lora CF Sub 8 Lora 9 50 14 27
2 Alcala Alcala 9 45 24 17
3 Mairena Mairena 9 42 22 16
4 Montequinto Sub 8 Montequinto 9 34 27 16
5 Club Polideportivo Bormujos Club 9 40 31 15
6 San Alberto Magno Alberto 9 32 30 11
7 Andalucia Este CF A Andalucia 9 14 37 3
8 Municipal de Gerena Sub 10 Municipal 9 8 80 0
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 4
Equipo PJ GF GC Puntos
1 Mairena Mairena 12 49 16 29
2 Sededos Sub 8 Sededos 12 48 20 27
3 Montequinto Sub 8 Montequinto 12 32 22 25
4 San Alberto Magno Alberto 12 72 19 24
5 Bellavista Sub 8 Bellavista 12 20 47 9
6 Doctor Fleming Doctor 11 18 50 6
7 Atletico Oromana Atletico 0 0 0 0
8 La Liara Balompie Liara 11 14 79 0
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 10 C Real Betis 26 146 47 67
2 Union Balompedica Lebrijana Union 26 109 35 60
3 Montequinto Sub 8 Montequinto 26 105 37 58
4 Mairena Mairena 26 126 65 56
5 Rociera Rociera 26 91 45 55
6 Viso Graphenstone Viso 26 76 58 42
7 Mosqueo Mosqueo 26 83 93 39
8 Mosquito Mosquito 26 94 87 38
9 Cantera de Utrera Cantera 26 61 82 30
10 Pablo VI Sub 8 Pablo 26 77 98 26
11 Ciudad de Moron B Ciudad Moron 26 59 129 20
12 La Barrera B Barrera 26 51 131 13
13 La Motilla La Motilla 26 61 153 12
14 Alcala Alcala 26 50 129 11
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 27 90
2 La Liara Balompie Liara 30 140 79 72
3 Alcosa Pol. Alcosa Pol. 30 95 60 57
4 Pablo VI Sub 8 Pablo 30 124 81 55
5 Andalucia Este CF A Andalucia 30 121 90 54
6 Viso Graphenstone Viso 30 98 82 52
7 Utrera CD Utrera CD 30 92 87 50
8 Alcala Alcala 30 87 89 46
9 Ciudad de Moron Ciudad Moron 30 93 100 46
10 Sededos Sub 8 Sededos 30 76 82 45
11 Doctor Fleming Doctor 30 79 110 32
12 CD Antonio Puerta A Antonio 30 79 145 24
13 Atletico Oromana Atletico 30 70 171 24
14 Mosqueo Mosqueo 30 56 129 22
15 Bellavista Sub 8 Bellavista 30 61 137 16
16 Montequinto Sub 8 Montequinto 30 36 189 1
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA BENJAMIN
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 215 23 90
2 Sevilla A Sevilla A 30 255 35 81
3 Asociación Nervion Sub 8 Asociación 30 126 66 62
4 Sededos Sub 8 Sededos 30 130 73 62
5 Tomares Tomares 30 94 85 54
6 Bellavista Sub 8 Bellavista 30 87 77 50
7 Coria CF Sub 8 Coria 30 103 91 47
8 Viso Graphenstone Viso 30 94 102 44
9 Utrera CD Utrera CD 30 111 113 41
10 Pablo VI Sub 8 Pablo 30 87 106 38
11 AD Dani Triana Sub 8 Dani Triana 30 95 100 37
12 Alcosa Pol. Alcosa Pol. 30 74 77 33
13 Montequinto Sub 8 Montequinto 30 64 109 25
14 AAVV Centro Histórico Sub 8 AAVV Centro 30 44 128 17
15 AD San Jose AD San Jose 30 68 227 11
16 Los Mares Los Mares 30 29 255 0
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 28 255 18 79
2 Real Betis Balompié B Real Betis. 28 255 21 77
3 Pablo VI Sub 8 Pablo 28 134 53 70
4 Doctor Fleming Doctor 28 148 63 63
5 La Liara Balompie Liara 28 139 82 55
6 Ciudad de Moron Ciudad Moron 28 83 106 39
7 Miguel de Unamuno Miguel 28 63 95 37
8 Union Balompedica Lebrijana Union 28 70 86 35
9 Vistazul Vistazul 28 85 105 35
10 Alcala Alcala 28 80 111 35
11 San Alberto Magno Alberto 28 71 115 27
12 Mosquito Mosquito 28 76 163 27
13 Los Caminantes Caminantes 28 59 153 21
14 Brenes Balompie Brenes 28 34 225 8
15 Ibarburu Ibarburu 28 34 211 6
16 Montequinto Sub 8 Montequinto 0 0 0 0

  USO DE MEMORIA  
5,589,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2648
Total Execution Time  0.2662
  CADENA URL  
/historico/Cd-Montequinto-Benjamin
  GET DATOS  
$_GET['/historico/Cd-Montequinto-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (34)  
0.0029  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 = 'Cd-Montequinto-Benjamin' 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=33206 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=33206 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 74454
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=33206 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 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 = '33206' ORDER BY l.year DESC,cat.coefficient DESC
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 = '33206' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '33206' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 74454 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=33206 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74454) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74454 AND teamId = 33206
0.0019  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 = 74454 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '33206' 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 = '33206' and rp.type = 4
0.0021  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 = '33206' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025  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 = 33206 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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_base` 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 = 74454 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.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 `tables2023_base` 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 = 69680 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_base` 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 = 60682 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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_base` 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 = 62294 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.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 `tables2020_base` 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 = 54037 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.0025  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_base` 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 = 54033 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.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_base` 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 = 53309 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.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 `tables2020_base` 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 = 55281 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_base` 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 = 44981 AND t.round = 14 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_base` 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 = 42870 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 `tables2017_base` 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 = 34836 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 `tables2016_base` 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 = 18254 AND t.round = 26 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 `tables2016_base` 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 = 18279 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1549  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 = 6024 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050  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 = 5985 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 74454 ORDER BY nameShow LIMIT 100