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

Concordia Chiajna

Entrenador: Ilie Poenaru

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	Viitorul	5	5	7	6
11	Tunari	4	6	7	4
12	CSM Slatina	4	5	6	4
13	Chindia	4	3	4	4
14	Progresul	3	2	8	0

TEMPORADA 2022/2023

SEGUNDA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Csikszereda	6	12	6	39
2	1599	6	9	7	36
3	CSM Slatina	6	2	5	34
4	Unirea	6	7	11	34
5	Metaloglobus	6	12	6	32
6	Minaur Baia	6	3	4	22
7	Politehnica	6	5	11	19
8	Brașov	6	23	5	44
9	Concordia	6	8	6	39
10	Dumbrăviţa	6	12	8	33
11	Viitorul	6	10	11	32
12	Progresul	6	15	7	29
13	Unirea	6	5	27	18
14	Ripensia	6	2	11	17

TEMPORADA 2021/2022

SEGUNDA RUMANÍA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Petrolul	10	9	7	63
2	Hermannstadt	10	14	5	61
3	Universitate	10	13	9	57
4	Steaua	10	10	10	50
5	Concordia	10	8	17	44
6	Unirea	10	6	12	41

TEMPORADA 2020/2021

SEGUNDA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Farul	25	34	26	42
2	Universitate	25	33	28	39
3	Metaloglobus	25	31	22	39
4	Ripensia	25	24	33	36
5	Dacia	25	47	39	35
6	CSM Slatina	25	25	40	19
7	Pandurii	25	23	54	14
8	Petrolul	25	38	20	42
9	Viitorul	25	47	41	41
10	FC Buzău	25	30	27	35
11	Concordia	25	29	24	34
12	Unirea	25	23	31	29
13	Şcolar	25	18	33	26
14	Aerostar	25	23	54	11

TEMPORADA 2019/2020

SEGUNDA RUMANÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UTA Arad	23	49	13	50
2	Mioveni	23	36	22	39
3	Turris-Oltul	22	36	25	39
4	FC Arges	23	34	25	38
5	Petrolul	23	23	20	38
6	Rapid	23	32	20	37
7	Metaloglobus	23	28	20	37
8	FC Buzău	23	35	27	33
9	Farul	23	27	20	33
10	Viitorul	22	30	25	33
11	Politehnica	22	20	12	32
12	Dunărea	23	29	30	31
13	Ripensia	23	28	34	28
14	Universitate	23	29	26	27
15	Şcolar	22	30	35	24
16	Concordia	22	20	30	24
17	Csikszereda	23	17	33	22
18	Sportul	23	16	59	9
19	Pandurii	23	10	53	8
20	Daco-Getica	0	0	0	0

TEMPORADA 2018/2019

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gaz Metan	14	25	9	48
2	Botosani	14	18	9	44
3	Dinamo	14	16	7	43
4	Voluntari	14	14	16	31
5	Politehnica	14	12	18	31
6	Hermannstadt	14	9	19	27
7	Dunărea	14	8	18	25
8	Concordia	14	17	23	19

TEMPORADA 2017/2018

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Dinamo	14	29	10	54
2	Botosani	14	12	9	40
3	Sepsi	14	21	14	34
4	Gaz Metan	14	18	15	30
5	Concordia	14	13	17	30
6	Voluntari	14	16	22	27
7	Poli	14	10	16	27
8	Daco-Getica	14	9	25	17

TEMPORADA 2016/2017

LIGA RUMANA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Politehnica	14	16	5	43
2	Gaz Metan	14	17	11	39
3	Voluntari	14	17	16	37
4	Botosani	14	15	12	33
5	Concordia	14	14	18	29
6	Poli	14	16	14	27
7	Pandurii	14	12	18	27
8	Tîrgu Mures	14	5	18	14

TEMPORADA 2015/2016

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Politehnica	14	17	15	39
2	Universitate	14	19	17	39
3	Botosani	14	29	19	38
4	CFR Cluj	14	25	13	36
5	Concordia	14	19	13	35
6	Voluntari	14	19	20	29
7	Poli	14	14	36	20
8	Petrolul	14	9	18	18

TEMPORADA 2014/2015

