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

Chindia Târgovişte

Entrenador: Diego Longo

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 1
Equipo		PJ	GF	GC	Puntos
1	CFR Cluj	30	48	16	76
2	FCSB	30	54	28	62
3	Universitate	30	55	29	54
4	FC Arges	30	28	22	48
5	Farul	30	42	21	48
6	Voluntari	30	31	27	47
7	Botosani	30	33	28	46
8	Rapid	30	34	31	40
9	UTA Arad	30	24	20	40
10	Sepsi	30	33	29	39
11	Chindia	30	23	23	35
12	Craiova 1948	30	31	35	33
13	Mioveni	30	19	36	29
14	Dinamo	30	24	66	17
15	Clinceni	30	21	64	14
16	Gaz Metan	30	21	46	2

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

LIGA RUMANA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Viitorul	14	25	17	43
2	Hermannstadt	12	18	14	35
3	Sepsi	13	19	17	34
4	Clinceni	14	14	21	32
5	Voluntari	14	16	12	31
6	Politehnica	14	17	17	30
7	Dinamo	9	8	11	25
8	Chindia	12	9	17	23

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 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

SEGUNDA RUMANÍA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Botosani	24	47	19	53
2	Săgeata	24	43	29	46
3	Delta Tulcea	24	45	22	42
4	Otopeni	24	37	27	41
5	Brăila	24	39	35	40
6	Clinceni	24	34	38	32
7	Unirea	24	35	38	30
8	Dunărea	24	23	30	28
9	Sportul	24	28	58	28
10	Foresta	24	31	35	27
11	Farul	24	35	41	27
12	Chindia	24	33	41	26
13	Dinamo	24	27	44	19
14	Callatis	0	0	0	0
15	Municipal	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

TERCERA RUMANÍA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Chindia	30	63	11	73
2	Chimia Brazi	30	82	23	71
3	Filipestii	30	40	31	49
4	Târgovişte	30	37	27	48
5	Urban Titu	30	40	31	46
6	Baloteşti	30	38	33	44
7	Viitorul	30	42	40	44
8	Conpet	30	37	37	43
9	Atletic	30	35	43	41
10	Albota	30	39	42	40
11	Inter	30	37	42	39
12	Plopeni	30	32	45	31
13	Petrolul	30	30	54	31
14	Alexandria	30	26	43	24
15	Victoria	30	24	53	24
16	Argeşul	30	15	62	19

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 Copa Rumanía

RIVALES EN Segunda Rumanía

USO DE MEMORIA

6,858,776 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1611
Total Execution Time	0.1624

CADENA URL

/historico/Chindia-Targovi-Te

GET DATOS

$_GET['/historico/Chindia-Targovi-Te']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0033	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 = 'Chindia-Targovi-Te' 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.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=7566 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=7566 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=7566 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=7566 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=7566 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=7566 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=7566 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0025	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.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 = 72232
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7566 AND type_rel = 2
0.0024	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7566 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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,860435) ORDER BY n.cover_points DESC, update_date DESC
0.0039	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 = '7566' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0038	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 = '7566' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73515 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 = 75661 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0030	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=7566 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019	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,74011,73672,71432,71247) 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 = 71247 AND teamId = 7566
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 75661 AND teamId = 7566
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 74011 AND teamId = 7566
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 7566
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 7566
0.0020	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 = '7566' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7566' 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 = '7566' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044	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 = 7566 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 events2024 e ON e.player_id = p.id AND e.league_id = 75661 WHERE rp.league_id = 75661 AND rp.teamId = 7566 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020	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 = 7566 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031	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 = 7566 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.0028	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.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* `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.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* `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.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* `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.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 = 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 = 50015 AND t.round = 26 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 = 55591 AND t.round = 14 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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.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* `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 = 2192 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.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* `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 = 25917 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Chindia Târgovişte

Chindia Târgovişte

Selecciona un equipo

Competiciones que juega

Segunda Rumanía Grupo 3

RIVALES EN Fase Previa Copa.

RIVALES EN Copa Rumanía

RIVALES EN Segunda Rumanía