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

Sochaux II

Temporada 2023/2024

TEMPORADA 2023/2024

NATIONAL 3 GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Rumilly	24	49	18	54
2	Pontarlier	24	44	23	44
3	Sochaux II	24	31	26	39
4	Jura Dolois	24	34	31	36
5	Yzeure	24	22	32	35
6	Dijon II	24	38	28	34
7	Besancon FC	24	33	35	33
8	US Cosne	24	34	32	32
9	FC Gueugnon	24	28	29	31
10	Louhans	24	30	26	28
11	ASPTT Dijon	24	27	41	28
12	Vesoul	24	30	41	25
13	Selongey	24	31	42	23
14	Chapelle	24	24	51	15

TEMPORADA 2022/2023

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Mâcon	26	61	27	54
2	Pontarlier	26	48	27	51
3	Dijon II	26	49	25	48
4	Jura Dolois	26	49	38	48
5	Selongey	26	41	35	48
6	Besancon FC	26	52	31	42
7	Sochaux II	26	69	31	41
8	US Cosne	26	36	35	36
9	FC Gueugnon	26	35	34	34
10	Morteau	26	30	42	30
11	Grandvillars	26	36	49	28
12	Saint-Apolli	26	35	49	27
13	Montceau	26	20	50	19
14	Quetigny	26	27	115	3

TEMPORADA 2021/2022

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Besancon RC	26	51	27	57
2	FC Gueugnon	26	43	16	51
3	Sochaux II	26	52	26	51
4	Jura Dolois	26	44	35	43
5	Besancon FC	26	39	36	42
6	Grandvillars	26	44	39	40
7	Dijon II	26	39	30	36
8	Montceau	26	36	36	33
9	Pontarlier	26	36	41	32
10	Saint-Apolli	26	26	47	32
11	Selongey	26	38	31	31
12	Morteau	26	33	43	27
13	Paron	26	18	47	21
14	Valdahon	26	21	66	12

TEMPORADA 2020/2021

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Montceau	0	0	0	0
2	Sochaux II	0	0	0	0
3	Valdahon	0	0	0	0
4	Jura Dolois	0	0	0	0
5	Dijon II	0	0	0	0
6	Pontarlier	0	0	0	0
7	Besancon RC	0	0	0	0
8	Paron	0	0	0	0
9	Besancon FC	0	0	0	0
10	Grandvillars	0	0	0	0
11	Selongey	0	0	0	0
12	Saint-Apolli	0	0	0	0
13	Morteau	0	0	0	0
14	FC Gueugnon	0	0	0	0

TEMPORADA 2019/2020

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Auxerre II	17	37	12	45
2	FC Gueugnon	18	37	20	38
3	Besancon FC	18	33	13	37
4	Dijon II	18	27	16	32
5	Besancon RC	16	34	24	27
6	Sochaux II	17	27	23	24
7	Pontarlier	15	24	23	22
8	Montceau	16	29	33	20
9	Jura Dolois	17	17	25	19
10	Morteau	15	19	19	18
11	Selongey	16	15	32	15
12	Valdahon	17	16	30	14
13	FC Sens	18	20	40	12
14	Novillars	18	19	44	8

TEMPORADA 2018/2019

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Dijon II	26	60	26	60
2	Louhans	25	63	32	53
3	Auxerre II	26	51	22	53
4	Besancon FC	26	37	17	49
5	Montceau	26	47	32	46
6	FC Gueugnon	26	27	23	39
7	Jura Dolois	26	43	36	38
8	Sochaux II	26	29	34	29
9	Selongey	26	40	47	26
10	Morteau	25	24	38	25
11	Charitoise	26	30	55	23
12	Besancon RC	26	29	46	21
13	Avallon CO	26	27	58	16
14	Grandvillars	26	31	72	12

TEMPORADA 2017/2018

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Pontarlier	27	40	23	55
2	Auxerre II	27	51	23	54
3	Dijon II	27	50	22	54
4	Besancon RC	27	41	27	53
5	FC Gueugnon	27	57	27	51
6	Sochaux II	27	52	29	51
7	Louhans	27	55	26	47
8	Besancon FC	27	46	35	36
9	Jura Dolois	27	34	39	35
10	Avallon CO	27	33	28	32
11	Selongey	27	43	48	27
12	Saint-Apolli	27	20	49	23
13	Quetigny	27	24	41	21
14	Saint Vit	27	21	70	18
15	Clémenceau	28	24	104	6

TEMPORADA 2016/2017

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Geneviève	26	42	22	51
2	Pontarlier	26	39	22	48
3	Noisy-le-Sec	26	45	29	47
4	Créteil II	26	41	36	43
5	FC Gueugnon	26	36	28	40
6	Troyes II	26	36	27	38
7	Ivry	26	34	37	32
8	Dijon II	26	25	25	31
9	Sochaux II	26	25	29	31
10	Selongey	26	23	44	30
11	Sénart	26	31	40	28
12	Besancon FC	26	34	40	26
13	Besancon RC	26	26	39	25
14	Ornans	26	32	51	25

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Lyon-Duchèr	30	44	19	62
2	Grenoble	30	40	19	59
3	Auxerre II	30	39	27	49
4	Olympique	30	39	41	47
5	Jura Sud	30	41	34	44
6	Villefranche	30	37	30	43
7	Drancy	30	33	29	41
8	Saint-Louis	30	30	30	40
9	GOAL FC	30	26	32	38
10	FC Mulhouse	30	33	36	37
11	Yzeure	30	27	29	36
12	Moulins	30	34	41	36
13	Le Puy	30	27	35	32
14	Montceau	30	28	50	32
15	Sarre-Union	30	34	41	28
16	Sochaux II	30	23	42	24

TEMPORADA 2014/2015

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Belfort	30	51	30	61
2	Fleury-Merog	30	38	25	51
3	FC Mulhouse	30	45	32	48
4	Montceau	30	41	38	45
5	Sarre-Union	30	47	42	44
6	Moulins	30	35	30	44
7	Aubervillier	30	29	35	43
8	Jura Sud	30	40	42	40
9	Drancy	30	40	43	36
10	Troyes II	30	34	43	35
11	Yzeure	30	24	29	34
12	V.Châtillon	30	24	32	34
13	Sochaux II	30	38	43	33
14	Metz II	30	29	35	33
15	Raon-l'Etape	30	37	44	32
16	Saint-Étien	30	33	42	31

TEMPORADA 2013/2014

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Épinal	30	56	37	55
2	Moulins	30	51	35	52
3	Yzeure	30	43	31	48
4	Olympique	30	53	45	47
5	FC Mulhouse	30	36	38	45
6	Lyon-Duchèr	30	40	37	43
7	Belfort	30	32	32	42
8	Raon-l'Etape	30	45	49	42
9	Sarre-Union	30	48	48	40
10	Sochaux II	30	37	40	40
11	Villefranche	30	34	32	38
12	GOAL FC	30	33	39	38
13	Saint-Priest	30	28	45	38
14	Montceau	30	37	48	36
15	Jura Sud	30	45	44	35
16	Vesoul	30	26	44	25

TEMPORADA 2012/2013

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Grenoble	34	63	30	62
2	Raon-l'Etape	34	53	31	62
3	Strasbourg	34	47	29	62
4	Lyon-Duchèr	34	49	39	55
5	Moulins	34	51	36	54
6	FC Mulhouse	34	46	39	53
7	Villefranche	34	44	42	47
8	PSG II	34	44	49	44
9	Yzeure	34	37	35	43
10	Jura Sud	34	31	38	43
11	Sochaux II	34	30	34	40
12	Sarre-Union	34	28	52	40
13	Belfort	34	31	37	38
14	Montceau	34	30	43	38
15	GOAL FC	34	37	47	37
16	Auxerre II	34	29	52	37
17	UJA Maccabi	34	25	33	35
18	Nancy II	34	42	51	33

