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

Luçon

Temporada 2015/2016

TEMPORADA 2015/2016

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Strasbourg	34	35	19	58
2	Orléans	34	50	37	56
3	Amiens SC	34	44	35	55
4	Athlético	34	50	43	54
5	Chateauroux	34	52	45	52
6	Dunkerque	34	42	42	47
7	Avranches	34	44	36	46
8	US Boulogne	34	50	45	46
9	Chambly	34	46	40	44
10	Béziers	34	35	38	44
11	Luçon	34	45	50	44
12	CS Sedan	34	31	34	43
13	CA Bastia	34	29	33	43
14	Belfort	34	26	32	41
15	Herbiers	34	44	51	39
16	Colmar	34	39	46	37
17	Épinal	34	39	53	30
18	Fréjus	34	22	44	27

TEMPORADA 2014/2015

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Red Star	34	68	30	70
2	Bourg-Péron	34	57	25	66
3	Paris FC	34	50	28	66
4	Strasbourg	34	50	29	65
5	Luçon	34	40	25	58
6	Dunkerque	34	38	31	52
7	US Boulogne	34	49	39	50
8	Fréjus	34	42	38	49
9	Avranches	34	42	38	46
10	Colmar	34	40	44	45
11	Amiens SC	34	45	48	41
12	Poiré-sur-V	34	36	44	41
13	Athlético	34	40	58	40
14	Chambly	34	42	54	37
15	CA Bastia	34	32	43	32
16	Colomiers	34	30	50	32
17	Istres	34	27	61	22
18	Épinal	34	30	73	15

TEMPORADA 2013/2014

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Orléans	34	46	22	65
2	Luzenac	34	51	30	63
3	Gazélec	34	45	27	60
4	Dunkerque	34	35	30	50
5	Colmar	34	37	39	50
6	Amiens SC	34	32	24	49
7	Red Star	34	37	33	48
8	Carquefou	34	32	30	47
9	Paris FC	34	32	27	46
10	Fréjus	34	35	35	46
11	Bourg-Péron	34	38	45	43
12	Luçon	34	32	41	41
13	Poiré-sur-V	34	37	52	41
14	US Boulogne	34	36	40	40
15	Colomiers	34	39	39	39
16	Strasbourg	34	36	40	35
17	Vannes	34	35	45	32
18	Uzès Pont G.	34	25	61	23

TEMPORADA 2012/2013

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Luçon	34	68	45	63
2	Trelissac	34	58	39	61
3	Herbiers	34	51	30	57
4	Saint-Malo	34	50	31	54
5	Romorantin	34	39	31	52
6	Girondins	34	51	44	52
7	Avranches	34	50	35	51
8	Pontivy	34	40	36	50
9	Concarneau	34	44	44	49
10	Fontenay	34	41	38	48
11	Le Mans II	34	44	53	44
12	V.Châtillon	34	36	51	44
13	Stade	34	49	53	42
14	Plabennec	34	37	46	42
15	Caen II	34	45	51	41
16	Lorient II	34	40	57	37
17	Le Havre II	34	31	47	34
18	Saumur	34	33	76	19

TEMPORADA 2011/2012

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Carquefou	34	53	23	71
2	Luçon	34	63	38	71
3	Avranches	34	53	33	63
4	Plabennec	34	55	40	56
5	Romorantin	34	58	33	55
6	Herbiers	34	39	40	51
7	Concarneau	34	49	44	46
8	Mantes	34	45	45	45
9	Saumur	34	39	43	43
10	Le Havre II	34	46	55	43
11	V.Châtillon	34	43	45	41
12	Le Mans II	34	41	47	41
13	Fontenay	34	30	43	39
14	Pacy	34	34	50	39
15	Caen II	34	34	42	38
16	Pontivy	34	29	37	37
17	Lorient II	34	38	55	36
18	Vitréenne	34	24	60	24

TEMPORADA 2010/2011

NATIONAL 2 GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Poiré-sur-V	32	47	24	59
2	Cherbourg	32	42	37	49
3	Vitréenne	32	39	26	48
4	Herbiers	32	48	36	46
5	Carquefou	32	42	36	46
6	Yzeure	32	30	26	44
7	Moulins	32	42	43	44
8	Le Mans II	32	44	38	42
9	Avranches	32	32	31	42
10	V.Châtillon	32	36	39	42
11	Romorantin	32	43	44	41
12	Luçon	32	36	43	40
13	Lorient II	32	39	42	39
14	Fontenay	32	34	43	39
15	Caen II	32	40	55	38
16	Saint-Pryve	32	40	53	36
17	Stade	32	27	45	29

TEMPORADA 2009/2010

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Niort	34	53	23	65
2	Yzeure	34	39	29	58
3	Luçon	34	45	39	56
4	PSG II	34	37	28	54
5	Albi	34	42	40	54
6	Montluçon	34	45	36	52
7	Herbiers	34	48	44	49
8	Colomiers	34	33	29	48
9	Le Mans II	34	42	35	44
10	FC Libourne	34	35	31	44
11	Red Star	34	38	44	42
12	Pau FC	34	30	35	39
13	Girondins	34	23	32	38
14	Aurillac	34	26	40	38
15	Fontenay	34	31	41	36
16	Anglet	34	29	42	36
17	Balma	34	28	42	30
18	Toulouse	34	25	39	28

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 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

National

Pos	Equipos		Pts
1		Strasbourg	58
2		Orléans	56
3		Amiens SC	55
4		Athlético Marseille	54
5		Chateauroux	52
6		Dunkerque	47
7		Avranches	46
8		US Boulogne	46
9		Chambly	44
10		Béziers	44
11		Luçon	44
12		CS Sedan	43
13		CA Bastia	43
14		Belfort	41
15		Les Herbiers	39
16		Colmar	37
17		Épinal	30
18		Fréjus St-Raphaël	27

RIVALES EN Copa de Francia

RIVALES EN National

USO DE MEMORIA

6,357,240 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8915
Total Execution Time	0.8935

CADENA URL

/historico/Lucon

GET DATOS

$_GET['/historico/Lucon']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0151	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 = 'Lucon' 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.0304	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 = 'Lucon' 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.0144	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6707 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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149	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=6707 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0182	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 = 15088
0.0162	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 = 19690
0.0147	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6707 AND type_rel = 2
0.0170	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 = '6707' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0161	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 = '6707' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0173	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 = 19690 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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 = 15088 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0153	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=6707 AND l.year in (2015,2016,2017) ORDER BY l.id DESC, l.year DESC ;
0.0147	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 (19690,16245,15088) 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.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 15088 AND teamId = 6707
0.0156	SELECT count(id) as num_players from rel_players WHERE league_id = 19690 AND teamId = 6707
0.0242	SELECT count(id) as num_players from rel_players WHERE league_id = 16245 AND teamId = 6707
0.0165	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 15088 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0152	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 = '6707' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6707' and rp.type = 4
0.0146	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 = '6707' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164	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 events2016 e ON e.player_id = p.id AND e.league_id = 15088 WHERE rp.league_id = 15088 AND rp.teamId = 6707 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.0166	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 events2016 e ON e.player_id = p.id AND e.league_id = 15088 WHERE rp.league_id = 15088 AND rp.teamId = 6707 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0172	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 events2016 e ON e.player_id = p.id AND e.league_id = 15088 WHERE rp.league_id = 15088 AND rp.teamId = 6707 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0164	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 = 6707 AND l.year <= 2016 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0164	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 = 15088 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158	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 = 3828 AND t.round = 34 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* `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 = 2534 AND t.round = 34 ORDER BY team.conference 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* `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 = 2100 AND t.round = 34 ORDER BY team.conference 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* `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 = 1682 AND t.round = 34 ORDER BY team.conference 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* `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 = 19926 AND t.round = 34 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 = 19929 AND t.round = 34 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* `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.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* `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

Luçon

Luçon

Selecciona un equipo

Competiciones que juega

National

RIVALES EN Copa de Francia

RIVALES EN National