Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Recambios Colón

Temporada 2023/2024

TEMPORADA 2023/2024

LLIGA COMUNITAT FFCV GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Vall Uxó	26	37	9	57
2	Almazora	25	39	32	46
3	Ribarroja	27	44	32	41
4	Recambios	27	40	32	41
5	L´Alcora	26	43	37	41
6	SD Sueca	26	30	28	40
7	Manises	27	36	36	40
8	Buñol	27	31	25	39
9	Onda	26	35	32	38
10	Alqueríes	25	30	29	33
11	Jove	25	29	41	30
12	SC Requena	25	26	32	29
13	Paiporta	27	24	36	27
14	Alboraya	26	34	46	24
15	UD Aldaia	25	23	35	19
16	L'Alcúdia	26	20	39	16

TEMPORADA 2022/2023

PRIMERA FFCV GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	CD Utiel	34	76	33	79
2	Buñol	34	65	21	72
3	Recambios	34	67	19	70
4	Paiporta	34	63	40	69
5	Manises	34	69	53	61
6	Ribarroja	34	52	38	59
7	L'Alcúdia	34	48	32	57
8	SC Requena	34	47	36	56
9	UD Aldaia	34	48	48	52
10	Quart Poblet	34	45	50	44
11	Mislata	34	47	61	42
12	Paterna CF	34	57	69	33
13	Union	34	38	57	33
14	Antonio	34	42	65	28
15	Algemesí	34	45	67	28
16	Vilamarxant	34	45	71	27
17	Alginet	34	35	93	22
18	Marcelino	34	40	76	21

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Valencia	36	65	27	74
2	Saguntino	36	46	30	64
3	Atzeneta	36	46	25	63
4	CD Acero	36	36	27	62
5	Torrent	36	42	32	60
6	Orihuela CF	36	50	35	58
7	CD Roda	36	34	23	56
8	Ilicitano	36	56	29	54
9	Villarreal	36	52	39	51
10	Torrellano	36	37	37	51
11	Hércules B	36	35	36	49
12	Silla CF	36	44	46	47
13	Castellón	36	32	34	46
14	Jove	36	23	31	45
15	Olimpic	36	29	44	40
16	Callosa	36	27	39	37
17	Recambios	36	22	46	31
18	Benigànim	36	32	78	25
19	Villajoyosa	36	14	64	19

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UD Alzira	20	29	12	38
2	CD Roda	20	28	16	35
3	Saguntino	20	30	27	31
4	Villarreal	20	32	18	30
5	Silla CF	20	20	21	25
6	Recambios	20	16	19	23
7	Benicarló	20	22	21	22
8	Torrent	20	17	25	21
9	CD Acero	20	18	25	20
10	Paterna CF	20	14	25	20
11	Vilamarxant	20	13	30	15
12	Eldense	18	30	11	41
13	Ilicitano	18	33	17	38
14	Intercity	18	30	8	37
15	Olimpic	18	22	24	25
16	Benigànim	18	14	30	20
17	Jove	18	17	23	19
18	Crevillente	18	17	24	19
19	Hércules B	18	13	17	18
20	Villajoyosa	18	17	27	17
21	Novelda CF	18	15	27	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	28	55	14	65
2	UD Alzira	28	36	21	54
3	Atzeneta	28	40	22	50
4	Villarreal	28	46	29	48
5	Intercity	28	49	33	48
6	Eldense	28	36	27	40
7	Saguntino	28	35	28	40
8	Recambios	28	34	32	40
9	Novelda CF	28	35	33	39
10	Olimpic	28	30	29	39
11	Jove	28	37	34	38
12	CD Roda	28	32	41	38
13	Crevillente	28	25	36	34
14	Hércules B	28	27	28	32
15	Ilicitano	28	26	32	30
16	Paterna CF	28	26	37	29
17	Vilamarxant	28	37	54	29
18	CD Acero	28	24	35	26
19	Silla CF	28	20	39	25
20	Benigànim	28	20	66	16

TEMPORADA 2018/2019

PRIMERA FFCV GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Recambios	34	80	13	88
2	Ribarroja	34	68	23	73
3	CD Utiel	34	61	21	69
4	Torrent	34	60	27	69
5	Buñol	34	40	24	56
6	Discóbolo-L	34	48	47	54
7	Burjassot	34	43	48	46
8	SC Requena	34	27	30	45
9	Marcelino	34	43	41	44
10	Quart Poblet	34	39	48	44
11	Benagéber	34	44	44	40
12	Vallbonense	34	37	63	39
13	Juv. Barrio	34	36	51	38
14	Alcàsser	34	45	55	35
15	UD Aldaia	34	30	46	35
16	Mislata	34	34	66	28
17	Castellar-Ol	34	33	64	25
18	Serranos	34	31	88	12

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	At. Levante	40	72	31	84
2	Castellón	40	64	32	83
3	Orihuela CF	40	62	28	78
4	Nucía	40	67	34	71
5	Eldense	40	54	40	70
6	Torre	40	48	27	69
7	Olimpic	40	39	32	60
8	Villarreal	40	53	55	56
9	UD Alzira	40	42	46	51
10	Novelda CF	40	37	42	51
11	CD Roda	40	47	45	51
12	Crevillente	40	35	46	48
13	Paterna CF	40	40	47	47
14	Silla CF	40	47	46	46
15	Rayo Ibense	40	34	48	46
16	Paiporta	40	42	63	43
17	Ilicitano	40	38	46	42
18	Almazora	40	32	64	42
19	Buñol	40	32	44	39
20	CF Borriol	40	34	69	27
21	Recambios	40	32	66	25

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Olimpic	40	68	19	87
2	UD Alzira	40	61	25	80
3	Ontinyent	40	56	29	76
4	Castellón	40	65	31	76
5	Orihuela CF	40	62	31	71
6	Novelda CF	40	46	27	70
7	Villarreal	40	67	47	69
8	Ilicitano	40	58	37	68
9	Torre	40	58	50	61
10	Crevillente	40	39	37	58
11	Silla CF	40	51	57	51
12	Rayo Ibense	40	49	56	49
13	Almazora	40	43	48	48
14	Recambios	40	33	44	46
15	CF Borriol	40	41	55	45
16	Paterna CF	40	35	60	43
17	Buñol	40	44	62	42
18	Muro	40	39	50	39
19	Torrevieja	40	38	71	35
20	Almoradí	40	32	77	27
21	Segorbe	40	22	94	13

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Saguntino	38	62	25	82
2	Ontinyent	38	62	39	71
3	Castellón	38	60	41	70
4	Ilicitano	38	64	39	69
5	Villarreal	38	64	43	61
6	UD Alzira	38	57	50	60
7	Novelda CF	38	51	39	58
8	Orihuela CF	38	50	46	56
9	Torre	38	43	35	55
10	Rayo Ibense	38	38	40	54
11	Torrevieja	38	46	47	52
12	Crevillente	38	41	37	51
13	Muro	38	44	51	49
14	Paterna CF	38	38	53	41
15	CF Borriol	38	36	51	40
16	Recambios	38	42	61	39
17	Buñol	38	22	43	39
18	Jove	38	34	48	38
19	Benigànim	38	41	66	33
20	CD Acero	38	28	69	23

TEMPORADA 2014/2015

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Canals	34	49	30	68
2	Recambios	34	70	35	67
3	Alginet	34	81	47	66
4	UE Gandia	34	52	29	63
5	Dénia	34	58	33	60
6	Jávea	34	67	44	58
7	Portuarios	34	46	43	49
8	Tavernes	34	49	48	46
9	SD Sueca	34	40	49	44
10	CD Llosa	34	35	60	43
11	Contestano	34	43	44	42
12	Racing	34	38	45	40
13	Canalense	34	41	49	40
14	Atlètic	34	41	53	38
15	Pego	34	32	47	35
16	Massanassa	34	41	59	32
17	CD Chella	34	37	62	31
18	Catarroja	34	29	72	23

TEMPORADA 2013/2014

PRIMERA FFCV GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Castellar-Ol	34	61	33	73
2	Torrent	34	60	35	67
3	SC Requena	34	63	34	64
4	Recambios	34	54	30	63
5	Quart Poblet	34	61	36	63
6	Mislata	34	55	44	60
7	Juv. Barrio	34	47	41	56
8	Burjassot	34	56	37	53
9	Cheste	34	51	48	48
10	Alboraya	34	46	42	46
11	Chiva	34	46	53	45
12	Discóbolo-L	34	43	63	38
13	Godella	34	43	59	35
14	Paiporta	34	44	53	35
15	Buñol	34	45	59	35
16	Cf Crack´s	34	37	54	31
17	Fbm Moncada	34	28	77	19
18	Marcelino	34	19	61	18

TEMPORADA 2011/2012

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CF Cullera	34	77	20	72
2	Alginet	34	60	22	71
3	Castellonens	34	56	30	66
4	Canals	34	43	30	56
5	Alberic	34	46	34	55
6	Jávea	34	41	32	54
7	Ciudad	34	50	53	54
8	Pego	34	36	31	51
9	Benigànim	34	53	43	50
10	CD Torrent	34	39	43	45
11	Recambios	34	46	42	44
12	Tavernes	34	35	46	43
13	Carcaixent	34	53	51	42
14	SD Sueca	34	40	49	41
15	Racing	34	28	42	41
16	Torrent	34	36	45	39
17	Aldaia	34	29	77	19
18	Ontinyent B	34	27	105	8

TEMPORADA 2010/2011

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	CD Llosa	34	69	26	80
2	Muro	34	69	31	75
3	Alberic	34	52	22	72
4	Alginet	34	62	32	59
5	Ciudad	34	57	42	57
6	Canals	34	45	39	56
7	Racing	34	49	43	51
8	CD Torrent	34	45	39	51
9	Castellonens	34	39	42	48
10	Benigànim	34	58	57	44
11	Tavernes	34	47	50	44
12	Ontinyent B	34	52	44	41
13	CF Cullera	34	44	41	39
14	Pego	34	49	61	38
15	Recambios	34	30	43	38
16	Xirivella	34	34	91	23
17	Enguera	34	24	66	21
18	Guadasuar	34	33	89	15

TEMPORADA 2009/2010

PRIMERA FFCV GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Alberic	34	63	27	71
2	Muro	34	76	38	63
3	Ciudad	34	63	43	63
4	CD Torrent	34	58	35	62
5	Racing	34	62	46	60
6	Benigànim	34	55	36	59
7	Alginet	34	51	50	49
8	Recambios	34	44	40	45
9	CD Llosa	34	48	49	45
10	Tavernes	34	56	52	44
11	Enguera	34	44	38	43
12	Canals	34	45	44	42
13	Pego	34	43	62	42
14	Guadasuar	34	29	34	41
15	Torrent	34	42	49	40
16	Carlet	34	42	58	33
17	Benifaio	34	35	69	29
18	UD Oliva	34	14	100	6

Competiciones que juega

Lliga Comunitat FFCV Grupo 1

Pos	Equipos		Pts
1		UD Vall de Uxó	57
2		Almazora	46
3		Ribarroja CF	41
4		Recambios Colón	41
5		L´Alcora	41
6		SD Sueca	40
7		Manises	40
8		Buñol	39
9		Onda	38
10		Alqueríes CF	33
11		Nou Jove Castelló	30
12		SC Requena	29
13		Paiporta	27
14		Alboraya	24
15		UD Aldaia	19
16		L'Alcúdia	16

	Ascenso : UD Vall de Uxó
	Playoff Ascenso : Almazora, Ribarroja CF
	Descenso : Alboraya, UD Aldaia, L'Alcúdia

RIVALES EN Lliga Comunitat.

USO DE MEMORIA

6,924,880 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5194
Total Execution Time	0.5206

CADENA URL

/historico/Recambios-Colon

GET DATOS

$_GET['/historico/Recambios-Colon']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0141	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 = 'Recambios-Colon' 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.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=4077 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=4077 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0258	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 = 73539
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4077 AND type_rel = 2
0.0128	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4077 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 (7478,49696,49710,93128,340221) ORDER BY n.cover_points DESC, update_date DESC
0.0131	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 = '4077' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0130	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 = '4077' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127	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 = 73539 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=4077 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (73539,71823) 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.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 73539 AND teamId = 4077
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 71823 AND teamId = 4077
0.0141	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 = 73539 WHERE rp.league_id = 73539 AND rp.teamId = 4077 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.0145	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 = 73539 WHERE rp.league_id = 73539 AND rp.teamId = 4077 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0144	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 = 73539 WHERE rp.league_id = 73539 AND rp.teamId = 4077 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 4077 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0133	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 = 73539 AND t.round = 27 ORDER BY team.conference ASC,t.position 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* `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 = 68782 AND t.round = 34 ORDER BY team.conference ASC,t.position 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* `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 = 62390 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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* `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 = 58584 AND t.round = 22 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* `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 = 44495 AND t.round = 34 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* `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 = 39030 AND t.round = 42 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* `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 = 15447 AND t.round = 38 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* `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 = 4088 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* `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 = 2676 AND t.round = 34 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* `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 = 1461 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* `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 = 1202 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* `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 = 896 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Recambios Colón

Recambios Colón

Selecciona un equipo

Competiciones que juega

Lliga Comunitat FFCV Grupo 1

RIVALES EN Lliga Comunitat.