4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 FCSB FCSB 6 10 5 46
2 Farul Constanța Farul 6 13 6 35
3 Universitatea Craiova Universitate 6 8 8 34
4 CFR Cluj CFR Cluj 6 8 10 34
5 FC Rapid Bucuresti Rapid 6 6 14 29
6 Sepsi Sepsi 6 7 9 28
TEMPORADA 2022/2023
LIGA RUMANA GRUPO 2
Equipo PJ GF GC Puntos
1 Farul Constanța Farul 10 22 13 53
2 FCSB FCSB 10 15 15 46
3 CFR Cluj CFR Cluj 10 11 14 42
4 Universitatea Craiova Universitate 10 15 14 40
5 FC Rapid Bucuresti Rapid 10 17 20 38
6 Sepsi Sepsi 10 10 14 29
TEMPORADA 2021/2022
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 Sepsi Sepsi 9 21 4 42
2 Botosani Botosani 9 18 9 41
3 FC Rapid Bucuresti Rapid 9 22 7 39
4 U Craiova 1948 Craiova 1948 9 14 11 34
5 UTA Arad UTA Arad 9 10 6 33
6 Mioveni Mioveni 9 12 10 31
7 Chindia Târgovişte Chindia 9 8 8 26
8 Dinamo Bucureşti Dinamo 9 14 11 23
9 LPS HD Clinceni Clinceni 9 4 32 -43
10 Gaz Metan Gaz Metan 9 6 31 -46
TEMPORADA 2020/2021
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 U Craiova 1948 Craiova 1948 29 43 22 54
2 FC Rapid Bucuresti Rapid 29 47 39 49
3 Mioveni Mioveni 29 41 22 48
4 Dunărea Călăraşi Dunărea 29 35 40 44
5 Csikszereda Csikszereda 29 32 26 42
6 ASU Politehnica Timisoara Politehnica 29 27 29 41
TEMPORADA 2019/2020
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Arges FC Arges 4 5 3 8
2 Turris-Oltul T. Măgurele Turris-Oltul 5 5 5 6
3 FC Rapid Bucuresti Rapid 5 4 4 6
4 Petrolul Ploiesti Petrolul 5 4 4 6
5 UTA Arad UTA Arad 5 8 8 5
6 Mioveni Mioveni 4 2 4 4
TEMPORADA 2018/2019
TERCERA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Rapid Bucuresti Rapid 28 97 18 75
2 Afumati Afumati 28 76 26 64
3 Progresul Spartac Progresul 28 64 26 60
4 Unirea Slobozia Unirea 28 68 35 60
5 CS Popesti Leordeni Popesti 28 55 39 48
6 Tunari Tunari 28 56 32 43
7 Înainte Modelu Înainte 28 45 54 36
8 Făurei Făurei 28 35 59 35
9 Axiopolis Axiopolis 28 36 51 33
10 CSM Medgidia Medgidia 28 33 60 32
11 Steaua Bucureşti II Steaua 28 52 61 30
12 Agricola Borcea Agricola 28 47 84 30
13 Sportul Chişcani Sportul 28 51 66 28
14 Oltenita Oltenita 28 32 60 24
15 Bragadiru Bragadiru 0 0 0 0
16 Delta Dobrogea Tulcea Delta 28 4 80 0
TEMPORADA 2015/2016
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 FC Rapid Bucuresti Rapid 10 12 11 44
2 Dunărea Călăraşi Dunărea 10 22 8 41
3 Brăila Brăila 10 16 13 35
4 SC Bacău SC Bacău 10 16 16 30
5 FC Farul Constanta Farul 10 17 23 29
6 LPS HD Clinceni Clinceni 10 15 27 27
TEMPORADA 2014/2015
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 59 23 71
2 Tîrgu Mures Tîrgu Mures 34 51 25 68
3 FC Astra Giurgiu Astra 34 53 27 57
4 CFR Cluj CFR Cluj 34 46 29 57
5 Universitatea Craiova Universitate 34 40 34 53
6 Petrolul Ploiesti Petrolul 34 42 30 52
7 Dinamo Bucureşti Dinamo 34 47 44 48
8 Botosani Botosani 34 40 43 47
9 Pandurii Pandurii 34 47 42 45
10 Politehnica Iași Politehnica 34 31 39 43
11 Viitorul Constanţa Viitorul 34 44 54 43
12 Concordia Chiajna Concordia 34 39 44 41
13 Gaz Metan Gaz Metan 34 29 34 39
14 FC Brasov FC Brasov 34 33 46 36
15 Universitatea Cluj Universitate 34 29 41 35
16 FC Rapid Bucuresti Rapid 34 21 42 33
17 Oțelul Galați Oțelul 34 24 45 32
18 FC Ceahlaul Piatra Neamt Ceahlaul 34 25 58 27
TEMPORADA 2013/2014
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Politehnica Iași Politehnica 22 47 16 49
2 FC Rapid Bucuresti Rapid 22 34 20 41
3 Unirea Slobozia Unirea 22 29 22 41
4 LPS HD Clinceni Clinceni 22 41 28 37
5 Berceni Berceni 22 33 26 36
6 SC Bacău SC Bacău 22 29 31 29
7 Unirea Tărlungeni Unirea 22 18 22 27
8 FC Buzău FC Buzău 22 25 24 25
9 Brăila Brăila 22 24 34 23
10 Foresta Suceava Foresta 22 22 42 19
11 FC Farul Constanta Farul 22 12 35 18
12 Dunărea Galaţi Dunărea 22 24 38 17
13 Sportul Studenţesc Sportul 0 0 0 0
TEMPORADA 2012/2013
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 74 29 79
2 Pandurii Pandurii 34 57 43 63
3 Petrolul Ploiesti Petrolul 34 60 34 62
4 FC Astra Giurgiu Astra 34 64 37 60
5 FC Vaslui FC Vaslui 34 50 34 58
6 Dinamo Bucureşti Dinamo 34 48 40 56
7 FC Brasov FC Brasov 34 50 51 51
8 CFR Cluj CFR Cluj 34 56 39 49
9 FC Rapid Bucuresti Rapid 34 35 35 49
10 Gaz Metan Gaz Metan 34 42 46 46
11 Oțelul Galați Oțelul 34 38 42 43
12 Universitatea Cluj Universitate 34 39 55 38
13 Viitorul Constanţa Viitorul 34 45 57 36
14 FC Ceahlaul Piatra Neamt Ceahlaul 34 41 59 34
15 Concordia Chiajna Concordia 34 29 49 33
16 Turnu Severin Turnu 34 36 47 32
17 Politehnica Iași Politehnica 34 31 50 26
18 ACF Gloria Bistrita Gloria 34 21 69 17
TEMPORADA 2011/2012
LIGA RUMANA
Equipo PJ GF GC Puntos
1 CFR Cluj CFR Cluj 34 63 31 71
2 FC Vaslui FC Vaslui 34 58 29 70
3 FCSB FCSB 34 46 26 66
4 FC Rapid Bucuresti Rapid 34 54 29 64
5 Dinamo Bucureşti Dinamo 34 57 32 62
6 Oțelul Galați Oțelul 34 34 29 52
7 Universitatea Cluj Universitate 34 46 37 47
8 Pandurii Pandurii 34 47 40 47
9 FC Brasov FC Brasov 34 39 34 45
10 Concordia Chiajna Concordia 34 42 52 45
11 FC Ceahlaul Piatra Neamt Ceahlaul 34 36 46 42
12 FC Astra Giurgiu Astra 34 36 43 41
13 Gaz Metan Gaz Metan 34 39 54 41
14 Petrolul Ploiesti Petrolul 34 42 44 39
15 Tîrgu Mures Tîrgu Mures 34 34 47 35
16 Voinţa Sibiu Voinţa 34 24 45 32
17 Sportul Studenţesc Sportul 34 33 55 30
18 Mioveni Mioveni 34 20 77 12
TEMPORADA 2010/2011
LIGA RUMANA
Equipo PJ GF GC Puntos
1 Oțelul Galați Oțelul 34 46 25 70
2 Politehnica Timisoara Politehnica 34 63 38 66
3 FC Vaslui FC Vaslui 34 51 28 65
4 FC Rapid Bucuresti Rapid 34 43 22 59
5 FCSB FCSB 34 44 27 57
6 Dinamo Bucureşti Dinamo 34 68 52 56
7 Gaz Metan Gaz Metan 34 41 32 55
8 Universitatea Cluj Universitate 34 48 54 47
9 FC Astra Giurgiu Astra 34 36 30 45
10 CFR Cluj CFR Cluj 34 50 45 45
11 Tîrgu Mures Tîrgu Mures 34 34 41 45
12 FC Brasov FC Brasov 34 34 40 43
13 Pandurii Pandurii 34 36 46 37
14 ACF Gloria Bistrita Gloria 34 34 49 35
15 FC Universitatea Craiova Universitate 34 35 48 30
16 Victoria Brăneşti Victoria 34 35 61 25
17 FC Unirea Urziceni Unirea 34 23 63 25
18 Sportul Studenţesc Sportul 34 38 58 23
TEMPORADA 2009/2010
LIGA RUMANA
Equipo PJ GF GC Puntos
1 CFR Cluj CFR Cluj 34 46 23 69
2 FC Unirea Urziceni Unirea 34 53 26 66
3 FC Vaslui FC Vaslui 34 44 28 62
4 FCSB FCSB 34 49 36 62
5 Politehnica Timisoara Politehnica 34 52 28 56
6 FC Rapid Bucuresti Rapid 34 54 35 55
7 Dinamo Bucureşti Dinamo 34 48 37 53
8 Oțelul Galați Oțelul 34 38 38 50
9 FC Brasov FC Brasov 34 40 30 46
10 Gaz Metan Gaz Metan 34 33 37 42
11 ACF Gloria Bistrita Gloria 34 35 46 41
12 FC Universitatea Craiova Universitate 34 44 52 36
13 FC Astra Giurgiu Astra 34 33 45 36
14 Internaţional C. de Argeş Internaţion 34 32 49 36
15 Pandurii Pandurii 34 19 30 34
16 FC Politehnica Iasi Politehnica 34 28 50 31
17 FC Ceahlaul Piatra Neamt Ceahlaul 34 28 57 28
18 FC Unirea Alba Iulia Unirea Alba 34 33 62 26
TEMPORADA 2008/2009
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FC Unirea Urziceni Unirea 34 51 20 70
2 Politehnica Timisoara Politehnica 34 58 38 67
3 Dinamo Bucureşti Dinamo 34 56 30 65
4 CFR Cluj CFR Cluj 34 44 26 59
5 FC Vaslui FC Vaslui 34 44 37 57
6 FCSB FCSB 34 44 27 56
7 FC Universitatea Craiova Universitate 34 44 25 56
8 FC Rapid Bucuresti Rapid 34 44 34 55
9 FC Brasov FC Brasov 34 35 25 55
10 Argeş Piteşti Argeş 34 41 47 44
11 Pandurii Pandurii 34 27 36 43
12 Oțelul Galați Oțelul 34 37 48 40
13 ACF Gloria Bistrita Gloria 34 32 44 38
14 FC Politehnica Iasi Politehnica 34 32 47 37
15 Gaz Metan Gaz Metan 34 36 51 36
16 FC Farul Constanta Farul 34 27 56 30
17 Otopeni Otopeni 34 32 54 22
18 FC Buzău FC Buzău 34 23 62 17

  USO DE MEMORIA  
6,476,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1469
Total Execution Time  0.1481
  CADENA URL  
/historico/Fc-Rapid-Bucuresti
  GET DATOS  
$_GET['/historico/Fc-Rapid-Bucuresti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
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 = 75607
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2801 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 2801 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (3418,21431,33861,41492,45037) ORDER BY n.cover_points DESC, update_date DESC
0.0038  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 = '2801' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 74011 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 = 72230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = '2801' 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 = '2801' 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 = '2801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  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 = 2801 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75607 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.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 `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 = 68105 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.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 `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 = 71246 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.0057  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 = 63214 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.0030  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 = 66915 AND t.round = 9 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` 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 = 58562 AND t.round = 21 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` 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 = 61989 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.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 `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 = 50089 AND t.round = 24 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` 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 = 56849 AND t.round = 5 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 `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 = 44930 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 `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 = 15516 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` 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 = 24171 AND t.round = 10 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 `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 = 3826 AND t.round = 34 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 `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 = 2739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2013` 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 = 2030 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2012` 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 = 1354 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0047  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 `tables2011` 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 = 1107 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2010` 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 = 866 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2009` 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 = 282 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC