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

Etoile Sahel

Entrenador: Imed Younes

Temporada 2019/2020

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

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	Club	30	50	18	65
2	Etoile Sahel	30	47	17	64
3	ES Tunis	30	52	21	60
4	CS Sfaxien	30	35	21	47
5	Zarzis	30	35	25	45
6	Stade	30	29	32	43
7	Marsa	30	33	37	43
8	CA Bizertin	30	21	21	41
9	Kairouanaise	30	32	33	38
10	Stade	30	20	28	37
11	Hammam-Lif	30	30	35	36
12	Etoile	30	24	40	32
13	EGS Gafsa	30	26	39	30
14	Monastir	30	20	30	25
15	Gabès	30	21	44	19
16	Sportive	30	22	56	17

TEMPORADA 2013/2014

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	30	48	15	66
2	Etoile Sahel	30	36	15	56
3	CS Sfaxien	30	34	20	55
4	Club	30	29	20	54
5	Marsa	30	28	25	43
6	CA Bizertin	30	29	20	41
7	Stade	30	27	23	40
8	Kairouanaise	30	26	25	35
9	Etoile	30	21	26	35
10	Monastir	30	28	32	34
11	Hammam-Lif	30	20	32	34
12	EGS Gafsa	30	25	39	34
13	Stade	30	19	33	32
14	Olympique	30	22	32	29
15	LPTA Tozeur	30	23	35	29
16	Grombalia	30	23	46	26

TEMPORADA 2012/2013

LIGA TUNECINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CS Sfaxien	6	11	7	13
2	ES Tunis	6	8	6	12
3	Etoile Sahel	6	6	6	9
4	Club	6	2	8	1

TEMPORADA 2011/2012

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	30	61	22	69
2	CA Bizertin	30	54	25	65
3	CS Sfaxien	30	47	26	56
4	Etoile Sahel	30	33	22	49
5	Marsa	30	39	28	47
6	Club	30	36	26	44
7	Monastir	30	31	34	36
8	Olympique	30	31	35	36
9	EGS Gafsa	30	27	38	36
10	Hammam	30	29	37	35
11	Stade	30	28	37	34
12	Kairouanaise	30	29	38	33
13	Zarzis	30	36	52	31
14	Hammam-Lif	30	29	47	31
15	Beni-Khalled	30	24	44	21
16	Gabès	30	22	45	20

TEMPORADA 2010/2011

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	50	18	64
2	Etoile Sahel	26	49	24	59
3	CS Sfaxien	26	32	23	44
4	Club	26	32	27	35
5	CA Bizertin	26	23	29	35
6	Hammam-Lif	26	23	31	34
7	EGS Gafsa	26	28	34	32
8	Kairouanaise	26	28	29	31
9	Stade	26	25	31	31
10	Marsa	26	27	33	30
11	Olympique	26	25	29	29
12	Zarzis	26	22	24	27
13	Gabès	26	19	32	24
14	Hammam	26	19	38	20

TEMPORADA 2009/2010

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	26	56	24	54
2	Club	26	28	15	50
3	Etoile Sahel	26	41	27	46
4	CA Bizertin	26	36	33	40
5	Stade	26	22	16	39
6	CS Sfaxien	26	32	26	37
7	Olympique	26	28	32	32
8	Kairouanaise	26	22	34	31
9	Hammam-Lif	26	30	32	30
10	Zarzis	26	17	26	29
11	EGS Gafsa	26	29	39	28
12	Hammam	26	28	36	27
13	Kasserine	26	22	46	27
14	Monastir	26	25	30	26

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 2006/2007

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	Etoile Sahel	26	43	18	53
2	Club	26	38	22	49
3	ES Tunis	26	40	26	49
4	Monastir	26	34	24	47
5	CS Sfaxien	26	37	28	38
6	Stade	26	25	26	32
7	EGS Gafsa	26	25	32	30
8	Olympique	26	24	35	30
9	Hammam-Lif	26	22	26	29
10	Marsa	26	22	34	27
11	Zarzis	26	20	25	26
12	CA Bizertin	26	28	38	25
13	EOG Kram	26	15	27	24
14	Hammam	26	14	26	23

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

TEMPORADA 2004/2005

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	CS Sfaxien	26	44	12	58
2	Etoile Sahel	26	38	11	58
3	Club	26	46	16	56
4	ES Tunis	26	43	15	55
5	Marsa	26	21	22	33
6	EOG Kram	26	22	28	30
7	CA Bizertin	26	26	34	30
8	Monastir	26	27	30	29
9	EGS Gafsa	26	22	33	27
10	Stade	26	28	40	26
11	Hammam-Lif	26	19	31	25
12	Zarzis	26	17	26	24
13	Beni-Khalled	26	14	45	20
14	Olympique	26	15	39	18

TEMPORADA 2003/2004

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	22	38	13	53
2	Etoile Sahel	22	30	9	44
3	Club	22	32	15	42
4	CS Sfaxien	22	35	22	37
5	Marsa	22	27	25	36
6	Stade	22	23	24	30
7	Hammam-Lif	22	21	25	30
8	CA Bizertin	22	23	25	28
9	Monastir	22	22	29	23
10	Olympique	22	13	27	16
11	Beni-Khalled	22	10	32	14
12	Club	22	11	39	9

TEMPORADA 2002/2003

LIGA TUNECINA
Equipo		PJ	GF	GC	Puntos
1	ES Tunis	22	47	17	57
2	Etoile Sahel	22	32	18	38
3	Club	22	23	20	35
4	CS Sfaxien	22	28	23	31
5	Stade	22	28	27	30
6	Monastir	22	23	21	29
7	Hammam-Lif	22	24	28	29
8	CA Bizertin	22	21	22	28
9	Marsa	22	18	28	25
10	Olympique	22	18	23	24
11	Zarzis	22	15	30	18
12	Sportive	22	21	41	18

Competiciones que juega

Liga Tunecina

Pos	Equipos		Pts
1		ES Tunis	62
2		CS Sfaxien	51
3		Monastir	45
4		Etoile Sahel	43
5		Club Africain	40
6		Stade Tunisien	36
7		Ben Guerdane	34
8		Chebba	30
9		AS Soliman	28
10		US Tataouine	28
11		Etoile Metlaoui	25
12		CA Bizertin	23
13		JS Kairouanaise	22
14		Hammam-Lif	22

	CAF Champions League : ES Tunis, CS Sfaxien
	Copa Confederaciones : Monastir
	Descenso : JS Kairouanaise, Hammam-Lif

RIVALES EN CAF Champions Le.

RIVALES EN Clasificación CA.

RIVALES EN Campeonato de Cl.

RIVALES EN Copa Túnez

RIVALES EN Liga Tunecina

USO DE MEMORIA

7,677,064 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2160
Total Execution Time	0.2172

CADENA URL

/historico/Etoile-Sahel/2020

GET DATOS

$_GET['/historico/Etoile-Sahel/2020']

POST DATOS

No hay datos POST existentes

CONSULTAS (66)

0.0043	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 = 'Etoile-Sahel' AND l.year = 2020 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.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=4484 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=4484 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=4484 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=4484 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=4484 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=4484 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=4484 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=4484 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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 = 50949
0.0025	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 = 51595
0.0026	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 = 55377
0.0024	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 = 50821
0.0027	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 = 51123
0.0031	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 = 50875
0.0026	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 = 51677
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4484 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4484 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (3235,14226,15515,16143,43891) ORDER BY n.cover_points DESC, update_date DESC
0.0037	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 = '4484' ORDER BY l.year DESC,cat.coefficient DESC
0.0029	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 = '4484' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '4484' 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 = 51595 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 50821 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 50875 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 = 51677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 50949 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=4484 AND l.year in (2019,2020,2021) 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 (62709,61487,60916,59840,55377,51123,50875) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 59840 AND teamId = 4484
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 55377 AND teamId = 4484
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 61487 AND teamId = 4484
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 51123 AND teamId = 4484
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 60916 AND teamId = 4484
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 50875 AND teamId = 4484
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 62709 AND teamId = 4484
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023	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 = '4484' 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 = '4484' and rp.type = 4
0.0023	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 = '4484' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0055	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 events2020 e ON e.player_id = p.id AND e.league_id = 50949 WHERE rp.league_id = 50949 AND rp.teamId = 4484 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.0044	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 events2020 e ON e.player_id = p.id AND e.league_id = 50949 WHERE rp.league_id = 50949 AND rp.teamId = 4484 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0037	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 events2020 e ON e.player_id = p.id AND e.league_id = 50949 WHERE rp.league_id = 50949 AND rp.teamId = 4484 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0043	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 = 4484 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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 = 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.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* `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.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* `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.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* `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.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* `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.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* `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 = 4161 AND t.round = 30 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* `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 = 2955 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* `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 = 2241 AND t.round = 14 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* `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 = 10898 AND t.round = 6 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* `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 = 1599 AND t.round = 30 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* `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 = 1598 AND t.round = 26 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* `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 = 1057 AND t.round = 26 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* `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.0028	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.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* `tables2007` 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 = 9952 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* `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.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* `tables2005` 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 = 15372 AND t.round = 26 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* `tables2004` 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 = 23798 AND t.round = 22 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* `tables2003` 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 = 23799 AND t.round = 22 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 = 50949 ORDER BY nameShow LIMIT 100
0.0020	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 66 AND l.year = 2020 ORDER BY l.group_code ASC

Etoile Sahel

Etoile Sahel

Selecciona un equipo

Competiciones que juega

Liga Tunecina

RIVALES EN CAF Champions Le.

RIVALES EN Clasificación CA.

RIVALES EN Campeonato de Cl.

RIVALES EN Copa Túnez

RIVALES EN Liga Tunecina