4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del UD Maracena
TEMPORADA 2022/2023
1ª ANDALUZA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 We Sub 14 We Sub 14 30 68 23 72
2 Arenas de Armilla Sub 14 Arenas 30 80 41 62
3 Granada Sub 14 B Granada 30 63 31 61
4 Ciudad de Granada Sub 14 Ciudad 29 57 27 55
5 Málaga Sub 14 B Málaga 30 56 31 55
6 Alhaurín De La Torre Sub 14 Alhaurín 30 51 27 55
7 Malaka Sub 14 Malaka 29 50 18 53
8 Atletico Jaén Sub 14 Atletico 30 48 43 44
9 Úbeda Viva Sub 14 Úbeda Viva 30 48 60 38
10 Español Albolote Sub 14 Español 30 38 50 34
11 Pavia Sub 14 Pavia 30 24 51 26
12 Los Molinos Sub 14 Molinos 30 25 54 26
13 Deportivo Jaén Deportivo 30 20 61 26
14 El Ejido 2012 A Ejido 2012 30 26 55 21
15 La Cañada Atletico B Cañada 30 30 68 18
16 UD Maracena UD Maracena 30 26 70 18
TEMPORADA 2021/2022
DIVISIÓN DE HONOR ANDALUZA INFANTIL
Equipo PJ GF GC Puntos
1 Real Betis Sub 14 Real Betis 30 107 8 85
2 Sevilla FC Sub 14 Sevilla 30 98 14 74
3 Granada CF Sub 14 Granada 30 88 29 72
4 UD Almeria Sub 14 Almeria 30 72 32 66
5 Málaga CF Sub 14 Málaga 30 65 29 62
6 Córdoba CF Sub 14 Córdoba 30 35 43 42
7 Peloteros Sierra Sur Sub 14 Peloteros 30 44 49 38
8 Cádiz CF Sub 14 Cádiz 30 52 58 38
9 Puerto Malagueño Sub 14 Puerto 30 38 53 36
10 AD Nervión Sub 14 Nervión 30 48 71 36
11 Tiro Pichon Sub 14 Tiro Pichon 30 45 78 33
12 UD Tomares Sub 14 Tomares 30 33 53 29
13 La Cañada Atlético Sub 14 Cañada 30 21 49 29
14 Atletico Jaén Sub 14 Atletico 30 53 85 24
15 San Roque Balompie Sub 14 Roque 30 20 96 8
16 UD Maracena UD Maracena 30 22 94 7
TEMPORADA 2020/2021
1ª ANDALUZA INFANTIL GRUPO 7
Equipo PJ GF GC Puntos
1 Málaga CF Sub 14 Málaga 8 24 10 19
2 UD Almeria Sub 14 Almeria 8 21 16 16
3 Puerto Malagueño Sub 14 Puerto 8 16 13 13
4 UD Maracena UD Maracena 7 16 13 11
5 Tiro Pichon Sub 14 Tiro Pichon 8 17 16 8
6 Granada CF Sub 14 Granada 8 10 11 8
7 La Cañada Atlético Sub 14 Cañada 8 10 22 8
8 Atletico Jaén Sub 14 Atletico 7 5 18 3
TEMPORADA 2019/2020
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 UD Maracena UD Maracena 21 102 8 60
2 Granada Sub 14 B Granada 21 55 26 50
3 Ciudad de Baza 2017 Ciudad Baza 21 89 45 42
4 CD Ciudad de Granada B Ciudad 21 62 45 42
5 Arenas de Armilla Cultura Y Arenas 21 58 23 41
6 Motril Motril 21 53 44 35
7 Huetor Tajar Huetor Tajar 21 45 46 34
8 Reino de Granada Reino 21 61 52 29
9 Atarfe Industrial Cf Atarfe 21 50 62 29
10 We Fútbol Club B Fútbol Club 21 49 54 27
11 Cd Huescar Cd Huescar 21 48 65 26
12 Medina Lauxa Sub 14 Medina Lauxa 21 36 56 22
13 Calahonda-Carchuna Calahonda-Ca 21 37 57 20
14 Sierra Nevada Cenes Sierra 21 28 85 10
15 Sporting Club Vegas del Gen Sporting 21 24 75 7
16 CD Santa Fe B Santa 21 28 82 6
TEMPORADA 2018/2019
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 CD Santa Fe A Santa 30 148 28 80
2 UD Maracena UD Maracena 30 106 34 75
3 Arenas de Armilla Cultura Y Arenas 30 121 32 69
4 We Fútbol Club B Fútbol Club 30 118 34 64
5 Granada Sub 14 B Granada 30 105 41 59
6 Calahonda-Carchuna Calahonda-Ca 30 79 46 55
7 Medina Lauxa Sub 14 Medina Lauxa 30 84 50 53
8 Atarfe Industrial Cf Atarfe 30 68 60 48
9 Cd Huescar Cd Huescar 30 65 47 46
10 Sierra Nevada Cenes Sierra 30 88 88 35
11 Zaidin Zaidin 30 74 90 34
12 Ciudad de Baza 2017 Ciudad Baza 30 48 80 28
13 Reino de Granada Reino 30 44 90 23
14 Albolote Soccer Alda Albolote 30 40 164 14
15 Almuñecar 77 Almuñecar 30 19 213 6
16 Pinos Puente Pinos Puente 30 20 130 3
17 Ogijares 89 Cf Ogijares 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA GRANADA INFANTIL GRUPO 2
Equipo PJ GF GC Puntos
1 Huetor Tajar Huetor Tajar 30 125 39 75
2 CD Santa Fe A Santa 30 123 25 68
3 Atarfe Industrial Cf Atarfe 30 105 29 67
4 Medina Lauxa Sub 14 Medina Lauxa 30 114 36 64
5 We Fútbol Club B Fútbol Club 30 76 30 61
6 Ciudad de Baza 2017 Ciudad Baza 30 89 64 55
7 UD Maracena UD Maracena 30 80 39 49
8 Cd Huescar Cd Huescar 30 78 38 49
9 Albolote Soccer Alda Albolote 30 58 74 44
10 Illora Illora 30 56 67 42
11 Vandalia de Peligros Vandalia 30 32 88 22
12 Chauchina Chauchina 30 57 172 22
13 Ciudad de Granada C Ciudad 30 35 108 19
14 Caniles Caniles 30 33 121 19
15 Arenas de Armilla Cultura Y Arenas 30 45 94 18
16 Guadix Cf Guadix Cf 30 35 117 15
TEMPORADA 2016/2017
2ª ANDALUZA GRANADA INFANTIL GRUPO 1
Equipo PJ GF GC Puntos
1 UD Maracena UD Maracena 30 196 29 84
2 Zaidin Zaidin 29 157 15 78
3 CD Ciudad de Granada B Ciudad 30 129 34 70
4 Calahonda-Carchuna Calahonda-Ca 30 80 44 64
5 Puerto de Motril Puerto 30 132 33 62
6 Ogijares 89 Cf Ogijares 30 117 51 53
7 Cullar Vega Base Cullar Vega 29 72 75 43
8 Motril Cf Motril Cf 30 66 84 43
9 Huetor Vega Huetor Vega 30 72 96 39
10 Almuñecar 77 Almuñecar 30 62 93 38
11 Granada Base Granada Base 30 71 84 33
12 Atletico Salobreña Atletico 30 50 75 31
13 Cp Granada 74 Granada 30 40 142 20
14 Churriana de la Vega Churriana 30 36 167 11
15 Club Baloncesto Alhendin Club 30 28 141 10
16 Monachil Monachil 30 32 177 9
TEMPORADA 2015/2016
3ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 Albolote Soccer Alda A Albolote 30 82 27 77
2 Zaidin Zaidin 30 88 37 69
3 Alfacar Alfacar 30 110 51 62
4 Ciudad de Granada FF B Ciudad 30 88 62 56
5 Cd Huescar Cd Huescar 30 78 54 51
6 Motril Cf Motril Cf 30 61 73 48
7 Granada CF C Granada 30 72 74 48
8 We Fútbol Club B Fútbol Club 30 59 56 47
9 Huetor Vega Huetor Vega 30 80 63 46
10 Ogijares 89 Cf Ogijares 30 64 59 44
11 Almuñecar 77 Almuñecar 30 57 68 42
12 Cullar Vega Base Cullar Vega 30 69 81 31
13 Granada Base Granada Base 30 92 114 27
14 UD Maracena UD Maracena 30 59 87 26
15 Atlético La Zubia Atlético 30 40 95 15
16 Arenas de Armilla Arenas 30 32 130 2
TEMPORADA 2014/2015
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 Motril UD Motril UD 30 103 19 77
2 Cd Ciudad De Granada Ff Ciudad 30 121 18 76
3 Granada Sub 14 B Granada 30 102 29 70
4 Medina Lauxa Sub 14 Medina Lauxa 30 99 49 61
5 Huetor Tajar Huetor Tajar 30 90 43 57
6 Estrellas Chana UD Estrellas 30 75 46 54
7 Guadix Cf Guadix Cf 30 91 56 52
8 Calahonda-Carchuna Calahonda-Ca 30 63 63 49
9 Atarfe Industrial Cf Atarfe 30 62 81 33
10 UD Maracena UD Maracena 30 51 92 32
11 Cp Granada 74 Granada 30 56 86 31
12 Atletico Salobreña Atletico 30 40 84 30
13 Almuñecar 77 Almuñecar 30 41 66 29
14 Huetor Vega Huetor Vega 30 41 107 17
15 At La Zubia At La Zubia 30 28 108 13
16 Zaidin Zaidin 30 26 142 10
TEMPORADA 2011/2012
2ª ANDALUZA GRANADA INFANTIL
Equipo PJ GF GC Puntos
1 Granada Sub 14 B Granada 20 88 18 53
2 Arenas De Armilla Cd Arenas 20 78 18 52
3 UD Maracena UD Maracena 20 100 19 50
4 Cp Granada 74 Granada 20 67 30 47
5 Atarfe Industrial Cf Atarfe 20 63 52 40
6 Motril Cf Motril Cf 20 46 29 36
7 Otura Cf Otura Cf 20 44 40 34
8 Cd Ciudad De Granada Ff Ciudad 20 42 38 31
9 Estrellas Chana UD Estrellas 20 48 65 30
10 Guadix Cf Guadix Cf 20 46 37 29
11 CD Santa Fe A Santa 20 41 52 29
12 Cd Baza Cd Baza 20 34 50 24
13 Cd Vandalia De Peligros Cf Vandalia 20 47 87 22
14 CD El Padul CD El Padul 20 30 59 12
15 Cd Huescar Cd Huescar 20 27 61 12
16 Cullar Vega Cf Cullar Vega 20 34 71 9
17 At La Zubia At La Zubia 20 22 71 5
18 Ogijares 89 Cf Ogijares 20 29 89 4

  USO DE MEMORIA  
5,769,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1673
Total Execution Time  0.1685
  CADENA URL  
/historico/Ud-Maracena-Infantil
  GET DATOS  
$_GET['/historico/Ud-Maracena-Infantil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0027  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 = 'Ud-Maracena-Infantil' 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.0038  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 = 'Ud-Maracena-Infantil' 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.0019  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0036  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=9067 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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=9067 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=9067 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=9067 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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=9067 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025  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 = 68958
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9067 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=456 AND type_rel = 3
0.0024  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 = '9067' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '9067' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '9067' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0027  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 = '9067' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 68958 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=9067 AND l.year in (2022,2023,2024) 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 (68958,64288) 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.0020  SELECT count(id) as num_players from rel_players_base WHERE league_id = 68958 AND teamId = 9067
0.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64288 AND teamId = 9067
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 `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 = 68958 AND t.round = 30 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 = '9067' 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 = '9067' 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 = '9067' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0023  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 = 9067 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029  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 = 68958 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.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 `tables2022_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 = 64288 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.0112  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 = 59838 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.0027  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 = 62009 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.0039  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 = 53041 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.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 `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 = 45195 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 40676 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 35182 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033  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 = 17627 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  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 = 4415 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0040  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_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 = 1862 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 456 AND l.year = 2023 ORDER BY l.group_code ASC