4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cidade de Ribeira CF
TEMPORADA 2023/2024
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Noia Noia 31 62 28 63
2 Boiro Boiro 31 52 25 59
3 San Tirso SD Tirso 31 39 28 56
4 Sigueiro CF Sigueiro CF 31 54 36 54
5 CD Lalín CD Lalín 31 51 40 52
6 SD Sofán SD Sofán 31 53 40 48
7 AD Miño AD Miño 31 44 35 47
8 At. Coruña Montañeros Coruña 31 42 28 46
9 Cidade de Ribeira CF Cidade 31 55 52 42
10 Galicia Mugardos Galicia 31 35 36 41
11 Ribadeo FC Ribadeo FC 31 46 50 39
12 Dubra Dubra 31 35 43 39
13 Club Lemos Club Lemos 31 34 41 38
14 CD Castro CD Castro 31 42 52 33
15 Victoria CF Victoria CF 31 30 55 30
16 SDC Residencia Residencia 31 34 59 29
17 As Pontes As Pontes 31 31 45 28
18 Eume Deportivo Eume 31 29 75 18
TEMPORADA 2022/2023
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 Cidade de Ribeira CF Cidade 34 73 23 79
2 SD Negreira SD Negreira 34 70 27 70
3 Flavia Flavia 34 57 35 69
4 CD Lalín CD Lalín 34 84 39 68
5 CF Dumbría CF Dumbría 34 73 29 67
6 SCD Santa Comba Santa Comba 34 63 32 67
7 Cordeiro CF Cordeiro CF 34 60 28 62
8 Puebla Galicia CF Puebla 34 69 49 59
9 Soneira Sd Soneira Sd 34 59 57 49
10 Calo SR Calo SR 34 49 54 39
11 SD Agolada SD Agolada 34 43 62 39
12 Tordoia Tordoia 34 53 61 38
13 Cruces SD Cruces SD 34 33 48 36
14 SD Esteirana Esteirana 34 42 64 34
15 CD Baio CD Baio 34 49 70 32
16 Mazaricos Mazaricos 34 29 92 24
17 CF Silleda CF Silleda 34 28 92 13
18 CF Vista Alegre Vista Alegre 34 29 101 11
TEMPORADA 2021/2022
PRIMERA GALICIA GRUPO 12
Equipo PJ GF GC Puntos
1 CD Union CD Union 6 14 7 20
2 Cidade de Ribeira CF Cidade 6 11 3 18
3 Flavia Flavia 6 10 7 13
4 SD Negreira SD Negreira 6 9 7 12
5 CD Baio CD Baio 6 5 15 7
6 Mazaricos Mazaricos 6 3 13 2
TEMPORADA 2019/2020
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 O Pino O Pino 25 55 26 46
2 CF Dumbría CF Dumbría 25 47 36 46
3 Soneira Sd Soneira Sd 25 53 44 46
4 CD Lalín CD Lalín 25 41 27 43
5 Tordoia Tordoia 25 44 46 40
6 Flavia Flavia 25 46 36 39
7 Cordeiro CF Cordeiro CF 25 41 29 37
8 Praiña Praiña 25 29 33 34
9 SD Agolada SD Agolada 25 39 39 33
10 Negreira Negreira 25 30 33 33
11 Piloño Piloño 25 27 36 32
12 Esclavitud Esclavitud 25 33 39 31
13 CD Baio CD Baio 25 32 44 31
14 Mazaricos Mazaricos 25 35 43 27
15 Val do Ulla Val do Ulla 25 38 52 27
16 CD Union CD Union 25 34 33 26
17 Volantes de Baño Volantes 25 37 46 26
18 Cidade de Ribeira CF Cidade 25 35 54 25
TEMPORADA 2018/2019
SEGUNDA GALICIA GRUPO 5
Equipo PJ GF GC Puntos
1 Cidade de Ribeira CF Cidade 34 91 43 75
2 Cacheiras Cacheiras 34 88 41 75
3 Lesende CFC Lousame Lesende 34 77 51 65
4 Valiño Cabo de Cruz Valiño Cabo 33 84 58 59
5 Abanqueiro SD Abanqueiro 34 80 75 59
6 Ccd Taragoña Taragoña 34 66 51 55
7 Calo SR Calo SR 34 76 77 51
8 Sálvora Sálvora 34 65 71 50
9 Urdilde Urdilde 34 61 50 49
10 Udqueiruga Udqueiruga 34 80 84 47
11 Recesende Recesende 34 53 59 43
12 Luaña SD Luaña SD 34 55 65 41
13 Agron CF Agron CF 34 53 64 40
14 Milladoiro SD Milladoiro 34 55 60 39
15 Carcacia Carcacia 34 56 71 39
16 Baroña CF Baroña CF 33 46 69 33
17 Sar Extramundi Extramundi 34 56 72 28
18 Brion SD Brion SD 34 41 122 12
TEMPORADA 2017/2018
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 SD Agolada SD Agolada 34 60 29 73
2 Puebla Galicia CF Puebla 34 69 28 69
3 SD Piloño SD Piloño 34 61 43 69
4 Flavia Flavia 34 60 30 64
5 CD Union CD Union 34 63 43 62
6 Bastavales Bastavales 34 56 46 57
7 Soneira Sd Soneira Sd 34 60 40 56
8 Lalín Lalín 34 69 48 55
9 Bertamiráns FC Bertamiráns 34 51 53 46
10 CD Baio CD Baio 34 43 43 40
11 Cordeiro CF Cordeiro CF 34 53 59 40
12 Chaián Chaián 34 45 46 39
13 Sigueiro CF Sigueiro CF 34 44 54 39
14 Tordoia Tordoia 34 32 54 37
15 SD Fisterra SD Fisterra 34 39 59 36
16 Cidade de Ribeira CF Cidade 34 43 82 29
17 San Lorenzo Verdillo Lorenzo 34 38 76 25
18 CF Silleda CF Silleda 34 35 88 17
TEMPORADA 2016/2017
PRIMERA GALICIA GRUPO 2
Equipo PJ GF GC Puntos
1 CF Dumbría CF Dumbría 34 69 30 75
2 SD Agolada SD Agolada 34 62 46 65
3 Sigueiro CF Sigueiro CF 34 66 43 56
4 Puebla Galicia CF Puebla 34 49 38 55
5 SD Piloño SD Piloño 34 74 62 53
6 CD Union CD Union 34 52 44 53
7 Cordeiro CF Cordeiro CF 34 72 56 51
8 Flavia Flavia 34 59 46 51
9 Cidade de Ribeira CF Cidade 34 70 55 49
10 Tordoia Tordoia 34 49 44 44
11 SD Fisterra SD Fisterra 33 46 48 44
12 CF Silleda CF Silleda 34 34 52 44
13 Val do Ulla Val do Ulla 34 48 49 43
14 Outes Outes 34 41 65 41
15 Lalín Lalín 33 48 58 40
16 Sporting Zas Sporting 34 43 72 34
17 Esclavitud Esclavitud 34 35 61 27
18 SD Villestro Villestro 34 46 94 22
TEMPORADA 2015/2016
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 CD Castro CD Castro 38 67 31 78
2 Dubra Dubra 38 79 44 76
3 CSD Arzua CSD Arzua 38 58 40 76
4 At. Arteixo At. Arteixo 38 74 28 74
5 Bertamiráns FC Bertamiráns 38 56 31 66
6 UD Paiosaco UD Paiosaco 38 55 39 63
7 Sporting Sada Sporting 38 44 32 61
8 Viveiro Viveiro 38 62 48 56
9 Laracha Laracha 38 62 53 53
10 Club Lemos Club Lemos 38 59 48 51
11 SD Chantada SD Chantada 38 41 41 50
12 SD Sarriana SD Sarriana 38 39 41 48
13 Xallas FC Xallas FC 38 41 46 47
14 AD Estudiantil Estudiantil 38 48 52 46
15 SCD Milagrosa Milagrosa 38 41 62 44
16 SD Villestro Villestro 38 49 63 39
17 Puebla Galicia CF Puebla 38 41 64 31
18 Cidade de Ribeira CF Cidade 38 49 96 26
19 CF Dumbría CF Dumbría 38 31 86 22
20 O Val O Val 38 31 82 21
TEMPORADA 2014/2015
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Negreira Negreira 38 74 41 82
2 Galicia Mugardos Galicia 38 64 47 72
3 Noia Noia 38 52 37 69
4 Dubra Dubra 38 67 53 66
5 At. Arteixo At. Arteixo 38 83 48 65
6 Sporting Sada Sporting 38 61 56 57
7 Viveiro Viveiro 38 53 60 55
8 CD Castro CD Castro 38 69 53 53
9 Cidade de Ribeira CF Cidade 38 68 69 51
10 CSD Arzua CSD Arzua 38 55 58 50
11 CF Dumbría CF Dumbría 38 43 52 50
12 AD Estudiantil Estudiantil 38 57 43 49
13 SD Chantada SD Chantada 38 53 58 49
14 O Val O Val 38 48 66 47
15 Xallas FC Xallas FC 38 52 58 45
16 SD Sarriana SD Sarriana 38 45 59 44
17 SDC Residencia Residencia 38 45 68 44
18 Atl. Escairón Atl. 38 51 69 39
19 Betanzos CF Betanzos CF 38 46 72 29
20 CD Dorneda CD Dorneda 38 53 72 28
TEMPORADA 2013/2014
PREFERENTE GALICIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ribadeo FC Ribadeo FC 38 76 37 84
2 Bergantiños FC Bergantiños 38 65 26 83
3 Silva SD Silva SD 38 74 41 74
4 Viveiro Viveiro 38 60 34 72
5 CF Dumbría CF Dumbría 38 63 31 67
6 AD Estudiantil Estudiantil 38 50 37 61
7 Sporting Sada Sporting 38 52 41 61
8 Dubra Dubra 38 54 48 55
9 SDC Residencia Residencia 38 51 52 54
10 Galicia Mugardos Galicia 38 61 57 49
11 Cidade de Ribeira CF Cidade 38 54 50 49
12 SD Chantada SD Chantada 38 43 47 47
13 CD Castro CD Castro 38 41 44 45
14 Xallas FC Xallas FC 38 44 65 40
15 O Val O Val 38 41 63 39
16 San Tirso SD Tirso 38 37 58 38
17 Ud Carral Ud Carral 38 42 72 37
18 Club Lemos Club Lemos 38 49 80 35
19 Narón BP Narón BP 38 47 78 33
20 Soneira Sd Soneira Sd 38 41 84 24
TEMPORADA 1983/1984
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 38 86 15 65
2 CD Ourense CD Ourense 38 48 17 53
3 Deportivo Fabril Deportivo 38 60 34 52
4 CD Lugo CD Lugo 38 62 35 48
5 Celta C – Gran Peña Celta Gran. 38 52 38 45
6 Lalín Lalín 38 39 31 42
7 Barco Barco 38 49 39 41
8 Céltiga FC Céltiga FC 38 46 38 39
9 Arenteiro Arenteiro 38 28 32 38
10 Viveiro Viveiro 38 44 49 36
11 Noia Noia 38 32 42 36
12 Celta Fortuna Celta 38 40 38 35
13 Club Lemos Club Lemos 38 46 49 34
14 San Martiño Martiño 38 46 64 33
15 Tyde F.C. Tyde F.C. 38 44 64 32
16 Alondras CF Alondras CF 38 40 60 32
17 Vista Alegre SD Vista Alegre 38 35 45 32
18 Flavia Flavia 38 27 45 30
19 Cidade de Ribeira CF Cidade 38 37 66 24
20 Eume Deportivo Eume 38 22 82 13
TEMPORADA 1982/1983
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 38 64 18 60
2 Arosa Arosa 38 58 20 58
3 CD Ourense CD Ourense 38 63 25 57
4 CD Lugo CD Lugo 38 64 27 51
5 Celta C – Gran Peña Celta Gran. 38 65 42 48
6 Club Lemos Club Lemos 38 30 34 41
7 Deportivo Fabril Deportivo 38 55 53 39
8 Alondras CF Alondras CF 38 52 48 38
9 Lalín Lalín 38 34 30 38
10 Barco Barco 38 38 46 36
11 Vista Alegre SD Vista Alegre 38 46 51 35
12 Celta Fortuna Celta 38 34 45 34
13 Viveiro Viveiro 38 40 46 31
14 Eume Deportivo Eume 38 43 58 31
15 Arenteiro Arenteiro 38 32 53 30
16 San Martiño Martiño 38 34 44 30
17 Flavia Flavia 38 27 47 28
18 Cidade de Ribeira CF Cidade 38 31 53 28
19 Gondomar Cf Gondomar Cf 38 63 77 28
20 Porriño Industrial Porriño 38 31 87 19
TEMPORADA 1981/1982
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 Pontevedra Pontevedra 38 78 24 60
2 CD Ourense CD Ourense 38 70 24 56
3 CD Lugo CD Lugo 38 72 30 55
4 Arosa Arosa 38 46 33 46
5 Celta C – Gran Peña Celta Gran. 38 51 40 45
6 Celta Fortuna Celta 38 42 33 45
7 Viveiro Viveiro 38 57 35 43
8 Vista Alegre SD Vista Alegre 38 40 44 40
9 Flavia Flavia 38 35 39 39
10 Alondras CF Alondras CF 38 48 51 37
11 Deportivo Fabril Deportivo 38 47 50 36
12 Lalín Lalín 38 35 45 33
13 San Martiño Martiño 38 37 54 32
14 Arenteiro Arenteiro 38 41 50 32
15 Club Lemos Club Lemos 38 40 34 32
16 Cidade de Ribeira CF Cidade 38 34 53 32
17 Porriño Industrial Porriño 38 42 48 30
18 Cambados Cambados 38 49 66 29
19 SD Fisterra SD Fisterra 38 29 93 22
20 Verín Verín 38 19 66 16
TEMPORADA 1980/1981
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 CD Lugo CD Lugo 38 73 15 59
2 Arosa Arosa 38 82 28 58
3 Celta C – Gran Peña Celta Gran. 38 55 30 54
4 Alondras CF Alondras CF 38 66 42 47
5 CD Ourense CD Ourense 38 53 29 46
6 Vista Alegre SD Vista Alegre 38 52 35 46
7 Cambados Cambados 38 54 53 39
8 Arenteiro Arenteiro 38 46 49 38
9 Porriño Industrial Porriño 38 51 59 38
10 Deportivo Fabril Deportivo 38 54 46 36
11 San Martiño Martiño 38 39 48 35
12 Cidade de Ribeira CF Cidade 38 34 41 33
13 SD Fisterra SD Fisterra 38 41 61 33
14 Club Lemos Club Lemos 38 34 46 32
15 Celta Fortuna Celta 38 32 41 29
16 Choco Choco 38 38 64 29
17 Flavia Flavia 38 43 60 29
18 Noia Noia 38 30 54 28
19 Céltiga FC Céltiga FC 38 35 66 28
20 Boiro Boiro 38 32 77 23
TEMPORADA 1979/1980
TERCERA DIVISIÓN GRUPO 1
Equipo PJ GF GC Puntos
1 SD Compostela Compostela 38 62 27 56
2 Real Avilés Industrial Real Avilés 38 62 28 53
3 Caudal Deportivo Caudal 38 61 35 48
4 Ponferradina Ponferradina 38 64 34 48
5 Alondras CF Alondras CF 38 56 40 41
6 Cambados Cambados 38 45 36 40
7 CD Lugo CD Lugo 38 51 46 39
8 Arosa Arosa 38 60 53 38
9 Real Oviedo Vetusta Real Oviedo 38 44 45 38
10 CD Turón CD Turón 38 32 42 37
11 Noia Noia 38 36 53 36
12 Celta Fortuna Celta 38 52 58 35
13 Club Siero Club Siero 38 45 50 35
14 Cidade de Ribeira CF Cidade 38 35 45 34
15 Cacabelense Cacabelense 38 54 69 34
16 Deportivo Fabril Deportivo 38 47 56 34
17 UD Gijón Industrial Gijón 38 49 55 32
18 Celta C – Gran Peña Celta Gran. 38 32 49 30
19 L´Entregu CF L´Entregu 38 36 59 29
20 San Martín San Martín 38 33 76 23

  USO DE MEMORIA  
7,065,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.5782
Total Execution Time  0.5802
  CADENA URL  
/historico/Club-Atletico-Rivera
  GET DATOS  
$_GET['/historico/Club-Atletico-Rivera']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0133  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 = 'Club-Atletico-Rivera' 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=11881 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=11881 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 73534
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11881 AND type_rel = 2
0.0128  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 = '11881' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 73534 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=11881 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 (73534,68964) 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.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 73534 AND teamId = 11881
0.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 68964 AND teamId = 11881
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 = 73534 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0128  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 = '11881' 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 = '11881' and rp.type = 4
0.0126  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 = '11881' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 11881 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.0146  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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 11881 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 = 73534 WHERE rp.league_id = 73534 AND rp.teamId = 11881 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 11881 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73534 AND t.round = 31 ORDER BY team.conference ASC,t.position 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 `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 = 68964 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.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 = 65121 AND t.round = 22 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 = 67192 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.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 `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 = 51295 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 = 45178 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 = 39705 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 `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 = 34036 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 = 16696 AND t.round = 38 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 `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 = 4049 AND t.round = 38 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 `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 = 2587 AND t.round = 38 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 `tables1984` 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 = 20980 AND t.round = 38 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 `tables1983` 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 = 21017 AND t.round = 38 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 `tables1982` 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 = 20978 AND t.round = 38 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 `tables1981` 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 = 20977 AND t.round = 38 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 `tables1980` 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 = 21016 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC