Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

Bergerac

Entrenador: Yassine Azahaf

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	24	36	23	42
3	FC Libourne	24	40	28	39
4	Angouleme	24	31	27	37
5	Blois	24	37	30	37
6	Bergerac	24	33	28	36
7	Bourges Foot	24	29	37	34
8	Herbiers	24	31	26	33
9	Saint-Pryve	23	26	25	32
10	Saumur	24	30	33	28
11	Romorantin	24	28	37	27
12	Avoine OCC	23	22	31	25
13	Trelissac	24	24	35	21
14	Angers	24	17	40	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 3
Equipo		PJ	GF	GC	Puntos
1	Sète	21	33	15	49
2	Blois	20	24	20	38
3	Herbiers	20	29	19	35
4	Bergerac	20	21	15	33
5	Colomiers	20	28	19	31
6	Bourges Foot	21	25	21	31
7	Saint-Pryve	21	25	26	31
8	Angouleme	21	32	26	30
9	Nantes II	21	23	19	28
10	Romorantin	21	25	20	25
11	Andrézieux	21	26	25	23
12	Trelissac	21	18	22	22
13	Montpellier	21	25	38	22
14	Chamalières	19	18	25	21
15	Saint-Étien	21	19	32	18
16	Stade	21	18	47	9

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 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sporting	30	41	25	57
2	Marignane	30	39	25	57
3	Colomiers	30	43	27	51
4	Bergerac	30	43	28	49
5	Fréjus	30	41	32	49
6	Martigues	30	42	33	47
7	Sète	30	39	26	43
8	Monaco II	30	44	34	43
9	Grasse	30	32	31	39
10	Hyères	30	35	32	36
11	Stade	30	30	36	36
12	Nice II	30	31	48	35
13	Stade	30	32	46	32
14	Olympique	30	31	46	28
15	Tarbes	30	32	60	26
16	Paulhan/Péz	30	19	45	23

TEMPORADA 2016/2017

NATIONAL 2 GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Stade	30	44	34	56
2	Cholet	30	46	32	52
3	Bergerac	30	35	34	49
4	Granville	30	40	41	47
5	Trelissac	30	44	31	46
6	Vitré	30	36	34	45
7	Romorantin	30	35	31	44
8	PSG II	30	44	36	42
9	Saint-Malo	30	32	32	42
10	Fontenay	30	47	49	42
11	Lorient II	30	41	35	39
12	Chartres	30	33	41	33
13	Plabennec	30	30	37	29
14	Mantes	30	23	41	29
15	Nantes II	30	40	40	28
16	Voltigeurs	30	26	48	26

TEMPORADA 2015/2016

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Concarneau	30	41	24	56
2	Saint-Malo	30	57	32	55
3	Romorantin	30	54	44	54
4	Bergerac	30	36	33	52
5	Lorient II	30	40	31	44
6	Cholet	30	36	28	44
7	Voltigeurs	30	46	41	43
8	Fleury-Merog	30	32	35	41
9	Trelissac	30	38	32	39
10	Nantes II	30	37	38	35
11	Fontenay	30	40	45	35
12	Plabennec	30	34	49	34
13	V.Châtillon	30	26	34	31
14	Vitré	30	33	46	30
15	Stade	30	22	37	25
16	Girondins	30	23	46	22

TEMPORADA 2014/2015

NATIONAL 3 GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Bergerac	26	33	22	51
2	Bayonne	26	34	19	46
3	Lège-Cap-Fe	26	35	30	44
4	Toulouse II	26	28	17	43
5	Blagnac	26	31	23	43
6	Fabrègues	26	37	35	36
7	Aurillac	26	19	18	35
8	Angouleme	26	26	26	34
9	Anglet	26	31	32	34
10	Villenave	26	27	36	32
11	Balma	26	17	19	29
12	Agde	26	15	21	28
13	Rodéo	26	31	39	26
14	Bassin	26	16	43	15

