4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Collerense Fem
TEMPORADA 2023/2024
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 UE Cornellà Fem Cornellà 27 60 22 60
2 Vic Riuprimer Refo Fem Riuprimer 27 54 32 54
3 CF Igualada Fem Igualada 27 44 21 49
4 Villarreal B Fem Villarreal 27 61 38 49
5 Zaragoza B Fem Zaragoza 28 50 30 46
6 Collerense Fem Collerense 27 47 37 42
7 Seagull Fem Seagull Fem 27 40 29 41
8 Atlético Baleares Fem C Atlético 28 54 46 41
9 Fontsanta-Fatjo Fem Fontsanta-Fa 27 46 47 40
10 Son Sardina Fem Sardina 27 42 43 40
11 Aem SE B Fem 28 37 28 39
12 Valdefierro Fem Valdefierro 28 27 43 33
13 Riudoms Fem Riudoms Fem 27 27 45 24
14 Sant Gabriel Fem Sant Gabriel 27 31 53 23
15 Stadium Casablanca Fem Stadium 27 17 51 16
16 Rayo Vallecano B Fem Rayo 27 16 88 5
TEMPORADA 2022/2023
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Huesca Fem Huesca Fem 30 101 14 79
2 Seagull Fem Seagull Fem 30 82 22 75
3 Sant Gabriel Fem Sant Gabriel 30 75 46 60
4 Villarreal B Fem Villarreal 30 67 37 57
5 Vic Riuprimer Refo Fem Riuprimer 30 69 30 56
6 Collerense Fem Collerense 30 74 49 55
7 Son Sardina Fem Sardina 30 60 54 50
8 UE Cornellà Fem Cornellà 30 53 40 49
9 Riudoms Fem Riudoms Fem 30 48 36 43
10 Fontsanta-Fatjo Fem Fontsanta-Fa 30 46 50 31
11 Stadium Casablanca Fem Stadium 30 46 75 30
12 Zaragoza B Fem Zaragoza 30 34 61 27
13 CD Castellón Fem Castellón 30 28 64 27
14 Ejea SD Fem Ejea SD Fem 30 45 98 21
15 Algaida Fem Algaida Fem 30 22 98 14
16 Sta. Ponsa Talarrubias Fem Sta. Ponsa. 30 29 105 11
TEMPORADA 2021/2022
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 CE Europa Fem Europa 26 83 13 69
2 Atlético Baleares Fem Atlético 26 48 12 58
3 Espanyol B Fem Espanyol 26 82 30 57
4 Son Sardina Fem Sardina 26 73 33 56
5 Huesca Fem Huesca Fem 26 59 29 45
6 Sant Gabriel Fem Sant Gabriel 26 54 34 44
7 Riudoms Fem Riudoms Fem 26 45 42 43
8 Collerense Fem Collerense 26 61 53 35
9 Vic Riuprimer Refo Fem Riuprimer 26 49 46 35
10 Stadium Casablanca Fem Stadium 26 29 87 22
11 Zaragoza B Fem Zaragoza 26 24 43 22
12 Fontsanta-Fatjo Fem Fontsanta-Fa 26 21 75 14
13 Sant Lluis Sant Lluis 26 29 63 12
14 Pardinyes Fem Pardinyes 26 16 113 3
TEMPORADA 2020/2021
PRIMERA DIVISIÓN B FEMENINA GRUPO 4
Equipo PJ GF GC Puntos
1 Seagull Fem Seagull Fem 24 43 34 43
2 Zaragoza CFF Fem Zaragoza 24 34 23 41
3 Athletic Club B Fem Athletic 24 41 29 37
4 CD Parquesol Fem Parquesol 24 31 41 26
5 Real Sporting Fem Real 24 43 48 25
6 Espanyol B Fem Espanyol 24 27 60 24
7 CF Pozuelo Fem Pozuelo 24 22 42 21
8 Collerense Fem Collerense 24 35 60 18
9 PM Friol Fem Friol 24 25 52 15
TEMPORADA 2019/2020
PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo PJ GF GC Puntos
1 Santa Teresa Fem Santa Teresa 22 43 15 51
2 Granada CF Fem Granada 22 43 15 50
3 Albacete Fem Albacete 22 48 16 47
4 Villarreal Fem Villarreal 22 37 24 42
5 Málaga CF Fem Málaga 22 28 21 36
6 Alhama ElPozo Fem Alhama 22 40 31 35
7 Pozoalbense Fem Pozoalbense 22 36 39 32
8 Córdoba CF Fem Córdoba 22 21 21 31
9 CP Cacereño Fem Cacereño 22 36 36 30
10 UDG Tenerife B Fem Tenerife 22 27 36 28
11 Spar Gran Canaria Fem Spar Gran C. 22 34 36 27
12 Levante B Fem Levante 22 31 33 24
13 Valencia B Fem Valencia 22 24 34 21
14 CD Juan Grande Fem Juan Grande 22 28 39 16
15 Real Union Tacuense Fem Real Union. 22 18 57 12
16 Collerense Fem Collerense 22 31 72 9
TEMPORADA 2018/2019
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Zaragoza CFF Fem Zaragoza 26 54 13 66
2 Seagull Fem Seagull Fem 26 55 15 63
3 Barcelona B Fem Barcelona 26 72 26 53
4 AEM Fem AEM Fem 26 55 33 48
5 Collerense Fem Collerense 26 56 32 48
6 Espanyol B Fem Espanyol 26 61 37 44
7 Sant Gabriel Fem Sant Gabriel 26 50 32 40
8 Pardinyes Fem Pardinyes 26 36 40 34
9 CE Europa Fem Europa 26 39 50 31
10 CF Igualada Fem Igualada 26 29 39 30
11 Son Sardina Fem Sardina 26 21 53 27
12 Sant Pere Pescador Fem Sant Pere P. 26 38 69 22
13 Pallejà Fem Pallejà 26 21 57 13
14 Mallorca Toppfotball Fem Mallorca 26 12 103 6
TEMPORADA 2017/2018
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona B Fem Barcelona 26 81 17 63
2 Seagull Fem Seagull Fem 26 70 15 61
3 Collerense Fem Collerense 26 68 29 59
4 Espanyol B Fem Espanyol 26 51 23 54
5 AEM Fem AEM Fem 26 59 31 49
6 CE Europa Fem Europa 26 52 45 43
7 CF Igualada Fem Igualada 26 41 48 42
8 Son Sardina Fem Sardina 26 39 55 35
9 Sant Gabriel Fem Sant Gabriel 26 40 44 28
10 Pallejà Fem Pallejà 26 46 66 23
11 Pardinyes Fem Pardinyes 26 32 51 23
12 Levante Las Planas Fem Levante 26 23 67 17
13 Sporting Mahón Sporting 26 19 68 14
14 Peña Ferranca Peña 26 25 87 7
TEMPORADA 2016/2017
TERCERA FEDERACIÓN FEMENINA GRUPO 3
Equipo PJ GF GC Puntos
1 Barcelona B Fem Barcelona 26 79 23 60
2 Seagull Fem Seagull Fem 26 60 14 58
3 Espanyol B Fem Espanyol 26 41 33 51
4 CE Europa Fem Europa 26 48 35 48
5 Son Sardina Fem Sardina 26 52 48 42
6 Collerense Fem Collerense 26 49 46 38
7 Sant Gabriel Fem Sant Gabriel 26 44 37 37
8 AEM Fem AEM Fem 26 37 37 37
9 CF Igualada Fem Igualada 26 37 39 36
10 Pallejà Fem Pallejà 26 31 46 27
11 UE L´Estartit Femenino L´Estartit 26 46 49 26
12 Sabadell A Sabadell A 26 38 57 26
13 Levante Las Planas Fem Levante 26 34 59 26
14 Porto Cristo Porto Cristo 26 22 95 5
TEMPORADA 2015/2016
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Athletic Fem Athletic 30 75 15 78
2 Barcelona Fem Barcelona 30 98 12 77
3 Atlético Fem Atlético 30 83 24 69
4 Levante Fem Levante Fem 30 56 38 54
5 Real Sociedad Fem Real 30 50 33 53
6 Valencia Fem Valencia 30 65 30 49
7 Costa Adeje Tenerife Fem Costa Adeje 30 49 44 47
8 Sporting Huelva Fem Sporting 30 44 39 46
9 Espanyol Fem Espanyol 30 28 48 36
10 Rayo Vallecano Fem Rayo 30 35 48 36
11 Santa Teresa Fem Santa Teresa 30 43 62 32
12 Zaragoza CFF Fem Zaragoza 30 38 68 32
13 Albacete Fem Albacete 30 47 93 25
14 Oiartzun KE Fem Oiartzun 30 24 67 24
15 Real Oviedo Fem Real Oviedo 30 21 78 11
16 Collerense Fem Collerense 30 28 85 10
TEMPORADA 2014/2015
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 95 9 77
2 Atlético Fem Atlético 30 54 21 69
3 Athletic Fem Athletic 30 73 25 65
4 Valencia Fem Valencia 30 59 25 59
5 Levante Fem Levante Fem 30 60 25 55
6 Rayo Vallecano Fem Rayo 30 45 35 47
7 Espanyol Fem Espanyol 30 50 54 43
8 Sporting Huelva Fem Sporting 30 51 55 41
9 Santa Teresa Fem Santa Teresa 30 33 53 34
10 Real Oviedo Fem Real Oviedo 30 35 61 32
11 Real Sociedad Fem Real 30 39 47 30
12 Collerense Fem Collerense 30 32 65 25
13 Zaragoza CFF Fem Zaragoza 30 27 53 25
14 Albacete Fem Albacete 30 38 64 25
15 Sant Gabriel Fem Sant Gabriel 30 28 63 23
16 Sevilla FC Fem Sevilla 30 27 91 15
TEMPORADA 2013/2014
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 82 12 79
2 Athletic Fem Athletic 30 80 22 69
3 Rayo Vallecano Fem Rayo 30 44 28 51
4 Levante Fem Levante Fem 30 38 29 51
5 Valencia Fem Valencia 30 45 27 51
6 Atlético Fem Atlético 30 66 37 50
7 Sporting Huelva Fem Sporting 30 43 37 43
8 Real Sociedad Fem Real 30 35 34 38
9 Collerense Fem Collerense 30 44 61 35
10 Sant Gabriel Fem Sant Gabriel 30 38 55 34
11 Real Oviedo Fem Real Oviedo 30 30 40 32
12 Espanyol Fem Espanyol 30 37 51 32
13 Zaragoza CFF Fem Zaragoza 30 29 55 31
14 Sevilla FC Fem Sevilla 30 23 60 26
15 Granada CF Fem Granada 30 41 82 22
16 Levante Las Planas Fem Levante 30 28 73 22
TEMPORADA 2012/2013
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 30 91 13 76
2 Athletic Fem Athletic 30 84 24 74
3 Atlético Fem Atlético 30 70 21 68
4 Levante Fem Levante Fem 30 52 21 65
5 Espanyol Fem Espanyol 30 47 25 54
6 Rayo Vallecano Fem Rayo 30 81 48 49
7 Zaragoza CFF Fem Zaragoza 30 65 77 45
8 Sant Gabriel Fem Sant Gabriel 30 40 44 40
9 Sporting Huelva Fem Sporting 30 41 52 38
10 Real Sociedad Fem Real 30 41 44 33
11 Levante Las Planas Fem Levante 30 34 47 32
12 Sevilla FC Fem Sevilla 30 37 52 30
13 Valencia Fem Valencia 30 29 51 30
14 Collerense Fem Collerense 30 47 77 29
15 C. Llanos Olivenza Fem Llanos 30 30 74 16
16 SD Lagunak SD Lagunak 30 13 132 1
TEMPORADA 2011/2012
PRIMERA DIVISIÓN FEMENINA
Equipo PJ GF GC Puntos
1 Barcelona Fem Barcelona 34 119 19 94
2 Athletic Fem Athletic 34 118 25 91
3 Espanyol Fem Espanyol 34 117 38 76
4 Rayo Vallecano Fem Rayo 34 90 44 70
5 Levante Fem Levante Fem 34 63 27 68
6 Atlético Fem Atlético 34 83 41 65
7 Real Sociedad Fem Real 34 58 35 62
8 Sporting Huelva Fem Sporting 34 51 48 56
9 Zaragoza CFF Fem Zaragoza 34 72 75 47
10 Sant Gabriel Fem Sant Gabriel 34 55 67 37
11 C. Llanos Olivenza Fem Llanos 34 39 65 35
12 Collerense Fem Collerense 34 54 91 33
13 Valencia Fem Valencia 34 37 83 31
14 SD Lagunak SD Lagunak 34 32 70 31
15 Ue L´estartit L´estartit 34 35 74 29
16 Málaga CF Fem Málaga 34 35 91 23
17 El Olivo Fem Olivo 34 43 112 19
18 Sd Reocín Sd Reocín 34 30 126 9
TEMPORADA 2010/2011
PRIMERA DIVISIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 Levante Fem Levante Fem 10 25 6 23
2 SD Lagunak SD Lagunak 11 12 11 20
3 Ue L´estartit L´estartit 10 27 16 19
4 Collerense Fem Collerense 10 18 12 19
5 Sevilla FC Fem Sevilla 10 11 17 11
6 Las Palmas Femenino Palmas 10 12 21 7
7 Real Valladolid Fem Real 11 2 24 4
TEMPORADA 2009/2010
PRIMERA DIVISIÓN FEMENINA GRUPO 6
Equipo PJ GF GC Puntos
1 AD Torrejón Femenino Torrejón 12 42 13 28
2 Collerense Fem Collerense 12 33 21 21
3 Las Palmas Femenino Palmas 12 31 25 21
4 SD Lagunak SD Lagunak 12 24 16 19
5 Valencia Fem Valencia 12 36 23 17
6 Real Valladolid Fem Real 12 18 38 11
7 Gimnastic de Tarragona Fem Gimnastic 12 6 54 0

  USO DE MEMORIA  