TEMPORADA 2011/2012

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Olympique	32	71	34	66
2	Bourg-Péron	32	56	26	62
3	Lyon-Duchèr	32	57	33	61
4	Raon-l'Etape	32	50	30	53
5	Metz II	32	58	40	47
6	Valence	32	40	31	47
7	Yzeure	32	42	36	45
8	FC Mulhouse	32	44	40	43
9	Moulins	32	31	30	43
10	Nancy II	32	34	42	42
11	Belfort	32	38	42	39
12	Villefranche	32	28	51	37
13	Sochaux II	32	40	44	35
14	GOAL FC	32	28	49	34
15	Amnéville	32	50	61	33
16	Sarre-Union	32	33	69	27
17	Jura Sud	32	31	73	19

TEMPORADA 2010/2011

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Besancon RC	32	41	22	64
2	Épinal	32	51	22	61
3	Ivry	32	53	31	56
4	Sochaux II	32	49	36	53
5	Villefranche	32	45	34	50
6	Amnéville	32	50	45	49
7	Bourg-Péron	32	50	48	47
8	PSG II	32	55	41	46
9	Auxerre II	32	41	32	44
10	Jura Sud	32	35	42	44
11	Nancy II	32	48	40	43
12	FC Mulhouse	32	45	44	41
13	Belfort	32	35	35	38
14	Raon-l'Etape	32	39	49	37
15	Lyon-Duchèr	32	40	51	35
16	GOAL FC	32	34	68	22
17	Louhans	32	13	84	7

TEMPORADA 2009/2010

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Gap	34	57	34	60
2	Gazélec	34	45	29	58
3	Jura Sud	34	47	37	57
4	Olympique	34	50	38	51
5	Sporting	34	40	32	50
6	Martigues	34	39	35	49
7	Marignane	34	33	38	49
8	Agde	34	30	39	46
9	Montceau	34	42	42	45
10	CA Bastia	34	40	38	44
11	Bourg-Péron	34	37	47	44
12	Sochaux II	34	37	32	42
13	Villefranche	34	41	45	42
14	Andrézieux	34	36	39	41
15	Lyon-Duchèr	34	30	35	41
16	Pontet	34	40	54	41
17	Montpellier	34	35	41	36
18	Grenoble	34	31	55	28

TEMPORADA 2008/2009

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Besancon RC	34	67	34	72
2	Compiègne	34	52	30	64
3	FC Mulhouse	34	46	32	62
4	Montceau	34	46	33	58
5	Colmar	34	33	29	54
6	Sochaux II	34	45	36	53
7	Dunkerque	34	43	39	49
8	Auxerre II	34	39	37	47
9	Lens II	34	45	40	45
10	Strasbourg	34	34	35	44
11	Lille II	34	40	48	43
12	Raon-l'Etape	34	39	49	41
13	Sénart	34	24	32	37
14	Nancy II	34	32	41	36
15	Noisy-le-Sec	34	31	43	36
16	Vesoul	34	39	49	35
17	Metz II	34	30	47	35
18	Geneviève	34	28	59	22

TEMPORADA 2007/2008

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Evian Thonon	34	52	17	74
2	Besancon RC	34	61	20	68
3	Vesoul	34	61	42	61
4	Sochaux II	34	65	45	60
5	Saint-Priest	34	50	38	53
6	Olympique	34	45	32	49
7	Montceau	34	36	33	48
8	Auxerre II	34	52	48	45
9	Strasbourg	34	42	43	45
10	Red Star	34	38	40	40
11	Jura Sud	34	31	37	38
12	FC Mulhouse	34	31	55	38
13	Raon-l'Etape	33	36	57	37
14	Metz II	33	35	45	36
15	Nancy II	34	28	36	34
16	Épinal	34	33	49	34
17	Belfort	34	30	50	32
18	Épernay	34	25	64	26

