4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Recreativo Portuense
TEMPORADA 2023/2024
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 AD Taraguilla Taraguilla 27 63 27 59
2 Barbate Barbate 26 49 23 56
3 Chipiona CF Chipiona CF 27 50 29 53
4 RB Linense B Linense 26 47 31 52
5 CD Vejer Balompié Vejer 27 41 38 43
6 At. Sanluqueño B Sanluqueño 27 44 49 41
7 CD Jédula CD Jédula 26 25 28 36
8 Tarifa UD Tarifa UD 27 30 31 35
9 Athletic Nueva Jarilla Athletic 26 31 32 35
10 CD Ubrique CD Ubrique 27 33 37 34
11 Olvera Olvera 26 41 39 33
12 CD UD Villamartín Villamartín 27 45 44 33
13 Chiclana Industrial Chiclana 27 44 44 33
14 San Jose Atletico Jose 26 23 40 25
15 J. Sanluqueña Sanluqueña 27 32 61 22
16 Recreativo Portuense Recreativo 27 26 71 12
TEMPORADA 2022/2023
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 San Fernando CD B Fernando 30 68 35 56
2 Trebujena CF Trebujena 30 46 32 54
3 Roteña Roteña 30 55 41 54
4 Puerto Real CF Puerto Real 30 63 29 53
5 Guadiaro Guadiaro 30 54 39 53
6 RC Portuense Portuense 30 55 34 51
7 Balón de Cádiz CF Balón 30 39 38 47
8 Algeciras CF B Algeciras 30 63 54 42
9 Jerez Industrial CF Jerez 30 44 35 41
10 Grupo Empresa Bazán CF Grupo 30 49 53 41
11 Xerez Deportivo B Xerez 30 57 51 40
12 CD Guadalcacín Guadalcacín 30 53 46 39
13 CD Jédula CD Jédula 30 43 51 39
14 Barbate Barbate 30 55 53 35
15 Recreativo Portuense Recreativo 30 27 74 17
16 CD UD Villamartín Villamartín 30 20 126 7
TEMPORADA 2021/2022
PRIMERA ANDALUZA GRUPO 15
Equipo PJ GF GC Puntos
1 Balón de Cádiz CF Balón 28 70 27 67
2 UD Algaida UD Algaida 28 54 26 61
3 Xerez Deportivo B Xerez 28 59 33 57
4 RC Portuense Portuense 28 52 25 53
5 Roteña Roteña 28 40 34 43
6 San Fernando CD B Fernando 28 48 47 40
7 Trebujena CF Trebujena 28 37 37 40
8 CD Jédula CD Jédula 28 37 49 38
9 CD UD Villamartín Villamartín 28 35 41 35
10 Recreativo Portuense Recreativo 28 32 47 28
TEMPORADA 2020/2021
PRIMERA ANDALUZA GRUPO 32
Equipo PJ GF GC Puntos
1 CD UD Villamartín Villamartín 4 8 4 9
2 Recreativo Portuense Recreativo 4 6 3 9
3 CD El Torno 2009 Torno 2009 4 9 10 9
4 CD Vejer Balompié Vejer 6 10 9 6
5 Tarifa UD Tarifa UD 6 7 14 3
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Puerto Real CF Puerto Real 25 53 23 57
2 Jerez Industrial CF Jerez 25 48 21 54
3 Balón de Cádiz CF Balón 25 48 27 46
4 Ubrique UD Ubrique UD 25 39 29 44
5 Roteña Roteña 25 36 29 42
6 CD El Torno 2009 Torno 2009 25 42 30 39
7 Trebujena CF Trebujena 25 41 31 39
8 Tarifa UD Tarifa UD 25 35 33 36
9 CD UD Villamartín Villamartín 25 32 31 35
10 Chipiona CF Chipiona CF 25 49 40 34
11 San Bernardo Bernardo 25 35 35 32
12 Tesorillo Tesorillo 25 33 45 32
13 Chiclana Industrial Chiclana 25 31 45 31
14 Recreativo Portuense Recreativo 25 29 36 29
15 Barbate Barbate 25 19 37 21
16 Algeciras CF B Algeciras 25 29 64 21
17 Grupo Empresa Bazán CF Grupo 25 23 46 15
18 CD Vejer Balompié Vejer 25 26 46 14
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Chiclana CF Chiclana CF 34 57 29 72
2 Trebujena CF Trebujena 34 68 34 71
3 Grupo Empresa Bazán CF Grupo 34 62 27 67
4 Balón de Cádiz CF Balón 34 68 35 67
5 CD UD Villamartín Villamartín 34 59 34 67
6 Ubrique UD Ubrique UD 34 66 47 60
7 Jerez Industrial CF Jerez 34 54 47 49
8 Algeciras CF B Algeciras 34 72 67 48
9 CD Vejer Balompié Vejer 34 49 51 45
10 Recreativo Portuense Recreativo 34 48 50 45
11 Tarifa UD Tarifa UD 34 44 52 44
12 Chiclana Industrial Chiclana 34 50 59 43
13 Tesorillo Tesorillo 34 56 52 41
14 CD El Torno 2009 Torno 2009 34 52 61 40
15 Guadiaro Guadiaro 34 47 58 38
16 San Fernando CD B Fernando 33 35 66 26
17 Alcalá del Valle Alcalá 33 31 79 20
18 J. Sanluqueña Sanluqueña 34 24 94 12
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Grupo Empresa Bazán CF Grupo 34 68 26 69
2 Roteña Roteña 34 55 33 64
3 Trebujena CF Trebujena 34 59 37 62
4 Jerez Industrial CF Jerez 33 63 39 59
5 CD UD Villamartín Villamartín 34 58 45 59
6 Balón de Cádiz CF Balón 34 58 37 54
7 Chiclana CF Chiclana CF 33 56 37 54
8 CD Vejer Balompié Vejer 34 52 46 52
9 CD El Torno 2009 Torno 2009 33 61 66 48
10 San Fernando CD B Fernando 34 56 53 46
11 Guadiaro Guadiaro 34 53 54 46
12 Tesorillo Tesorillo 33 51 63 41
13 J. Sanluqueña Sanluqueña 33 50 68 40
14 Recreativo Portuense Recreativo 33 39 49 39
15 San Jose Obrero UD Jose Obrero 34 40 60 37
16 Rayo Sanluqueño Rayo 34 47 64 35
17 CD Jédula CD Jédula 33 29 70 27
18 Chipiona CF Chipiona CF 33 25 73 18
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 2
Equipo PJ GF GC Puntos
1 Chiclana Industrial Chiclana 34 75 29 73
2 Balón de Cádiz CF Balón 34 91 40 67
3 Trebujena CF Trebujena 33 62 26 67
4 Jerez Industrial Cf Jerez 34 85 40 65
5 Grupo Empresa Bazán CF Grupo 33 70 48 59
6 CD UD Villamartín Villamartín 34 71 43 59
7 Tesorillo Tesorillo 33 70 59 57
8 Guadiaro Guadiaro 34 56 54 49
9 CD El Torno 2009 Torno 2009 33 44 43 49
10 San Jose Obrero UD Jose Obrero 34 55 61 43
11 Chipiona CF Chipiona CF 33 51 70 42
12 CD Jédula CD Jédula 33 50 55 41
13 Recreativo Portuense Recreativo 34 49 57 40
14 At. Sanluqueño B Sanluqueño 34 55 71 37
15 Estella Cd Estella Cd 33 36 79 28
16 AD Los Cortijillos Cortijillos 33 29 74 23
17 Algeciras CF B Algeciras 33 30 69 19
18 CD Rivera CD Rivera 33 30 91 18
TEMPORADA 2015/2016
PRIMERA ANDALUZA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Onubense Atlético 34 68 30 76
2 Cádiz CF Mirandilla Cádiz 34 90 32 71
3 CD Rota CD Rota 34 71 47 68
4 AD Cartaya AD Cartaya 34 64 32 64
5 La Palma CF La Palma CF 34 55 48 55
6 Xerez CD Xerez CD 34 49 41 54
7 Chiclana CF Chiclana CF 34 49 40 53
8 Ol. Valverdeña Valverdeña 34 51 45 50
9 Chipiona CF Chipiona CF 34 45 55 48
10 Isla Cristina Isla 34 38 47 48
11 Jerez Industrial CF Jerez 34 39 41 47
12 Recreativo Portuense Recreativo 34 52 48 43
13 Grupo Empresa Bazán CF Grupo 34 44 55 35
14 Algeciras CF B Algeciras 34 27 42 33
15 San Roque de Lepe B Roque Lepe 34 36 57 31
16 At. Sanluqueño B Sanluqueño 34 25 54 31
17 CD UD Villamartín Villamartín 34 25 64 23
18 AD Los Cortijillos Cortijillos 34 27 77 13
TEMPORADA 2014/2015
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Recreativo Portuense Recreativo 28 51 21 58
2 Algeciras CF B Algeciras 28 59 26 54
3 CD Jédula CD Jédula 28 61 37 54
4 San Bernardo Bernardo 28 48 42 42
5 San Jose Obrero UD Jose Obrero 28 45 39 42
6 Tesorillo Tesorillo 28 45 41 41
7 Novo Chiclana Novo 28 41 36 38
8 Barbate Barbate 28 44 40 37
9 Estella Cd Estella Cd 28 39 47 35
10 CD Rivera CD Rivera 28 34 43 34
11 Puerto Real CF Puerto Real 28 43 56 34
12 Trebujena CF Trebujena 28 45 67 32
13 Pueblo Nuevo Granja Pueblo Nuevo 28 33 53 29
14 Xerez Cd B Xerez Cd B 28 43 61 24
15 Rayo Sanluqueño Rayo 28 29 51 22
16 CD Portorrealeña Portorreale 0 0 0 0
TEMPORADA 2013/2014
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 CD UD Villamartín Villamartín 30 60 36 58
2 Los Cortijillos Cortijillos 30 46 32 58
3 Algeciras CF B Algeciras 30 58 26 54
4 CD Rivera CD Rivera 30 46 31 54
5 CD Balona Balompié CF Balona 30 55 43 51
6 Pueblo Nuevo La Granja Pueblo Nuevo 30 46 46 49
7 Estella Cd Estella Cd 30 52 35 47
8 Recreativo Portuense Recreativo 30 50 38 46
9 Barbate Barbate 30 40 44 39
10 Rayo Sanluqueño Rayo 30 44 46 39
11 CD Jédula CD Jédula 30 40 48 39
12 Atletico El Gastor Atletico 30 43 54 35
13 Tarifa UD Tarifa UD 30 43 59 34
14 Athletic Nueva Jarilla Athletic 30 38 46 34
15 Cdg Don Benito Benito 30 42 86 24
16 Federico Mayo C.F. Federico 30 24 57 16

  USO DE MEMORIA  