6,392,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1215
Total Execution Time  0.1229
  CADENA URL  
/historico/Ud-Collerense-Femenino
  GET DATOS  
$_GET['/historico/Ud-Collerense-Femenino']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0032  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 = 'Ud-Collerense-Femenino' 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.0018  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=8853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=8853 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8853 AND type_rel = 2
0.0028  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8853 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 (56627,61247,669363,738418,742691) ORDER BY n.cover_points DESC, update_date DESC
0.0023  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '8853' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '8853' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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=8853 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (74015) 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.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 74015 AND teamId = 8853
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 = '8853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8853' 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 = '8853' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 74015 WHERE rp.league_id = 74015 AND rp.teamId = 8853 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.0019  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 = 74015 WHERE rp.league_id = 74015 AND rp.teamId = 8853 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 74015 WHERE rp.league_id = 74015 AND rp.teamId = 8853 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 8853 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 74015 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `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 = 68597 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.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 `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 = 63472 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 58765 AND t.round = 18 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 = 61715 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 = 49901 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 `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 = 44731 AND t.round = 26 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 `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 = 39304 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 `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 = 35130 AND t.round = 26 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 = 16581 AND t.round = 30 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 = 4011 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 `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 = 2747 AND t.round = 30 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 = 2114 AND t.round = 30 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 `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 = 1847 AND t.round = 34 ORDER BY team.conference 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 `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 = 23924 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 `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 = 23928 AND t.round = 12 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 = 23930 AND t.round = 12 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 `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 = 23937 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC