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

Resultados de Fútbol

Dinamo Zagreb

Entrenador: Sergej Jakirovic

Temporada 2016/2017

TEMPORADA 2016/2017

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	HNK Rijeka	36	71	23	88
2	Dinamo	36	68	24	86
3	Hajduk Split	36	70	31	69
4	NK Osijek	36	52	37	66
5	Lokomotiva	36	41	38	44
6	Istra 1961	36	33	49	39
7	Slaven	36	36	45	38
8	Inter	36	26	57	28
9	HNK Cibalia	36	26	79	21
10	Split	36	12	52	18

TEMPORADA 2015/2016

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	67	19	85
2	HNK Rijeka	36	56	20	77
3	Hajduk Split	36	46	28	61
4	Lokomotiva	36	56	53	52
5	Inter	36	39	48	47
6	Split	36	28	29	46
7	Slaven	36	41	42	42
8	NK Osijek	36	27	49	34
9	Istra 1961	36	23	58	24
10	NK Zagreb	36	27	64	17

TEMPORADA 2014/2015

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	85	21	88
2	HNK Rijeka	36	76	29	75
3	Hajduk Split	36	59	56	53
4	Lokomotiva	36	59	68	46
5	NK Zagreb	36	45	54	46
6	Slaven	36	38	49	42
7	Split	36	42	49	41
8	NK Osijek	36	42	59	36
9	Istra 1961	36	36	59	35
10	Zadar	36	37	75	32

TEMPORADA 2013/2014

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	36	81	26	84
2	HNK Rijeka	36	72	35	73
3	Hajduk Split	36	58	42	62
4	Split	36	41	41	52
5	Lokomotiva	36	57	59	52
6	Istra 1961	36	45	56	44
7	Zadar	36	35	67	35
8	NK Osijek	36	38	62	33
9	Slaven	36	46	65	32
10	Hrvatski	36	41	61	30

TEMPORADA 2012/2013

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	33	68	20	77
2	Lokomotiva	33	54	38	57
3	HNK Rijeka	33	46	42	53
4	Hajduk Split	33	45	31	52
5	Split	33	49	37	52
6	Istra 1961	33	35	32	44
7	NK Osijek	33	25	33	39
8	Slaven	33	35	50	39
9	Zadar	33	39	61	36
10	Inter	33	36	41	35
11	HNK Cibalia	33	29	44	32
12	NK Zagreb	33	28	60	27

TEMPORADA 2011/2012

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	73	11	75
2	Hajduk Split	30	50	24	54
3	Slaven	30	41	27	52
4	Split	30	43	32	50
5	HNK Cibalia	30	35	35	45
6	NK Zagreb	30	36	42	45
7	Lokomotiva	30	33	33	44
8	NK Osijek	30	45	38	43
9	Istra 1961	30	35	33	42
10	Zadar	30	29	44	40
11	Inter	30	33	33	38
12	HNK Rijeka	30	29	29	38
13	Lučko	30	29	36	31
14	HNK Sibenik	30	27	39	27
15	Karlovac	30	25	53	24
16	NK Varazdin	30	16	70	8

TEMPORADA 2010/2011

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	52	12	72
2	Hajduk Split	30	54	32	55
3	Split	30	38	22	53
4	HNK Cibalia	30	33	24	44
5	Inter	30	31	35	42
6	Karlovac	30	25	27	41
7	Slaven	30	34	30	40
8	NK Osijek	30	31	29	39
9	HNK Rijeka	30	29	35	39
10	Zadar	30	31	34	38
11	NK Varazdin	30	32	38	36
12	HNK Sibenik	30	37	38	35
13	NK Zagreb	30	32	39	35
14	Lokomotiva	30	24	37	33
15	Istra 1961	30	24	44	31
16	Hrvatski	30	24	55	23

TEMPORADA 2009/2010

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	30	70	20	62
2	Hajduk Split	30	50	21	58
3	HNK Cibalia	30	46	20	57
4	HNK Sibenik	30	34	37	50
5	NK Osijek	30	49	36	47
6	Karlovac	30	32	23	47
7	Slaven	30	44	45	43
8	Lokomotiva	30	35	38	42
9	HNK Rijeka	30	49	44	40
10	NK Varazdin	30	36	43	36
11	Istra 1961	30	31	40	35
12	Zadar	30	27	41	34
13	NK Zagreb	30	43	49	33
14	Inter	30	36	50	33
15	Medjimurje	30	37	61	29
16	Croatia	30	30	81	14

TEMPORADA 2008/2009

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	33	71	26	74
2	Hajduk Split	33	59	25	68
3	HNK Rijeka	33	50	44	56
4	Slaven	33	46	39	55
5	NK Zagreb	33	38	39	47
6	HNK Sibenik	33	44	35	46
7	NK Osijek	33	40	41	41
8	HNK Cibalia	33	33	53	38
9	Inter	33	41	50	36
10	NK Varazdin	33	41	55	35
11	Zadar	33	28	49	29
12	Croatia	33	31	66	25

TEMPORADA 2007/2008

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	33	91	34	82
2	Slaven	33	45	29	54
3	NK Osijek	33	43	34	54
4	HNK Rijeka	33	53	41	53
5	Hajduk Split	33	57	41	52
6	NK Zagreb	33	51	40	44
7	NK Varazdin	33	46	53	40
8	HNK Cibalia	33	40	48	40
9	Zadar	33	49	61	40
10	HNK Sibenik	33	34	52	39
11	Inter	33	27	59	33
12	Medjimurje	33	37	81	15

TEMPORADA 2006/2007

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	Dinamo	33	84	22	92
2	Hajduk Split	33	60	25	72
3	NK Zagreb	33	58	40	58
4	Slaven	33	40	37	49
5	HNK Sibenik	33	50	48	49
6	NK Osijek	33	42	45	43
7	HNK Rijeka	33	51	53	42
8	NK Varazdin	33	49	62	42
9	Medjimurje	33	40	60	37
10	HNK Cibalia	33	33	53	32
11	Istra 1961	33	28	40	29
12	Kamen Ingrad	33	27	77	11

TEMPORADA 2005/2006

LIGA CROATA HNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	22	61	11	56
2	HNK Rijeka	22	42	28	45
3	NK Osijek	22	25	32	34
4	NK Varazdin	22	34	35	31
5	Hajduk Split	22	28	21	29
6	Kamen Ingrad	22	26	30	29
7	Istra 1961	22	29	26	28
8	NK Zagreb	22	19	27	27
9	HNK Cibalia	22	24	35	26
10	Slaven	22	29	38	22
11	Inter	22	17	34	22
12	Medjimurje	22	26	43	21

TEMPORADA 2004/2005

LIGA CROATA HNL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dinamo	10	17	7	47
2	NK Osijek	10	12	13	41
3	Kamen Ingrad	10	6	11	41
4	Istra 1961	10	7	8	35
5	Medimurje	10	11	10	33
6	Zadar	10	11	15	32

TEMPORADA 2003/2004

LIGA CROATA HNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Hajduk Split	22	46	18	55
2	Dinamo	22	47	16	50
3	HNK Rijeka	22	26	25	31
4	NK Osijek	22	36	40	29
5	NK Varazdin	22	21	25	29
6	Kamen Ingrad	22	32	27	28
7	Zadar	22	37	44	28
8	Inter	22	22	23	27
9	Slaven	22	22	27	26
10	HNK Cibalia	22	25	35	20
11	NK Zagreb	22	21	32	19
12	Marsonia	22	25	48	17

TEMPORADA 2002/2003

LIGA CROATA HNL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Dinamo	22	51	17	57
2	Hajduk Split	22	42	14	50
3	NK Varazdin	22	40	21	45
4	HNK Cibalia	22	28	28	32
5	Kamen Ingrad	22	23	22	30
6	NK Zagreb	22	28	30	30
7	Slaven	22	24	26	29
8	NK Osijek	22	21	39	23
9	Zadar	22	21	40	21
10	HNK Rijeka	22	23	33	18
11	Pomorac	22	26	41	17
12	HNK Sibenik	22	23	39	17

TEMPORADA 2001/2002

LIGA CROATA HNL
Equipo		PJ	GF	GC	Puntos
1	NK Zagreb	30	71	24	67
2	Hajduk Split	30	61	28	65
3	Dinamo	30	58	30	59
4	NK Varazdin	30	58	40	57
5	HNK Rijeka	30	46	37	51
6	Slaven	30	34	36	42
7	Pomorac	30	36	41	40
8	NK Osijek	30	45	48	37
9	HNK Cibalia	30	34	37	36
10	HNK Sibenik	30	33	36	36
11	Zadar	30	43	47	36
12	Kamen Ingrad	30	28	46	35
13	Hrvatski	30	34	45	34
14	NK Cakovec	30	31	44	32
15	Marsonia	30	37	46	30
16	Topolovac	30	31	95	14

Competiciones que juega

Champions League Grupo 8

Pos	Equipos		Pts
1		Juventus	14
2		Sevilla	11
3		Olympique Lyonnais	8
4		Dinamo Zagreb	0

	Siguiente Ronda : Juventus, Sevilla
	: Olympique Lyonnais
	Eliminado : Dinamo Zagreb

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Croata

RIVALES EN Liga Croata HNL

USO DE MEMORIA

7,064,104 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2272
Total Execution Time	0.2284

CADENA URL

/historico/Dinamo-Zagreb/2017

GET DATOS

$_GET['/historico/Dinamo-Zagreb/2017']

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0094	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 = 'Dinamo-Zagreb' AND l.year = 2017 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.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	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=9815 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026	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 = 33347
0.0026	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 = 33325
0.0026	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 = 33891
0.0024	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 = 34117
0.0024	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 = 34140
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9815 AND type_rel = 2
0.0037	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9815 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023	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 (1429,1516,1725,1801,5306) ORDER BY n.cover_points DESC, update_date DESC
0.0059	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 = '9815' AND l.year = 2017 ORDER BY l.year DESC,cat.coefficient DESC
0.0059	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 = '9815' 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 = 34715 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 34117 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022	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 = 34140 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019	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 = 33347 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0048	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=9815 AND l.year in (2016,2017,2018) ORDER BY l.id DESC, l.year DESC ;
0.0022	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 (39161,38745,38724,38427,34715,34117,20315) 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.0031	SELECT count(id) as num_players from rel_players WHERE league_id = 38724 AND teamId = 9815
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 34715 AND teamId = 9815
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 34117 AND teamId = 9815
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 38745 AND teamId = 9815
0.0034	SELECT count(id) as num_players from rel_players WHERE league_id = 39161 AND teamId = 9815
0.0270	SELECT count(id) as num_players from rel_players WHERE league_id = 38427 AND teamId = 9815
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 20315 AND teamId = 9815
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 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 = 34715 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0033	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 events2017 e ON e.player_id = p.id AND e.league_id = 34715 WHERE rp.league_id = 34715 AND rp.teamId = 9815 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.0038	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 events2017 e ON e.player_id = p.id AND e.league_id = 34715 WHERE rp.league_id = 34715 AND rp.teamId = 9815 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022	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 events2017 e ON e.player_id = p.id AND e.league_id = 34715 WHERE rp.league_id = 34715 AND rp.teamId = 9815 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059	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 = 9815 AND l.year <= 2017 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 33347 AND t.round = 36 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* `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 = 15430 AND t.round = 36 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* `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 = 3816 AND t.round = 36 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* `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 = 2423 AND t.round = 36 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* `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 = 2023 AND t.round = 33 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* `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 = 1342 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 1069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 875 AND t.round = 30 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* `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 = 458 AND t.round = 33 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* `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 = 8680 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 8681 AND t.round = 33 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* `tables2006` 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 = 10233 AND t.round = 10 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* `tables2006` 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 = 8683 AND t.round = 22 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* `tables2005` 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 = 8685 AND t.round = 22 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* `tables2005` 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 = 10243 AND t.round = 10 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* `tables2004` 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 = 10231 AND t.round = 10 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* `tables2004` 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 = 8686 AND t.round = 22 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* `tables2003` 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 = 10230 AND t.round = 10 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* `tables2003` 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 = 8688 AND t.round = 22 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* `tables2002` 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 = 8689 AND t.round = 30 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 = 34715 ORDER BY nameShow LIMIT 100


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Dinamo Zagreb

Dinamo Zagreb

Selecciona un equipo

Competiciones que juega

Champions League Grupo 8

RIVALES EN Champions League

RIVALES EN Fase Previa Cham.

RIVALES EN Copa Croata

RIVALES EN Liga Croata HNL