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

Luzenac

Temporada 2017/2018

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 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
Equipo		PJ	GF	GC	Puntos
1	Creteil	38	68	44	76
2	Metz	38	62	37	70
3	CA Bastia	38	56	51	61
4	Fréjus	38	52	43	60
5	Rouen 1899	38	50	37	59
6	Carquefou	38	53	35	57
7	Poiré-sur-V	38	47	35	57
8	Orléans	38	43	40	57
9	Amiens SC	38	48	38	54
10	Vannes	38	45	34	51
11	Colmar	38	43	45	50
12	Luzenac	38	43	47	48
13	US Boulogne	38	46	44	47
14	Red Star	38	34	45	46
15	Bourg-Péron	38	28	40	45
16	Uzès Pont G.	38	31	47	43
17	Paris FC	38	38	56	40
18	Épinal	38	45	56	39
19	Cherbourg	38	41	59	39
20	QRM	38	34	74	23

TEMPORADA 2011/2012

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Nîmes	38	65	38	68
2	Gazélec	38	57	32	68
3	Niort	38	61	33	67
4	Vannes	38	55	38	62
5	Épinal	38	61	47	62
6	Rouen 1899	38	48	46	60
7	Orléans	38	41	41	56
8	Colmar	38	54	44	55
9	Fréjus	38	50	58	51
10	Creteil	38	51	50	50
11	Red Star	38	44	52	50
12	Poiré-sur-V	38	41	46	49
13	QRM	38	45	54	47
14	Cherbourg	38	56	57	46
15	Luzenac	38	47	56	45
16	Paris FC	38	39	48	44
17	Beauvais	38	39	43	42
18	Martigues	38	43	69	39
19	Besancon RC	38	42	65	38
20	Bayonne	38	38	60	34

TEMPORADA 2010/2011

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Bastia	40	81	24	91
2	Amiens SC	40	58	27	84
3	Guingamp	40	87	36	80
4	Strasbourg	40	56	27	77
5	Cannes	40	51	35	68
6	Fréjus	40	56	41	67
7	Beauvais	40	53	48	61
8	Rouen 1899	40	54	44	59
9	Orléans	40	43	40	53
10	Creteil	40	41	48	51
11	Niort	40	46	46	49
12	Paris FC	40	45	46	49
13	Luzenac	40	39	44	49
14	Pacy	40	41	47	47
15	Colmar	40	34	48	44
16	Gap	40	44	62	43
17	Bayonne	40	36	58	43
18	Rodez	40	41	63	40
19	Plabennec	40	33	52	39
20	UJA Maccabi	40	36	79	28
21	FC Gueugnon	40	21	81	16

TEMPORADA 2009/2010

NATIONAL
Equipo		PJ	GF	GC	Puntos
1	Evian Thonon	38	61	28	82
2	Troyes	38	64	31	71
3	Stade Reims	38	63	30	71
4	Creteil	38	48	36	63
5	Pacy	38	60	41	60
6	Paris FC	38	51	43	58
7	Beauvais	38	50	48	56
8	Fréjus	38	44	34	54
9	Luzenac	38	51	48	53
10	Cannes	38	37	37	53
11	Amiens SC	38	55	54	51
12	Rouen 1899	38	47	43	50
13	Bayonne	38	41	47	50
14	Plabennec	38	41	55	50
15	Rodez	38	41	46	45
16	FC Gueugnon	38	41	47	42
17	Moulins	38	37	57	38
18	Cassis-Carno	38	41	58	36
19	Hyères	38	32	55	35
20	Louhans	38	18	85	21

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 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Cassis-Carno	34	49	31	69
2	Gap	34	58	28	63
3	Gazélec	34	37	32	57
4	Monaco II	34	47	33	52
5	Marignane	34	41	32	51
6	Albi	34	45	32	50
7	Saint-Étien	34	33	35	47
8	Hyères	34	33	26	46
9	Sporting	34	36	36	46
10	Fréjus	34	41	43	46
11	CA Bastia	34	35	48	44
12	Luzenac	34	49	51	43
13	Andrézieux	34	31	33	41
14	Balma	34	34	44	39
15	Montpellier	34	33	43	39
16	Nice II	34	36	41	37
17	Toulouse II	34	31	49	29
18	Manosque	34	33	65	28

TEMPORADA 2006/2007

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Rodez	34	47	23	66
2	Albi	34	47	33	59
3	Bayonne	34	38	30	56
4	Girondins	34	40	28	54
5	Moulins	34	40	29	54
6	Orléans	34	45	35	53
7	Le Mans II	34	45	33	50
8	Aurillac	34	46	45	49
9	Anglet	33	45	43	46
10	Montluçon	34	37	33	45
11	Toulouse II	34	47	41	43
12	Luzenac	34	40	43	42
13	Nantes II	34	44	42	40
14	Stade	33	40	57	39
15	Balma	34	29	49	37
16	Herbiers	34	40	49	36
17	Saint-George	34	22	46	32
18	Brive	34	28	61	17

TEMPORADA 2005/2006

NATIONAL 2 GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Yzeure	34	56	35	61
2	Rodez	34	58	46	59
3	Saint-Étien	34	54	36	57
4	Toulouse II	34	48	30	57
5	Le Mans II	34	54	41	55
6	Brive	34	40	30	47
7	Montluçon	34	37	43	47
8	Albi	34	49	41	45
9	Orléans	33	34	34	45
10	Aurillac	33	37	40	45
11	Nantes II	34	46	48	43
12	Luzenac	34	33	42	43
13	Girondins	34	31	40	40
14	Balma	34	34	64	40
15	Anglet	34	40	38	39
16	Andrézieux	34	30	35	39
17	Stade	34	29	45	35
18	Blois	34	38	60	28

Competiciones que juega

National 3 Grupo 9

Pos	Equipos		Pts
1		Nîmes II	50
2		Toulouse II	47
3		Montpellier II	43
4		Canet Roussillon	43
5		Fabrègues	42
6		Blagnac	37
7		Balma	36
8		Rodéo FC Toulouse	34
9		Avenir Foot Lozère	31
10		Agde	28
11		Olympique Alès	27
12		Narbonne	24
13		Castanet	24
14		Luzenac	21

RIVALES EN National 3

USO DE MEMORIA

6,165,608 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.6916
Total Execution Time	0.6933

CADENA URL

/historico/Luzenac

GET DATOS

$_GET['/historico/Luzenac']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0132	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 = 'Luzenac' 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.0142	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 = 'Luzenac' 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=4440 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=4440 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=4440 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=4440 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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=4440 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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=4440 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=4440 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=4440 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=4440 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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128	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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=4440 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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 = 39137
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4440 AND type_rel = 2
0.0129	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4440 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126	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 (702756) ORDER BY n.cover_points DESC, update_date 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 = '4440' 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 = '4440' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '4440' 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 = '4440' 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 = 39137 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128	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=4440 AND l.year in (2017,2018,2019) 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 (47499,39137) 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 = 39137 AND teamId = 4440
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 47499 AND teamId = 4440
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 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 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 = '4440' 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 = '4440' and rp.type = 4
0.0126	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 = '4440' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136	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 events2018 e ON e.player_id = p.id AND e.league_id = 39137 WHERE rp.league_id = 39137 AND rp.teamId = 4440 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.0132	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 events2018 e ON e.player_id = p.id AND e.league_id = 39137 WHERE rp.league_id = 39137 AND rp.teamId = 4440 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 events2018 e ON e.player_id = p.id AND e.league_id = 39137 WHERE rp.league_id = 39137 AND rp.teamId = 4440 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 4440 AND l.year <= 2018 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* `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.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 = 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.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* `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.0143	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 = 19937 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 19941 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* `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 = 19945 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Luzenac

Luzenac

Selecciona un equipo

Competiciones que juega

National 3 Grupo 9

RIVALES EN National 3