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

Shonan Bellmare

Entrenador: Satoshi Yamaguchi

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Cerezo Osaka	10	15	9	19
2	Machida	10	13	10	19
3	Sanfrecce	9	14	5	17
4	Vissel Kobe	10	14	7	17
5	Nagoya	9	9	8	16
6	Yokohama	9	14	11	15
7	FC Tokyo	10	17	15	15
8	Gamba Osaka	9	8	7	15
9	Júbilo	10	15	13	13
10	Kashiwa	8	7	6	13
11	Kashima	9	10	10	13
12	Albirex	10	9	12	12
13	Urawa Reds	9	12	12	11
14	Avispa	9	8	9	11
15	Tokyo Verdy	9	12	13	9
16	Kyoto Sanga	10	8	13	9
17	Kawasaki	9	10	11	8
18	Shonan	10	14	20	7
19	Sagan Tosu	9	11	18	7
20	Consadole	10	9	20	7

TEMPORADA 2022/2023

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Vissel Kobe	34	60	29	71
2	Yokohama	34	63	40	64
3	Sanfrecce	34	42	28	58
4	Urawa Reds	34	42	27	57
5	Kashima	34	43	34	52
6	Nagoya	34	41	36	52
7	Avispa	34	37	43	51
8	Kawasaki	34	51	45	50
9	Cerezo Osaka	34	39	34	49
10	Albirex	34	36	40	45
11	FC Tokyo	34	42	46	43
12	Consadole	34	56	61	40
13	Kyoto Sanga	34	40	45	40
14	Sagan Tosu	34	43	47	38
15	Shonan	34	40	56	34
16	Gamba Osaka	34	38	61	34
17	Kashiwa	34	33	47	33
18	Yokohama	34	31	58	29

TEMPORADA 2021/2022

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Yokohama	34	70	35	68
2	Kawasaki	34	65	42	66
3	Sanfrecce	34	52	41	55
4	Kashima	34	47	42	52
5	Cerezo Osaka	34	46	40	51
6	FC Tokyo	34	46	43	49
7	Kashiwa	34	43	44	47
8	Nagoya	34	30	35	46
9	Urawa Reds	34	48	39	45
10	Consadole	34	45	55	45
11	Sagan Tosu	34	45	44	42
12	Shonan	34	31	39	41
13	Vissel Kobe	34	35	41	40
14	Avispa	34	29	38	38
15	Gamba Osaka	34	33	44	37
16	Kyoto Sanga	34	30	38	36
17	Shimizu	34	44	54	33
18	Júbilo	34	32	57	30

TEMPORADA 2020/2021

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Kawasaki	38	81	28	92
2	Yokohama	38	82	35	79
3	Vissel Kobe	38	62	36	73
4	Kashima	38	62	36	69
5	Nagoya	38	44	30	66
6	Urawa Reds	38	47	38	63
7	Sagan Tosu	38	43	35	59
8	Avispa	38	42	37	54
9	FC Tokyo	38	49	53	53
10	Consadole	38	48	50	51
11	Sanfrecce	38	44	42	49
12	Cerezo Osaka	38	47	51	48
13	Gamba Osaka	38	33	49	44
14	Shimizu	38	37	54	42
15	Kashiwa	38	37	56	41
16	Shonan	38	36	43	37
17	Tokushima	38	34	55	36
18	Oita Trinita	38	31	55	35
19	Vegalta	38	31	62	28
20	Yokohama	38	32	77	27

TEMPORADA 2019/2020

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Kawasaki	34	88	31	83
2	Gamba Osaka	34	46	42	65
3	Nagoya	34	44	27	63
4	Cerezo Osaka	34	46	37	60
5	Kashima	34	54	43	59
6	FC Tokyo	34	47	42	57
7	Kashiwa	34	60	46	52
8	Sanfrecce	34	46	37	48
9	Yokohama	34	69	59	47
10	Urawa Reds	34	43	56	46
11	Oita Trinita	34	36	45	43
12	Sagan Tosu	33	37	41	36
13	Vissel Kobe	34	50	59	36
14	Consadole	33	45	58	36
15	Yokohama	34	38	60	33
16	Shimizu	34	48	70	28
17	Vegalta	34	36	61	28
18	Shonan	34	29	48	27

TEMPORADA 2018/2019

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Yokohama	34	68	38	70
2	FC Tokyo	34	46	29	64
3	Kashima	34	54	30	63
4	Kawasaki	34	57	34	60
5	Cerezo Osaka	34	39	25	59
6	Sanfrecce	34	45	29	55
7	Gamba Osaka	34	54	48	47
8	Vissel Kobe	34	61	59	47
9	Oita Trinita	34	35	35	47
10	Consadole	34	54	49	46
11	Vegalta	34	38	45	41
12	Shimizu	34	45	69	39
13	Nagoya	34	45	50	37
14	Urawa Reds	34	34	50	37
15	Sagan Tosu	34	32	53	36
16	Shonan	34	40	63	36
17	Matsumoto	34	21	40	31
18	Júbilo	34	29	51	31

TEMPORADA 2017/2018

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Kawasaki	34	57	27	69
2	Sanfrecce	34	47	35	57
3	Kashima	34	50	39	56
4	Consadole	34	48	48	55
5	Urawa Reds	34	51	39	51
6	FC Tokyo	34	39	34	50
7	Cerezo Osaka	34	39	38	50
8	Shimizu	34	56	48	49
9	Gamba Osaka	34	41	46	48
10	Vissel Kobe	34	45	52	45
11	Vegalta	34	44	54	45
12	Yokohama	34	56	56	41
13	Shonan	34	38	43	41
14	Sagan Tosu	34	29	34	41
15	Nagoya	34	52	59	41
16	Júbilo	34	35	48	41
17	Kashiwa	34	47	54	39
18	V-Varen	34	39	59	30

TEMPORADA 2016/2017

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Shonan	42	58	36	83
2	V-Varen	42	59	41	80
3	Nagoya	42	85	65	75
4	Avispa	42	54	36	74
5	Tokyo Verdy	42	64	49	70
6	JEF United	42	70	58	68
7	Tokushima	42	71	45	67
8	Matsumoto	42	61	45	66
9	Oita Trinita	42	58	50	64
10	Yokohama	42	60	49	63
11	Montedio	42	45	47	59
12	Kyoto Sanga	42	55	47	57
13	Fagiano	42	44	49	55
14	Mito	42	45	48	54
15	Ehime	42	54	68	51
16	Machida	42	53	53	50
17	Zweigen	42	49	67	49
18	Gifu	42	56	68	46
19	Kamatamare	42	41	61	38
20	Renofa	42	48	69	38
21	Roasso	42	36	59	37
22	Thespa Gunma	42	32	88	20

TEMPORADA 2015/2016

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Urawa Reds	17	35	12	41
2	Vissel Kobe	17	33	18	35
3	Kawasaki	17	35	24	34
4	Gamba Osaka	17	31	22	34
5	Kashiwa	17	32	23	30
6	Omiya Ardija	17	24	18	30
7	Yokohama	17	32	19	29
8	Sagan Tosu	17	26	22	29
9	FC Tokyo	17	23	21	29
10	Sanfrecce	17	26	22	26
11	Kashima	17	24	24	20
12	Vegalta	17	19	23	20
13	Ventforet	17	14	27	16
14	Júbilo	17	16	27	13
15	Nagoya	17	14	29	13
16	Albirex	17	14	24	12
17	Shonan	17	12	29	11
18	Avispa	17	15	41	8

TEMPORADA 2014/2015

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Sanfrecce	17	44	14	40
2	Kashima	17	30	16	37
3	Gamba Osaka	17	32	24	31
4	Urawa Reds	17	30	23	31
5	Yokohama	17	24	15	29
6	FC Tokyo	17	21	15	28
7	Kawasaki	17	30	22	27
8	Kashiwa	17	24	18	27
9	Shonan	17	20	20	26
10	Nagoya	17	26	30	24
11	Albirex	17	21	25	20
12	Sagan Tosu	17	15	22	20
13	Vissel Kobe	17	27	30	19
14	Ventforet	17	14	21	17
15	Matsumoto	17	13	28	13
16	Vegalta	17	17	28	12
17	Shimizu	17	15	33	12
18	Montedio	17	10	29	10

TEMPORADA 2013/2014

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Shonan	42	86	25	101
2	Matsumoto	42	65	35	83
3	JEF United	42	55	44	68
4	Júbilo	42	67	55	67
5	Giravanz	42	50	50	65
6	Montedio	42	57	44	64
7	Oita Trinita	42	52	55	63
8	Fagiano	42	52	48	61
9	Kyoto Sanga	42	57	52	60
10	Consadole	42	48	44	59
11	Yokohama	42	49	47	55
12	Tochigi	42	52	58	55
13	Roasso	42	45	53	54
14	V-Varen	42	45	42	52
15	Mito	42	46	46	50
16	Avispa	42	52	60	50
17	Gifu	42	54	61	49
18	Thespa Gunma	42	45	54	49
19	Ehime	42	54	58	48
20	Tokyo Verdy	42	31	48	42
21	Kamatamare	42	34	71	33
22	Kataller	42	28	74	23

TEMPORADA 2012/2013

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Sanfrecce	34	51	29	63
2	Yokohama	34	49	31	62
3	Kawasaki	34	65	51	60
4	Cerezo Osaka	34	53	32	59
5	Kashima	34	60	52	59
6	Urawa Reds	34	66	57	56
7	Albirex	34	49	42	56
8	FC Tokyo	34	61	47	54
9	Shimizu	34	48	57	50
10	Kashiwa	34	56	59	48
11	Nagoya	34	47	48	47
12	Sagan Tosu	34	54	63	46
13	Vegalta	34	41	38	45
14	Omiya Ardija	34	45	48	45
15	Ventforet	34	30	41	37
16	Shonan	34	34	62	25
17	Júbilo	34	40	56	23
18	Oita Trinita	34	31	67	14

TEMPORADA 2011/2012

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Ventforet	42	63	35	86
2	Shonan	42	66	43	75
3	Kyoto Sanga	42	61	45	74
4	Yokohama	42	62	45	73
5	JEF United	42	61	33	72
6	Oita Trinita	42	59	40	71
7	Tokyo Verdy	42	65	46	66
8	Fagiano	42	41	34	65
9	Giravanz	42	53	47	64
10	Montedio	42	51	49	61
11	Tochigi	42	50	49	60
12	Matsumoto	42	46	43	59
13	Mito	42	47	49	56
14	Roasso	42	40	48	55
15	Tokushima	42	45	49	51
16	Ehime	42	47	46	50
17	Thespa Gunma	42	31	45	47
18	Avispa	42	53	68	41
19	Kataller	42	38	59	38
20	Gainare	42	33	78	38
21	Gifu	42	27	55	35
22	Machida	42	34	67	32

TEMPORADA 2010/2011

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	FC Tokyo	38	67	22	77
2	Sagan Tosu	38	68	34	69
3	Consadole	38	49	32	68
4	Tokushima	38	51	38	65
5	Tokyo Verdy	38	69	45	59
6	JEF United	38	46	39	58
7	Kyoto Sanga	38	50	45	58
8	Giravanz	38	45	46	58
9	Thespa Gunma	38	51	51	57
10	Tochigi	38	44	39	56
11	Roasso	38	33	44	51
12	Oita Trinita	38	42	45	50
13	Fagiano	38	43	58	48
14	Shonan	38	46	48	46
15	Ehime	38	44	54	44
16	Kataller	38	36	53	43
17	Mito	38	40	49	42
18	Yokohama	38	40	54	41
19	Gainare	38	36	60	31
20	Gifu	38	39	83	24

TEMPORADA 2009/2010

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Nagoya	34	54	37	72
2	Gamba Osaka	34	65	44	62
3	Cerezo Osaka	34	58	32	61
4	Kashima	34	51	31	60
5	Kawasaki	34	61	47	54
6	Shimizu	34	60	49	54
7	Sanfrecce	34	45	38	51
8	Yokohama	34	43	39	51
9	Albirex	34	48	45	49
10	Urawa Reds	34	48	41	48
11	Júbilo	34	38	49	44
12	Omiya Ardija	34	39	45	42
13	Montedio	34	29	42	42
14	Vegalta	34	40	46	39
15	Vissel Kobe	34	37	45	38
16	FC Tokyo	34	36	41	36
17	Kyoto Sanga	34	30	60	19
18	Shonan	34	31	82	16

TEMPORADA 2008/2009

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Vegalta	51	87	39	106
2	Cerezo Osaka	51	100	53	104
3	Shonan	51	84	52	98
4	Ventforet	51	76	46	97
5	Sagan Tosu	51	71	51	88
6	Consadole	51	74	61	79
7	Tokyo Verdy	51	68	61	74
8	Mito	51	70	79	73
9	Tokushima	51	67	52	72
10	Thespa Gunma	51	64	76	65
11	Avispa	51	52	71	65
12	Gifu	51	62	72	62
13	Kataller	51	48	58	61
14	Roasso	51	66	82	58
15	Ehime	51	54	80	47
16	Yokohama	51	43	70	44
17	Tochigi	51	38	77	37
18	Fagiano	51	40	84	36

TEMPORADA 2007/2008

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Sanfrecce	42	99	35	100
2	Montedio	42	66	40	78
3	Vegalta	42	62	47	70
4	Cerezo Osaka	42	81	60	69
5	Shonan	42	68	48	65
6	Sagan Tosu	42	50	51	64
7	Ventforet	42	56	47	59
8	Avispa	42	55	66	58
9	Thespa Gunma	42	45	52	53
10	Yokohama	42	51	56	50
11	Mito	42	52	70	47
12	Roasso	42	46	72	43
13	Gifu	42	41	69	42
14	Ehime	42	39	66	37
15	Tokushima	42	40	72	29

TEMPORADA 2006/2007

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Consadole	48	66	45	91
2	Tokyo Verdy	48	90	57	89
3	Kyoto Sanga	48	80	59	86
4	Vegalta	48	72	54	83
5	Cerezo Osaka	48	72	55	80
6	Shonan	48	72	55	77
7	Avispa	48	77	61	73
8	Sagan Tosu	48	63	66	72
9	Montedio	48	46	56	58
10	Ehime	48	39	66	45
11	Thespa Gunma	48	42	71	42
12	Mito	48	32	70	34
13	Tokushima	48	31	67	33

Competiciones que juega

Liga Japonesa J1

Pos	Equipos		Pts
1		Cerezo Osaka	19
2		Machida Zelvia	19
3		Sanfrecce Hiroshima	17
4		Vissel Kobe	17
5		Nagoya Grampus	16
6		Yokohama F. Marinos	15
7		FC Tokyo	15
8		Gamba Osaka	15
9		Júbilo Iwata	13
10		Kashiwa Reysol	13
11		Kashima Antlers	13
12		Albirex Niigata	12
13		Urawa Reds	11
14		Avispa Fukuoka	11
15		Tokyo Verdy	9
16		Kyoto Sanga	9
17		Kawasaki Frontale	8
18		Shonan Bellmare	7
19		Sagan Tosu	7
20		Consadole Sapporo	7

	Campeón : Cerezo Osaka
	: Machida Zelvia
	: Sanfrecce Hiroshima
	Descenso : Shonan Bellmare, Sagan Tosu, Consadole Sapporo

RIVALES EN Copa de la Liga.

RIVALES EN Liga Japonesa J1

USO DE MEMORIA

7,822,992 bytes

BENCHMARKS

Loading Time Base Classes	0.0017
Controller Execution Time ( Home / Category )	0.7147
Total Execution Time	0.7165

CADENA URL

/historico/Shonan-Bellmare

GET DATOS

$_GET['/historico/Shonan-Bellmare']

POST DATOS

No hay datos POST existentes

CONSULTAS (38)

0.0144	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4521 AND type_rel = 2
0.0146	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4521 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (55281,371173,635934,641452,672136) ORDER BY n.cover_points DESC, update_date DESC
0.0156	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 = '4521' ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '4521' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 75185 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0155	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=4521 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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 (75185,74986,71686) 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.0153	SELECT count(id) as num_players from rel_players WHERE league_id = 74986 AND teamId = 4521
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 4521
0.0159	SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 4521
0.0146	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 = '4521' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4521' 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 = '4521' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0174	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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4521 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.0175	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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4521 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 74986 WHERE rp.league_id = 74986 AND rp.teamId = 4521 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157	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 = 4521 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0151	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 = 74986 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 70787 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.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* `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 = 66261 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.0151	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 = 61091 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.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* `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 = 55273 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.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* `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 = 48456 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 42417 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 37765 AND t.round = 42 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* `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 = 20266 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 20311 AND t.round = 17 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* `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 = 10155 AND t.round = 17 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* `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 = 10156 AND t.round = 17 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 = 3562 AND t.round = 42 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 = 2286 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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 = 1641 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 1351 AND t.round = 38 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* `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 = 1066 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 13520 AND t.round = 51 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* `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 = 13519 AND t.round = 45 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* `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 = 13518 AND t.round = 52 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Shonan Bellmare

Shonan Bellmare

Selecciona un equipo

Competiciones que juega

Liga Japonesa J1

RIVALES EN Copa de la Liga.

RIVALES EN Liga Japonesa J1