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

Gamba Osaka

Entrenador: Dani Poyatos

Temporada 2000/2001

TEMPORADA 2000/2001

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Kashima	15	36	19	39
2	Júbilo	15	31	14	39
3	Shimizu	15	34	27	27
4	Sanfrecce	15	36	27	24
5	JEF United	15	25	28	23
6	Nagoya	15	27	25	22
7	Kashiwa	15	29	23	21
8	Yokohama	15	19	20	21
9	FC Tokyo	15	29	28	20
10	Tokyo Verdy	15	22	26	20
11	Gamba Osaka	15	21	26	17
12	Urawa Reds	15	20	24	15
13	Cerezo Osaka	15	19	39	15
14	Consadole	15	23	29	14
15	Vissel Kobe	15	25	32	14
16	Avispa	15	22	31	14

TEMPORADA 1999/2000

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Kashima	15	28	10	34
2	Kashiwa	15	23	10	34
3	Júbilo	15	35	17	30
4	Gamba Osaka	15	27	20	30
5	Yokohama	15	24	24	25
6	Avispa	15	22	20	23
7	FC Tokyo	15	23	19	22
8	Nagoya	15	25	27	22
9	Cerezo Osaka	15	20	24	21
10	Sanfrecce	15	23	25	19
11	Kyoto Sanga	15	23	30	19
12	Tokyo Verdy	15	20	21	18
13	Shimizu	15	13	19	17
14	Kawasaki	15	12	27	14
15	Vissel Kobe	15	19	32	12
16	JEF United	15	15	27	10

TEMPORADA 1998/1999

LIGA JAPONESA J1 - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Júbilo	15	29	15	36
2	Tokyo Verdy	15	20	15	34
3	Shimizu	15	28	23	31
4	Kashiwa	15	26	18	30
5	Cerezo Osaka	15	25	21	30
6	Sanfrecce	15	30	18	27
7	Yokohama	15	31	20	25
8	Nagoya	15	30	23	22
9	Kashima	15	23	19	19
10	Gamba Osaka	15	21	25	18
11	Avispa	15	23	30	18
12	Vissel Kobe	15	20	24	16
13	JEF United	15	19	34	14
14	Urawa Reds	15	21	33	13
15	Kyoto Sanga	15	18	28	12
16	Shonan	15	15	33	9

TEMPORADA 1997/1998

LIGA JAPONESA J1 - 1ª FASE
Equipo		PJ	GF	GC	Puntos
1	Júbilo	17	52	18	39
2	Shimizu	17	32	14	39
3	Nagoya	17	37	21	37
4	Yokohama	17	39	21	33
5	Kashima	17	41	28	33
6	Tokyo Verdy	17	34	25	31
7	Urawa Reds	17	30	23	29
8	Flugels	17	33	32	28
9	Cerezo Osaka	17	36	47	24
10	Kashiwa	17	32	35	23
11	Shonan	17	27	34	22
12	Sanfrecce	17	22	33	22
13	JEF United	17	31	31	21
14	Gamba Osaka	17	27	29	19
15	Kyoto Sanga	17	20	33	18
16	Consadole	17	28	44	15
17	Avispa	17	22	47	9
18	Vissel Kobe	17	20	48	9

TEMPORADA 1996/1997

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Júbilo	16	40	14	42
2	Gamba Osaka	16	38	23	36
3	Yokohama	16	42	28	36
4	Kashima	16	46	23	33
5	Shimizu	16	27	16	30
6	Nagoya	16	23	24	30
7	Urawa Reds	16	26	21	27
8	Cerezo Osaka	16	32	30	25
9	Shonan	16	30	32	23
10	Kashiwa	16	29	31	22
11	Flugels	16	23	27	19
12	JEF United	16	22	32	19
13	Tokyo Verdy	16	22	38	18
14	Sanfrecce	16	21	27	15
15	Avispa	16	18	31	10
16	Kyoto Sanga	16	21	38	10
17	Vissel Kobe	16	19	44	9

TEMPORADA 1995/1996

LIGA JAPONESA J1
Equipo		PJ	GF	GC	Puntos
1	Kashima	30	61	34	62
2	Nagoya	30	63	39	61
3	Flugels	30	58	44	61
4	Kashiwa	30	67	52	60
5	Júbilo	30	53	38	60
6	Tokyo Verdy	30	68	42	57
7	Urawa Reds	30	51	31	55
8	Yokohama	30	39	40	40
9	JEF United	30	45	47	40
10	Shimizu	30	50	60	37
11	Shonan	30	47	58	36
12	Gamba Osaka	30	38	59	31
13	Avispa	30	42	64	29
14	Cerezo Osaka	30	38	56	28
15	Sanfrecce	30	36	60	28
16	Kyoto Sanga	30	22	54	24

TEMPORADA 1994/1995

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Tokyo Verdy	26	60	26	59
2	Nagoya	26	49	34	51
3	Shimizu	26	42	34	43
4	Kashiwa	26	57	54	41
5	Urawa Reds	26	44	38	40
6	Júbilo	26	40	37	40
7	Yokohama	26	39	37	40
8	Kashima	26	44	41	39
9	JEF United	26	49	51	39
10	Flugels	26	36	57	34
11	Cerezo Osaka	26	36	39	33
12	Sanfrecce	26	31	43	28
13	Gamba Osaka	26	38	53	26
14	Shonan	26	34	55	20

TEMPORADA 1993/1994

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Tokyo Verdy	22	48	26	49
2	Shonan	22	48	26	48
3	Yokohama	22	44	26	38
4	Kashima	22	44	36	34
5	Shimizu	22	28	31	34
6	Sanfrecce	22	27	31	31
7	Júbilo	22	29	37	29
8	Flugels	22	31	33	27
9	Gamba Osaka	22	29	36	26
10	JEF United	22	35	42	25
11	Urawa Reds	22	33	51	22
12	Nagoya	22	33	54	20

TEMPORADA 1992/1993

LIGA JAPONESA J1 - 2ª FASE
Equipo		PJ	GF	GC	Puntos
1	Tokyo Verdy	18	43	10	49
2	Shimizu	18	26	9	39
3	Kashima	18	31	25	29
4	Sanfrecce	18	31	25	28
5	Yokohama	18	31	24	27
6	Gamba Osaka	18	24	34	23
7	Flugels	18	20	30	22
8	Nagoya	18	27	28	17
9	JEF United	18	25	44	14
10	Urawa Reds	18	15	44	13

Competiciones que juega

Liga Japonesa J1 - 2ª Fase

Pos	Equipos		Pts
1		Kashima Antlers	39
2		Júbilo Iwata	39
3		Shimizu S-Pulse	27
4		Sanfrecce Hiroshima	24
5		JEF United	23
6		Nagoya Grampus	22
7		Kashiwa Reysol	21
8		Yokohama F. Marinos	21
9		FC Tokyo	20
10		Tokyo Verdy	20
11		Gamba Osaka	17
12		Urawa Reds	15
13		Cerezo Osaka	15
14		Consadole Sapporo	14
15		Vissel Kobe	14
16		Avispa Fukuoka	14

RIVALES EN Copa Emperador

RIVALES EN Liga Japonesa J1.

USO DE MEMORIA

6,174,448 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2017
Total Execution Time	0.2029

CADENA URL

/historico/Gamba-Osaka/2001

GET DATOS

$_GET['/historico/Gamba-Osaka/2001']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0055	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 = 'Gamba-Osaka' AND l.year = 2001 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.0020	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=1199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=1199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=1199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=1199 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032	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 = 27704
0.0032	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 = 27714
0.0034	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 = 27732
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1199 AND type_rel = 2
0.0027	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1199 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025	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 (3231,5286,5904,5940,5960) ORDER BY n.cover_points DESC, update_date DESC
0.0124	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 = '1199' ORDER BY l.year DESC,cat.coefficient DESC
0.0131	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '1199' AND l.year = 2001 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '1199' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 27732 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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 = 27714 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 27704 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0064	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=1199 AND l.year in (2000,2001,2002) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (27738,27717,27706,23564) 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.0053	SELECT count(id) as num_players from rel_players WHERE league_id = 27706 AND teamId = 1199
0.0049	SELECT count(id) as num_players from rel_players WHERE league_id = 27717 AND teamId = 1199
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 23564 AND teamId = 1199
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 27738 AND teamId = 1199
0.0024	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM* `tables2001` 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 = 27704 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0036	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 = '1199' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0017	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1199' and rp.type = 4
0.0020	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 = '1199' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037	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 events2001 e ON e.player_id = p.id AND e.league_id = 27704 WHERE rp.league_id = 27704 AND rp.teamId = 1199 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.0032	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 events2001 e ON e.player_id = p.id AND e.league_id = 27704 WHERE rp.league_id = 27704 AND rp.teamId = 1199 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0030	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 events2001 e ON e.player_id = p.id AND e.league_id = 27704 WHERE rp.league_id = 27704 AND rp.teamId = 1199 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 1199 AND l.year <= 2001 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022	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* `tables2001` 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 = 27714 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables2001` 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 = 27704 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2000` 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 = 27717 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2000` 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 = 27706 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1999` 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 = 27707 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables1999` 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 = 27719 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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* `tables1998` 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 = 27708 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables1998` 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 = 27720 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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* `tables1997` 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 = 29437 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables1997` 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 = 44492 AND t.round = 17 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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* `tables1996` 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 = 44548 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables1995` 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 = 29439 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables1995` 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 = 44550 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024	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* `tables1994` 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 = 29440 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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* `tables1994` 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 = 44551 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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* `tables1993` 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 = 29441 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables1993` 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 = 44552 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	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 = 27704 ORDER BY nameShow LIMIT 100

Gamba Osaka

Gamba Osaka

Selecciona un equipo

Competiciones que juega

Liga Japonesa J1 - 2ª Fase

RIVALES EN Copa Emperador

RIVALES EN Liga Japonesa J1.

RIVALES EN Liga Japonesa J1.