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

Reilac Shiga

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Kochi United	7	16	3	21
2	Veertien	7	12	8	14
3	Okinawa SV	6	13	7	12
4	Reilac Shiga	6	8	6	10
5	TIAMO	6	11	10	10
6	Suzuka Point	7	9	9	10
7	Sony Sendai	7	8	8	10
8	Honda	7	6	4	9
9	Tochigi City	6	10	10	9
10	Verspah Oita	7	9	10	8
11	Yokogawa	7	8	9	8
12	Reinmeer	7	5	6	7
13	Maruyasu	7	8	10	7
14	Minebea	7	4	12	5
15	Criacao	7	3	12	5
16	Urayasu	7	4	10	3

TEMPORADA 2022/2023

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	28	51	26	53
2	Urayasu	28	42	35	45
3	Reilac Shiga	28	47	37	44
4	Sony Sendai	28	46	40	43
5	Reinmeer	28	30	24	42
6	Verspah Oita	28	28	29	40
7	Kochi United	28	30	26	38
8	Maruyasu	28	34	34	37
9	Suzuka Point	28	34	41	36
10	Veertien	28	35	32	35
11	Criacao	28	25	33	34
12	TIAMO	28	32	42	34
13	Yokogawa	28	30	36	32
14	Minebea	28	35	44	31
15	Okinawa SV	28	18	38	26

TEMPORADA 2021/2022

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Nara Club	30	48	25	59
2	Osaka	30	47	34	59
3	Honda	30	47	23	56
4	Reinmeer	30	35	23	51
5	Maruyasu	30	48	34	49
6	Yokogawa	30	49	33	48
7	Veertien	30	43	29	45
8	Verspah Oita	30	40	44	43
9	Suzuka Point	30	31	40	41
10	Minebea	30	33	33	36
11	Kochi United	30	30	39	34
12	Kagura	30	32	42	34
13	TIAMO	30	40	50	32
14	Sony Sendai	30	23	39	28
15	Criacao	30	30	52	24
16	Reilac Shiga	30	21	57	21

TEMPORADA 2020/2021

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Iwaki FC	32	65	28	71
2	Honda	32	69	25	67
3	Verspah Oita	32	46	24	62
4	Suzuka Point	32	51	46	50
5	Kagura	32	38	37	50
6	Sony Sendai	32	52	39	48
7	Osaka	32	37	35	48
8	TIAMO	32	58	57	48
9	Reinmeer	32	41	49	45
10	Nara Club	32	39	36	43
11	Veertien	32	40	43	40
12	Reilac Shiga	32	35	48	37
13	Kochi United	32	30	49	33
14	Maruyasu	32	27	46	33
15	Yokogawa	32	38	53	32
16	Minebea	32	26	48	27
17	FC Kariya	32	26	55	18

TEMPORADA 2019/2020

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Verspah Oita	15	27	16	32
2	Tegevajaro	14	26	11	28
3	Sony Sendai	15	25	22	26
4	Honda	15	20	12	22
5	Suzuka Point	15	23	19	21
6	Veertien	15	17	16	21
7	Iwaki FC	15	24	24	21
8	Reilac Shiga	15	23	27	20
9	Kagura	15	18	24	20
10	Minebea	15	19	25	19
11	Nara Club	15	21	21	18
12	Yokogawa	14	15	17	18
13	Osaka	14	20	24	17
14	Kochi United	15	17	20	16
15	Maruyasu	15	14	22	15
16	Reinmeer	14	17	26	15

TEMPORADA 2018/2019

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	30	59	30	63
2	Sony Sendai	30	60	34	55
3	Imabari	30	41	26	51
4	Yokogawa	30	44	39	48
5	Tegevajaro	30	37	34	41
6	Minebea	30	41	39	41
7	Verspah Oita	30	42	36	40
8	Osaka	30	33	32	40
9	Reilac Shiga	30	27	40	40
10	Veertien	30	38	34	39
11	Maruyasu	30	30	30	38
12	Suzuka Point	30	43	47	36
13	Reinmeer	30	40	44	36
14	Nara Club	30	27	32	34
15	Kagura	30	26	51	25
16	Ryutsu	30	35	75	21

TEMPORADA 2017/2018

LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	15	34	8	41
2	Vanraure	15	20	7	31
3	Sony Sendai	15	37	25	28
4	Imabari	15	35	16	27
5	Reilac Shiga	15	22	17	27
6	Yokogawa	15	28	18	24
7	Verspah Oita	15	16	14	24
8	Osaka	15	22	17	23
9	Tegevajaro	15	23	24	23
10	Maruyasu	15	12	16	18
11	Nara Club	15	11	12	17
12	Veertien	15	22	32	15
13	Reinmeer	15	20	30	15
14	Minebea	15	16	27	12
15	Ryutsu	15	12	37	8
16	Cobaltore	15	10	40	2

TEMPORADA 2016/2017

LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	15	33	9	34
2	Reinmeer	15	27	18	31
3	Vanraure	15	18	13	27
4	Imabari	15	38	21	26
5	Nara Club	15	23	22	26
6	Osaka	15	32	18	25
7	Sony Sendai	15	28	21	23
8	Maruyasu	15	19	22	21
9	Minebea	15	21	23	18
10	Urayasu	15	14	19	17
11	Verspah Oita	15	15	23	15
12	Ryutsu	15	23	31	14
13	Reilac Shiga	15	16	26	14
14	Tochigi Uva	15	7	26	14
15	Yokogawa	15	18	28	13
16	Veertien	15	13	25	10

TEMPORADA 2015/2016

LIGA FÚTBOL JAPÓN - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Ryutsu	15	30	14	35
2	Osaka	15	28	14	32
3	Azul Claro.	15	21	11	29
4	Minebea	15	18	10	26
5	Vanraure	15	19	10	25
6	Honda	15	21	16	25
7	Sony Sendai	15	24	15	23
8	Reilac Shiga	15	19	23	22
9	Urayasu	15	19	22	19
10	Yokogawa	15	10	14	19
11	Reinmeer	15	15	17	17
12	Maruyasu	15	10	15	17
13	Verspah Oita	15	13	18	16
14	Nara Club	15	17	25	14
15	Tochigi Uva	15	19	42	10
16	Fagiano	15	10	27	6

TEMPORADA 2014/2015

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Vanraure	15	21	8	34
2	Sony Sendai	15	22	11	34
3	Honda	15	31	9	33
4	Kagoshima	15	20	11	30
5	Osaka	15	26	11	29
6	Azul Claro.	15	17	12	28
7	Nara Club	15	14	13	23
8	Sagawa	15	24	14	22
9	Minebea	15	16	21	19
10	Reilac Shiga	15	18	17	18
11	Verspah Oita	15	21	27	18
12	Yokogawa	15	15	18	17
13	Ryutsu	15	16	31	10
14	Maruyasu	15	10	26	9
15	Tochigi Uva	15	12	27	8
16	Fagiano	15	7	34	4

TEMPORADA 2013/2014

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Honda	13	36	11	34
2	Kagoshima	13	23	5	34
3	Sagawa	13	21	12	27
4	Sony Sendai	13	26	12	26
5	Verspah Oita	13	17	9	23
6	Renofa	13	25	13	22
7	Azul Claro.	13	11	14	14
8	Yokogawa	13	14	18	12
9	Vanraure	13	11	18	12
10	Fagiano	13	10	22	11
11	Tochigi Uva	13	9	19	10
12	Minebea	13	11	24	10
13	Reilac Shiga	13	9	32	9
14	Maruyasu	13	11	25	8

TEMPORADA 2010/2011

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Sagawa Shiga	33	60	34	70
2	Parceiro	33	51	27	63
3	Machida	33	61	28	61
4	Matsumoto	33	60	38	59
5	V-Varen	33	61	44	56
6	Honda	33	40	36	52
7	Zweigen	33	49	40	47
8	Minebea	33	47	45	47
9	Ryūkyū	33	47	51	46
10	Tochigi Uva	33	40	43	45
11	Kamatamare	33	39	49	40
12	Sagawa	33	43	61	38
13	Reilac Shiga	33	43	65	38
14	Blaublitz	33	38	52	37
15	Yokogawa	33	33	37	36
16	Arte	33	39	55	34
17	United	33	27	63	19
18	Sony Sendai	17	14	24	16

TEMPORADA 2009/2010

LIGA FÚTBOL JAPÓN - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Gainare	34	64	31	77
2	Sagawa Shiga	34	69	35	62
3	Machida	34	71	44	61
4	Honda	34	52	43	59
5	V-Varen	34	50	38	53
6	Sagawa	34	54	46	53
7	Matsumoto	34	48	41	52
8	Blaublitz	34	54	41	51
9	Zweigen	34	46	41	50
10	Ryūkyū	34	51	51	48
11	Reilac Shiga	34	51	56	46
12	Yokogawa	34	34	38	44
13	Minebea	34	36	39	42
14	Sony Sendai	34	34	42	42
15	Tochigi Uva	34	41	75	31
16	United	34	31	55	30
17	Arte	34	28	51	29
18	Ryutsu	34	33	80	19

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

Liga Fútbol Japón - 1ª Fase

Pos	Equipos		Pts
1		Kochi United	21
2		Veertien Kuwana	14
3		Okinawa SV	12
4		Reilac Shiga	10
5		TIAMO Hirakata	10
6		Suzuka Point Getters	10
7		Sony Sendai	10
8		Honda	9
9		Tochigi City	9
10		Verspah Oita	8
11		Yokogawa Musashino	8
12		Reinmeer Aomori	7
13		Maruyasu Industries	7
14		Minebea Mitsumi	5
15		Criacao Shinjuku	5
16		Urayasu	3

	Ascenso : Kochi United
	Playoff Ascenso : Veertien Kuwana
	Playoff Descenso : Criacao Shinjuku
	Descenso : Urayasu

RIVALES EN Liga Fútbol Japó.

USO DE MEMORIA

6,694,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6196
Total Execution Time	0.6208

CADENA URL

/historico/Mio-Biwako-Shiga

GET DATOS

$_GET['/historico/Mio-Biwako-Shiga']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0116	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 = 'Mio-Biwako-Shiga' 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.0107	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=15192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=15192 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0218	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 = 75435
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15192 AND type_rel = 2
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=233 AND type_rel = 3
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 233 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0108	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 (1210510,1085447,1000011,822371,638010) ORDER BY n.cover_points DESC, update_date DESC
0.0110	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 = '15192' ORDER BY l.year DESC,cat.coefficient 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 = '15192' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0111	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 = '15192' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0110	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 = 75435 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116	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=15192 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0112	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 (75435,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.0120	SELECT count(id) as num_players from rel_players WHERE league_id = 75435 AND teamId = 15192
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 71686 AND teamId = 15192
0.0113	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 75435 AND t.round = 8 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0108	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 = '15192' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15192' and rp.type = 4
0.0108	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 = '15192' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0120	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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 15192 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.0114	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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 15192 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0110	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 = 75435 WHERE rp.league_id = 75435 AND rp.teamId = 15192 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0121	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 = 15192 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0120	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 = 75435 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 70962 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 66708 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125	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 = 61094 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.0122	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 = 55426 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 48941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 42642 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 43954 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0122	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 = 37804 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0117	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 = 38924 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 20345 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 23946 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 12822 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 10273 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 4442 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 4443 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 49989 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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 = 49990 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110	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.0115	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
0.0108	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 = 75435 ORDER BY nameShow LIMIT 100

Reilac Shiga

Reilac Shiga

Selecciona un equipo

Competiciones que juega

Liga Fútbol Japón - 1ª Fase

RIVALES EN Liga Fútbol Japó.