4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Coria CF
TEMPORADA 2022/2023
3ª ANDALUZA SEVILLA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 UD Loreto UD Loreto 30 121 25 81
2 Lora CF Lora CF 30 99 44 69
3 Juventud Gines Juventud 30 80 40 67
4 Camas CF Camas CF 29 79 28 61
5 Mairena del Aljarafe Mairena 30 76 50 55
6 CD Valencina FC Fem Valencina 29 65 50 44
7 Olivarense Atletico Olivarense 30 75 65 44
8 Puebla CF Puebla CF 29 60 55 44
9 Coria CF Coria CF 29 75 69 42
10 Atletico Algabeño Atletico 29 70 56 40
11 Atletico Sanlucar Atletico 30 44 58 33
12 Manantial Manantial 29 48 85 30
13 AD San Jose AD San Jose 30 41 100 23
14 CD Alcala del Valle Alcala Valle 29 32 106 16
15 Municipal de Gerena Municipal 22 27 77 14
16 Umbrete Umbrete 29 41 125 4
TEMPORADA 2021/2022
3ª ANDALUZA SEVILLA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 Castilleja Castilleja 28 67 36 62
2 Coria CF Coria CF 28 73 38 55
3 Olivarense Atletico Olivarense 28 79 40 52
4 UD Loreto UD Loreto 28 62 51 51
5 Camas CF Camas CF 28 66 41 50
6 Doctor Fleming B Doctor 28 55 38 45
7 Mairena del Aljarafe Mairena 28 56 40 43
8 Juventud Gines Juventud 28 63 49 42
9 Consolacion Consolacion 28 67 64 36
10 CD Los Caminantes Caminantes 28 40 53 34
11 San Roque Balompie C Roque 27 32 48 29
12 Atletico Libertad Atletico 27 49 81 25
13 Camino Viejo Camino Viejo 28 43 69 24
14 Espartinas CF Espartinas 28 36 72 23
15 Cmd San Juan Juan 28 37 105 12
TEMPORADA 2020/2021
3ª ANDALUZA SEVILLA CADETE GRUPO 3
Equipo PJ GF GC Puntos
1 La Liara Balompie Liara 26 126 27 70
2 Olivarense Atletico Olivarense 26 62 41 51
3 UD Loreto UD Loreto 26 79 47 48
4 Los Caminantes Caminantes 26 67 47 47
5 Doctor Fleming Doctor 26 56 47 46
6 Coria CF Coria CF 26 64 36 45
7 Camino Viejo A Camino Viejo 26 69 58 42
8 Juventud Gines Juventud 26 45 45 36
9 San Juan CMD Juan 26 51 67 32
10 Mairena del Aljarafe Mairena 26 41 59 30
11 Atletico Libertad Atletico 26 43 75 24
12 Tor del Rey de Pilas Pilas 26 34 68 22
13 Umbrete Umbrete 26 20 63 19
14 Villanueva Atletico Villanueva 26 21 98 8
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 San Roque Balompie Sub 16 Roque 22 67 20 54
2 Calavera CF Calavera CF 23 48 18 52
3 Coria CF Coria CF 22 65 29 44
4 Camas CF Camas CF 22 63 43 39
5 UD Tomares UD Tomares 23 57 41 37
6 C Atl. Antoniano Atl. 22 58 47 34
7 Ciudad de Moron Ciudad Moron 22 63 56 32
8 Centro Historico AAVV Centro 22 34 43 31
9 CD Alcala Sub 16 Alcala 20 34 32 30
10 CD Asoc. Dva. Nervion Asoc. Dva.. 22 54 52 27
11 UD Bellavista Bellavista 23 32 51 25
12 CD Montequinto Montequinto 23 39 50 21
13 Bormujos JD Bormujos JD 23 34 71 18
14 Cabecense Cabecense 22 29 65 15
15 Circulo Don Bosco CD Circulo 21 23 82 14
16 Ecija Balompie SAD Ecija 0 0 0 0
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Camas CF Camas CF 27 105 33 71
2 C.D. Mosquito C.D. 28 101 38 66
3 Cabecense Cabecense 27 72 34 60
4 Alora Sub 16 Alora 27 78 35 58
5 La Liara Balompie Liara 28 66 47 44
6 Los Caminantes B Caminantes 28 47 47 38
7 Atletico Algabeño Atletico 27 69 75 33
8 Centro Historico AAVV Centro 28 52 60 32
9 Escritor Alfonso Grosso Escritor 27 46 63 29
10 Benacazon Benacazon 28 42 96 29
11 Mairena del Aljarafe Mairena 27 37 58 28
12 Coria CF Coria CF 28 48 83 28
13 Bormujos JD Bormujos JD 28 58 78 26
14 Amigos Cerro del Aguila Amigos Cerro 28 53 81 23
15 Triana CF Triana CF 22 36 82 10
16 Cantillana Cantillana 0 0 0 0
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 CD Los Caminantes Caminantes 30 118 31 76
2 Tomares UD Tomares UD 30 111 34 74
3 Cabecense Cabecense 29 94 39 68
4 Portaceli Portaceli 30 89 53 58
5 Calavera CF Calavera CF 30 80 65 49
6 Alora Sub 16 Alora 30 64 50 48
7 Triana CF Triana CF 30 87 57 45
8 Coria CF Coria CF 30 48 66 38
9 Escritor Alfonso Grosso Escritor 30 70 78 35
10 AD San Jose AD San Jose 30 58 76 35
11 Atletico Dos Hermanas Atletico 28 67 69 34
12 El Pilar El Pilar 30 62 78 34
13 Cantillana Cantillana 30 58 94 30
14 Alcolea del Rio Alcolea 30 70 118 27
15 Atletico Libertad Atletico 29 58 93 23
16 Municipal de Gerena Municipal 30 40 173 7
TEMPORADA 2016/2017
4ª ANDALUZA SEVILLA CADETE GRUPO 9
Equipo PJ GF GC Puntos
1 Coria CF Coria CF 28 104 27 70
2 Espartinas A Espartinas 28 93 43 60
3 Castilleja Castilleja 28 97 44 53
4 Mures Mures 28 89 39 51
5 Atletico Libertad B Atletico 28 89 69 51
6 Puebla CF Puebla CF 28 71 45 50
7 Valencina Valencina 28 69 44 50
8 Jd Bormujos B Bormujos 28 89 46 47
9 San Martin San Martin 28 76 62 45
10 Huevar Huevar 28 84 58 44
11 Tor del Rey de Pilas Pilas 28 44 102 24
12 Gelves B Gelves B 28 43 84 21
13 Camas B Camas B 28 56 108 19
14 Club Atletico Aznalcazar Club 28 49 129 17
15 Academia Ugena Academia 28 37 190 4
TEMPORADA 2015/2016
2ª ANDALUZA SEVILLA CADETE
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 B Real Betis 30 90 16 73
2 CD Alcala Sub 16 Alcala 30 88 34 73
3 Sevilla FC Sub 16 B Sevilla 30 87 17 71
4 Centro Historico AAVV Centro 30 80 45 63
5 Tor del Rey de Pilas Pilas 30 44 39 48
6 CD Asoc. Dva. Nervión Asoc. Dva.. 30 57 50 46
7 Calavera CF Calavera CF 30 56 41 44
8 Circulo Don Bosco Circulo 30 55 45 43
9 Mairena del Aljarafe Mairena 30 47 61 39
10 Sevilla Este Sevilla Este 30 50 68 36
11 Ecija Balompie SAD Ecija 30 61 61 35
12 Coria CF Coria CF 30 42 62 34
13 Dos Hermanas Cf Hermanas 30 50 76 28
14 Andalucia Este CF Andalucia 30 21 73 19
15 San Jose Sub 16 Jose 30 33 86 18
16 Ciudad de Moron Ciudad Moron 30 35 122 13
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Mairena de Aljarafe Mairena 30 140 27 83
2 Tor del Rey de Pilas Pilas 30 90 43 74
3 Juan Velasco Juan Velasco 30 74 49 62
4 Diez Sanlucar Diez 30 86 39 60
5 San Juan San Juan 30 74 38 60
6 Centro Historico Centro 30 71 50 58
7 C.D. Cabecense C.D. 30 67 73 37
8 U.B. Lebrijana U.B. 30 52 63 35
9 Olivarense Olivarense 30 63 95 35
10 Antoniano Antoniano 30 68 75 34
11 Villanueva Villanueva 30 54 72 34
12 Ad Cerro Del Águila Cerro 30 53 86 32
13 Puebla Puebla 30 57 72 30
14 Coria CF Coria CF 30 43 80 27
15 Huevar Huevar 30 65 110 20
16 Gines Gines 30 35 120 11
TEMPORADA 2013/2014
1ª ANDALUZA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 16 Real Betis 30 105 13 83
2 Cádiz CF Sub 16 Cádiz 30 82 31 75
3 Sevilla FC Sub 16 Sevilla 29 89 19 69
4 Córdoba Cf Sub 16 Córdoba 30 72 37 59
5 Recreativo de Huelva Sub 16 Recreativo 30 71 33 58
6 Ad Taraguilla Taraguilla 30 65 58 45
7 CD Altair Sub 16 Altair 30 52 56 42
8 Séneca CF Sub 16 Séneca 29 48 38 39
9 Coria CF Coria CF 30 42 47 37
10 CD Utrera Sub 16 Utrera 30 48 61 35
11 CD Apedem A CD Apedem A 30 41 62 35
12 Atlético Sanluqueño Sub 16 Atlético 30 34 75 31
13 Xerez Cd Xerez Cd 29 40 61 27
14 San Fernando Isleño A Fernando 29 24 88 19
15 San Roque de Lepe CD Roque Lepe 30 26 99 15
16 Deportivo Córdoba CF Deportivo 30 28 89 11

  USO DE MEMORIA  
5,939,256 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0028
Controller Execution Time ( Home / Category )  0.1178
Total Execution Time  0.1206
  CADENA URL  
/historico/Coria-Cf-Cadete
  GET DATOS  
$_GET['/historico/Coria-Cf-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
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 = 70166
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 = 70198
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20739 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=451 AND type_rel = 3
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 = '20739' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '20739' 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 = 70166 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 70198 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=20739 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 (70198,70166) 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.0019  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70166 AND teamId = 20739
0.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70198 AND teamId = 20739
0.0018  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 = 70166 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '20739' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '20739' 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 = '20739' 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 = 20739 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70166 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.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 `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 = 70198 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 `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 = 64736 AND t.round = 34 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 = 64953 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 `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 = 59537 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.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 `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 = 60389 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.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 = 53878 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.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 `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 = 45905 AND t.round = 30 ORDER BY team.conference 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 = 45930 AND t.round = 30 ORDER BY team.conference 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 `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 = 40487 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 `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 = 40575 AND t.round = 30 ORDER BY team.conference 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 `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 = 34342 AND t.round = 30 ORDER BY team.conference 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 `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 = 34751 AND t.round = 30 ORDER BY team.conference 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 `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 = 17301 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 = 17362 AND t.round = 30 ORDER BY team.conference 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 `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 = 4308 AND t.round = 30 ORDER BY team.conference 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 `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 = 4473 AND t.round = 30 ORDER BY team.conference 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 `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 = 2817 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 70166 ORDER BY nameShow LIMIT 100