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

Angers SCO II

Temporada 2023/2024

TEMPORADA 2023/2024

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	La Roche VF	24	34	18	42
2	Paris	23	35	22	41
3	FC Libourne	23	40	25	39
4	Angouleme	24	31	27	37
5	Blois	23	35	30	34
6	Bergerac	23	30	28	33
7	Herbiers	24	31	26	33
8	Saint-Pryve	22	25	24	31
9	Bourges Foot	23	27	36	31
10	Saumur	24	30	33	28
11	Romorantin	23	28	35	27
12	Avoine OCC	22	21	30	24
13	Trelissac	23	23	34	20
14	Angers	23	16	38	13

TEMPORADA 2022/2023

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	GOAL FC	30	44	25	54
2	Herbiers	30	54	35	52
3	Bergerac	30	48	30	50
4	Angouleme	30	28	19	45
5	Trelissac	30	33	28	45
6	Chamalières	30	36	30	44
7	Romorantin	30	40	40	43
8	Saumur	30	36	35	41
9	Bourges Foot	30	32	35	41
10	Angers	30	37	44	41
11	Andrézieux	30	29	27	40
12	Lorient II	30	39	33	39
13	Nantes II	30	31	41	34
14	Stade	30	32	48	29
15	Yzeure	30	26	44	27
16	Vierzon	30	22	53	23

TEMPORADA 2021/2022

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Le Puy	30	40	17	61
2	Bergerac	30	38	16	60
3	Bourges Foot	30	46	25	56
4	Andrézieux	30	43	30	51
5	Angouleme	30	33	25	49
6	Béziers	30	45	36	47
7	Yzeure	30	33	28	44
8	Canet	30	35	36	37
9	Herbiers	30	31	34	37
10	Trelissac	30	27	34	35
11	Nantes II	30	33	37	34
12	Angers	30	27	32	33
13	Chamalières	30	30	41	32
14	Montpellier	30	33	44	30
15	Colomiers	30	30	46	27
16	Stade	30	24	67	10

TEMPORADA 2020/2021

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Béziers	9	15	5	21
2	Trelissac	9	13	5	17
3	Le Puy	8	12	4	16
4	Colomiers	9	7	4	16
5	Romorantin	8	10	3	14
6	Herbiers	9	11	5	14
7	Angers	9	11	12	13
8	Bourges Foot	8	11	7	11
9	Yzeure	9	10	7	11
10	Bergerac	8	9	7	10
11	Canet	9	9	10	10
12	Chamalières	9	5	8	10
13	Nantes II	9	6	10	10
14	Angouleme	9	5	21	6
15	Bourges 18	9	10	19	3
16	Stade	9	2	19	2

TEMPORADA 2019/2020

NATIONAL 2 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Stade	21	38	22	46
2	Chartres	21	42	19	44
3	Rouen 1899	20	23	15	39
4	Granville	21	22	21	38
5	Vannes	21	35	24	35
6	Paris	21	32	29	30
7	Lorient II	21	19	19	30
8	Fleury-Merog	21	24	23	29
9	Saint-Malo	20	23	22	28
10	Angers	21	21	19	27
11	Guingamp II	21	30	34	23
12	Sannois	21	20	24	23
13	Poissy	21	28	32	22
14	Vitré	21	19	26	18
15	Oissel	21	18	38	13
16	Mantes	21	7	34	6

TEMPORADA 2018/2019

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Angers	26	39	20	47
2	Challans	26	39	32	45
3	Fontenay	26	36	29	43
4	Voltigeurs	26	50	37	41
5	Saint-Nazair	26	31	28	38
6	USSA Vertou	26	31	29	38
7	La Roche VF	26	30	29	36
8	Saumur	26	35	37	36
9	Flèche	26	24	26	34
10	Le Mans II	26	32	34	33
11	Sablé	26	35	45	30
12	Herbiers	26	28	36	29
13	Stade	26	36	44	27
14	La Suze	26	31	51	27

TEMPORADA 2017/2018

NATIONAL 3 GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Nantes II	26	42	18	56
2	Sablé	26	41	24	52
3	Herbiers	26	34	30	41
4	Angers	26	35	24	38
5	USSA Vertou	26	33	30	37
6	La Roche VF	26	33	35	36
7	Poiré-sur-V	26	26	29	35
8	Stade	26	31	35	35
9	Challans	26	27	25	34
10	Voltigeurs	26	38	36	31
11	La Suze	26	39	43	30
12	Flèche	26	32	39	29
13	Change	26	25	36	29
14	Mulsanne-Tel	26	20	52	18

TEMPORADA 2016/2017

NATIONAL 3 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Stade	26	42	11	56
2	Angers	26	38	23	47
3	Guingamp II	26	41	30	42
4	Dinan-Léhon	26	28	24	41
5	Vannes	26	45	44	40
6	USSA Vertou	26	37	32	39
7	Stade	26	38	34	35
8	Stade	26	32	27	32
9	Sablé	26	31	34	31
10	Tour	26	24	38	30
11	Lannion	26	28	40	28
12	Change	26	31	54	28
13	Flèche	26	23	37	23
14	Union	26	31	41	20

TEMPORADA 2015/2016

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chartres	26	50	19	58
2	Avoine OCC	26	39	26	48
3	Le Mans	26	30	26	43
4	USSA Vertou	26	28	31	40
5	Angers	26	47	33	35
6	La Roche VF	26	33	44	34
7	Chatelleraul	26	34	34	33
8	Tours II	26	47	49	33
9	Bourges 18	26	28	30	33
10	Saint-Pryve	26	34	35	32
11	Bressuire	26	30	33	32
12	Poiré-sur-V	26	29	37	28
13	Châteauroux	26	32	50	27
14	Challans	26	21	35	21

TEMPORADA 2014/2015

NATIONAL 3 GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Cholet	26	34	21	45
2	Saint-Pryve	26	40	25	41
3	La Roche VF	26	38	31	39
4	Le Mans	26	34	28	39
5	Angers	26	34	34	38
6	Bressuire	26	28	29	38
7	Tours II	26	38	32	36
8	Avoine OCC	26	26	31	36
9	Châteauroux	26	42	35	35
10	Poiré	26	31	26	34
11	USSA Vertou	26	25	35	34
12	Chatelleraul	26	34	46	31
13	Chauray	26	30	44	30
14	Thouars	26	27	44	23

TEMPORADA 2013/2014

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Fleury-Merog	26	40	27	44
2	Tours II	26	37	26	43
3	Saint-Pryve	26	43	29	42
4	Châteauroux	26	44	34	42
5	Poiré	26	33	27	40
6	Cholet	26	35	34	38
7	Chartres	26	42	37	36
8	Geneviève	26	27	27	36
9	La Roche VF	26	35	41	35
10	Chatelleraul	26	41	43	34
11	Thouars	26	27	43	31
12	Angers	26	38	39	30
13	Saumur	26	21	29	29
14	Stade	26	21	48	14

TEMPORADA 2012/2013

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Nantes II	26	53	20	55
2	Angers	26	49	29	51
3	Châteauroux	26	49	36	47
4	Sablé	26	44	35	39
5	Chauray	26	30	24	39
6	Cholet	26	41	27	37
7	Poiré	26	28	24	35
8	Limoges	26	31	42	33
9	Thouars	26	30	32	31
10	Stade	26	22	31	31
11	Chatelleraul	26	31	54	30
12	Avoine	26	30	43	25
13	La Suze	26	40	57	20
14	Flèche	26	23	47	17

TEMPORADA 2011/2012

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Chartres	9	23	7	23
2	Vertou	9	16	10	22
3	Cholet	9	18	7	20
4	Angers	9	19	10	18
5	Trelissac	9	12	8	17
6	Nantes II	9	12	8	14
7	Chatelleraul	9	15	12	13
8	Stade	9	16	17	13
9	Tours II	9	15	18	10
10	Saint-Pryve	9	13	16	10
11	Poiré	9	8	12	9
12	Herbiers	9	7	12	9
13	Saint-Jean-L	9	6	17	8
14	Limoges	9	13	18	7
15	Thouars	9	8	18	5
16	Cognac	9	10	21	5

TEMPORADA 2010/2011

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Saumur	28	55	20	60
2	Nantes II	28	50	28	54
3	Angers	28	51	30	54
4	Tours II	28	32	28	41
5	Stade	28	36	36	38
6	Cholet	28	38	40	37
7	Vierzon	28	34	55	36
8	Châteauroux	28	32	28	35
9	Cognac	28	37	41	35
10	Chatelleraul	28	40	50	35
11	Sablé	28	35	33	34
12	USSA Vertou	28	33	33	34
13	Bourges 18	28	33	33	33
14	Chataignerai	28	37	45	32
15	Bonchamp	28	23	66	10
16	Montluçon	0	0	0	0

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 7
Equipo		PJ	GF	GC	Puntos
1	Poiré-sur-V	30	52	27	63
2	Saint-Pryve	30	54	34	61
3	Saumur	30	48	37	46
4	Angers	30	51	44	44
5	Châteauroux	30	40	34	43
6	Nantes II	30	40	35	43
7	Cholet	30	39	36	40
8	Stade	30	36	36	39
9	Tours II	30	46	41	38
10	Geneviève	30	32	36	38
11	Chatelleraul	30	38	47	37
12	Bourges 18	30	30	39	36
13	Niort II	30	34	38	35
14	Thouars	30	39	53	31
15	Blois	30	31	49	29
16	Ararat Issy	30	27	51	28

TEMPORADA 2008/2009

NATIONAL 3 GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Carquefou	29	43	23	59
2	Avranches	30	45	32	52
3	Nantes II	30	52	37	51
4	Stade	30	55	31	50
5	Concarneau	30	36	31	48
6	Montagnarde	30	40	32	47
7	Stade	30	47	36	46
8	Mondeville	30	46	37	45
9	Lorient II	29	40	36	43
10	Angers	30	41	39	39
11	USSA Vertou	30	32	29	38
12	Change	30	39	38	38
13	Dives	30	45	58	38
14	Fléchois	30	17	43	21
15	Tour	30	29	60	21
16	Bonchamp	30	27	72	12

TEMPORADA 2007/2008

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Luçon	30	46	16	65
2	Saint-Pryve	30	50	31	53
3	Saumur	30	52	36	51
4	Angers	30	38	32	48
5	Arménienne	30	45	33	47
6	Auxerre III	30	40	34	47
7	Châteauroux	30	38	25	46
8	Herbiers	30	43	28	45
9	Thouars	30	31	26	42
10	Malesherbes	30	34	41	38
11	Blois	30	33	31	36
12	Nivernais	30	29	39	35
13	Flèche	30	26	30	32
14	Créteil II	30	32	41	29
15	Chatelleraul	30	26	60	22
16	Écommoy FC	30	17	77	14

Competiciones que juega

Grupo 2

National 2 Grupo 2

Pos	Equipos		Pts
1		La Roche VF	42
2		Paris 13 Atletico	41
3		FC Libourne	39
4		Angouleme	37
5		Blois	34
6		Bergerac	33
7		Les Herbiers	33
8		Saint-Pryve	31
9		Bourges Foot 18	31
10		Saumur	28
11		Romorantin	27
12		Avoine OCC	24
13		Trelissac	20
14		Angers SCO II	13

	Ascenso : La Roche VF
	Descenso : Saumur, Romorantin, Avoine OCC, Trelissac, Angers SCO II

RIVALES EN National 2

USO DE MEMORIA

6,784,704 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7313
Total Execution Time	0.7326

CADENA URL

/historico/Angers-Ii

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0154	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 = 'Angers-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.0146	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=6801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=6801 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0296	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 = 72963
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6801 AND type_rel = 2
0.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220 AND type_rel = 3
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 220 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148	SELECT /53 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 (1303338,1286561,1233296,1230274,1161224) ORDER BY n.cover_points DESC, update_date DESC
0.0152	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 = '6801' ORDER BY l.year DESC,cat.coefficient DESC
0.0150	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 = '6801' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '6801' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147	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 = 72963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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=6801 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (72963,67320) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 72963 AND teamId = 6801
0.0149	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 6801
0.0146	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 = '6801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6801' and rp.type = 4
0.0148	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 = '6801' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0158	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6801 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.0156	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6801 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152	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 = 72963 WHERE rp.league_id = 72963 AND rp.teamId = 6801 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 6801 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151	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 = 72963 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.0149	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 = 68294 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 63482 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 57116 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 50568 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 44561 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 39138 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 34007 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 15897 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 4306 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 2546 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 2107 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 1689 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 20001 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 20009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 20019 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 20025 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Angers SCO II

Angers SCO II

Selecciona un equipo

Competiciones que juega

National 2 Grupo 2

RIVALES EN National 2