LIGA RUMANA
Equipo		PJ	GF	GC	Puntos
1	FCSB	34	59	23	71
2	Tîrgu Mures	34	51	25	68
3	Astra	34	53	27	57
4	CFR Cluj	34	46	29	57
5	Universitate	34	40	34	53
6	Petrolul	34	42	30	52
7	Dinamo	34	47	44	48
8	Botosani	34	40	43	47
9	Pandurii	34	47	42	45
10	Politehnica	34	31	39	43
11	Viitorul	34	44	54	43
12	Concordia	34	39	44	41
13	Gaz Metan	34	29	34	39
14	FC Brasov	34	33	46	36
15	Universitate	34	29	41	35
16	Rapid	34	21	42	33
17	Oțelul	34	24	45	32
18	Ceahlaul	34	25	58	27

TEMPORADA 2013/2014

LIGA RUMANA
Equipo		PJ	GF	GC	Puntos
1	FCSB	34	71	20	77
2	Astra	34	70	28	72
3	Petrolul	34	53	20	68
4	Dinamo	34	52	34	59
5	CFR Cluj	34	44	33	51
6	FC Vaslui	34	38	32	51
7	Pandurii	34	59	39	50
8	Botosani	34	36	52	43
9	Ceahlaul	34	27	31	41
10	Oțelul	34	43	52	41
11	Universitate	34	29	46	40
12	Viitorul	34	29	50	40
13	Gaz Metan	34	32	38	39
14	Concordia	34	34	47	39
15	FC Brasov	34	32	40	38
16	Poli	34	26	42	38
17	Săgeata	34	32	54	38
18	Corona	34	20	69	14

TEMPORADA 2012/2013

LIGA RUMANA
Equipo		PJ	GF	GC	Puntos
1	FCSB	34	74	29	79
2	Pandurii	34	57	43	63
3	Petrolul	34	60	34	62
4	Astra	34	64	37	60
5	FC Vaslui	34	50	34	58
6	Dinamo	34	48	40	56
7	FC Brasov	34	50	51	51
8	CFR Cluj	34	56	39	49
9	Rapid	34	35	35	49
10	Gaz Metan	34	42	46	46
11	Oțelul	34	38	42	43
12	Universitate	34	39	55	38
13	Viitorul	34	45	57	36
14	Ceahlaul	34	41	59	34
15	Concordia	34	29	49	33
16	Turnu	34	36	47	32
17	Politehnica	34	31	50	26
18	Gloria	34	21	69	17

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		Metaloglobus	7
6		FC Arges	6
7		Viitorul Pandurii	6
8		Tunari	4
9		CSM Slatina	4
10		Chindia Târgovişte	4
11		Alexandria	4
12		FC Ceahlaul Piatra Neamt	3
13		Dumbrăviţa	3
14		Progresul Spartac	0

	Descenso : FC Arges, Viitorul Pandurii

RIVALES EN Fase Previa Copa.

RIVALES EN Segunda Rumanía

USO DE MEMORIA

6,435,032 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7199
Total Execution Time	0.7212

CADENA URL

/historico/Concordia-Chiajna

GET DATOS

$_GET['/historico/Concordia-Chiajna']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0140	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 = 'Concordia-Chiajna' 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.0125	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=4636 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132	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.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4636 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4636 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128	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 (44341,50949,135476,299261,680014) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '4636' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134	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 = '4636' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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.0135	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=4636 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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,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.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 75661 AND teamId = 4636
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 4636
0.0139	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4636
0.0131	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 = 75661 AND t.round = 5 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127	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 = '4636' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4636' and rp.type = 4
0.0127	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 = '4636' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 4636 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.0145	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 = 4636 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 4636 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132	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 = 4636 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0129	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 = 72232 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 68106 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 71249 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.0129	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 = 63225 AND t.round = 19 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* `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 = 66962 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.0130	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 = 58562 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 61990 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.0131	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.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* `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 = 49256 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 38849 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 42958 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 33801 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 38061 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 15579 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 20793 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 3826 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 2510 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 2030 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 75661 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

Concordia Chiajna

Concordia Chiajna

Selecciona un equipo

Competiciones que juega

Segunda Rumanía Grupo 3

RIVALES EN Fase Previa Copa.

RIVALES EN Segunda Rumanía