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

Resultados de Fútbol

Ben Guerdane

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA TUNECINA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Tataouine	7	7	2	15
2	CA Bizertin	7	7	2	13
3	Olympique	7	7	4	12
4	Etoile	7	8	7	10
5	AS Soliman	7	7	8	9
6	EGS Gafsa	7	2	4	8
7	Marsa	7	5	11	6
8	Guerdane	7	3	8	5

TEMPORADA 2022/2023

LIGA TUNECINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Etoile Sahel	14	19	3	34
2	ES Tunis	14	20	10	28
3	Club	14	17	9	27
4	Monastir	14	23	14	26
5	Guerdane	14	18	16	21
6	CS Sfaxien	14	12	10	18
7	Olympique	14	9	20	16
8	Tataouine	14	6	42	4

TEMPORADA 2021/2022

LIGA TUNECINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	10	16	8	24
2	Monastir	10	16	9	22
3	CS Sfaxien	10	10	7	16
4	Club	10	6	10	15
5	Etoile Sahel	10	13	11	13
6	Guerdane	10	3	19	3

TEMPORADA 2020/2021

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	37	16	60
2	Etoile Sahel	26	46	26	50
3	Guerdane	26	25	16	41
4	AS Soliman	26	35	34	40
5	CS Sfaxien	26	29	16	40
6	Rejiche	26	27	23	36
7	Club	26	26	30	33
8	Tataouine	26	24	30	33
9	Etoile	26	17	21	32
10	Monastir	26	28	29	31
11	CA Bizertin	26	21	27	31
12	Olympique	26	25	26	31
13	Stade	26	22	22	29
14	Kairouanaise	26	14	60	3

TEMPORADA 2019/2020

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	41	12	62
2	CS Sfaxien	26	33	19	51
3	Monastir	26	36	19	45
4	Etoile Sahel	26	37	25	43
5	Club	26	28	14	40
6	Stade	26	26	27	36
7	Guerdane	26	26	31	34
8	Chebba	26	33	33	30
9	AS Soliman	26	29	32	28
10	Tataouine	26	21	28	28
11	Etoile	26	23	34	25
12	CA Bizertin	26	18	35	23
13	Kairouanaise	26	19	41	22
14	Hammam-Lif	26	20	40	22

TEMPORADA 2018/2019

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	37	15	56
2	CS Sfaxien	26	34	15	52
3	Etoile Sahel	25	38	17	51
4	CA Bizertin	26	31	27	38
5	Guerdane	26	22	21	38
6	Club	26	22	24	37
7	Monastir	26	30	30	31
8	Tataouine	26	30	39	31
9	Etoile	26	22	26	30
10	Stade	25	27	34	28
11	Stade	26	22	30	26
12	Kairouanaise	26	20	32	26
13	Hammam-Lif	26	17	23	25
14	Gabès	26	23	42	19

TEMPORADA 2017/2018

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	46	19	58
2	Etoile Sahel	26	38	17	47
3	Club	26	36	21	47
4	CS Sfaxien	26	37	18	46
5	CA Bizertin	26	40	32	37
6	Monastir	26	25	22	36
7	Etoile	26	30	35	34
8	Kairouanaise	26	20	32	32
9	Stade	26	29	36	31
10	Gabès	26	25	32	29
11	Stade	26	15	21	28
12	Guerdane	26	22	34	26
13	Zarzis	26	13	26	26
14	Médenine	26	12	43	17

TEMPORADA 2016/2017

LIGA TUNECINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	10	18	2	26
2	Etoile Sahel	10	16	9	22
3	Club	10	17	11	16
4	CS Sfaxien	10	11	10	12
5	Etoile	10	8	18	9
6	Guerdane	10	0	20	1

TEMPORADA 2015/2016

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	Etoile Sahel	30	57	17	77
2	ES Tunis	30	60	21	72
3	CS Sfaxien	30	57	21	72
4	Etoile	30	36	26	49
5	CA Bizertin	30	21	21	43
6	Club	30	42	38	39
7	Sidi Bouzid	30	25	38	37
8	Hammam-Lif	30	27	32	36
9	Kairouanaise	30	27	37	36
10	Marsa	30	25	35	34
11	Stade	30	28	35	33
12	Guerdane	30	21	30	33
13	Zarzis	30	30	39	33
14	EGS Gafsa	30	31	41	30
15	Kasserine	30	17	49	23
16	Stade	30	17	41	21

TEMPORADA 2014/2015

LIGUE II TÚNEZ GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Kasserine	10	16	11	20
2	Sidi Bouzid	10	15	11	17
3	Guerdane	10	12	10	17
4	Hammam	10	14	13	14
5	Olympique	10	6	13	8
6	Sfax	10	8	13	6

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 2
Equipo		PJ	GF	GC	Puntos
1	Etoile	10	9	4	20
2	Grombalia	10	10	4	19
3	LPTA Tozeur	10	13	11	15
4	Sfax	10	9	9	13
5	Guerdane	10	13	16	7
6	Beni-Khalled	10	8	18	5

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

Competiciones que juega

Grupo 1

Liga Tunecina Grupo 3

Pos	Equipos		Pts
1		US Tataouine	15
2		CA Bizertin	13
3		Olympique Béja	12
4		Etoile Metlaoui	10
5		AS Soliman	9
6		EGS Gafsa	8
7		Marsa	6
8		Ben Guerdane	5

	Descenso : Marsa, Ben Guerdane

RIVALES EN Copa Túnez

RIVALES EN Liga Tunecina

USO DE MEMORIA

6,068,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	4.4676
Total Execution Time	4.4690

CADENA URL

/historico/Ben-Guerdane

GET DATOS

$_GET['/historico/Ben-Guerdane']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.3102	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 = 'Ben-Guerdane' 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=13998 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=13998 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=13998 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=13998 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13998 AND type_rel = 2
0.1056	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13998 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (750513) ORDER BY n.cover_points DESC, update_date DESC
0.4167	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 = '13998' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.3041	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 = '13998' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.2921	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=13998 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0142	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 (75149,75141) 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.1534	SELECT count(id) as num_players from rel_players WHERE league_id = 75149 AND teamId = 13998
0.0941	SELECT count(id) as num_players from rel_players WHERE league_id = 75141 AND teamId = 13998
0.0890	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 = '13998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0293	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13998' 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 = '13998' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.2968	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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 13998 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.0852	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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 13998 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1212	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 = 75149 WHERE rp.league_id = 75149 AND rp.teamId = 13998 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.3081	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 = 13998 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.1681	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 = 73429 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0806	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 = 75149 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0516	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 = 69564 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0239	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 = 71110 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0865	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 = 65402 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0408	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 = 67437 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.1351	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 = 59840 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.0257	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 = 50949 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.1762	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 = 43613 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1337	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 = 38680 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1209	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 = 34772 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0519	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 = 37976 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1439	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 = 15401 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0934	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 = 9213 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.1508	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 = 11803 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0540	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.0585	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.0408	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 = 15385 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0953	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.0598	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


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Ben Guerdane

Ben Guerdane

Selecciona un equipo

Competiciones que juega

Liga Tunecina Grupo 3

RIVALES EN Copa Túnez

RIVALES EN Liga Tunecina