4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Ciudad de Moron
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peloteros Sierra Sur Sub 12 Peloteros 26 182 42 73
2 Real Betis Sub 12 D Real Betis 26 196 32 68
3 CD Alcala CD Alcala 26 111 69 50
4 Estilo de Futbol de Utrera Estilo 26 103 114 50
5 Puebla Cazalla Sub 12 Puebla 26 100 74 45
6 Carmona Sub 12 Carmona 26 92 54 44
7 Viso A Viso A 26 101 77 43
8 Mosquito A Mosquito A 26 90 78 34
9 Ciudad de Moron Ciudad Moron 26 94 92 31
10 CD Atletico Oromana Atletico 26 101 119 30
11 Utrera A Utrera A 26 85 101 29
12 Consolacion B Consolacion 26 79 138 22
13 CD Mairena CD Mairena 26 40 135 14
14 Pablo VI Pablo VI 26 17 255 0
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 18 210 11 54
2 Mosquito Sub 12 Mosquito 18 76 29 46
3 Aficionado de Ecija Sub 12 Aficionado 18 51 62 33
4 Utrera Sub 12 Utrera 18 66 52 27
5 Pablo VI A Pablo VI A 18 55 63 25
6 Asociación Nervion Sub 12 B Asociación 18 53 68 25
7 Estepa Industrial Estepa 18 35 62 16
8 Viso A Viso A 18 24 80 14
9 La Barrera Sub 12 Barrera 18 29 83 13
10 Ciudad de Moron Ciudad Moron 18 41 130 9
TEMPORADA 2019/2020
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 B Sevilla 23 255 10 65
2 Real Betis Balompie C Real Betis. 23 187 26 64
3 La Barrera Sub 12 Barrera 23 145 43 57
4 Ciudad de Moron Ciudad Moron 23 123 86 46
5 Atlético Antoniano Atlético 23 83 87 44
6 Tabladilla Tabladilla 23 81 79 41
7 CD Cabecense Cabecense 23 71 77 35
8 Entretorres Entretorres 23 74 120 31
9 Estilo de Futbol de Utrera Estilo 23 56 83 30
10 Los Palacios CF Palacios 23 79 156 24
11 C.D Sededos C.D Sededos 23 58 135 23
12 Doctor Fleming Sub 12 Doctor 23 70 96 20
13 Viso Graphenstone B Viso 23 41 124 20
14 Consolacion Consolacion 23 46 84 19
15 Mosqueo Mosqueo 23 32 167 10
16 CD Jose Antonio Luque Jose Antonio 23 41 143 7
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 28 255 20 81
2 La Liara Sub 12 Liara 28 192 43 73
3 Union Balompedica Lebrijana Union 28 122 70 68
4 Mosqueo A Mosqueo A 28 103 91 47
5 CD Alcala CD Alcala 28 88 79 46
6 Ciudad de Moron Ciudad Moron 28 106 81 44
7 Estilo de Futbol de Utrera Estilo 28 89 111 44
8 Tabladilla Tabladilla 28 98 100 36
9 C.D Sededos C.D Sededos 28 64 79 36
10 Atlético Antoniano Atlético 28 86 124 33
11 Doctor Fleming Sub 12 Doctor 28 67 113 29
12 San Alberto Magno Alberto 28 96 162 26
13 C.D Montequinto Montequinto 28 59 112 24
14 Cantera de Utrera Cantera 28 62 205 12
15 Atletico Dos Hermanas A Atletico 28 43 169 9
16 M. Unamuno A Unamuno 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 AD San José Sub 12 José 14 56 25 34
2 Viso Graphenstone Viso 14 47 33 31
3 Los Caminantes Caminantes 14 46 30 28
4 AD Dani Triana Ar Rabad A Dani Triana 14 45 28 26
5 Ciudad de Moron Ciudad Moron 14 51 54 14
6 Camas Camas 14 44 56 13
7 La Liara Sub 12 Liara 14 36 55 12
8 Lora Lora 14 29 73 4
TEMPORADA 2016/2017
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 Sevilla 28 255 21 80
2 Real Betis Balompie C Real Betis. 28 196 27 80
3 San Roque Balompié Sub 12 B Roque 28 107 79 54
4 Centro Historico Sub 12 Centro 28 104 89 49
5 Colegio Claret Sub 12 Colegio 27 103 116 49
6 Viso Viso 28 94 104 45
7 Circulo Don Bosco Circulo 28 94 101 43
8 Los Caminantes Caminantes 28 54 97 33
9 Lora Lora 28 85 103 31
10 CD Antonio Puerta Sub 12 Antonio 28 83 144 29
11 Utrera Sub 12 Utrera 28 88 149 28
12 Ciudad de Moron Ciudad Moron 28 75 128 23
13 El Pilar El Pilar 27 53 118 22
14 CD Alcala CD Alcala 28 65 130 20
15 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 28 72 158 16
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Real Betis Balompie C Real Betis. 30 255 22 90
2 Sevilla A Sevilla A 30 237 39 81
3 San Roque Balompié Sub 12 B Roque 30 132 76 64
4 Circulo Don Bosco Circulo 30 147 97 58
5 Ciudad de Moron Ciudad Moron 30 176 95 56
6 Colegio Claret Sub 12 Colegio 30 135 94 53
7 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 30 164 73 50
8 Jose Antonio Luque Jose Antonio 30 108 95 48
9 Alcosa Polid. Alcosa 30 132 138 44
10 C.D Montequinto Montequinto 30 99 135 40
11 Cantera de Utrera Cantera 30 91 162 34
12 Andalucia Este Andalucia 30 76 119 32
13 Estepa Industrial Estepa 30 68 112 26
14 Utrera B Utrera B 30 44 211 13
15 La Cantera Futbol Club Cantera 30 61 255 12
16 Sevilla Este Sevilla Este 30 35 255 4
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 30 169 31 85
2 Nervion Nervion 30 154 65 72
3 La Liara Balompié Liara 30 99 59 67
4 Atlético Antoniano Atlético 30 116 65 65
5 U.P Viso U.P Viso 30 103 89 54
6 Tinte de Utrera Tinte Utrera 30 80 54 52
7 CD Cabecense Cabecense 30 94 72 52
8 SAM-CAM Sub 12 SAM-CAM 30 97 101 45
9 Ciudad de Moron Ciudad Moron 30 119 110 41
10 Jose Antonio Luque Jose Antonio 30 84 98 36
11 Tabladilla Tabladilla 30 100 131 33
12 Atletico Oromana Sub 12 Atletico 30 69 113 30
13 C.D. Mairena C.D. Mairena 30 78 108 25
14 Pablo VI Pablo VI 30 82 155 15
15 Los Palacios CF Palacios 30 68 147 15
16 Rociera Rociera 30 60 174 7
TEMPORADA 2013/2014
3ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla F.C. Sevilla F.C. 17 162 11 51
2 Real Betis Balompie C Real Betis. 18 145 24 51
3 CD Cabecense Cabecense 18 157 75 42
4 Alcalá del Valle C.D Alcalá 18 120 37 40
5 Andalucía Este Andalucía 18 87 37 39
6 Sevilla Este Sevilla Este 18 94 38 38
7 Los Palacios CF Palacios 18 112 52 35
8 Pablo VI Pablo VI 18 78 66 27
9 Ciudad de Moron Ciudad Moron 18 64 68 26
10 Estepa Industrial Estepa 17 52 98 18
11 San Roque Balompié Sub 12 B Roque 18 38 86 16
12 Diablos Rojos Diablos 19 60 93 16
13 CD Antonio Puerta B Antonio 18 52 64 12
14 Torreblanca A Torreblanca 19 48 122 9
15 Peña Bética Alcalá Peña 19 44 194 4
16 C.D. Altair C.D. Altair 15 10 255 0

  USO DE MEMORIA  
5,508,680 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6623
Total Execution Time  0.6637
  CADENA URL  
/historico/Cf-Ciudad-De-Moron-Alevin
  GET DATOS  
$_GET['/historico/Cf-Ciudad-De-Moron-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0131  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 = 'Cf-Ciudad-De-Moron-Alevin' 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.0139  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 = 'Cf-Ciudad-De-Moron-Alevin' 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.0125  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  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=92004 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0134  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 = 64485
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92004 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=474 AND type_rel = 3
0.0129  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 = '92004' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '92004' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = '92004' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 64485 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=92004 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (64485,62288) 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.0125  SELECT count(id) as num_players from rel_players_base WHERE league_id = 62288 AND teamId = 92004
0.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64485 AND teamId = 92004
0.0127  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 64485 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0129  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 = '92004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92004' and rp.type = 4
0.0132  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 = '92004' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134  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 = 92004 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64485 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.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 `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 = 62288 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.0134  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 = 60529 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.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 `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 = 53974 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.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 `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 = 53959 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.0132  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 = 45018 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 42081 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 42863 AND t.round = 14 ORDER BY team.conference 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 `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 = 34538 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 17870 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 4517 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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_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 = 3098 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC