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 Hermannstadt Hermannstadt 6 10 4 31
2 UTA Arad UTA Arad 6 10 8 31
3 Oțelul Galați Oțelul 6 7 5 30
4 Universitatea Cluj Universitate 7 8 7 29
5 Petrolul Ploiesti Petrolul 6 5 9 26
6 Voluntari Voluntari 7 11 9 23
7 U Craiova 1948 Craiova 1948 7 6 10 22
8 Botosani Botosani 6 9 8 21
9 Politehnica Iași Politehnica 6 4 6 21
10 Dinamo Bucureşti Dinamo 7 5 9 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 1
Equipo PJ GF GC Puntos
1 UTA Arad UTA Arad 23 49 13 50
2 Mioveni Mioveni 23 36 22 39
3 Turris-Oltul T. Măgurele Turris-Oltul 22 36 25 39
4 FC Arges FC Arges 23 34 25 38
5 Petrolul Ploiesti Petrolul 23 23 20 38
6 FC Rapid Bucuresti Rapid 23 32 20 37
7 Metaloglobus Metaloglobus 23 28 20 37
8 FC Buzău FC Buzău 23 35 27 33
9 Farul Constanța Farul 23 27 20 33
10 Viitorul Pandurii Viitorul 22 30 25 33
11 ASU Politehnica Timisoara Politehnica 22 20 12 32
12 Dunărea Călăraşi Dunărea 23 29 30 31
13 Ripensia Timisoara Ripensia 23 28 34 28
14 Universitatea Cluj Universitate 23 29 26 27
15 Şcolar Reşiţa Şcolar 22 30 35 24
16 Concordia Chiajna Concordia 22 20 30 24
17 Csikszereda Csikszereda 23 17 33 22
18 CS Sportul Snagov Sportul 23 16 59 9
19 Pandurii Pandurii 23 10 53 8
20 Daco-Getica Daco-Getica 0 0 0 0
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 5
Equipo PJ GF GC Puntos
1 Universitatea Cluj Universitate 28 88 16 74
2 Dacia Maramureș Dacia 28 56 25 56
3 Performanța Ighiu Performanța 28 56 32 54
4 Metalurgistul Cugir Metalurgistu 28 47 30 51
5 Industria Galda Industria 28 47 37 50
6 FC Unirea Alba Iulia Unirea Alba 28 45 34 48
7 Sănătatea Cluj Sănătatea 28 49 25 45
8 CFR Cluj II CFR Cluj II 28 53 36 44
9 Unirea Tășnad Unirea 28 40 48 40
10 Avântul Reghin Avântul 28 36 43 35
11 Avrig Avrig 28 37 42 33
12 Gaz Metan Medias II Metan Medias 28 28 60 23
13 Iernut Iernut 28 39 73 19
14 Unirea Dej Unirea Dej 28 21 55 17
15 Viitorul Ghimbav Viitorul 28 15 101 3
TEMPORADA 2015/2016
SEGUNDA RUMANÍA GRUPO 6
Equipo PJ GF GC Puntos
1 CSM Râmnicu Vâlcea Râmnicu 10 15 9 35
2 FC Olimpia Satu Mare Olimpia Satu 10 17 9 32
3 Şoimii Pâncota Şoimii 10 12 12 32
4 Universitatea Cluj Universitate 10 11 13 28
5 Unirea Tărlungeni Unirea 10 20 12 23
6 CS Sportul Snagov Sportul 10 3 23 0
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
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
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Tîrgu Mures Tîrgu Mures 32 52 20 69
2 Universitatea Cluj Universitate 32 60 24 67
3 Mioveni Mioveni 32 46 20 66
4 UTA Arad UTA Arad 32 50 26 58
5 Argeş Piteşti Argeş 32 48 30 54
6 Otopeni Otopeni 32 59 40 53
7 Turnu Severin Turnu 32 39 36 45
8 FC Baia Mare Baia Mare 32 34 35 44
9 Bihor Oradea Bihor Oradea 32 49 40 42
10 Arieşul Turda Arieşul 32 40 43 42
11 FC Silvania FC Silvania 32 31 46 37
12 CSM Râmnicu Vâlcea Râmnicu 32 51 51 36
13 Minerul Lupeni Minerul 32 33 41 36
14 Mureşul Deva Mureşul 32 28 50 31
15 Fortuna Covaci Fortuna 32 37 59 26
16 Jiul Petrosani Jiul 31 21 59 26
17 Drobeta-Turnu Severin Drobeta-Turn 31 12 70 17
TEMPORADA 2008/2009
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Unirea Alba Iulia Unirea Alba 34 58 28 69
2 Internaţional C. de Argeş Internaţion 34 61 40 64
3 Tîrgu Mures Tîrgu Mures 34 54 27 57
4 CSM Râmnicu Vâlcea Râmnicu 34 52 37 54
5 Drobeta-Turnu Severin Drobeta-Turn 34 48 43 54
6 Liberty Oradea Liberty 34 38 28 51
7 Mioveni Mioveni 34 45 40 51
8 Minerul Lupeni Minerul 34 41 43 48
9 UTA Arad UTA Arad 34 32 35 47
10 Jiul Petrosani Jiul 34 46 36 46
11 Bihor Oradea Bihor Oradea 34 44 49 46
12 Mureşul Deva Mureşul 34 44 51 45
13 Arieşul Turda Arieşul 34 30 29 44
14 Universitatea Cluj Universitate 34 37 33 43
15 ACU Arad ACU Arad 34 45 51 41
16 CFR Timisoara Timisoara 34 41 60 39
17 FCM Târgovişte Târgovişte 34 23 53 26
18 Arieşul 1907 Arieşul 34 22 78 11

  USO DE MEMORIA  
7,215,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.7236
Total Execution Time  0.7248
  CADENA URL  
/historico/Cfm-Universitatea-Cluj
  GET DATOS  
$_GET['/historico/Cfm-Universitatea-Cluj']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0256  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 = 75606
0.0133  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 = 72230
0.0132  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 = 74011
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=740 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 740 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  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 (41463,44167,632793,650810,838766) ORDER BY n.cover_points DESC, update_date DESC
0.0132  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 = '740' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 73672 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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.0141  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=740 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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,74803,73672,71432) 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.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 75606 AND teamId = 740
0.0150  SELECT count(id) as num_players from rel_players WHERE league_id = 74803 AND teamId = 740
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 740
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 740
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 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.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 = '740' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '740' and rp.type = 4
0.0137  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 = '740' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0183  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 = 740 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.0180  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 = 740 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 740 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 740 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72230 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 `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 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 `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.0128  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.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 `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.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 `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.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 `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.0143  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.0150  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.0156  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.0151  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 = 38958 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 15517 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 24178 AND t.round = 10 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 `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.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 `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.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 `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.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 `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.0145  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.0162  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 = 13958 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 13956 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC