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

Jendouba Sports

Temporada 2023/2024

TEMPORADA 2023/2024

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Jeunesse	19	36	9	42
2	Jendouba	18	24	9	38
3	Hammam-Lif	19	24	13	32
4	Sportif	18	19	13	29
5	Hammam	18	21	18	28
6	AS Ariana	18	17	20	26
7	Kairouanaise	18	15	12	23
8	ES Rades	20	19	28	23
9	M'Saken	19	10	16	20
10	Oued Ellil	18	7	17	19
11	CS Tabarka	19	18	29	19
12	Kalaâ Sport	19	11	24	14
13	Sporting	19	9	22	13

TEMPORADA 2022/2023

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Marsa	23	42	13	50
2	Kairouanaise	23	28	17	42
3	Jerba	23	20	21	33
4	Oued Ellil	23	21	17	31
5	Gabès	23	22	22	31
6	Jendouba	23	24	25	29
7	ES Rades	23	18	21	27
8	Rogba	23	21	25	27
9	Médenine	23	19	23	27
10	Sportif	23	18	22	27
11	Mohammedia	23	22	29	26
12	CS Bembla	23	22	42	21

TEMPORADA 2021/2022

LIGUE II TÚNEZ GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kairouanaise	10	14	8	19
2	Sportive	10	10	7	17
3	Jerba	10	11	10	16
4	Jendouba	10	7	7	13
5	Menzel Nour	10	8	12	9
6	Club	10	4	10	8

TEMPORADA 2020/2021

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Médenine	10	15	5	23
2	Hammam-Lif	10	16	14	18
3	Sportif	10	16	14	12
4	Jendouba	10	7	9	11
5	Sportive	10	7	13	10
6	Sbikha	10	12	18	8

TEMPORADA 2019/2020

LIGUE II TÚNEZ
Equipo		PJ	GF	GC	Puntos
1	Olympique	15	18	7	32
2	Sidi Bouzid	15	16	9	28
3	Sfax	15	18	15	26
4	Sbikha	15	15	15	22
5	Médenine	15	12	12	22
6	Sporting	15	14	10	21
7	Zarzis	15	9	6	21
8	Gabès	15	13	12	19
9	ES Rades	15	12	11	19
10	M'Saken	15	19	17	18
11	Menzel	15	5	15	14
12	AS Ariana	15	5	27	4
13	Rejiche	15	27	10	32
14	EGS Gafsa	15	18	11	31
15	Stade	15	9	7	22
16	Jendouba	15	17	15	21
17	Oued Ellil	15	15	13	21
18	Jerba	15	11	11	21
19	Sportive	15	13	14	19
20	Menzel	15	9	11	18
21	Hammam	15	12	20	15
22	Kasserine	15	15	21	14
23	Marsa	15	10	16	14
24	Stade	15	16	23	13

TEMPORADA 2018/2019

LIGUE II TÚNEZ
Equipo		PJ	GF	GC	Puntos
1	AS Soliman	22	40	23	46
2	Marsa	22	27	17	43
3	Olympique	22	30	18	42
4	Zarzis	22	26	20	38
5	Médenine	22	22	30	28
6	Jerba	22	23	28	27
7	Sfax	22	27	30	25
8	Sportive	22	24	24	23
9	Oued Ellil	22	34	43	23
10	AS Ariana	22	19	30	23
11	US Seliana	22	29	31	21
12	Sportif	22	21	28	20
13	Chebba	22	40	8	58
14	Menzel	22	25	17	39
15	EGS Gafsa	22	39	25	37
16	Stade	22	27	22	32
17	Kasserine	22	24	22	32
18	Jendouba	22	24	23	27
19	Hammam	22	19	24	27
20	ES Rades	21	29	31	26
21	Sporting	22	16	22	26
22	Jebeniana	21	20	34	21
23	Sidi Bouzid	21	18	37	21
24	Kerkennah	21	12	28	16

TEMPORADA 2017/2018

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tataouine	18	29	16	38
2	EGS Gafsa	18	27	15	34
3	Sfax	18	17	12	30
4	Marsa	18	22	18	29
5	Kasserine	18	26	26	24
6	Sportif	18	21	20	23
7	Hammam	18	18	18	21
8	Kerkennah	18	14	18	20
9	AS Ariana	18	16	26	19
10	STIR	18	10	31	9
11	Chebba	18	23	15	28
12	Sidi Bouzid	18	22	16	27
13	Olympique	18	17	19	26
14	Hammam-Lif	18	15	11	25
15	Menzel	18	18	19	25
16	AS Soliman	18	19	15	24
17	Jendouba	18	14	16	23
18	Stade	18	16	24	23
19	Sporting	18	16	21	21
20	Sportive	18	19	23	20

TEMPORADA 2016/2017

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Monastir	18	27	11	36
2	Menzel	18	21	11	30
3	Sporting	18	18	20	28
4	EGS Gafsa	18	22	11	24
5	Kasserine	18	15	19	24
6	Sportif	18	19	20	23
7	Hammam	18	16	17	23
8	FC Hammamet	18	16	18	22
9	Olympique	17	11	21	17
10	US Seliana	17	8	25	13
11	Sportive	18	18	10	32
12	Stade	18	18	10	31
13	Stade	18	21	21	28
14	Médenine	18	17	12	26
15	Jendouba	18	22	22	23
16	Sfax	18	18	21	23
17	M'Saken	18	21	24	22
18	AS Ariana	18	27	29	21
19	Grombalia	18	13	19	20
20	Stade	18	16	23	19

TEMPORADA 2015/2016

LIGUE II TÚNEZ GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gabès	10	13	7	18
2	Olympique	10	15	11	16
3	FC Hammamet	10	12	10	16
4	Tataouine	10	10	12	16
5	Monastir	10	9	12	11
6	Jendouba	10	8	15	6

TEMPORADA 2014/2015

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sfax	18	23	14	32
2	Olympique	18	20	14	29
3	Sidi Bouzid	18	22	19	29
4	Sportif	18	21	23	25
5	Olympique	18	18	17	24
6	Sbeitla	18	18	16	23
7	FC Hammamet	18	18	18	21
8	Jendouba	18	20	25	21
9	Stade	18	16	22	19
10	LPTA Tozeur	18	12	20	17

TEMPORADA 2013/2014

LIGUE II TÚNEZ GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Guerdane	18	28	20	32
2	Stade	18	15	16	28
3	Jendouba	18	14	13	27
4	Hamam Sousse	18	19	16	26
5	Sportif	18	25	19	25
6	Sfax	18	15	13	22
7	Enfidha	18	12	15	22
8	FC Hammamet	18	16	22	22
9	Olympique	18	14	16	20
10	Club	18	11	19	16

TEMPORADA 2012/2013

LIGUE II TÚNEZ GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Etoile	18	26	10	35
2	Grombalia	18	27	16	35
3	Beni-Khalled	18	20	16	24
4	M'Saken	18	22	18	23
5	Sportif	18	22	25	23
6	Jendouba	18	18	20	22
7	Kasserine	18	15	20	21
8	Enfida	18	15	20	21
9	Menzel	18	16	23	20
10	EA Mateur	18	12	25	18
11	LPTA Tozeur	18	21	13	30
12	Sfax	18	20	16	29
13	Guerdane	18	19	14	27
14	Sporting	18	20	20	27
15	Gabès	18	20	21	24
16	Sportif	18	12	12	22
17	Club	18	13	14	22
18	Sidi Bouzid	18	19	25	22
19	Sportive	18	25	23	21
20	SC Moknine	18	15	26	18

TEMPORADA 2011/2012

LIGUE II TÚNEZ
Equipo		PJ	GF	GC	Puntos
1	Olympique	30	37	29	53
2	Stade	30	38	24	50
3	Guerdane	30	34	25	49
4	Sportif	30	37	24	48
5	M'Saken	30	31	24	46
6	SC Moknine	30	44	47	42
7	Grombalia	30	34	33	41
8	Kasserine	30	28	32	39
9	Sportif	30	28	32	38
10	Jendouba	30	29	28	37
11	Sportive	30	30	33	37
12	LPTA Tozeur	30	26	26	36
13	EA Mateur	30	26	30	35
14	Club	30	26	42	35
15	Stade	30	30	39	33
16	Kalaâ Sport	30	27	37	28

TEMPORADA 2010/2011

LIGUE II TÚNEZ
Equipo		PJ	GF	GC	Puntos
1	Monastir	26	36	20	51
2	Beni-Khalled	26	37	29	46
3	Stade	26	35	26	40
4	LPTA Tozeur	26	31	26	39
5	Sportive	26	30	29	36
6	EA Mateur	26	20	25	35
7	Club	26	26	27	34
8	Sportif	26	30	32	34
9	SC Moknine	26	33	35	31
10	Jendouba	26	26	29	31
11	Kasserine	26	24	28	31
12	Olympique	26	23	26	30
13	M'Saken	26	27	31	30
14	Guerdane	26	20	35	21

TEMPORADA 2009/2010

LIGUE II TÚNEZ
Equipo		PJ	GF	GC	Puntos
1	Marsa	26	44	17	59
2	Gabès	26	42	23	52
3	Stade	26	29	19	45
4	Beni-Khalled	26	30	23	43
5	M'Saken	26	32	32	39
6	LPTA Tozeur	26	29	30	37
7	Jendouba	26	27	30	37
8	Sportive	26	34	30	35
9	Guerdane	26	25	27	34
10	Olympique	26	29	34	30
11	Sportif	26	19	26	29
12	EA Mateur	26	19	31	29
13	EM Mahdia	26	21	29	28
14	Menzel	26	20	49	11

TEMPORADA 2008/2009

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	50	21	60
2	Club	26	39	14	57
3	Etoile Sahel	26	48	17	53
4	CS Sfaxien	26	33	24	43
5	Monastir	26	23	24	35
6	Stade	26	30	31	34
7	Hammam-Lif	26	28	43	30
8	Hammam	26	20	26	26
9	CA Bizertin	26	15	25	26
10	Olympique	26	13	24	25
11	EGS Gafsa	26	18	33	25
12	Kasserine	26	16	26	24
13	Marsa	26	14	24	22
14	Jendouba	26	11	26	21

TEMPORADA 2007/2008

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	Club	26	37	12	63
2	Etoile Sahel	26	40	9	61
3	ES Tunis	26	36	18	46
4	Monastir	26	27	32	36
5	Stade	26	24	34	36
6	EGS Gafsa	26	35	31	35
7	Marsa	26	26	30	33
8	CA Bizertin	26	25	30	33
9	Hammam-Lif	26	24	28	32
10	CS Sfaxien	26	28	29	29
11	Olympique	26	21	26	28
12	Jendouba	26	18	30	27
13	Stade	26	21	34	23
14	Zarzis	26	12	31	16

TEMPORADA 2005/2006

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	43	20	56
2	Etoile Sahel	26	30	10	55
3	Club	26	37	19	47
4	CS Sfaxien	26	35	16	45
5	Monastir	26	21	20	41
6	Zarzis	26	20	23	31
7	Marsa	26	19	29	29
8	Hammam-Lif	26	27	42	28
9	Stade	26	21	25	27
10	CA Bizertin	26	15	22	27
11	EOG Kram	26	16	29	27
12	EGS Gafsa	26	26	36	26
13	Jendouba	26	15	22	23
14	Kairouanaise	26	23	35	23

Competiciones que juega

Grupo 1

Ligue II Túnez Grupo 1

Pos	Equipos		Pts
1		Jeunesse Sportive Omrane	42
2		Jendouba Sports	38
3		Hammam-Lif	32
4		Sportif de Korba	29
5		ES Hammam Sousse	28
6		AS Ariana	26
7		JS Kairouanaise	23
8		ES Rades	23
9		M'Saken	20
10		Oued Ellil	19
11		CS Tabarka	19
12		Kalaâ Sport	14
13		Sporting Ben Arous	13

	Ascenso : Jeunesse Sportive Omrane
	Descenso : Kalaâ Sport, Sporting Ben Arous

RIVALES EN Ligue II Túnez

RIVALES EN Copa Túnez

USO DE MEMORIA

6,930,560 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1440
Total Execution Time	0.1452

CADENA URL

/historico/Jendouba-Sports

GET DATOS

$_GET['/historico/Jendouba-Sports']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

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 = 'Jendouba-Sports' 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=4485 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=4485 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=4485 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 75141
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4485 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=414 AND type_rel = 3
0.0025	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 = '4485' ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '4485' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '4485' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 74234 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 75141 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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=4485 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (75141,74234) 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.0020	SELECT count(id) as num_players from rel_players WHERE league_id = 74234 AND teamId = 4485
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 75141 AND teamId = 4485
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 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 = 74234 AND t.round = 21 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '4485' 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 = '4485' and rp.type = 4
0.0021	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 = '4485' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0028	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 = 74234 WHERE rp.league_id = 74234 AND rp.teamId = 4485 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.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 = 74234 WHERE rp.league_id = 74234 AND rp.teamId = 4485 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 = 74234 WHERE rp.league_id = 74234 AND rp.teamId = 4485 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 4485 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74234 AND t.round = 21 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* `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 = 69695 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.0020	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 = 65687 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.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 = 61665 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.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* `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 = 51178 AND t.round = 15 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* `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 = 45065 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* `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 = 39712 AND t.round = 18 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* `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 = 36063 AND t.round = 18 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 = 15821 AND t.round = 18 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* `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 = 24240 AND t.round = 10 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* `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 = 9212 AND t.round = 18 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* `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 = 2981 AND t.round = 18 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* `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 = 15384 AND t.round = 18 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 = 15387 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* `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 = 15388 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* `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 = 15389 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* `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 = 274 AND t.round = 26 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* `tables2008` 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 = 9951 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* `tables2006` 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 = 15371 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	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 = 74234 ORDER BY nameShow LIMIT 100

Jendouba Sports

Jendouba Sports

Selecciona un equipo

Competiciones que juega

Ligue II Túnez Grupo 1

RIVALES EN Ligue II Túnez

RIVALES EN Copa Túnez