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

FC Arges

Entrenador: Eugen Neagoe

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Unirea Dej	4	5	1	10
2	Municipal	5	7	5	10
3	Metaloglobus	5	5	4	7
4	FC Arges	4	6	3	6
5	Alexandria	4	3	7	4
6	Ceahlaul	4	8	9	3
7	Dumbrăviţa	4	2	7	3
8	Concordia	4	7	3	12
9	Steaua	4	8	1	10
10	Chindia	5	5	4	7
11	Viitorul	5	5	7	6
12	Tunari	4	6	7	4
13	CSM Slatina	4	5	6	4
14	Progresul	4	2	10	0

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 2
Equipo		PJ	GF	GC	Puntos
1	CFR Cluj	10	18	9	57
2	FCSB	10	24	7	56
3	Universitate	10	22	9	48
4	Voluntari	10	9	14	35
5	Farul	10	5	16	32
6	FC Arges	10	3	26	27

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

TERCERA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Arges	28	73	15	72
2	Atletic	28	52	44	47
3	Voluntari	28	47	38	44
4	Flacara	28	41	29	43
5	Alexandria	28	34	33	42
6	Sporting	28	36	36	40
7	Craiova	28	44	41	38
8	Mioveni II	28	38	39	38
9	Aninoasa	28	34	34	37
10	Concordia	27	43	44	37
11	Steaua	28	39	44	35
12	Filiaşi	27	35	33	34
13	Energetician	28	26	49	27
14	Urban Titu	27	29	48	23
15	Podari	27	19	63	14

TEMPORADA 2015/2016

TERCERA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	FC Arges	26	56	24	56
2	Afumati	26	42	16	56
3	Voluntari	26	61	33	55
4	Sporting	26	35	29	45
5	Dinicu	26	31	26	42
6	Concordia	26	56	39	35
7	Sporting	26	36	28	35
8	Atletic	26	41	41	35
9	Podari	26	52	42	34
10	Ştefăneşt	26	33	29	34
11	Aninoasa	26	29	36	31
12	Inter Olt	26	23	49	29
13	Hărman	26	23	65	16
14	Urban Titu	26	24	85	16

TEMPORADA 2014/2015

TERCERA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chindia	26	57	19	59
2	Afumati	26	55	23	52
3	Concordia	26	53	31	46
4	Ştefăneşt	26	44	35	43
5	Sporting	26	39	33	38
6	FC Arges	26	40	37	38
7	Atletic	26	48	42	35
8	Inter	26	40	34	33
9	Urban Titu	26	26	38	33
10	Târgovişte	26	27	49	30
11	Podari	26	30	40	29
12	Dinicu	26	27	40	29
13	Vişina	26	34	53	29
14	Astra II	26	22	68	17

TEMPORADA 2013/2014

TERCERA RUMANÍA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Chindia	22	43	10	51
2	Fortuna	22	57	15	48
3	FC Arges	22	47	18	46
4	Zagon	22	33	21	39
5	ACSM	22	25	16	39
6	Atletic	22	37	31	38
7	Conpet	22	25	26	26
8	Avântul	22	23	32	22
9	Urban Titu	22	19	36	20
10	Târgovişte	22	19	46	19
11	Păpăuţi	22	22	53	17
12	Civitas	22	9	55	2

TEMPORADA 2012/2013

TERCERA RUMANÍA GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Unirea	18	26	5	45
2	Fortuna	18	45	9	44
3	Unirea	18	21	13	32
4	FC Arges	18	24	21	26
5	Conpet	18	23	15	25
6	Zagon	18	22	24	25
7	Avântul	18	21	29	18
8	Târgovişte	18	15	23	17
9	Civitas	18	17	39	13
10	Albota	18	6	42	6
11	Cisnădie	0	0	0	0
12	Plopeni	0	0	0	0
13	Sevişul	0	0	0	0

Competiciones que juega

Segunda Rumanía Grupo 3

Pos	Equipos		Pts
1		Concordia Chiajna	12
2		CSA Steaua Bucuresti	10
3		Unirea Dej	10
4		Municipal Reşiţa	10
5		Chindia Târgovişte	7
6		Metaloglobus	7
7		FC Arges	6
8		Viitorul Pandurii	6
9		Tunari	4
10		CSM Slatina	4
11		Alexandria	4
12		FC Ceahlaul Piatra Neamt	3
13		Dumbrăviţa	3
14		Progresul Spartac	0

	Descenso : Metaloglobus, FC Arges

RIVALES EN Fase Previa Copa.

RIVALES EN Segunda Rumanía

USO DE MEMORIA

6,388,392 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8678
Total Execution Time	0.8690

CADENA URL

/historico/Scm-Arge-Ul-Pite-Ti

GET DATOS

$_GET['/historico/Scm-Arge-Ul-Pite-Ti']

POST DATOS

No hay datos POST existentes

CONSULTAS (49)

0.0156	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 = 'Scm-Arge-Ul-Pite-Ti' 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.0145	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=17047 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0167	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 = 75661
0.0167	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 = 73515
0.0156	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.0145	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17047 AND type_rel = 2
0.0148	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17047 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0148	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 (492795,859599,876350,880001) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '17047' ORDER BY l.year DESC,cat.coefficient DESC
0.0148	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 = '17047' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '17047' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148	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 = 73515 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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 = 75661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151	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=17047 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148	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 (75661,73672,71809,71432,71247,70731) 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.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 71247 AND teamId = 17047
0.0158	SELECT count(id) as num_players from rel_players WHERE league_id = 75661 AND teamId = 17047
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 70731 AND teamId = 17047
0.0148	SELECT count(id) as num_players from rel_players WHERE league_id = 71809 AND teamId = 17047
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 17047
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17047
0.0146	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 = '17047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17047' and rp.type = 4
0.0156	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 = '17047' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0171	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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 17047 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.0151	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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 17047 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0146	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 = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 17047 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149	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 = 17047 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149	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 = 75661 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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.0148	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.0149	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 = 63214 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.0148	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 = 66914 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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.0152	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.0169	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.0156	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.0159	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.0159	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.0155	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 = 37191 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 15887 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163	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 = 8425 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161	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 = 3533 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162	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 = 2199 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

FC Arges

FC Arges

Selecciona un equipo

Competiciones que juega

Segunda Rumanía Grupo 3

RIVALES EN Fase Previa Copa.

RIVALES EN Segunda Rumanía