TEMPORADA 2013/2014

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Montpellier	26	50	24	52
2	Limoges	26	41	27	48
3	Genêts	26	44	33	47
4	Toulouse II	26	36	30	44
5	Bergerac	26	38	31	43
6	Aurillac	26	39	26	40
7	Rodéo	26	27	33	36
8	Lège-Cap-Fe	26	33	28	35
9	Angouleme	26	44	44	31
10	Balma	26	30	31	31
11	Chauray	26	27	30	31
12	Bayonne	26	24	41	27
13	Albi	26	31	47	17
14	Saint-Alban	26	37	76	13

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 6
Equipo		PJ	GF	GC	Puntos
1	Stade	32	45	22	62
2	Girondins	32	51	31	61
3	Stade	32	51	29	60
4	Trelissac	32	44	29	57
5	Toulouse II	32	60	32	55
6	Balma	32	38	27	55
7	Bergerac	32	54	42	46
8	Mérignac	32	39	36	45
9	SU Agen	32	40	38	41
10	Saint-Alban	32	37	48	41
11	Lormont	32	47	56	38
12	Blagnac	32	42	45	36
13	Langon-Caste	32	35	51	34
14	Revel	32	30	50	34
15	Brive	32	33	48	33
16	FC Libourne	32	24	49	29
17	Toulouse	32	28	65	18

TEMPORADA 2009/2010

NATIONAL 3 GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Béziers	30	63	36	65
2	Tarbes	30	53	33	58
3	Toulouse II	30	44	28	51
4	Trelissac	30	51	38	49
5	Bergerac	30	45	34	44
6	SU Agen	30	33	27	43
7	Cognac	30	50	48	40
8	Stade	30	36	37	40
9	Stade	30	35	28	39
10	Blagnac	30	42	41	39
11	Mérignac	30	29	46	36
12	Saint-Alban	30	37	49	35
13	Cugnaux	30	27	45	34
14	Tournefeuill	30	35	51	30
15	Bayonne II	30	41	58	28
16	Bassin	30	38	60	24

TEMPORADA 2008/2009

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Luzenac	34	59	26	69
2	Moulins	34	56	41	62
3	Pau FC	34	42	25	60
4	Fontenay	34	37	32	57
5	Yzeure	34	60	43	54
6	Girondins	34	41	35	52
7	Romorantin	34	49	49	49
8	Le Mans II	34	35	33	48
9	Luçon	34	39	37	47
10	Aurillac	34	48	44	44
11	Colomiers	34	33	32	41
12	Montluçon	34	43	54	39
13	Balma	34	47	54	36
14	Albi	34	27	42	36
15	Anglet	34	35	53	35
16	Chatelleraul	34	50	66	34
17	Stade	34	27	47	32
18	Bergerac	34	32	47	28

TEMPORADA 2007/2008

NATIONAL 3 GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Niort II	34	61	29	65
2	Bergerac	34	49	31	59
3	Colomiers	34	42	29	59
4	Tarbes	34	60	40	56
5	Bassin	34	43	35	48
6	Toulouse	34	42	34	48
7	Brive	33	40	38	47
8	Blagnac	34	34	39	47
9	Rodéo	33	35	36	45
10	Stade	34	27	37	42
11	GOAL FC	34	35	46	42
12	SU Agen	34	32	46	42
13	Trelissac	34	35	38	40
14	Cognac	34	40	53	40
15	Libourne	34	32	39	39
16	Cugnaux	34	33	43	38
17	Béziers	34	35	49	35
18	Angouleme	34	26	39	30

Competiciones que juega

Grupo 2

National 2 Grupo 2

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

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

RIVALES EN Copa de Francia

RIVALES EN National 2

USO DE MEMORIA

7,224,424 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6435
Total Execution Time	0.6448

CADENA URL

/historico/Bergerac

GET DATOS

$_GET['/historico/Bergerac']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0137	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 = 'Bergerac' 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.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=6786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=6786 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=6786 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=6786 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6786 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6786 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (170806,171757,186390,185571,578711) ORDER BY n.cover_points DESC, update_date DESC
0.0132	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 = '6786' ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '6786' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '6786' 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 = 72963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130	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=6786 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (74470,72963,71432) 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 = 72963 AND teamId = 6786
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 74470 AND teamId = 6786
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6786
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126	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 = '6786' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6786' and rp.type = 4
0.0127	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 = '6786' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0137	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 = 6786 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.0135	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 = 6786 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 6786 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 6786 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.0134	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.0145	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 = 50569 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.0144	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 = 39108 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 33905 AND t.round = 30 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* `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 = 15748 AND t.round = 30 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* `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 = 4315 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 2545 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* `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.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* `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.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* `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 = 20000 AND t.round = 34 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* `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 = 20008 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 19933 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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 = 20024 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 72963 ORDER BY nameShow LIMIT 100


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

Resultados de Fútbol

Bergerac

Bergerac

Selecciona un equipo

Competiciones que juega

National 2 Grupo 2

RIVALES EN Copa de Francia

RIVALES EN National 2