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.

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

Arosa

Entrenador: Luisito

Temporada 1974/1975

TEMPORADA 1968/1969

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	38	85	14	63
2	Langreo	38	86	36	55
3	Compostela	38	88	27	54
4	Ensidesa	38	93	36	53
5	CD Lugo	38	59	42	44
6	Pontevedra	38	38	37	39
7	Martin	38	37	47	38
8	Candás CF	38	39	43	36
9	Deportivo	38	38	45	36
10	Celta Gran.	38	41	55	35
11	Real Oviedo	38	37	46	33
12	Sporting	38	38	63	33
13	Alondras CF	38	48	65	33
14	L´Entregu	38	53	76	32
15	CD Turón	38	45	80	32
16	CD Praviano	38	47	66	31
17	Club Lemos	38	39	59	30
18	Ourense	38	33	60	29
19	Caudal	38	32	43	27
20	Arosa	38	23	59	27

TEMPORADA 1967/1968

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ourense	30	94	10	59
2	Compostela	30	88	28	49
3	Deportivo	30	64	24	42
4	CD Lugo	30	58	34	39
5	Celta Gran.	30	61	56	33
6	Pontevedra	30	52	37	32
7	CD Ourense	30	32	33	31
8	Alondras CF	30	39	48	30
9	Club Lemos	30	30	41	28
10	Celta	30	37	39	26
11	Arosa	30	32	41	24
12	As Pontes	30	39	70	22
13	Arsenal CF	30	28	60	20
14	Rápido	30	35	80	18
15	Club Ordenes	30	37	71	15
16	Betanzos CF	30	25	79	12

TEMPORADA 1966/1967

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	30	88	24	49
2	CD Lugo	30	74	23	48
3	Compostela	30	72	28	44
4	Celta	30	39	39	30
5	Ourense	30	39	35	30
6	Arosa	30	39	42	29
7	Arsenal CF	30	45	48	28
8	Rápido	30	40	48	28
9	Deportivo	30	57	52	28
10	As Pontes	30	39	48	27
11	Club Lemos	30	30	45	27
12	Betanzos CF	30	31	50	25
13	Alondras CF	30	37	66	25
14	Celta Gran.	30	47	56	24
15	Coruxo	30	31	68	22
16	Arenteiro	30	30	66	16

TEMPORADA 1965/1966

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	107	18	52
2	Ourense	30	71	18	49
3	Compostela	30	60	39	40
4	Deportivo	30	69	33	39
5	CD Lugo	30	70	35	38
6	CD Ourense	30	52	44	37
7	Arosa	30	29	44	27
8	Rápido	30	43	60	25
9	Club Lemos	30	39	53	25
10	Arenteiro	30	37	54	23
11	Celta Gran.	30	35	70	23
12	Celta	30	40	59	22
13	Betanzos CF	30	36	70	22
14	Alondras CF	30	34	62	22
15	Coruxo	30	38	71	21
16	Choco	30	31	61	15

TEMPORADA 1964/1965

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	72	19	51
2	Compostela	30	85	29	48
3	CD Lugo	30	62	26	42
4	Deportivo	30	53	30	40
5	Celta Gran.	30	39	48	29
6	Alondras CF	30	47	62	28
7	Choco	30	52	52	26
8	Arosa	30	30	44	26
9	Club Lemos	30	31	48	26
10	Arenteiro	30	31	55	25
11	Ourense	30	37	56	24
12	As Pontes	30	47	63	24
13	CD Foz	30	47	63	23
14	Coruxo	30	38	54	23
15	Arsenal CF	30	34	37	23
16	Celta	30	32	51	22

TEMPORADA 1963/1964

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Compostela	30	91	19	50
2	Deportivo	30	84	22	49
3	Racing	30	106	25	48
4	CD Lugo	30	64	39	38
5	Arsenal CF	30	40	47	32
6	Celta	30	44	52	29
7	CD Foz	30	42	57	29
8	Ourense	30	45	49	28
9	Alondras CF	30	41	49	28
10	Choco	30	38	44	28
11	Arosa	30	29	48	23
12	Celta Gran.	30	38	60	23
13	Club Lemos	30	35	61	22
14	Coruxo	30	32	86	19
15	Bueu	30	32	64	18
16	Marín CF	30	27	66	16

TEMPORADA 1962/1963

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	92	21	53
2	CD Lugo	30	71	20	47
3	Ourense	30	55	37	36
4	Celta	30	41	35	34
5	Alondras CF	30	58	42	34
6	Arosa	30	53	47	34
7	Deportivo	30	39	34	29
8	Club Lemos	30	40	36	28
9	Bueu	29	37	43	28
10	Arsenal CF	30	48	42	27
11	Celta Gran.	30	46	55	26
12	Marín CF	30	33	53	24
13	Coruxo	30	33	52	23
14	CD Foz	30	29	76	21
15	Viveiro	30	25	64	19
16	Zeltia	29	31	74	15

TEMPORADA 1961/1962

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Lugo	30	88	24	48
2	Racing	30	74	27	42
3	Arosa	30	65	49	37
4	Club Lemos	30	48	43	36
5	Ourense	30	62	47	33
6	Arsenal CF	30	49	38	33
7	Celta	30	56	55	31
8	Deportivo	30	54	44	29
9	Alondras CF	30	40	57	27
10	Coruxo	30	46	46	27
11	Zeltia	30	50	52	27
12	Viveiro	29	31	43	26
13	Marín CF	30	41	67	25
14	Celta Gran.	29	42	49	24
15	Choco	30	53	65	24
16	Club	28	25	118	7

TEMPORADA 1960/1961

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	97	33	49
2	CD Lugo	30	71	35	43
3	Celta	30	55	42	35
4	Club Lemos	30	38	35	34
5	Viveiro	30	48	39	34
6	Arsenal CF	30	49	37	32
7	Marín CF	30	45	49	30
8	Deportivo	30	45	58	29
9	Choco	30	52	57	28
10	Arosa	30	53	46	28
11	Club	30	36	42	28
12	Celta Gran.	30	46	52	27
13	Coruxo	30	49	64	26
14	Zeltia	30	55	68	24
15	Club Ordenes	30	35	54	21
16	Flavia	30	21	84	12

TEMPORADA 1959/1960

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Pontevedra	30	88	27	46
2	Celta	30	57	34	40
3	Arsenal CF	30	57	34	39
4	CD Lugo	30	54	27	38
5	Zeltia	29	73	45	37
6	Arosa	29	47	36	33
7	Celta Gran.	30	50	51	30
8	Viveiro	30	41	54	30
9	Flavia	30	51	59	28
10	Coruxo	30	42	53	28
11	Deportivo	30	35	51	25
12	Club Ordenes	30	39	58	24
13	Club	30	38	53	23
14	Club Lemos	30	42	62	22
15	CD Juvenil	30	34	76	19
16	Cambados	30	30	58	14

TEMPORADA 1958/1959

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	30	110	29	48
2	CD Lugo	30	89	36	45
3	Celta	30	87	34	45
4	CD Juvenil	30	66	50	38
5	Club Ordenes	30	43	48	33
6	Arsenal CF	30	46	53	31
7	Celta Gran.	30	58	60	30
8	Zeltia	30	68	69	29
9	Pontevedra	30	54	45	29
10	Arosa	30	42	57	27
11	Flavia	30	53	64	24
12	Cambados	30	47	66	24
13	Deportivo	30	60	66	24
14	Viveiro	30	38	85	22
15	Club	30	42	80	18
16	Juvenil	30	31	92	13

TEMPORADA 1957/1958

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Celta	30	89	16	53
2	CD Ourense	30	85	31	46
3	Celta Gran.	29	84	41	40
4	CD Lugo	30	67	35	39
5	Club	30	48	57	32
6	CD Juvenil	30	55	47	32
7	Deportivo	30	47	55	28
8	Cambados	30	45	68	28
9	Arsenal CF	29	49	33	27
10	Club Ordenes	30	49	61	26
11	Juvenil	30	48	59	25
12	Flavia	30	44	63	25
13	Arosa	30	51	57	25
14	Zeltia	30	38	76	23
15	Club Lemos	30	37	81	16
16	UD Arenal	30	42	98	11

TEMPORADA 1956/1957

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Ourense	34	94	34	51
2	Celta	34	99	41	49
3	CD Lugo	33	62	34	44
4	Arosa	34	55	45	42
5	Arsenal CF	34	58	44	40
6	Club Lemos	34	66	40	39
7	CD Juvenil	34	62	43	38
8	Flavia	34	51	69	36
9	Deportivo	34	51	52	34
10	Club	34	74	55	32
11	Celta Gran.	34	55	50	32
12	Juvenil	34	59	66	30
13	Zeltia	34	48	81	28
14	Pontevedra	34	52	69	27
15	Betanzos CF	33	50	71	25
16	Club Ordenes	34	41	81	25
17	Marín CF	34	40	79	24
18	Ribadeo FC	34	33	96	14

TEMPORADA 1954/1955

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Arsenal CF	18	44	17	25
2	Pontevedra	18	46	31	24
3	Marín CF	18	35	30	24
4	CD Ourense	18	36	25	23
5	Club Lemos	18	29	32	19
6	Celta	18	38	36	16
7	Deportivo	18	36	31	15
8	CD Lugo	18	27	44	13
9	Arosa	18	19	39	11
10	Club	18	19	44	10

TEMPORADA 1953/1954

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CD Juvenil	34	76	43	47
2	Ponferradina	34	80	48	45
3	Real	34	78	47	41
4	Celta	34	66	48	40
5	CD Lugo	34	51	41	40
6	Club Calzada	34	62	52	38
7	Racing Sama	34	61	46	37
8	Martin	34	59	68	36
9	Arsenal CF	34	64	59	36
10	CA Zamora	34	63	56	35
11	Júpiter	34	78	64	34
12	Pontevedra	34	67	69	32
13	CD Turón	34	66	81	30
14	CD Ourense	34	46	75	27
15	Arosa	34	44	73	25
16	Club Lemos	34	43	68	24
17	Marino	34	61	95	23
18	Club	34	47	79	22

TEMPORADA 1952/1953

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Circulo	30	57	28	41
2	Cultural	30	76	34	40
3	Ponferradina	30	69	38	38
4	Arsenal CF	30	53	40	35
5	CD Juvenil	30	48	43	34
6	CD Lugo B	30	41	35	34
7	Arosa	30	47	48	33
8	CA Zamora	30	42	44	29
9	Club Lemos	30	36	55	26
10	CD Turón	30	48	61	26
11	Racing Sama	30	37	59	26
12	Club Calzada	30	41	51	26
13	Pontevedra	30	55	57	25
14	Club	30	41	62	23
15	Marín CF	30	44	59	23
16	Real Oviedo	30	40	61	21

TEMPORADA 1951/1952

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Real Avilés	30	66	24	42
2	Circulo	30	68	40	40
3	Cultural	30	63	40	39
4	Arosa	30	71	50	37
5	Pontevedra	30	59	51	35
6	CA Zamora	30	65	45	33
7	Club Lemos	30	43	58	33
8	Arsenal CF	30	61	51	31
9	Real Oviedo	30	45	46	31
10	Ponferradina	30	64	60	29
11	Club	30	52	49	29
12	Racing Sama	30	61	64	28
13	Real	30	53	95	23
14	La Calzada	30	50	68	20
15	CD Juvenil	30	50	68	18
16	CD Lugo B	30	42	104	12

TEMPORADA 1950/1951

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	CA Zamora	30	111	51	44
2	Caudal	30	86	47	43
3	Real	30	63	45	40
4	CD Juvenil	30	73	50	39
5	Cultural	30	75	50	36
6	Circulo	30	51	47	31
7	Ponferradina	30	62	84	30
8	Racing Sama	30	59	62	30
9	Pontevedra	30	67	67	29
10	Arosa	29	53	63	26
11	Real Avilés	29	60	67	25
12	Real Oviedo	30	56	63	24
13	Arsenal CF	29	45	63	22
14	Club Lemos	30	48	79	22
15	Fábrica	29	38	71	17
16	Club	30	36	74	16

TEMPORADA 1949/1950

SEGUNDA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Racing	30	99	47	48
2	Lleida	30	76	46	41
3	Real	30	89	46	39
4	Real	30	77	59	38
5	Gimnástica	30	73	54	37
6	CE Sabadell	30	84	63	30
7	UD Orensana	30	44	49	28
8	Osasuna	30	71	77	28
9	Girona	30	49	69	27
10	Barakaldo	30	45	62	26
11	SG Lucense	30	54	65	25
12	Racing	30	63	81	25
13	Numancia	30	51	71	24
14	SD Erandio	30	54	86	24
15	Badalona	30	66	80	23
16	Arosa	30	44	84	17

TEMPORADA 1948/1949

TERCERA DIVISIÓN GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UD Orensana	24	60	36	34
2	Arosa	24	61	40	33
3	Circulo	24	61	37	30
4	SG Lucense	23	57	41	30
5	Real Avilés	24	68	44	30
6	Real	24	53	39	23
7	Cultural	24	46	54	23
8	Pontevedra	24	50	64	22
9	Caudal	24	45	50	22
10	CD Juvenil	24	46	50	19
11	Club	24	37	60	18
12	Club Berbés	23	53	69	17
13	Arsenal CF	22	16	69	5
14	Maestranza	0	0	0	0

Competiciones que juega

RIVALES EN Regional

USO DE MEMORIA

7,371,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0011
Controller Execution Time ( Home / Category )	0.1784
Total Execution Time	0.1796

CADENA URL

/historico/Arosa/1975

GET DATOS

$_GET['/historico/Arosa/1975']

POST DATOS

No hay datos POST existentes

CONSULTAS (36)

0.0079	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 = 'Arosa' AND l.year = 1975 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.0018	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=260 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	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=260 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039	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 = 20971
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=260 AND type_rel = 2
0.0033	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 260 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0035	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 (77653,81528,85580,93042,251724) ORDER BY n.cover_points DESC, update_date DESC
0.0109	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 = '260' ORDER BY l.year DESC,cat.coefficient DESC
0.0078	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 = '260' AND l.year = 1975 ORDER BY l.year DESC,cat.coefficient DESC
0.0081	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 = '260' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 20971 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0072	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=260 AND l.year in (1974,1975,1976) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (21013,20971) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 21013 AND teamId = 260
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 20971 AND teamId = 260
0.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables1975` 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 = 20971 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0032	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 = '260' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '260' and rp.type = 4
0.0023	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 = '260' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0025	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 events1975 e ON e.player_id = p.id AND e.league_id = 20971 WHERE rp.league_id = 20971 AND rp.teamId = 260 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.0025	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 events1975 e ON e.player_id = p.id AND e.league_id = 20971 WHERE rp.league_id = 20971 AND rp.teamId = 260 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 events1975 e ON e.player_id = p.id AND e.league_id = 20971 WHERE rp.league_id = 20971 AND rp.teamId = 260 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0063	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 = 260 AND l.year <= 1975 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0031	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* `tables1969` 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 = 20959 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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* `tables1968` 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 = 20958 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables1967` 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 = 20957 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables1966` 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 = 20956 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables1965` 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 = 20955 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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* `tables1964` 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 = 20954 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables1963` 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 = 20953 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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* `tables1953` 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 = 20943 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables1952` 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 = 20942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0037	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* `tables1951` 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 = 20941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables1950` 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 = 21046 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables1949` 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 = 20939 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 20971 ORDER BY nameShow LIMIT 100

Arosa

Arosa

Selecciona un equipo

Competiciones que juega

RIVALES EN Regional