4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Atletico Victoria

Atletico Victoria

Entrenador: Antonio Luis

TEMPORADA 2023/2024
TERCERA FEDERACIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Tenerife B Tenerife B 33 64 22 77
2 Lanzarote Lanzarote 33 64 28 74
3 Union Sur Yaiza Union Yaiza 33 62 19 73
4 Las Palmas At. Palmas 33 72 24 71
5 Panadería Pulido Panadería 33 52 38 55
6 Arucas Arucas 33 49 41 44
7 CD Santa Úrsula Santa 33 34 36 43
8 San Bartolomé CF Bartolomé 33 42 40 42
9 Villa Santa Brígida Villa Santa 33 38 33 40
10 Tamaraceite Tamaraceite 33 39 53 40
11 Marino Marino 33 42 51 39
12 Herbania Herbania 33 30 44 38
13 CD Buzanada CD Buzanada 33 28 42 36
14 Ibarra Ibarra 33 31 45 33
15 Atletico Victoria Atletico 33 31 52 29
16 UD Teror UD Teror 33 29 63 26
17 Gran Tarajal Gran Tarajal 33 21 50 24
18 Unión Puerto Unión 33 24 71 19
TEMPORADA 2022/2023
PREFERENTE CANARIAS GRUPO 1
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 34 78 18 81
2 Vera Vera 34 67 30 73
3 Atlético Tacoronte Atlético 34 58 22 73
4 CD Sauzal CD Sauzal 34 70 27 72
5 Tenisca Tenisca 34 66 30 70
6 Puerto Cruz Puerto Cruz 34 58 39 55
7 UD Fuencaliente Fuencaliente 34 70 44 54
8 Llanos Aridane Llanos 34 63 45 51
9 UD Icodense UD Icodense 34 67 53 51
10 EMF Matanza EMF Matanza 34 62 51 50
11 Juventud Laguna Juventud 34 66 61 48
12 Orotava Orotava 34 50 42 44
13 CD Guancha CD Guancha 34 51 49 41
14 Unión Tejina Unión 34 49 73 40
15 La Florida La Florida 34 41 85 27
16 EF El Cano EF El Cano 34 31 100 19
17 UD Tacoronte Tacoronte 34 31 88 10
18 CD Buenavista Buenavista 34 19 140 4
TEMPORADA 2021/2022
PREFERENTE CANARIAS GRUPO 4
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 22 50 12 52
2 CD Guancha CD Guancha 22 34 12 45
3 Orotava Orotava 22 31 26 41
4 Puerto Cruz Puerto Cruz 22 35 24 40
5 UD Icodense UD Icodense 22 26 39 30
6 EF El Cano EF El Cano 22 21 29 26
7 La Florida La Florida 22 27 33 25
8 CD Buenavista Buenavista 22 22 29 25
9 UD Fuencaliente Fuencaliente 22 22 29 24
10 EMF Matanza EMF Matanza 22 21 35 24
11 UD Cruz Santa Cruz Santa 22 24 32 22
12 Realejos Realejos 22 13 26 20
TEMPORADA 2020/2021
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 UD San Fernando Fernando 18 27 17 33
2 Panadería Pulido Panadería 18 22 14 32
3 UD Las Palmas C Palmas 18 26 22 30
4 Gran Tarajal Gran Tarajal 18 18 12 29
5 Unión Viera Unión Viera 18 26 30 26
6 Lanzarote Lanzarote 18 18 17 24
7 Unión Puerto Unión 18 25 30 24
8 UD Guía UD Guía 18 18 28 19
9 Villa Santa Brígida Villa Santa 18 18 21 18
10 Arucas Arucas 18 20 27 16
11 CD Mensajero Mensajero 20 28 17 40
12 Tenisca Tenisca 20 37 20 35
13 CD Atlético Paso Atlético 20 28 15 33
14 CD Buzanada CD Buzanada 20 29 21 32
15 Tenerife B Tenerife B 20 33 26 31
16 CD Santa Úrsula Santa 20 22 19 29
17 Vera Vera 20 24 24 29
18 Atlético Tacoronte Atlético 20 21 28 25
19 Atletico Victoria Atletico 20 16 30 21
20 AU Güímar AU Güímar 20 19 34 14
21 Ibarra Ibarra 20 10 33 10
TEMPORADA 2019/2020
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 25 55 10 59
2 Tenerife C Tenerife C 23 52 17 54
3 Las Zocas Las Zocas 25 50 23 49
4 UD Icodense UD Icodense 25 49 30 46
5 CD Águilas CD Águilas 24 61 29 45
6 San Lorenzo Constancia Lorenzo 24 43 32 43
7 CD Marino B CD Marino B 25 45 35 41
8 CD San Miguel Miguel 25 39 38 38
9 UD Cruz Santa Cruz Santa 25 26 27 36
10 Orotava Orotava 25 50 37 34
11 At. Granadilla Granadilla 25 30 46 30
12 Unión Tejina Unión 25 26 31 29
13 CD Sauzal CD Sauzal 25 35 53 28
14 Puerto Cruz Puerto Cruz 24 29 40 27
15 Santos Reyes Santos Reyes 24 20 55 20
16 CD Guancha CD Guancha 25 20 46 19
17 AD Añaza AD Añaza 25 16 57 15
18 Atlético San Juan Atlético 25 14 54 11
TEMPORADA 2018/2019
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Vera Vera 34 67 35 75
2 Atletico Victoria Atletico 34 72 24 71
3 UD Cruz Santa Cruz Santa 34 57 29 66
4 San Lorenzo Constancia Lorenzo 34 59 43 58
5 Atlético San Juan Atlético 34 62 60 54
6 UD Icodense UD Icodense 34 57 54 52
7 AD Añaza AD Añaza 34 61 58 51
8 Puerto Cruz Puerto Cruz 34 63 43 50
9 Orotava Orotava 34 66 47 49
10 Unión Tejina Unión 34 69 55 49
11 At. Granadilla Granadilla 34 52 49 47
12 CD Águilas CD Águilas 34 55 54 47
13 CD Guancha CD Guancha 34 46 50 44
14 CD Marino B CD Marino B 34 52 58 42
15 La Florida La Florida 34 39 46 31
16 I'Gara I'Gara 34 52 92 28
17 Cd Arguijón Arguijón 34 30 89 21
18 Ud Valle Frontera Valle 34 25 98 17
TEMPORADA 2017/2018
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Atlético Tacoronte Atlético 34 67 22 75
2 UD Icodense UD Icodense 34 77 46 66
3 Atletico Victoria Atletico 34 54 32 61
4 San Lorenzo Constancia Lorenzo 34 64 47 61
5 UD Cruz Santa Cruz Santa 34 55 39 59
6 Puerto Cruz Puerto Cruz 34 55 35 57
7 Orotava Orotava 34 45 37 49
8 La Florida La Florida 34 43 47 49
9 CD Marino B CD Marino B 34 55 52 47
10 CD Águilas CD Águilas 34 44 50 46
11 Ud Valle Frontera Valle 34 51 58 45
12 CD Guancha CD Guancha 34 50 48 42
13 At. Granadilla Granadilla 34 42 44 42
14 Unión Tejina Unión 34 54 68 42
15 CD Portezuelo Portezuelo 34 42 55 38
16 Juventud Laguna Juventud 34 36 70 25
17 Charco del Pino Charco Pino 34 40 73 24
18 Santiago del Teide Santiago 34 35 86 16
TEMPORADA 2015/2016
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 CD Buzanada CD Buzanada 36 75 33 78
2 Atlético Tacoronte Atlético 36 87 46 72
3 San Lorenzo Constancia Lorenzo 36 69 42 72
4 Charco del Pino Charco Pino 36 76 39 70
5 CD Laguna CD Laguna 36 69 31 67
6 CD Los Ángeles Ángeles 36 91 52 62
7 UD Gomera UD Gomera 36 68 50 55
8 CD Águilas CD Águilas 36 55 47 54
9 UD Icodense UD Icodense 36 63 55 53
10 Orotava Orotava 36 60 52 53
11 Raqui San Isidro Raqui Isidro 36 60 60 47
12 CD San Andrés Andrés 36 50 45 47
13 Juventud Laguna Juventud 36 53 61 46
14 Zamorano Esperanza Zamorano 36 50 52 45
15 CD Valeriana Valeriana 36 43 60 43
16 Atletico Victoria Atletico 36 47 61 42
17 Atlético San Juan Atlético 36 38 108 20
18 I'Gara I'Gara 36 32 126 17
19 Guargacho Guargacho 36 41 107 15
TEMPORADA 2014/2015
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 CD Mensajero Mensajero 38 61 35 71
2 Lanzarote Lanzarote 38 60 44 68
3 Marino Marino 38 58 42 65
4 Real Sporting San José Real 38 57 38 60
5 Union Sur Yaiza Union Yaiza 38 40 35 56
6 Villa Santa Brígida Villa Santa 38 55 50 53
7 Tenerife B Tenerife B 38 53 42 52
8 Unión Viera Unión Viera 38 61 54 51
9 Arucas Arucas 38 46 52 50
10 Ibarra Ibarra 38 51 58 49
11 Tenisca Tenisca 38 54 48 47
12 At. Granadilla Granadilla 38 45 53 47
13 CD Santa Úrsula Santa 38 41 49 47
14 El Cotillo El Cotillo 38 40 62 47
15 Telde Telde 38 44 51 46
16 Las Zocas Las Zocas 38 53 67 46
17 Vera Vera 38 56 69 45
18 Estrella Estrella 38 49 45 44
19 CD Laguna CD Laguna 38 45 58 44
20 Atletico Victoria Atletico 38 42 59 41
TEMPORADA 2013/2014
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 At. Granadilla Granadilla 38 68 34 82
2 Marino Marino 38 59 29 81
3 CD Mensajero Mensajero 38 57 18 77
4 Tenerife B Tenerife B 38 76 44 74
5 Estrella Estrella 38 59 39 66
6 Villa Santa Brígida Villa Santa 38 69 49 65
7 Atletico Victoria Atletico 38 49 55 54
8 Tenisca Tenisca 38 66 57 53
9 Union Sur Yaiza Union Yaiza 38 51 47 52
10 Vecindario Vecindario 38 60 45 50
11 El Cotillo El Cotillo 38 48 52 50
12 Lanzarote Lanzarote 38 33 44 48
13 Las Zocas Las Zocas 38 38 47 46
14 CD Laguna CD Laguna 38 38 48 45
15 Unión Viera Unión Viera 38 50 53 45
16 Ibarra Ibarra 38 47 67 41
17 Telde Telde 38 50 62 39
18 Vera Vera 38 48 93 33
19 Raqui San Isidro Raqui Isidro 38 34 73 31
20 Realejos Realejos 38 41 85 27
TEMPORADA 2012/2013
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Las Palmas At. Palmas 38 90 27 85
2 At. Granadilla Granadilla 38 63 31 81
3 Estrella Estrella 38 65 30 77
4 Unión Viera Unión Viera 38 82 49 75
5 CD Mensajero Mensajero 38 80 37 74
6 Tenerife B Tenerife B 38 63 40 63
7 Vecindario Vecindario 37 49 35 60
8 Corralejo Corralejo 38 43 41 56
9 Las Zocas Las Zocas 38 42 55 56
10 Villa Santa Brígida Villa Santa 38 55 59 54
11 San Andrés y Sauces Andrés 38 50 45 52
12 Telde Telde 38 44 55 52
13 Tenisca Tenisca 38 46 65 51
14 Lanzarote Lanzarote 38 59 58 49
15 Atletico Victoria Atletico 38 41 48 45
16 Vera Vera 38 43 75 42
17 Raqui San Isidro Raqui Isidro 38 41 57 33
18 San Pedro Mártir Pedro 38 21 41 24
19 Tijarafe Tijarafe 37 28 92 15
20 UD Gomera UD Gomera 38 30 95 14
TEMPORADA 2011/2012
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Marino Marino 38 74 35 76
2 Tenisca Tenisca 38 59 40 72
3 Las Palmas At. Palmas 38 68 29 71
4 Vera Vera 38 67 40 70
5 Lanzarote Lanzarote 38 47 34 66
6 At. Granadilla Granadilla 38 52 35 65
7 Estrella Estrella 38 47 34 63
8 Tenerife B Tenerife B 38 70 53 59
9 Corralejo Corralejo 38 48 45 58
10 Telde Telde 38 55 49 54
11 San Pedro Mártir Pedro 38 50 59 47
12 San Andrés y Sauces Andrés 38 46 64 46
13 CD Mensajero Mensajero 38 54 63 45
14 Villa Santa Brígida Villa Santa 38 56 66 45
15 Atletico Victoria Atletico 38 45 61 45
16 Las Zocas Las Zocas 38 46 60 41
17 Tijarafe Tijarafe 38 39 67 38
18 CD Laguna CD Laguna 38 35 55 37
19 Real Sporting San José Real 38 35 64 35
20 Charco del Pino Charco Pino 38 35 75 22
TEMPORADA 2010/2011
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Atletico Victoria Atletico 34 68 28 72
2 San Andrés y Sauces Andrés 34 55 33 66
3 Charco del Pino Charco Pino 34 70 38 61
4 Orotava Orotava 34 51 32 60
5 Ud Médano Ud Médano 34 60 55 55
6 CD San Andrés Andrés 34 54 36 52
7 CD Valle Guerra Valle Guerra 34 46 40 50
8 Tenerife C Tenerife C 34 54 43 48
9 Ibarra Ibarra 34 41 47 48
10 UD Icodense UD Icodense 34 49 45 45
11 Tegueste Tegueste 34 43 46 43
12 At. Paso At. Paso 34 45 53 43
13 UD Fuencaliente Fuencaliente 34 43 56 40
14 Norte Norte 34 41 54 37
15 Llanos Aridane Llanos 34 33 66 36
16 Puerto Cruz Puerto Cruz 34 34 59 29
17 Unión Breñas Unión 34 26 54 25
18 San Miguel CD Miguel 34 32 60 24
TEMPORADA 2008/2009
PREFERENTE CANARIAS GRUPO 2
Equipo PJ GF GC Puntos
1 Charco del Pino Charco Pino 30 56 23 66
2 CD San Andrés Andrés 31 64 29 60
3 Vera Vera 31 55 33 59
4 Tenerife C Tenerife C 31 39 18 56
5 San Andrés y Sauces Andrés 31 53 35 56
6 Raqui San Isidro Raqui Isidro 30 64 35 55
7 Atletico Victoria Atletico 32 53 38 55
8 Ibarra Ibarra 31 40 35 45
9 Norte Norte 30 40 37 45
10 I'Gara I'Gara 30 38 44 37
11 Breña Alta Breña Alta 30 30 35 35
12 UD Icodense UD Icodense 31 34 47 35
13 Real Unión de Irún Real Unión 31 37 56 34
14 Atlético Barranco Hondo Atlético 30 42 63 27
15 Águilas Atlético Águilas 32 30 61 27
16 Orotava Orotava 30 30 55 26
17 Unión Tejina Unión 31 30 60 26
18 La Palma La Palma 30 24 53 20
19 Puerto Cruz Puerto Cruz 5 9 11 9
20 Atlético Arona Atlético 1 1 1 1
TEMPORADA 1997/1998
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Atlético Baleares Atlético 38 94 21 88
2 Constància Constància 38 87 22 83
3 Sp. Mahonès Mahonès 38 53 35 73
4 Vilafranca Vilafranca 38 67 38 70
5 Binissalem Binissalem 38 69 38 64
6 Campos Campos 38 48 35 63
7 Poblense Poblense 38 65 48 58
8 Santa Eulàlia Santa 38 49 40 58
9 Manacor Manacor 38 42 38 56
10 CE Alaior CE Alaior 38 62 52 55
11 Pollensa Pollensa 38 49 46 53
12 Ferriolense Ferriolense 38 48 57 49
13 Platges de Calvià Platges 38 50 47 48
14 Atlètic De Ciutadella Atlètic 38 50 72 41
15 Andratx Andratx 38 38 67 41
16 UD Arenal UD Arenal 38 40 57 38
17 CE Ferreries Ferreries 38 35 62 37
18 CD Cardessar Cardessar 38 24 58 36
19 Atletico Victoria Atletico 38 36 96 21
20 SD Portmany SD Portmany 38 18 95 19
TEMPORADA 1960/1961
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Recreativo Recreativo 30 97 13 50
2 Xerez CD Xerez CD 30 62 26 45
3 Ayamonte Ayamonte 30 56 41 39
4 La Palma La Palma 30 66 44 37
5 Jerez Industrial CF Jerez 30 60 44 34
6 Balón de Cádiz CF Balón 30 57 33 34
7 RC Portuense Portuense 30 55 50 31
8 Utrera Utrera 30 62 55 30
9 Bollullos CF Bollullos 30 30 43 27
10 Barbate Barbate 30 55 67 26
11 Coria CF Coria CF 30 54 70 24
12 Imperio Ceuta Imperio 30 35 53 23
13 Atletico Victoria Atletico 30 40 71 22
14 Puerto Real CF Puerto Real 30 38 81 21
15 Ol. Valverdeña Valverdeña 30 39 70 19
16 At. Sanluqueño Sanluqueño 30 40 85 18
TEMPORADA 1959/1960
TERCERA DIVISIÓN GRUPO 12
Equipo PJ GF GC Puntos
1 Xerez CD Xerez CD 30 73 25 46
2 Sevilla At. Sevilla At. 30 54 27 41
3 RC Portuense Portuense 30 76 36 37
4 Ayamonte Ayamonte 30 50 39 36
5 La Palma La Palma 30 60 43 35
6 At. Sanluqueño Sanluqueño 30 45 41 33
7 Puerto Real CF Puerto Real 30 53 44 33
8 Jerez Industrial CF Jerez 30 63 41 32
9 Bollullos CF Bollullos 30 43 43 31
10 Ol. Valverdeña Valverdeña 30 61 69 28
11 Lebrijana Lebrijana 30 42 60 26
12 Imperio Riffien Imperio 30 54 71 24
13 Utrera Utrera 30 46 63 23
14 Barbate Barbate 30 52 81 20
15 Atletico Victoria Atletico 30 36 80 19
16 Moron Moron 30 31 76 16

  USO DE MEMORIA  
7,453,808 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1106
Total Execution Time  0.1119
  CADENA URL  
/historico/Atletico-Victoria
  GET DATOS  
$_GET['/historico/Atletico-Victoria']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=386 AND type_rel = 2
0.0019  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 386 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (226244,644264,886617,961464) 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 = '386' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 386 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038  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 = 72271 AND t.round = 33 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 = 68789 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.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 `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 = 64497 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.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 `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 = 58591 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.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 = 51278 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.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 `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 = 44766 AND t.round = 34 ORDER BY team.conference 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 `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 = 39650 AND t.round = 34 ORDER BY team.conference 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 `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 = 16711 AND t.round = 38 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 `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 = 3921 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 2561 AND t.round = 38 ORDER BY team.conference 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 `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 = 1954 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0044  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 = 1408 AND t.round = 42 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 `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 = 1137 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 `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 = 313 AND t.round = 34 ORDER BY team.conference 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 `tables1998` 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 = 21992 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0043  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 `tables1961` 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 = 21530 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 `tables1960` 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 = 21517 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC