Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Cavaly

Temporada 2023/2024

TEMPORADA 2023/2024

APERTURA HAITÍ GRUPO 1
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2020/2021

CLAUSURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	Don Bosco	8	14	5	16
2	Mirebalais	9	8	5	15
3	Rivartibonit	9	8	5	15
4	Ouanaminthe	9	7	7	13
5	Arcahaie	6	7	1	12
6	Cavaly	6	9	4	12
7	FICA	9	5	4	12
8	Tempête	8	7	8	12
9	Capoise	9	6	5	11
10	Triomphe	8	8	6	10
11	Real Du Cap	9	10	11	10
12	Violette	9	7	8	10
13	Racing	9	4	7	10
14	America	7	7	7	8
15	Juventus FC	8	5	8	8
16	Baltimore	8	6	9	6
17	Racing Club	8	8	16	6
18	Cosmopolites	7	3	13	4

TEMPORADA 2019/2020

APERTURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	Baltimore	4	5	0	10
2	Cavaly	4	7	3	10
3	Don Bosco	4	6	2	7
4	Capoise	4	4	2	6
5	Real Du Cap	4	4	3	6
6	Triomphe	4	4	3	6
7	Rivartibonit	4	2	2	6
8	FICA	4	2	3	6
9	Juventus FC	4	3	3	5
10	Violette	4	3	3	5
11	Arcahaie	4	2	3	5
12	Cosmopolites	4	2	3	5
13	Mirebalais	4	1	2	5
14	America	4	3	4	4
15	Ouanaminthe	4	1	4	4
16	Racing	4	1	5	4
17	Racing Club	4	1	3	3
18	Tempête	4	2	5	3

TEMPORADA 2018/2019

APERTURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	Real Du Cap	15	14	7	31
2	Capoise	15	19	6	28
3	Arcahaie	15	15	8	24
4	Tempête	15	14	9	24
5	Don Bosco	15	22	14	23
6	Racing	15	13	13	23
7	America	15	11	11	21
8	Baltimore	15	11	10	20
9	Violette	15	13	8	19
10	Triomphe	15	10	14	17
11	Mirebalais	15	13	18	17
12	Ouanaminthe	15	14	16	15
13	Racing Club	15	13	18	14
14	FICA	15	11	17	14
15	Cavaly	15	12	23	13
16	Cosmopolites	15	6	19	10

TEMPORADA 2017/2018

CLAUSURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	Arcahaie	15	16	6	35
2	Tempête	15	12	7	24
3	Don Bosco	15	20	18	24
4	FICA	15	20	13	23
5	Real Du Cap	15	17	11	23
6	Baltimore	15	11	11	22
7	Cosmopolites	15	11	19	22
8	Ouanaminthe	15	10	8	21
9	Mirebalais	15	11	12	21
10	Racing Club	15	16	12	20
11	Cavaly	15	16	14	20
12	Racing	15	13	11	19
13	Capoise	15	12	16	18
14	AS Sud-Est	15	16	22	18
15	Valencia	15	7	17	13
16	Petit Goave	15	6	17	9

TEMPORADA 2016/2017

CLAUSURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	Mirebalais	15	28	10	31
2	Don Bosco	15	18	7	29
3	Real Du Cap	15	15	8	27
4	Racing	14	15	7	24
5	FICA	15	10	6	24
6	Capoise	15	16	17	22
7	Baltimore	15	10	9	20
8	Eclair	15	15	13	20
9	Cavaly	15	13	14	18
10	Racing Club	15	7	12	17
11	Ouanaminthe	15	12	18	16
12	Petit Goave	15	12	13	16
13	Tempête	15	10	13	16
14	America	15	14	22	16
15	AS Sud-Est	15	7	21	12
16	Juventus FC	14	5	17	10

TEMPORADA 2015/2016

CLAUSURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	FICA	17	20	8	29
2	Ouanaminthe	16	19	9	29
3	Capoise	17	10	10	27
4	Real Du Cap	16	20	14	24
5	America	15	12	6	22
6	Violette	17	14	12	21
7	Petit Goave	16	10	14	21
8	Aigle Noir	16	11	9	20
9	Mirebalais	16	11	10	20
10	Racing	16	9	11	20
11	Cavaly	16	14	16	19
12	Don Bosco	15	9	11	19
13	Baltimore	16	9	10	18
14	Inter	13	9	13	18
15	Racing Club	16	15	17	17
16	Juventus FC	15	23	26	16
17	Tempête	16	8	17	16
18	Roulado	15	7	17	14

TEMPORADA 2014/2015

CLAUSURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	FICA	16	27	13	34
2	Cavaly	16	17	8	29
3	Baltimore	16	16	8	29
4	Racing Club	16	21	15	28
5	Don Bosco	16	21	12	26
6	Violette	15	18	13	26
7	Capoise	16	18	14	26
8	Valencia	16	19	14	24
9	Mirebalais	16	13	13	20
10	Aigle Noir	16	14	13	19
11	Roulado	16	12	19	19
12	America	16	19	19	18
13	PNH FC	16	12	16	18
14	Petit Goave	15	9	14	18
15	Racing	16	15	23	18
16	Inter	15	11	11	17
17	Ouanaminthe	16	14	22	16
18	Tempête	15	12	20	16
19	Racine	16	10	22	16
20	US LaJeune	16	10	19	13

TEMPORADA 2013/2014

APERTURA HAITÍ
Equipo		PJ	GF	GC	Puntos
1	America	10	18	7	21
2	Baltimore	10	12	8	16
3	Tempête	10	12	8	16
4	Petit Goave	10	7	5	15
5	Aigle Noir	10	14	11	14
6	Cavaly	10	11	9	14
7	Don Bosco	10	8	7	13
8	Racine	10	9	18	13
9	Mirebalais	10	10	8	11
10	Racing	10	4	15	7
11	Violette	10	3	12	3

TEMPORADA 2012/2013

LIGA HAITÍ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Valencia	22	26	12	38
2	Baltimore	22	19	16	33
3	Racing Club	22	18	17	33
4	Petit Goave	22	16	15	31
5	Aigle Noir	22	23	20	30
6	Mirebalais	22	20	18	30
7	Tempête	22	15	18	28
8	Cavaly	22	11	9	27
9	FICA	22	15	19	27
10	Victory	22	17	25	24
11	America	22	12	17	23
12	Don Bosco	22	19	25	22

TEMPORADA 2011/2012

LIGA HAITÍ GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Don Bosco	10	11	4	18
2	Cavaly	10	8	5	18
3	Victory	10	13	8	15
4	Mirebalais	10	9	9	11
5	Capoise	10	6	14	11
6	Violette	10	7	14	9

Competiciones que juega

Grupo 1

RIVALES EN Apertura Haití

USO DE MEMORIA

5,686,416 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.2033
Total Execution Time	0.2052

CADENA URL

/historico/Cavaly

GET DATOS

$_GET['/historico/Cavaly']

POST DATOS

No hay datos POST existentes

CONSULTAS (42)

0.0030	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 = 'Cavaly' 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=15410 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=15410 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 75610
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15410 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1716 AND type_rel = 3
0.0026	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 = '15410' ORDER BY l.year DESC,cat.coefficient 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 = '15410' 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 = '15410' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 75610 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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=15410 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (75610) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 75610 AND teamId = 15410
0.0019	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 = 75610 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '15410' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15410' 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 = '15410' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 15410 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.0021	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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 15410 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 = 75610 WHERE rp.league_id = 75610 AND rp.teamId = 15410 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 15410 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0019	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 = 75610 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.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* `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 = 58381 AND t.round = 17 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 = 61996 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.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* `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 = 55535 AND t.round = 4 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* `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 = 50627 AND t.round = 15 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* `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 = 49082 AND t.round = 15 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* `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 = 42857 AND t.round = 15 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 = 45288 AND t.round = 15 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 = 37975 AND t.round = 15 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 = 40535 AND t.round = 15 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 = 22213 AND t.round = 17 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* `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 = 36098 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 10892 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0517	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 = 15713 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 10891 AND t.round = 11 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 = 10889 AND t.round = 11 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* `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 = 49084 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 3309 AND t.round = 22 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* `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 = 49085 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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 = 49087 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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 = 75610 ORDER BY nameShow LIMIT 100

Cavaly

Cavaly

Selecciona un equipo

Competiciones que juega

RIVALES EN Apertura Haití