TEMPORADA 2006/2007

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Calais	34	55	24	66
2	Besancon RC	34	55	31	62
3	Lille II	34	46	34	56
4	Dunkerque	34	50	42	50
5	Metz II	34	44	37	50
6	Sochaux II	34	56	43	48
7	Compiègne	34	42	39	48
8	Épinal	34	42	42	46
9	Lens II	34	42	49	46
10	FC Mulhouse	34	38	45	46
11	Nancy II	34	38	39	44
12	Vesoul	34	33	39	44
13	Lesquin	34	36	47	43
14	Olympique	34	37	39	38
15	Strasbourg	34	41	44	36
16	Épernay	34	35	55	35
17	Leval	34	37	61	32
18	Schiltigheim	34	44	61	31

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Martigues	34	41	19	67
2	Olympique	34	65	40	59
3	Pontet	34	30	23	58
4	Cassis-Carno	33	46	33	53
5	Nice II	34	48	45	53
6	Saint-Priest	34	45	42	50
7	Sochaux II	34	43	35	48
8	Jura Sud	34	35	38	48
9	Gap	34	40	38	46
10	Monaco II	34	49	44	45
11	Montpellier	34	45	42	45
12	Fréjus	33	39	36	44
13	Besancon RC	34	39	43	41
14	Agde	34	30	44	39
15	Marseille	34	43	63	37
16	Racing	34	45	51	34
17	Bourg-Péron	34	39	58	29
18	Lyon-Duchèr	34	21	49	26

Competiciones que juega

Grupo 10

National 3 Grupo 10

Pos	Equipos		Pts
1		Rumilly Vallières	54
2		Pontarlier	44
3		Sochaux II	39
4		Jura Dolois	36
5		Yzeure	35
6		Dijon II	34
7		Besancon FC	33
8		US Cosne	32
9		FC Gueugnon	31
10		CS Louhans Cuiseaux	28
11		ASPTT Dijon	28
12		Vesoul	25
13		Selongey	23
14		AS La Chapelle Guinchay	15

RIVALES EN National 3

USO DE MEMORIA

7,157,336 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1451
Total Execution Time	0.1463

CADENA URL

/historico/Sochaux-Ii

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0035	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 = 'Sochaux-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.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=6682 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=6682 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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 = 73253
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6682 AND type_rel = 2
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6682 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (574192) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '6682' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0032	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 = '6682' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 73253 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=6682 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 (73253) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 73253 AND teamId = 6682
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 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 = 73253 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '6682' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6682' 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 = '6682' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 = 73253 WHERE rp.league_id = 73253 AND rp.teamId = 6682 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.0034	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 = 73253 WHERE rp.league_id = 73253 AND rp.teamId = 6682 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 73253 WHERE rp.league_id = 73253 AND rp.teamId = 6682 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 = 6682 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 = 73253 AND t.round = 24 ORDER BY team.conference ASC,t.position 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* `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 = 68296 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.0022	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 57382 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.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* `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 = 50958 AND t.round = 18 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* `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 = 44564 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* `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 = 39130 AND t.round = 29 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* `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 = 34011 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 15746 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 4378 AND t.round = 30 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* `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 = 2537 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 2098 AND t.round = 34 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 = 1680 AND t.round = 34 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* `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 = 19924 AND t.round = 34 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* `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 = 19928 AND t.round = 34 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* `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 = 19931 AND t.round = 34 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* `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 = 19936 AND t.round = 34 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* `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 = 19939 AND t.round = 34 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* `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 = 19944 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 73253 ORDER BY nameShow LIMIT 100

Sochaux II

Sochaux II

Selecciona un equipo

Competiciones que juega

National 3 Grupo 10

RIVALES EN National 3