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 2
Equipo PJ GF GC Puntos
1 UTA Arad UTA Arad 7 12 8 34
2 Oțelul Galați Oțelul 7 8 5 33
3 Hermannstadt Hermannstadt 7 10 5 31
4 Universitatea Cluj Universitate 7 8 7 29
5 Petrolul Ploiesti Petrolul 7 6 11 26
6 Botosani Botosani 7 11 9 24
7 Voluntari Voluntari 7 11 9 23
8 U Craiova 1948 Craiova 1948 7 6 10 22
9 Dinamo Bucureşti Dinamo 7 5 9 21
10 Politehnica Iași Politehnica 7 4 8 21
TEMPORADA 2022/2023
LIGA RUMANA GRUPO 3
Equipo PJ GF GC Puntos
1 U Craiova 1948 Craiova 1948 9 13 7 36
2 Voluntari Voluntari 9 17 11 34
3 Petrolul Ploiesti Petrolul 9 9 9 34
4 Universitatea Cluj Universitate 9 12 9 33
5 Botosani Botosani 9 10 5 31
6 Hermannstadt Hermannstadt 9 10 7 31
7 UTA Arad UTA Arad 9 10 9 26
8 FC Arges FC Arges 9 10 11 24
9 Chindia Târgovişte Chindia 9 7 12 23
10 Mioveni Mioveni 9 1 19 11
TEMPORADA 2021/2022
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Petrolul Ploiesti Petrolul 10 9 7 63
2 Hermannstadt Hermannstadt 10 14 5 61
3 Universitatea Cluj Universitate 10 13 9 57
4 CSA Steaua Bucuresti Steaua 10 10 10 50
5 Concordia Chiajna Concordia 10 8 17 44
6 Unirea Slobozia Unirea 10 6 12 41
TEMPORADA 2020/2021
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Farul Constanța Farul 25 34 26 42
2 Universitatea Cluj Universitate 25 33 28 39
3 Metaloglobus Metaloglobus 25 31 22 39
4 Ripensia Timisoara Ripensia 25 24 33 36
5 Dacia Maramureș Dacia 25 47 39 35
6 CSM Slatina CSM Slatina 25 25 40 19
7 Pandurii Pandurii 25 23 54 14
8 Petrolul Ploiesti Petrolul 25 38 20 42
9 Viitorul Pandurii Viitorul 25 47 41 41
10 FC Buzău FC Buzău 25 30 27 35
11 Concordia Chiajna Concordia 25 29 24 34
12 Unirea Slobozia Unirea 25 23 31 29
13 Şcolar Reşiţa Şcolar 25 18 33 26
14 Aerostar Bacău Aerostar 25 23 54 11
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
SEGUNDA RUMANÍA
Equipo PJ GF GC Puntos
1 Chindia Târgovişte Chindia 38 79 33 88
2 LPS HD Clinceni Clinceni 38 77 24 87
3 Universitatea Cluj Universitate 38 85 26 82
4 Petrolul Ploiesti Petrolul 38 77 38 77
5 CS Sportul Snagov Sportul 38 56 37 70
6 FC Arges FC Arges 38 54 33 68
7 Mioveni Mioveni 38 63 41 61
8 Luceafărul Oradea Luceafărul 38 57 59 52
9 Metaloglobus Metaloglobus 38 43 56 49
10 ASU Politehnica Timisoara Politehnica 38 39 38 48
11 Daco-Getica Daco-Getica 38 54 55 47
12 UTA Arad UTA Arad 38 55 64 47
13 Ripensia Timisoara Ripensia 38 44 54 47
14 Farul Constanța Farul 38 46 60 47
15 Pandurii Pandurii 38 57 65 44
16 Energeticianul Energetician 38 46 55 39
17 Aerostar Bacău Aerostar 38 60 68 38
18 ACS Poli Timişoara Poli 38 31 67 29
19 Baloteşti Baloteşti 38 31 88 24
20 Brăila Brăila 38 30 123 19
TEMPORADA 2017/2018
TERCERA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Petrolul Ploiesti Petrolul 24 57 18 60
2 Alexandria Alexandria 24 59 17 56
3 Turris-Oltul T. Măgurele Turris-Oltul 24 51 15 56
4 Astra II Astra II 24 33 18 42
5 CS Popesti Leordeni Popesti 24 47 38 35
6 Tunari Tunari 24 38 30 32
7 Flacara Moreni Flacara 23 36 38 30
8 Atletic Bradu Atletic 24 28 46 26
9 Concordia Chiajna II Concordia 24 33 41 25
10 Aninoasa Aninoasa 24 30 47 20
11 Sporting Roşiorii Sporting 24 24 42 20
12 Mioveni II Mioveni II 24 22 53 20
13 Viitorul Domneşti Viitorul 23 25 80 18
14 Urban Titu Urban Titu 0 0 0 0
TEMPORADA 2015/2016
LIGA RUMANA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Astra Giurgiu Astra 26 42 29 51
2 Dinamo Bucureşti Dinamo 26 36 24 48
3 Pandurii Pandurii 26 35 26 47
4 Viitorul Constanţa Viitorul 26 49 30 46
5 FCSB FCSB 26 35 25 44
6 Tîrgu Mures Tîrgu Mures 26 27 21 38
7 Politehnica Iași Politehnica 26 22 25 37
8 CFR Cluj CFR Cluj 26 31 25 31
9 Universitatea Craiova Universitate 26 26 27 31
10 Botosani Botosani 26 30 35 26
11 ACS Poli Timişoara Poli 26 24 35 25
12 Voluntari Voluntari 26 28 42 24
13 Concordia Chiajna Concordia 26 22 46 17
14 Petrolul Ploiesti Petrolul 26 17 34 8
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
LIGA RUMANA
Equipo PJ GF GC Puntos
1 FCSB FCSB 34 71 20 77
2 FC Astra Giurgiu Astra 34 70 28 72
3 Petrolul Ploiesti Petrolul 34 53 20 68
4 Dinamo Bucureşti Dinamo 34 52 34 59
5 CFR Cluj CFR Cluj 34 44 33 51
6 FC Vaslui FC Vaslui 34 38 32 51
7 Pandurii Pandurii 34 59 39 50
8 Botosani Botosani 34 36 52 43
9 FC Ceahlaul Piatra Neamt Ceahlaul 34 27 31 41
10 Oțelul Galați Oțelul 34 43 52 41
11 Universitatea Cluj Universitate 34 29 46 40
12 Viitorul Constanţa Viitorul 34 29 50 40
13 Gaz Metan Gaz Metan 34 32 38 39
14 Concordia Chiajna Concordia 34 34 47 39
15 FC Brasov FC Brasov 34 32 40 38
16 ACS Poli Timişoara Poli 34 26 42 38
17 Săgeata Năvodari Săgeata 34 32 54 38
18 Corona Braşov Corona 34 20 69 14
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
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Petrolul Ploiesti Petrolul 28 46 22 59
2 Bihor Oradea Bihor Oradea 28 43 20 58
3 Mioveni Mioveni 28 43 19 57
4 Voinţa Sibiu Voinţa 28 36 17 50
5 ALRO Slatina ALRO Slatina 28 46 26 48
6 UTA Arad UTA Arad 28 48 36 47
7 Politehnica Iași Politehnica 28 41 30 47
8 CSM Râmnicu Vâlcea Râmnicu 28 35 39 36
9 Arieşul Turda Arieşul 28 26 31 33
10 Turnu Severin Turnu 28 36 39 31
11 FC Unirea Alba Iulia Unirea Alba 28 22 35 30
12 Argeş Piteşti Argeş 28 27 40 29
13 Mureşul Deva Mureşul 28 31 48 26
14 ACU Arad ACU Arad 28 18 36 25
15 FC Silvania FC Silvania 28 9 69 10
16 Minerul Lupeni Minerul 0 0 0 0
TEMPORADA 2009/2010
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Victoria Brăneşti Victoria 34 62 28 71
2 Sportul Studenţesc Sportul 34 65 26 68
3 Petrolul Ploiesti Petrolul 34 58 20 67
4 Snagov Snagov 34 62 41 60
5 Delta Tulcea Delta Tulcea 34 41 23 59
6 Săgeata Năvodari Săgeata 34 46 29 58
7 Concordia Chiajna Concordia 34 51 36 54
8 FC Farul Constanta Farul 34 52 48 53
9 Botosani Botosani 34 45 36 49
10 Astra Giurgiu II Astra 34 43 41 49
11 Dunărea Galaţi Dunărea 34 37 39 45
12 FC Municipal Bacău Municipal 34 47 57 43
13 Steaua Bucureşti II Steaua 34 36 36 41
14 FC Buzău FC Buzău 34 39 44 35
15 Dinamo Bucureşti II Dinamo 34 36 67 29
16 Tricolorul Breaza Tricolorul 34 31 66 28
17 Râmnicu Sarat Râmnicu 34 14 68 19
18 Cetatea Suceava Cetatea 34 16 76 15

  USO DE MEMORIA  
6,668,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1337
Total Execution Time  0.1349
  CADENA URL  
/historico/Petrolul-Ploiesti
  GET DATOS  
$_GET['/historico/Petrolul-Ploiesti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (38)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1959 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1959 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (51055,51625,858716) ORDER BY n.cover_points DESC, update_date DESC
0.0035  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 = '1959' 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 = 74011 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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.0033  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=1959 AND l.year in (2023,2024,2025) 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 (75606,74011,71432,69547) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75606 AND teamId = 1959
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 74011 AND teamId = 1959
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 69547 AND teamId = 1959
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1959
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 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 = 75606 AND t.round = 7 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 = '1959' 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 = '1959' 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 = '1959' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 1959 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.0028  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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 1959 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 1959 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 1959 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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.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 `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 = 71247 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.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` 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 = 63225 AND t.round = 19 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 `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 = 66962 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.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` 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 = 61990 AND t.round = 7 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 `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.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 `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.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` 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 = 44553 AND t.round = 38 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` 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 = 38956 AND t.round = 26 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` 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 = 20793 AND t.round = 14 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 `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 = 15579 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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.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 `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 = 2510 AND t.round = 34 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 `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.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 `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.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 `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 = 13960 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 `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 = 13957 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC