4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Son Sardina
TEMPORADA 2023/2024
1ª REGIONAL BALEARES GRUPO 2
Equipo PJ GF GC Puntos
1 Consell Consell 30 85 22 70
2 Son Sardina Son Sardina 29 79 44 62
3 Juv Can Picafort Picafort 28 66 25 60
4 Port de Soller Port Soller 29 59 38 55
5 Cardassar B Cardassar B 29 63 41 51
6 Unió Esportiva Sta Maria Unió 28 49 33 50
7 Soller B Soller B 28 58 52 45
8 Constancia B Constancia 29 50 53 38
9 Maria de la Salut Maria Salut 29 44 50 37
10 Montaura Montaura 29 65 61 37
11 Atlético Rafal B Atlético 29 56 63 35
12 San Roque San Roque 29 41 61 31
13 Atlético Marratxí Atlético 29 54 74 29
14 Viva Sports Viva Sports 29 53 91 22
15 Alqueria Alqueria 29 34 95 11
16 Margaritense AtlÈtic Margaritense 13 7 60 0
TEMPORADA 2022/2023
PREFERENTE BALEARES GRUPO 6
Equipo PJ GF GC Puntos
1 Calvia Calvia 40 62 61 53
2 Esporles Esporles 40 64 58 53
3 UE Petra UE Petra 40 62 62 52
4 Indep. Camp Redó Indep. Camp 40 77 80 51
5 Murense Murense 40 60 49 50
6 S´Horta S´Horta 40 66 70 50
7 Son Sardina Son Sardina 40 60 88 37
8 CD Génova CD Génova 40 73 128 24
9 Alqueria Alqueria 40 27 104 20
10 Arta Arta 40 44 130 18
TEMPORADA 2021/2022
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Inter Manacor Inter 38 66 36 75
2 CD Sant Jordi Sant Jordi 38 71 39 71
3 Porreres Porreres 38 70 40 70
4 Cardassar Cardassar 38 55 32 69
5 Sineu Sineu 38 66 39 68
6 Recreativo La Victoria Recreativo 38 56 45 63
7 Ferriolense Ferriolense 38 45 42 63
8 UE Alcudia UE Alcudia 38 64 40 62
9 CD Génova CD Génova 38 60 43 61
10 CE Xilvar CE Xilvar 38 51 47 60
11 Santa Catalina Atlético Santa 38 52 41 53
12 UD Alaró UD Alaró 38 64 47 51
13 CD Son Cladera Cladera 38 42 43 48
14 UE Petra UE Petra 38 51 60 45
15 Calvia Calvia 38 49 63 42
16 Arta Arta 37 52 80 38
17 Alqueria Alqueria 37 38 70 35
18 Pla de Na Tesa Tesa 38 52 90 30
19 Son Sardina Son Sardina 38 47 95 26
20 Esporles Esporles 38 37 96 19
TEMPORADA 2020/2021
1ª REGIONAL BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Arta Arta 18 59 24 42
2 Pla de Na Tesa Tesa 18 49 34 38
3 Son Sardina Son Sardina 18 46 32 36
4 CF Pollença Pollença 18 35 23 33
5 S´Horta S´Horta 18 32 29 25
6 Platges de Calvià B Platges 18 31 33 25
7 Constancia B Constancia 18 32 35 21
8 Consell Consell 18 20 33 16
9 Port de Soller Port Soller 18 23 42 13
10 Vilafranca Vilafranca 18 30 72 10
TEMPORADA 2019/2020
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Alqueria Alqueria 26 48 27 54
2 Son Sardina Son Sardina 27 67 45 53
3 Indep. Camp Redó Indep. Camp 27 67 53 45
4 CF Pollença Pollença 27 44 40 44
5 Algaida Algaida 25 48 26 43
6 Calvia Calvia 23 54 31 42
7 Recreativo La Victoria Recreativo 27 45 37 42
8 Santa Mónica Santa 27 58 51 40
9 Serralta Serralta 26 54 40 38
10 Ce Campanet Ce Campanet 26 51 54 38
11 Consell Consell 26 54 72 37
12 Vilafranca Vilafranca 25 48 38 36
13 S´Horta S´Horta 26 35 51 35
14 Pla de Na Tesa Tesa 26 58 48 34
15 Espanya Espanya 27 26 43 30
16 UD Arenal UD Arenal 25 41 36 29
17 Platges de Calvià B Platges 27 35 51 24
18 Port de Soller Port Soller 26 33 56 22
19 Sporting Sant Marçal Sporting 26 30 53 21
20 Montaura Montaura 27 34 78 21
TEMPORADA 2018/2019
PREFERENTE BALEARES GRUPO 1
Equipo PJ GF GC Puntos
1 Andratx Andratx 38 89 30 86
2 UD Collerense Collerense 38 74 34 77
3 Rotlet Molinar Rotlet 38 67 37 74
4 Campos Campos 38 57 41 58
5 Sineu Sineu 38 63 63 58
6 Atletico Rafal Atletico 38 70 61 57
7 Son Veri Son Veri 38 61 57 57
8 UD Alaró UD Alaró 38 57 54 57
9 Cala Millor Cala Millor 38 63 61 55
10 Inter Manacor Inter 38 45 47 50
11 UE Petra UE Petra 38 51 53 49
12 A-Llubi A-Llubi 38 58 67 48
13 CD Génova CD Génova 38 68 83 48
14 CE Xilvar CE Xilvar 38 52 59 45
15 La Unión CF Unión 38 57 71 44
16 Recreativo La Victoria Recreativo 38 59 68 43
17 CD Sant Jordi Sant Jordi 38 52 68 42
18 Serverense Serverense 38 62 71 41
19 Port de Soller Port Soller 38 35 71 32
20 Son Sardina Son Sardina 38 48 92 29
TEMPORADA 2017/2018
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Cala Millor Cala Millor 38 87 42 73
2 Son Sardina Son Sardina 37 69 37 72
3 Espanya Espanya 38 67 49 66
4 UEF Santa María Santa María 38 73 59 65
5 Juventud UDSO Juventud 37 92 54 65
6 Pla de Na Tesa Tesa 37 71 54 64
7 Ce Campanet Ce Campanet 38 64 67 54
8 CF Pollença Pollença 38 63 75 53
9 Platges de Calvià B Platges 38 83 69 53
10 Baleares Sin Fronteras Baleares 37 62 61 53
11 Montaura Montaura 38 72 74 52
12 UD Arenal UD Arenal 38 51 50 51
13 Consell Consell 38 66 73 51
14 Sporting Sant Marçal Sporting 38 55 63 47
15 Olimpic de Felanitx Olimpic 38 57 61 46
16 S´Horta S´Horta 37 64 73 45
17 Santa Ponsa Santa Ponsa 38 66 107 45
18 Establiments Establiments 38 58 60 44
19 CD Binissalem B Binissalem 38 38 60 38
20 Valldemossa Atl Valldemossa 37 23 93 12
TEMPORADA 2016/2017
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Inter Manacor Inter 40 104 38 95
2 CD Sant Jordi Sant Jordi 40 96 43 84
3 Son Veri Son Veri 39 112 63 76
4 Llosetense C Llosetense 40 91 56 75
5 Sporting Sant Marçal Sporting 40 79 66 70
6 Pla de Na Tesa Tesa 40 74 66 70
7 Establiments Establiments 40 75 57 65
8 CF Pollença Pollença 40 78 85 55
9 CD Binissalem B Binissalem 40 65 79 55
10 Cala Millor Cala Millor 40 75 82 53
11 Juventud UDSO Juventud 40 79 71 50
12 S´Horta S´Horta 40 69 73 49
13 UD Arenal UD Arenal 40 58 65 49
14 Espanya Espanya 40 76 85 49
15 Son Sardina Son Sardina 40 73 81 46
16 Bunyola Bunyola 39 57 76 46
17 Santa Ponsa Santa Ponsa 40 78 107 46
18 Consell Consell 40 63 84 43
19 Valldemossa Atl Valldemossa 40 60 86 41
20 CE Escolar CE Escolar 40 70 99 39
21 Pilares La Soledad Pilares 40 61 131 33
TEMPORADA 2015/2016
1ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Indep. Camp Redó Indep. Camp 36 97 46 83
2 CE Xilvar CE Xilvar 38 80 54 76
3 Son Sardina Son Sardina 38 76 52 71
4 CD Sant Jordi Sant Jordi 38 58 35 71
5 Juventud UDSO Juventud 37 82 51 65
6 Sporting Sant Marçal Sporting 38 81 61 65
7 Inter Manacor Inter 38 74 57 64
8 CD Binissalem B Binissalem 38 51 55 58
9 Pla de Na Tesa Tesa 38 80 76 54
10 Pilares La Soledad Pilares 36 81 83 49
11 Santa Ponsa Santa Ponsa 37 63 61 49
12 Valldemossa Atl Valldemossa 38 63 71 46
13 S´Horta S´Horta 38 65 66 45
14 Cala Millor Cala Millor 38 72 93 43
15 CE Escolar CE Escolar 38 46 59 42
16 Consell Consell 38 43 57 41
17 Llosetense C Llosetense 38 53 69 41
18 UE Lloret UE Lloret 38 53 78 38
19 Arta Arta 38 47 97 35
20 Pina Pina 38 56 100 32
TEMPORADA 2014/2015
2ª REGIONAL BALEARES
Equipo PJ GF GC Puntos
1 Valldemossa Atl Valldemossa 37 101 40 80
2 Son Sardina Son Sardina 37 85 38 80
3 Cala Millor Cala Millor 36 78 51 67
4 Llucmajor Llucmajor 37 58 41 64
5 Llosetense C Llosetense 36 76 55 62
6 Baleares Sin Fronteras Baleares 36 71 47 59
7 Maria de la Salut Maria Salut 36 79 66 57
8 Serralta Serralta 36 71 57 56
9 Soller B Soller B 36 63 55 55
10 Montaura Montaura 36 65 61 55
11 Porto Cristo Porto Cristo 36 50 49 54
12 San Cayetano Cayetano 37 72 79 49
13 UEF Santa María Santa María 37 64 78 42
14 Bunyola Bunyola 36 44 62 37
15 Vilafranca Vilafranca 37 68 89 37
16 Alqueria Alqueria 37 75 88 34
17 Sporting Valldemossa Sporting 36 63 98 33
18 Son Ximelis Son Ximelis 37 43 80 29
19 Poblense B Poblense B 37 50 111 28
20 Pollença B Pollença B 9 7 38 4
TEMPORADA 1986/1987
TERCERA DIVISIÓN GRUPO 11
Equipo PJ GF GC Puntos
1 Sp. Mahonès Mahonès 38 87 27 59
2 Atlético Baleares Atlético 38 70 45 50
3 Serverense Serverense 38 55 31 49
4 Constància Constància 38 70 36 48
5 Peña Deportiva Peña 38 64 35 48
6 SD Portmany SD Portmany 38 59 46 43
7 CE Alaior CE Alaior 38 57 47 40
8 Manacor Manacor 38 66 69 39
9 UD Alaró UD Alaró 38 59 68 39
10 CE Ferreries Ferreries 38 44 42 39
11 SD Ibiza SD Ibiza 38 44 45 37
12 Murense Murense 38 50 62 34
13 Hospitalet Isla Blanca Hospitalet 38 38 48 33
14 Santanyi Santanyi 38 34 59 33
15 Platges de Calvià Platges 38 42 51 31
16 CE Escolar CE Escolar 38 47 73 30
17 Son Sardina Son Sardina 38 29 44 29
18 Montuiri Montuiri 38 36 59 29
19 Soller Soller 38 39 74 27
20 CD Isleño CD Isleño 38 32 61 23

  USO DE MEMORIA  
6,424,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6189
Total Execution Time  0.6201
  CADENA URL  
/historico/Son-Sardina
  GET DATOS  
$_GET['/historico/Son-Sardina']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0155  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 = 'Son-Sardina' 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.0128  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=18551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=18551 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0260  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 = 73783
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18551 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=686 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 686 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0132  SELECT /*53 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 (1104898,627067,564570) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '18551' ORDER BY l.year DESC,cat.coefficient DESC
0.0140  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 = '18551' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0144  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 = '18551' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0136  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 = 73783 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143  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=18551 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133  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 (73783,71378) 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 = 71378 AND teamId = 18551
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 73783 AND teamId = 18551
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 = 73783 AND t.round = 30 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 = '18551' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18551' 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 = '18551' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18551 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.0134  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18551 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 73783 WHERE rp.league_id = 73783 AND rp.teamId = 18551 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 18551 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73783 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.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 `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 = 68764 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 = 71378 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.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 = 63634 AND t.round = 38 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 `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 = 58943 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.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 `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 = 51289 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.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 `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 = 44632 AND t.round = 38 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 `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 = 39184 AND t.round = 38 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 `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 = 34179 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 16792 AND t.round = 38 ORDER BY team.conference 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 `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 = 3983 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 `tables1987` 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 = 21767 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 73783 ORDER BY nameShow LIMIT 100