5,993,856 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6349
Total Execution Time  0.6361
  CADENA URL  
/historico/Recreativo-Portuense
  GET DATOS  
$_GET['/historico/Recreativo-Portuense']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0136  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 = 'Recreativo-Portuense' 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.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=13860 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=13860 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255  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 = 73678
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13860 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13860 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0125  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 (68433) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '13860' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '13860' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '13860' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0137  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 = 73678 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0142  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=13860 AND l.year in (2023,2024,2025) 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 (73678,68699) 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 WHERE league_id = 68699 AND teamId = 13860
0.0124  SELECT count(id) as num_players from rel_players WHERE league_id = 73678 AND teamId = 13860
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 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 = 73678 AND t.round = 27 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '13860' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13860' and rp.type = 4
0.0127  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 = '13860' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13860 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.0126  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13860 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  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 = 73678 WHERE rp.league_id = 73678 AND rp.teamId = 13860 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 13860 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68699 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.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 `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 = 64021 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.0127  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 = 67383 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.0127  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 = 58974 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.0127  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 = 62157 AND t.round = 6 ORDER BY team.conference ASC,t.position 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 `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 = 51255 AND t.round = 25 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 `tables2019` 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 = 44621 AND t.round = 34 ORDER BY team.conference 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 `tables2018` 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 = 39325 AND t.round = 34 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 `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 = 34152 AND t.round = 34 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 `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 = 16712 AND t.round = 34 ORDER BY team.conference 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 `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 = 4105 AND t.round = 30 ORDER BY team.conference 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 `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 = 2586 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC