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

Nîmes II

Temporada 2021/2022

TEMPORADA 2021/2022

NATIONAL 3 GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Olympique	26	52	22	60
2	Agde	26	36	23	46
3	Aigues	26	40	27	43
4	Toulouse II	26	45	30	41
5	Stade	26	43	40	37
6	Balma	26	31	37	36
7	Alberes	26	35	36	34
8	Castanet	26	38	40	34
9	Rodez II	26	49	49	33
10	Narbonne	26	33	44	33
11	Blagnac	26	35	31	32
12	Nîmes II	26	29	39	25
13	Muretaine	26	23	45	22
14	Fabrègues	26	17	43	21

TEMPORADA 2020/2021

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Nîmes II	0	0	0	0
2	Toulouse II	0	0	0	0
3	Stade	0	0	0	0
4	Castanet	0	0	0	0
5	Fabrègues	0	0	0	0
6	Blagnac	0	0	0	0
7	Agde	0	0	0	0
8	Narbonne	0	0	0	0
9	Montpellier	0	0	0	0
10	Rodez II	0	0	0	0
11	Alberes	0	0	0	0
12	Muretaine	0	0	0	0
13	Balma	0	0	0	0
14	Olympique	0	0	0	0

TEMPORADA 2019/2020

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Annecy	21	30	16	42
2	Grasse	21	28	17	40
3	GOAL FC	21	32	19	39
4	Yzeure	21	30	21	39
5	Martigues	21	27	20	37
6	Louhans	21	40	26	33
7	Fréjus	21	21	22	27
8	Olympique	21	28	31	25
9	Hyères	21	13	21	25
10	Olympique	21	27	38	24
11	Jura Sud	21	24	37	23
12	Marignane	21	19	23	22
13	Monaco II	21	26	34	22
14	Saint-Priest	21	24	27	21
15	Marseille	21	23	33	19
16	Nîmes II	21	21	28	17

TEMPORADA 2018/2019

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Le Puy	30	34	19	52
2	Herbiers	30	41	27	50
3	Andrézieux	30	39	33	48
4	Yzeure	30	32	29	47
5	Sète	30	37	28	46
6	Blois	30	43	39	45
7	Saint-Pryve	30	33	27	44
8	Bergerac	30	37	33	42
9	Saint-Étien	30	41	36	41
10	Colomiers	30	31	32	40
11	Stade	30	27	34	38
12	Romorantin	30	28	25	37
13	Trelissac	30	28	31	37
14	Nîmes II	30	26	41	33
15	Girondins	30	21	38	26
16	Stade	30	26	52	25

TEMPORADA 2017/2018

NATIONAL 3 GRUPO 9
Equipo		PJ	GF	GC	Puntos
1	Nîmes II	26	48	25	50
2	Toulouse II	26	37	21	47
3	Montpellier	26	48	31	43
4	Canet	26	37	29	43
5	Fabrègues	26	43	28	42
6	Blagnac	26	29	25	37
7	Balma	26	36	33	36
8	Rodéo	26	30	30	34
9	Avenir Foot	26	31	38	31
10	Agde	26	31	40	28
11	Olympique	26	22	33	27
12	Narbonne	26	24	42	24
13	Castanet	26	21	45	24
14	Luzenac	26	24	41	21

TEMPORADA 2016/2017

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Grasse	26	40	28	50
2	Furiani	26	35	29	48
3	Aubagne	26	36	19	45
4	Balma	26	44	35	44
5	Rodéo	26	51	35	42
6	Cannet	26	47	29	41
7	Nîmes II	26	34	40	35
8	Ajaccio II	26	43	44	34
9	Fabrègues	26	36	35	33
10	Olympique	26	28	39	31
11	Toulouse II	26	30	34	29
12	Castanet	26	38	45	28
13	Agde	26	30	50	22
14	Sporting	26	25	55	15

TEMPORADA 2015/2016

NATIONAL 3 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sporting	24	48	23	51
2	Annecy	24	31	22	41
3	Nîmes II	24	42	29	40
4	FC Borgo	24	40	32	37
5	Cannet	24	44	38	35
6	Bastia II	24	36	36	32
7	Olympique	24	41	46	31
8	Evian Thonon	24	35	36	30
9	Agde	24	33	42	27
10	Île-Rousse	24	24	37	27
11	Fabrègues	24	28	39	26
12	Bains	24	27	36	25
13	Aubagne	24	38	51	25
14	Arles II	0	0	0	0

TEMPORADA 2014/2015

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Olympique	26	51	18	56
2	LAS Toulon	26	47	28	46
3	Sporting	26	42	25	43
4	Aubagne	26	43	33	41
5	Nîmes II	26	47	39	39
6	Olympique	26	36	25	38
7	Chambéry	26	36	32	38
8	ES Pennoise	26	32	35	38
9	Île-Rousse	26	34	45	37
10	Arles II	26	37	28	36
11	Bains	26	34	31	36
12	Ajaccio II	26	33	31	36
13	Échirolles	26	32	58	17
14	Uzès Pont G.	26	15	91	5

TEMPORADA 2013/2014

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sète	26	49	30	53
2	Île-Rousse	26	47	34	44
3	Vaulx	26	26	20	42
4	Olympique	26	33	32	38
5	Agde	26	30	30	38
6	Nîmes II	26	34	31	37
7	Olympique	26	37	34	36
8	Sporting	26	40	29	35
9	Arles II	26	41	34	35
10	Échirolles	26	24	33	34
11	Ajaccio II	26	35	41	33
12	Aubagne	26	42	48	32
13	ES Pennoise	26	26	36	32
14	Vénissieux	26	22	54	18

TEMPORADA 2012/2013

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Villenave	26	40	32	47
2	Balma	26	32	20	44
3	Victoria	26	36	26	44
4	Aurillac	26	34	19	43
5	Genêts	26	36	22	43
6	Bergerac	26	25	23	36
7	Toulouse II	26	35	29	34
8	Saint-Alban	26	32	34	34
9	Montpellier	26	24	22	32
10	Narbonne	26	39	37	31
11	Muretaine	26	31	42	30
12	Nîmes II	26	25	34	29
13	Auch	26	34	50	24
14	Lormont	26	25	58	19

TEMPORADA 2011/2012

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Genêts	9	14	6	18
2	Nîmes II	9	12	4	17
3	Muretaine	9	9	4	17
4	Balma	9	9	5	17
5	Montpellier	9	17	11	15
6	Stade	9	13	8	14
7	Narbonne	9	8	8	14
8	Toulouse II	9	12	13	14
9	Mérignac	9	6	9	13
10	F.C.	9	12	10	11
11	Bergerac	9	12	13	10
12	Saint-Alban	9	7	13	8
13	Blagnac	9	11	18	8
14	SU Agen	9	9	14	7
15	Lormont	9	11	18	7
16	Aurillac	9	9	17	7

TEMPORADA 2010/2011

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	FC Calvi	30	58	33	58
2	Athlético	30	62	40	55
3	Nîmes II	30	57	45	45
4	Montpellier	30	53	41	43
5	LAS Toulon	30	42	38	43
6	Nice II	30	34	38	41
7	Gardanne	30	45	56	40
8	Sportive	30	30	43	40
9	Grasse	30	32	36	39
10	Cortenais	30	35	45	39
11	EF Bastia	30	38	51	39
12	Trinité	30	53	50	38
13	Furiani	30	43	41	37
14	Bagnols-Pont	30	37	38	37
15	Valettoise	30	34	38	33
16	FC Borgo	30	47	67	30

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Monaco II	30	56	26	60
2	Uzès Pont G.	30	57	24	58
3	Grasse	30	38	34	50
4	FC Calvi	30	44	34	48
5	Athlético	29	39	43	44
6	Valettoise	30	32	36	42
7	Sportive	30	43	40	41
8	Trinité	30	43	45	41
9	Cortenais	30	41	47	41
10	Nice II	30	39	30	40
11	Nîmes II	30	39	39	39
12	Gardanne	29	33	39	39
13	Furiani	30	33	47	39
14	Olympique	30	29	36	34
15	Ajaccio II	30	34	53	26
16	Menton	30	22	49	22

TEMPORADA 2008/2009

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Stade	30	42	27	56
2	Pontet	30	40	29	52
3	Olympique	30	46	31	51
4	Uzès Pont G.	30	43	28	51
5	Nice II	30	39	30	43
6	Menton	30	49	43	41
7	Gardanne	30	39	39	40
8	Athlético	30	39	41	39
9	Valettoise	30	32	37	38
10	Nîmes II	30	33	35	36
11	Bastia II	30	33	38	36
12	Trinité	30	33	39	36
13	Cortenais	30	33	43	35
14	Marseille	30	28	35	34
15	Cannet	30	38	45	33
16	Manosque	30	22	49	21

TEMPORADA 2007/2008

NATIONAL 3 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Agde	30	46	22	59
2	Pontet	30	52	27	58
3	Chambéry	29	43	30	54
4	Stade	30	44	30	48
5	Menton	30	45	37	47
6	Grenoble	30	54	41	44
7	Uzès Pont G.	29	41	34	41
8	Nîmes II	30	41	38	40
9	Marseille	30	46	44	40
10	Athlético	30	39	39	38
11	Sète II	30	42	44	37
12	Valettoise	30	31	34	34
13	Gardanne	29	39	44	32
14	Bastelicacci	29	32	58	29
15	EF Bastia	30	29	54	27
16	Île-Rousse	30	24	72	23

Competiciones que juega

National 3 Grupo 10

Pos	Equipos		Pts
1		Olympique Alès	60
2		Agde	46
3		Aigues Mortes	43
4		Toulouse II	41
5		Stade Beaucairois	37
6		Balma	36
7		Alberes Argelès	34
8		Castanet	34
9		Rodez II	33
10		Narbonne	33
11		Blagnac	32
12		Nîmes II	25
13		AS Muretaine	22
14		Fabrègues	21

	Ascenso : Olympique Alès
	Descenso : AS Muretaine, Fabrègues

RIVALES EN National 3

USO DE MEMORIA

6,496,112 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7767
Total Execution Time	0.7780

CADENA URL

/historico/Nimes-Ii

GET DATOS

$_GET['/historico/Nimes-Ii']

POST DATOS

No hay datos POST existentes

CONSULTAS (51)

0.0131	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 = 'Nimes-Ii' 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.0141	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 = 'Nimes-Ii' 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.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0124	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=6792 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0137	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 = 63492
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6792 AND type_rel = 2
0.0128	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 = '6792' ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '6792' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0126	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 = '6792' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = '6792' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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 = 63492 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129	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=6792 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (63492) 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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 63492 AND teamId = 6792
0.0143	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 63492 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0137	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 = '6792' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6792' and rp.type = 4
0.0135	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 = '6792' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0179	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 events2022 e ON e.player_id = p.id AND e.league_id = 63492 WHERE rp.league_id = 63492 AND rp.teamId = 6792 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.0179	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 events2022 e ON e.player_id = p.id AND e.league_id = 63492 WHERE rp.league_id = 63492 AND rp.teamId = 6792 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0170	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 events2022 e ON e.player_id = p.id AND e.league_id = 63492 WHERE rp.league_id = 63492 AND rp.teamId = 6792 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0136	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 = 6792 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 63492 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.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* `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 = 57387 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.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* `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 = 44573 AND t.round = 30 ORDER BY team.conference 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* `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 = 39137 AND t.round = 26 ORDER BY team.conference 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* `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 = 34013 AND t.round = 26 ORDER BY team.conference 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* `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 = 15900 AND t.round = 26 ORDER BY team.conference 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* `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 = 4314 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 2544 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136	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 = 2105 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0138	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 = 1688 AND t.round = 9 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* `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 = 19999 AND t.round = 30 ORDER BY team.conference 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* `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 = 20007 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 20016 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 20023 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 63492 ORDER BY nameShow LIMIT 100

Nîmes II

Nîmes II

Selecciona un equipo

Competiciones que juega

National 3 Grupo 10

RIVALES EN National 3