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

Giravanz Kitakyushu

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Omiya Ardija	11	21	7	27
2	Azul Claro.	11	21	11	21
3	Osaka	11	15	6	20
4	Imabari	11	14	12	20
5	Gifu	11	18	11	19
6	Sagamihara	11	10	8	17
7	Ryūkyū	11	17	16	16
8	Gainare	11	11	12	16
9	Matsumoto	11	15	17	16
10	Zweigen	11	20	20	15
11	Parceiro	11	19	19	14
12	Kataller	11	9	11	14
13	Fukushima	11	17	14	11
14	Giravanz	11	8	9	11
15	YSCC	11	9	14	10
16	Nara Club	11	13	17	9
17	Tegevajaro	11	11	17	9
18	Grulla	11	9	25	9
19	Vanraure	11	6	12	8
20	Kamatamare	11	11	16	7

TEMPORADA 2022/2023

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Ehime	38	59	48	73
2	Kagoshima	38	58	41	62
3	Kataller	38	59	48	62
4	Imabari	38	54	42	59
5	Nara Club	38	45	32	57
6	Gainare	38	57	52	56
7	Vanraure	38	49	47	56
8	Gifu	38	44	35	54
9	Matsumoto	38	51	47	54
10	Grulla	38	48	49	54
11	Osaka	38	41	38	53
12	YSCC	38	48	50	52
13	Azul Claro.	38	48	48	51
14	Parceiro	38	52	60	50
15	Fukushima	38	37	42	47
16	Kamatamare	38	29	45	44
17	Ryūkyū	38	43	61	43
18	Sagamihara	38	44	48	41
19	Tegevajaro	38	31	52	39
20	Giravanz	38	33	45	31

TEMPORADA 2021/2022

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Iwaki FC	34	72	23	76
2	Fujieda MYFC	34	58	29	67
3	Kagoshima	34	55	39	66
4	Matsumoto	34	46	33	66
5	Imabari	34	55	40	60
6	Kataller	34	55	48	60
7	Ehime	34	51	41	52
8	Parceiro	34	42	41	52
9	Tegevajaro	34	45	47	46
10	Vanraure	34	32	46	43
11	Fukushima	34	37	45	42
12	Gainare	34	55	56	41
13	Giravanz	34	41	45	40
14	Gifu	34	43	53	37
15	Azul Claro.	34	27	46	31
16	YSCC	34	25	66	28
17	Kamatamare	34	27	49	27
18	Sagamihara	34	31	50	25

TEMPORADA 2020/2021

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Júbilo	42	75	42	91
2	Kyoto Sanga	42	59	31	84
3	Ventforet	42	65	38	80
4	V-Varen	42	69	44	78
5	Machida	42	64	38	72
6	Albirex	42	61	40	68
7	Montedio	42	61	49	68
8	JEF United	42	48	36	66
9	Ryūkyū	42	57	47	65
10	Mito	42	59	50	59
11	Fagiano	42	40	36	59
12	Tokyo Verdy	42	62	66	58
13	Blaublitz	42	41	53	47
14	Tochigi	42	37	51	45
15	Renofa	42	37	51	43
16	Omiya Ardija	42	51	56	42
17	Zweigen	42	39	60	41
18	Thespa Gunma	42	35	56	41
19	Sagamihara	42	33	54	38
20	Ehime	42	38	67	35
21	Giravanz	42	35	66	35
22	Matsumoto	42	36	71	34

TEMPORADA 2019/2020

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Tokushima	42	67	33	84
2	Avispa	42	51	29	84
3	V-Varen	42	66	39	80
4	Ventforet	42	50	41	65
5	Giravanz	42	59	51	65
6	Júbilo	42	58	47	63
7	Montedio	42	59	42	62
8	Kyoto Sanga	42	47	45	59
9	Mito	42	68	62	58
10	Tochigi	42	41	39	58
11	Albirex	42	55	55	57
12	Tokyo Verdy	42	48	48	54
13	Matsumoto	42	44	52	54
14	JEF United	42	47	51	53
15	Omiya Ardija	42	43	52	53
16	Ryūkyū	42	58	61	50
17	Fagiano	42	39	49	50
18	Zweigen	42	57	67	49
19	Machida	42	41	52	49
20	Thespa Gunma	42	40	62	49
21	Ehime	42	38	68	34
22	Renofa	42	43	74	33

TEMPORADA 2018/2019

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Giravanz	34	51	27	66
2	Thespa Gunma	34	59	34	63
3	Fujieda MYFC	34	42	31	63
4	Kataller	34	54	31	58
5	Roasso	34	45	39	57
6	Cerezo Osaka	34	49	56	52
7	Blaublitz	34	45	35	49
8	Vanraure	34	49	42	48
9	Gainare	33	48	59	47
10	Parceiro	33	32	34	46
11	Fukushima	33	45	51	43
12	Azul Claro.	34	35	43	39
13	YSCC	33	53	62	39
14	Kamatamare	33	33	48	39
15	Sagamihara	34	36	45	38
16	Tokyo	34	43	52	36
17	Gamba Osaka	34	54	55	35
18	Grulla	33	34	63	23

TEMPORADA 2017/2018

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Ryūkyū	32	70	40	66
2	Kagoshima	32	46	35	57
3	Gainare	32	61	47	53
4	Azul Claro.	32	40	29	52
5	Thespa Gunma	32	37	35	52
6	Gamba Osaka	32	53	43	47
7	Cerezo Osaka	32	47	36	46
8	Blaublitz	32	37	35	43
9	Sagamihara	32	42	53	42
10	Parceiro	32	39	37	41
11	Kataller	32	41	50	41
12	Fukushima	32	36	43	40
13	Grulla	32	41	56	40
14	Tokyo	32	38	45	36
15	YSCC	32	40	48	34
16	Fujieda MYFC	32	32	48	34
17	Giravanz	32	22	42	27

TEMPORADA 2016/2017

TERCERA JAPONESA J3
Equipo		PJ	GF	GC	Puntos
1	Blaublitz	32	53	31	61
2	Tochigi	32	44	24	60
3	Azul Claro.	32	60	27	59
4	Kagoshima	32	49	37	55
5	Parceiro	32	34	25	50
6	Ryūkyū	32	44	36	50
7	Fujieda MYFC	32	50	43	47
8	Kataller	32	37	33	47
9	Giravanz	32	44	37	46
10	Fukushima	32	39	43	43
11	Tokyo	32	36	47	43
12	Sagamihara	32	34	41	39
13	Cerezo Osaka	32	39	43	35
14	YSCC	32	41	54	32
15	Grulla	32	32	49	29
16	Gamba Osaka	32	31	65	26
17	Gainare	32	31	63	21

TEMPORADA 2015/2016

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Consadole	42	65	33	85
2	Shimizu	42	85	37	84
3	Matsumoto	42	62	32	84
4	Cerezo Osaka	42	62	46	78
5	Kyoto Sanga	42	50	37	69
6	Fagiano	42	58	44	65
7	Machida	42	53	44	65
8	Yokohama	42	50	51	59
9	Tokushima	42	46	42	57
10	Ehime	42	41	40	56
11	JEF United	42	52	53	53
12	Renofa	42	55	63	53
13	Mito	42	45	49	48
14	Montedio	42	43	49	47
15	V-Varen	42	39	51	47
16	Roasso	42	38	53	46
17	Thespa Gunma	42	52	66	45
18	Tokyo Verdy	42	43	61	43
19	Kamatamare	42	43	62	43
20	Gifu	42	47	71	43
21	Zweigen	42	36	60	39
22	Giravanz	42	43	64	38

TEMPORADA 2014/2015

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Omiya Ardija	42	72	37	86
2	Júbilo	42	72	43	82
3	Avispa	42	63	37	82
4	Cerezo Osaka	42	57	40	67
5	Ehime	42	47	39	65
6	V-Varen	42	42	33	60
7	Giravanz	42	59	58	59
8	Tokyo Verdy	42	42	41	58
9	JEF United	42	50	45	57
10	Consadole	42	47	43	57
11	Fagiano	42	40	35	54
12	Zweigen	42	46	43	54
13	Roasso	42	42	45	53
14	Tokushima	42	35	44	53
15	Yokohama	42	33	58	52
16	Kamatamare	42	30	33	51
17	Kyoto Sanga	42	45	51	50
18	Thespa Gunma	42	34	55	48
19	Mito	42	40	47	46
20	Gifu	42	37	71	43
21	Oita Trinita	42	41	51	38
22	Tochigi	42	39	64	35

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

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Gamba Osaka	42	99	46	87
2	Vissel Kobe	42	78	41	83
3	Kyoto Sanga	42	68	46	70
4	Tokushima	42	56	51	67
5	JEF United	42	68	49	66
6	V-Varen	42	48	40	66
7	Matsumoto	42	54	54	66
8	Consadole	42	60	49	64
9	Tochigi	42	61	55	63
10	Montedio	42	74	61	59
11	Yokohama	42	49	46	58
12	Fagiano	42	52	48	56
13	Tokyo Verdy	42	52	58	56
14	Avispa	42	47	54	56
15	Mito	42	50	58	55
16	Giravanz	42	50	60	49
17	Ehime	42	43	52	47
18	Kataller	42	45	59	44
19	Roasso	42	40	70	43
20	Thespa Gunma	42	43	61	40
21	Gifu	42	37	80	37
22	Gainare	42	38	74	31

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

SEGUNDA JAPONESA J2
Equipo		PJ	GF	GC	Puntos
1	Kashiwa	36	71	24	80
2	Ventforet	36	71	40	70
3	Avispa	36	63	34	69
4	JEF United	36	58	37	61
5	Tokyo Verdy	36	47	34	58
6	Yokohama	36	54	47	54
7	Roasso	36	39	43	54
8	Tokushima	36	51	47	51
9	Sagan Tosu	36	42	41	51
10	Tochigi	36	46	42	50
11	Ehime	36	34	34	48
12	Thespa Gunma	36	36	48	48
13	Consadole	36	37	38	46
14	Gifu	36	32	45	45
15	Oita Trinita	36	39	49	41
16	Mito	36	29	45	38
17	Fagiano	36	27	51	32
18	Kataller	36	39	71	28
19	Giravanz	36	20	65	15

TEMPORADA 2008/2009

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Sagawa Shiga	34	62	36	66
2	Yokogawa	34	48	34	60
3	Sony Sendai	34	49	30	59
4	Giravanz	34	49	31	58
5	Gainare	34	65	37	56
6	Machida	34	38	30	54
7	Honda	34	49	38	51
8	Reilac Shiga	34	51	43	48
9	Sagawa	34	56	46	47
10	Blaublitz	34	39	54	46
11	V-Varen	34	38	43	44
12	United	34	26	37	41
13	Minebea	34	34	38	40
14	Arte	34	34	46	40
15	Ryutsu	34	41	55	40
16	Ryūkyū	34	42	57	38
17	FC Kariya	34	26	51	31
18	Mizushima	34	28	69	18

TEMPORADA 2007/2008

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	34	77	33	69
2	Tochigi	34	64	36	65
3	Kataller	34	56	34	60
4	Yokogawa	34	46	31	60
5	Fagiano	34	59	43	57
6	Gainare	34	56	41	56
7	Ryutsu	34	53	47	55
8	Sagawa	34	43	39	53
9	Sony Sendai	34	53	41	50
10	Giravanz	34	48	47	49
11	FC Kariya	34	43	39	48
12	Sagawa Shiga	34	52	46	47
13	Blaublitz	34	47	46	41
14	Reilac Shiga	34	39	61	38
15	Ryūkyū	34	31	53	29
16	United	34	30	53	28
17	Arte	34	38	102	18
18	Mizushima	34	29	72	17

Competiciones que juega

Tercera Japonesa J3

Pos	Equipos		Pts
1		Omiya Ardija	27
2		Azul Claro Numazu	21
3		Osaka	20
4		Imabari	20
5		Gifu	19
6		Sagamihara	17
7		Ryūkyū	16
8		Gainare Tottori	16
9		Matsumoto Yamaga	16
10		Zweigen Kanazawa	15
11		Parceiro Nagano	14
12		Kataller Toyama	14
13		Fukushima United	11
14		Giravanz Kitakyushu	11
15		YSCC	10
16		Nara Club	9
17		Tegevajaro Miyazaki	9
18		Grulla Morioka	9
19		Vanraure Hachinohe	8
20		Kamatamare Sanuki	7

	Ascenso : Omiya Ardija, Azul Claro Numazu, Osaka

RIVALES EN Copa de la Liga.

RIVALES EN Tercera Japonesa.

USO DE MEMORIA

7,813,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6440
Total Execution Time	0.6452

CADENA URL

/historico/Giravanz-Kitak

GET DATOS

$_GET['/historico/Giravanz-Kitak']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.0138	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 = 'Giravanz-Kitak' 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.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=5782 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=5782 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=5782 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5782 AND type_rel = 2
0.0124	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=515 AND type_rel = 3
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 515 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128	SELECT /53 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 (1194856,840228,812834,543923,269590) ORDER BY n.cover_points DESC, update_date DESC
0.0140	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 = '5782' ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '5782' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '5782' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131	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=5782 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128	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,74985,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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 74985 AND teamId = 5782
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 75185 AND teamId = 5782
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 5782
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 = '5782' 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 = '5782' 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 = '5782' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148	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 = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 5782 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 events2024 e ON e.player_id = p.id AND e.league_id = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 5782 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128	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 = 74985 WHERE rp.league_id = 74985 AND rp.teamId = 5782 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 5782 AND l.year <= 2024 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* `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 = 74985 AND t.round = 12 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* `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 = 70796 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* `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 = 66262 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* `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 = 61092 AND t.round = 42 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* `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 = 55275 AND t.round = 42 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* `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 = 48804 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 42574 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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,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 = 37773 AND t.round = 34 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 = 20246 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* `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 = 10157 AND t.round = 42 ORDER BY team.conference 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* `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.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* `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 = 2299 AND t.round = 42 ORDER BY team.conference 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* `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.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* `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.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* `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 = 13521 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* `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 = 49991 AND t.round = 34 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* `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 = 49992 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Giravanz Kitakyushu

Giravanz Kitakyushu

Selecciona un equipo

Competiciones que juega

Tercera Japonesa J3

RIVALES EN Copa de la Liga.

RIVALES EN Tercera Japonesa.