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

UTA Arad

Entrenador: Mircea Rednic

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA RUMANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hermannstadt	6	10	4	31
2	UTA Arad	6	10	8	31
3	Oțelul	6	7	5	30
4	Universitate	7	8	7	29
5	Petrolul	6	5	9	26
6	Voluntari	7	11	9	23
7	Craiova 1948	7	6	10	22
8	Botosani	6	9	8	21
9	Politehnica	6	4	6	21
10	Dinamo	7	5	9	21

TEMPORADA 2022/2023

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Craiova 1948	9	13	7	36
2	Voluntari	9	17	11	34
3	Petrolul	9	9	9	34
4	Universitate	9	12	9	33
5	Botosani	9	10	5	31
6	Hermannstadt	9	10	7	31
7	UTA Arad	9	10	9	26
8	FC Arges	9	10	11	24
9	Chindia	9	7	12	23
10	Mioveni	9	1	19	11

TEMPORADA 2021/2022

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Sepsi	9	21	4	42
2	Botosani	9	18	9	41
3	Rapid	9	22	7	39
4	Craiova 1948	9	14	11	34
5	UTA Arad	9	10	6	33
6	Mioveni	9	12	10	31
7	Chindia	9	8	8	26
8	Dinamo	9	14	11	23
9	Clinceni	9	4	32	-43
10	Gaz Metan	9	6	31	-46

TEMPORADA 2020/2021

LIGA RUMANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Chindia	9	7	3	36
2	Gaz Metan	9	15	10	32
3	Viitorul	9	9	4	32
4	UTA Arad	9	7	9	32
5	Dinamo	9	11	8	31
6	FC Arges	9	10	7	31
7	Voluntari	9	6	7	28
8	Hermannstadt	9	6	9	26
9	Astra	9	6	12	24
10	Politehnica	9	7	15	20

TEMPORADA 2019/2020

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	FC Arges	4	5	3	8
2	Turris-Oltul	5	5	5	6
3	Rapid	5	4	4	6
4	Petrolul	5	4	4	6
5	UTA Arad	5	8	8	5
6	Mioveni	4	2	4	4

TEMPORADA 2018/2019

SEGUNDA RUMANÍA
Equipo		PJ	GF	GC	Puntos
1	Chindia	38	79	33	88
2	Clinceni	38	77	24	87
3	Universitate	38	85	26	82
4	Petrolul	38	77	38	77
5	Sportul	38	56	37	70
6	FC Arges	38	54	33	68
7	Mioveni	38	63	41	61
8	Luceafărul	38	57	59	52
9	Metaloglobus	38	43	56	49
10	Politehnica	38	39	38	48
11	Daco-Getica	38	54	55	47
12	UTA Arad	38	55	64	47
13	Ripensia	38	44	54	47
14	Farul	38	46	60	47
15	Pandurii	38	57	65	44
16	Energetician	38	46	55	39
17	Aerostar	38	60	68	38
18	Poli	38	31	67	29
19	Baloteşti	38	31	88	24
20	Brăila	38	30	123	19

TEMPORADA 2017/2018

SEGUNDA RUMANÍA
Equipo		PJ	GF	GC	Puntos
1	Dunărea	38	75	24	93
2	Hermannstadt	38	66	13	91
3	Chindia	38	71	28	75
4	FC Arges	38	61	35	68
5	Afumati	38	53	32	68
6	Clinceni	38	63	54	58
7	Politehnica	38	55	43	57
8	Luceafărul	38	65	59	53
9	Mioveni	38	54	46	52
10	Sportul	38	51	37	51
11	Ripensia	38	72	60	48
12	UTA Arad	38	60	55	47
13	Baloteşti	38	54	74	47
14	Pandurii	38	49	57	42
15	Brăila	38	70	72	41
16	Metaloglobus	38	38	55	41
17	Ştiinţa	38	46	73	37
18	Foresta	38	35	106	33
19	Tîrgu Mures	37	38	85	31
20	Olimpia Satu	37	19	87	0

TEMPORADA 2016/2017

SEGUNDA RUMANÍA
Equipo		PJ	GF	GC	Puntos
1	Daco-Getica	34	77	18	84
2	Sepsi	34	62	29	71
3	UTA Arad	34	64	32	66
4	Mioveni	34	51	30	59
5	Chindia	34	57	37	58
6	Dunărea	34	52	40	56
7	Afumati	34	56	36	56
8	FC Brasov	34	49	35	56
9	Olimpia Satu	34	53	34	54
10	Luceafărul	34	48	38	47
11	Brăila	34	37	56	46
12	Foresta	34	50	70	41
13	Clinceni	34	47	69	39
14	Politehnica	34	48	59	38
15	Baloteşti	33	41	56	37
16	Sportul	34	35	77	21
17	Râmnicu	33	16	67	18
18	Unirea	32	16	76	1
19	Berceni	0	0	0	0
20	Şoimii	0	0	0	0

TEMPORADA 2015/2016

SEGUNDA RUMANÍA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Gaz Metan	10	17	9	41
2	UTA Arad	10	18	14	41
3	Chindia	10	18	12	40
4	Mioveni	10	15	17	27
5	Baia Mare	10	16	20	25
6	FC Brasov	10	14	26	23

TEMPORADA 2014/2015

TERCERA RUMANÍA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	UTA Arad	24	56	20	56
2	Nuova Mama	24	54	13	52
3	Naţional	24	47	15	50
4	Vulturii	24	31	19	50
5	Millenium	24	23	25	34
6	Pandurii	24	36	40	30
7	Filiaşi	24	26	25	29
8	Ineu	24	22	36	28
9	Hunedoara	24	22	38	28
10	Minerul	24	31	40	25
11	Ştiinţa	24	24	34	25
12	ASRA Apă Cr.	24	24	43	19
13	Minerul	24	6	54	8

TEMPORADA 2013/2014

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Universitate	22	33	11	49
2	Sportul	22	29	18	37
3	Râmnicu	22	26	18	36
4	ALRO Slatina	22	24	16	36
5	Tîrgu Mures	22	25	14	34
6	Gloria	22	23	19	34
7	Olimpia Satu	22	22	19	33
8	Mioveni	22	21	24	29
9	Bihor Oradea	22	18	21	26
10	UTA Arad	22	19	30	21
11	Universitate	22	9	39	17
12	Minerul	22	17	37	13

TEMPORADA 2012/2013

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Corona	24	41	22	48
2	Poli	24	39	19	45
3	Damila	24	38	22	44
4	UTA Arad	24	29	17	40
5	Tîrgu Mures	24	31	29	35
6	Râmnicu	24	27	28	34
7	Bihor Oradea	24	35	31	33
8	Mioveni	24	27	23	32
9	Argeş	24	34	40	31
10	Luceafărul	24	25	32	26
11	Maramureş	24	21	36	23
12	Olt	24	27	29	22
13	Unirea Alba	24	12	58	11
14	Politehnica	0	0	0	0
15	Voinţa	0	0	0	0

TEMPORADA 2011/2012

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Politehnica	30	54	19	65
2	Gloria	30	60	29	65
3	Turnu	30	50	25	59
4	UTA Arad	30	41	20	51
5	ALRO Slatina	30	41	22	50
6	Luceafărul	30	34	27	47
7	Chindia	30	34	24	44
8	Bihor Oradea	30	40	35	44
9	Unirea Alba	30	34	26	41
10	Argeş	30	34	47	39
11	Râmnicu	30	34	38	35
12	Maramureş	30	38	50	35
13	Olt	30	30	35	34
14	Daco-Getica	30	24	44	20
15	Mureşul	30	20	72	20
16	Arieşul	30	10	65	11

TEMPORADA 2010/2011

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Petrolul	28	46	22	59
2	Bihor Oradea	28	43	20	58
3	Mioveni	28	43	19	57
4	Voinţa	28	36	17	50
5	ALRO Slatina	28	46	26	48
6	UTA Arad	28	48	36	47
7	Politehnica	28	41	30	47
8	Râmnicu	28	35	39	36
9	Arieşul	28	26	31	33
10	Turnu	28	36	39	31
11	Unirea Alba	28	22	35	30
12	Argeş	28	27	40	29
13	Mureşul	28	31	48	26
14	ACU Arad	28	18	36	25
15	FC Silvania	28	9	69	10
16	Minerul	0	0	0	0

Competiciones que juega

Liga Rumana Grupo 2

Pos	Equipos		Pts
1		Hermannstadt	31
2		UTA Arad	31
3		Oțelul Galați	30
4		Universitatea Cluj	29
5		Petrolul Ploiesti	26
6		Voluntari	23
7		U Craiova 1948	22
8		Botosani	21
9		Politehnica Iași	21
10		Dinamo Bucureşti	21

	Playoffs : Hermannstadt, UTA Arad
	Playoff Descenso : U Craiova 1948, Botosani
	Descenso : Politehnica Iași, Dinamo Bucureşti

RIVALES EN Copa Rumanía

RIVALES EN Fase Previa Copa.

RIVALES EN Liga Rumana

USO DE MEMORIA

6,719,088 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1626
Total Execution Time	0.1639

CADENA URL

/historico/Uta-Arad

GET DATOS

$_GET['/historico/Uta-Arad']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0039	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 = 'Uta-Arad' 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.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=7556 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=7556 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=7556 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=7556 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=7556 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=7556 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 75606
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 = 73672
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7556 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7556 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 (107298,256081,261510,948768) ORDER BY n.cover_points DESC, update_date DESC
0.0032	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 = '7556' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0053	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 = '7556' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 74011 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 = 72230 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=7556 AND l.year in (2023,2024,2025) 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 (75606,74011,73672,71809,71432) 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.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75606 AND teamId = 7556
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 74011 AND teamId = 7556
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 71809 AND teamId = 7556
0.0028	SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 7556
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7556
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 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 = 75606 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0031	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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 7556 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.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 events2024 e ON e.player_id = p.id AND e.league_id = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 7556 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023	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 = 75606 WHERE rp.league_id = 75606 AND rp.teamId = 7556 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 7556 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75606 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 68105 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.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* `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 = 71247 AND t.round = 9 ORDER BY team.conference ASC,t.position 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* `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 = 66915 AND t.round = 9 ORDER BY team.conference ASC,t.position 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* `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 = 58371 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.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* `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 = 62145 AND t.round = 9 ORDER BY team.conference ASC,t.position 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* `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 = 50089 AND t.round = 24 ORDER BY team.conference ASC,t.position 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* `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 = 56849 AND t.round = 5 ORDER BY team.conference ASC,t.position 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* `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 = 44553 AND t.round = 38 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* `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 = 38850 AND t.round = 38 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* `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 = 33804 AND t.round = 38 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* `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 = 15517 AND t.round = 26 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* `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 = 24176 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* `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 = 8426 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* `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 = 2740 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* `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 = 2193 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* `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 = 1745 AND t.round = 30 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* `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 = 13960 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 = 75606 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

UTA Arad

UTA Arad

Selecciona un equipo

Competiciones que juega

Liga Rumana Grupo 2

RIVALES EN Copa Rumanía

RIVALES EN Fase Previa Copa.

RIVALES EN Liga Rumana