23 Feb 23	Finalizado	CFR Cluj	0 - 0	Lazio	367
16 Feb 23	Finalizado	Lazio	1 - 0	CFR Cluj	208
03 Nov 22	Finalizado	CFR Cluj	1 - 0	Ballkani	55
27 Oct 22	Finalizado	Sivasspor	3 - 0	CFR Cluj	27
13 Oct 22	Finalizado	CFR Cluj	2 - 0	Slavia Praha	133
06 Oct 22	Finalizado	Slavia Praha	0 - 1	CFR Cluj	111
15 Sep 22	Finalizado	CFR Cluj	0 - 1	Sivasspor	75
08 Sep 22	Finalizado	Ballkani	1 - 1	CFR Cluj	37

Fase Previa Champions League »

	13 Jul 22	Finalizado	CFR Cluj	2 - 2	Pyunik			208
	05 Jul 22	Finalizado	Pyunik	0 - 0	CFR Cluj			318

Partidos Amistosos »

27 Mar 23	Finalizado	CFR Cluj	1 - 1	Hermannstadt	10
13 Ene 23	Finalizado	Darmstadt 98	1 - 0	CFR Cluj	17
11 Ene 23	Finalizado	CFR Cluj	1 - 1	Holstein Kiel	0
25 Jun 22	Finalizado	CFR Cluj	2 - 0	HNK Hajduk Split	0
24 Jun 22	Finalizado	CFR Cluj	1 - 0	Partizan Belgrade	5
21 Jun 22	Finalizado	Napredak Krusevac	0 - 3	CFR Cluj	1
18 Jun 22	Finalizado	FC Koper	0 - 2	CFR Cluj	1

Fase Previa Conference League »

25 Ago 22	Finalizado	CFR Cluj	1 - 0	Maribor	47
18 Ago 22	Finalizado	Maribor	0 - 0	CFR Cluj	35
11 Ago 22	Finalizado	CFR Cluj	1 - 0	Shakhtyor Soligorsk	71
04 Ago 22	Finalizado	Shakhtyor Soligorsk	0 - 0	CFR Cluj	37
27 Jul 22	Finalizado	Inter Escaldes	1 - 1	CFR Cluj	78
21 Jul 22	Finalizado	CFR Cluj	3 - 0	Inter Escaldes	24

Liga Rumana »

01 Jun 23	Finalizado	CFR Cluj	1 - 0	U Craiova 1948	124
28 May 23	Finalizado	CFR Cluj	1 - 2	Farul Constanța	20
20 May 23	Finalizado	Sepsi	1 - 2	CFR Cluj	18
14 May 23	Finalizado	FCSB	1 - 0	CFR Cluj	15
07 May 23	Finalizado	CFR Cluj	1 - 1	Universitatea Craiova	33
01 May 23	Finalizado	FC Rapid Bucuresti	3 - 1	CFR Cluj	20
22 Abr 23	Finalizado	Farul Constanța	1 - 0	CFR Cluj	32
15 Abr 23	Finalizado	CFR Cluj	2 - 1	Sepsi	18
09 Abr 23	Finalizado	CFR Cluj	1 - 1	FCSB	41
02 Abr 23	Finalizado	Universitatea Craiova	1 - 1	CFR Cluj	16
19 Mar 23	Finalizado	CFR Cluj	2 - 2	FC Rapid Bucuresti	27
13 Mar 23	Finalizado	CFR Cluj	4 - 0	Universitatea Cluj	60
06 Mar 23	Finalizado	Sepsi	2 - 2	CFR Cluj	77
02 Mar 23	Finalizado	CFR Cluj	2 - 1	UTA Arad	284
27 Feb 23	Finalizado	Petrolul Ploiesti	2 - 5	CFR Cluj	46
19 Feb 23	Finalizado	CFR Cluj	3 - 1	FC Arges	2
11 Feb 23	Finalizado	Universitatea Craiova	2 - 0	CFR Cluj	26
05 Feb 23	Finalizado	CFR Cluj	0 - 1	FCSB	36
30 Ene 23	Finalizado	Voluntari	0 - 1	CFR Cluj	195
23 Ene 23	Finalizado	Farul Constanța	0 - 3	CFR Cluj	69
20 Dic 22	Finalizado	CFR Cluj	0 - 1	Hermannstadt	427
15 Dic 22	Finalizado	FCSB	0 - 1	CFR Cluj	301
11 Dic 22	Finalizado	Botosani	1 - 1	CFR Cluj	25
04 Dic 22	Finalizado	CFR Cluj	2 - 0	Chindia Târgovişte	19
30 Nov 22	Finalizado	Hermannstadt	2 - 3	CFR Cluj	13
13 Nov 22	Finalizado	Mioveni	0 - 1	CFR Cluj	88
07 Nov 22	Finalizado	CFR Cluj	3 - 1	U Craiova 1948	68
30 Oct 22	Finalizado	FC Rapid Bucuresti	2 - 1	CFR Cluj	16
23 Oct 22	Finalizado	Universitatea Cluj	1 - 2	CFR Cluj	3
17 Oct 22	Finalizado	CFR Cluj	2 - 1	Sepsi	79
10 Oct 22	Finalizado	UTA Arad	1 - 1	CFR Cluj	14
01 Oct 22	Finalizado	CFR Cluj	1 - 0	Petrolul Ploiesti	21
19 Sep 22	Finalizado	FC Arges	0 - 1	CFR Cluj	127
11 Sep 22	Finalizado	CFR Cluj	2 - 0	Universitatea Craiova	14
31 Ago 22	Finalizado	CFR Cluj	4 - 0	Voluntari	4
28 Ago 22	Finalizado	CFR Cluj	1 - 3	Farul Constanța	5
14 Ago 22	Finalizado	CFR Cluj	0 - 1	Botosani	33
07 Ago 22	Finalizado	Chindia Târgovişte	0 - 2	CFR Cluj	4
30 Jul 22	Finalizado	CFR Cluj	4 - 2	Mioveni	29
24 Jul 22	Finalizado	U Craiova 1948	3 - 1	CFR Cluj	4
16 Jul 22	Finalizado	CFR Cluj	1 - 0	FC Rapid Bucuresti	21

Copa Rumanía »

26 Abr 23	Finalizado	Sepsi	3 - 0	CFR Cluj	68
06 Abr 23	Finalizado	CFR Cluj	1 - 0	FC Arges	229
07 Dic 22	Finalizado	Farul Constanța	0 - 0	CFR Cluj	67
10 Nov 22	Finalizado	Dumbrăviţa	0 - 5	CFR Cluj	21
20 Oct 22	Finalizado	Universitatea Cluj	1 - 1	CFR Cluj	17

Supercopa Rumanía »

09 Jul 22

Finalizado

CFR Cluj

1 - 2

Sepsi

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del CFR Cluj Temporada 2022/2023

		Edad	Altura	Peso
Portero
34	C. Balgradean	36	187	82	-	-	-
23	R. Gal	23	-	-	-	-	-
1	S. Scuffet	27	193	75	-	-	1
Defensa
3	Andrei Burcă	31	188	78	-	-	1
47	C. Braun	32	181	76	-	-	-
4	C. Manea	26	183	72	-	-	-
33	Denis Kolinger	30	199	89	-	-	1
6	J. Billong	30	192	90	-	-	-
44	Jefferson Yuri	29	186	76	2	-	2
2	Karlo Bručić	32	184	71	-	-	-
45	Mário Camora	37	178	68	-	-	1
Centrocampista
73	K. Muhar	28	190	83	-	-	2
40	Lovro Cvek	28	183	79	-	-	1
37	M. Bordeianu	32	175	70	-	-	-
21	Nana Boateng	29	180	72	1	-	2
28	O. Hoban	41	182	79	-	-	-
8	Roger	28	186	74	-	-	-
20	V. Hammershøj-Mistrati	31	177	78	-	-	-
Delantero
7	Alexandru Paun	29	177	67	-	-	-
9	C. Malele	30	185	83	-	-	-
10	Ciprian Deac	38	177	71	1	-	2
11	Claudiu Petrila	23	176	67	-	-	1
15	E. Yeboah	21	188	-	-	-	3
32	R. Janga	32	192	63	1	-	-
99	S. Bus	31	185	83	-	-	-

Noticias del CFR Cluj

Ver últimas noticias

El Rizespor ficha a Petrucci

BeSoccer - Martes, 30 Agosto 2016

0 267

El conjunto turco refuerza su centro del campo con el fichaje ex del Manchester United que apunta a titular en la medular.

El Cluj ficha a Rus

BeSoccer - Domingo, 21 Agosto 2016

0 263

El veterano defensa se ha comprometido con el CFR Cluj rumano, procedente del Voluntari.

Registran la sede del Cluj por un posible blanqueo de más de ocho millones

BeSoccer - Jueves, 19 Mayo 2016

0 190

Los fiscales estiman que se habría lavado una suma de 8.485.682 euros a través de unas empresas "off-shore" de Chipre y las Islas Seychelles, que prestaron asesoramiento e intermediación en el campo deportivo, como serían el traspaso de algunos jugadores del club y la optimización de sus actividades.

El Cluj conquista la Copa con goles de Juan Carlos y Cristian López

BeSoccer - Miércoles, 18 Mayo 2016

0 507

Los españoles Juan Carlos y Cristian López evitaron con sus goles la victoria del Dinamo Bucarest (2-2) y propiciaron la conquista de la Copa de Rumanía por el Cluj, que ganó en los lanzamientos de penaltis.

Sepsi, defensa rumano, baja ante España por lesión

BeSoccer - Viernes, 25 Marzo 2016

0 207

El defensa rumano del Nuremberg alemán, Laszlo Sepsi, ha abandonado la concentración de su selección por molestias musculares, por lo que se perderá el amistoso contra España, que se disputará el domingo en Cluj-Napoca.

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Sivasspor	11
2		CFR Cluj	10
3		Slavia Praha	8
4		Ballkani	4

	Siguiente Ronda : Sivasspor
	: CFR Cluj

USO DE MEMORIA

7,222,984 bytes

BENCHMARKS

Loading Time Base Classes	0.0024
Controller Execution Time ( Home / Category )	0.2510
Total Execution Time	0.2535

CADENA URL

/Cfr-Cluj/2023

GET DATOS

$_GET['/Cfr-Cluj/2023']

POST DATOS

No hay datos POST existentes

CONSULTAS (65)

0.0136	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 = 'Cfr-Cluj' AND l.year = 2023 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.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=742 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=742 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=742 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=742 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=742 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=742 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=742 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=742 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 68871
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 = 70410
0.0023	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 = 68105
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 = 71246
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 = 71804
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 = 67749
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 = 67756
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 = 67757
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 = 67758
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 = 69841
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 = 70731
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 = 69547
0.0023	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 = 67921
0.0031	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 = '742' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '742' 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 = 67749 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 67758 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 = 70410 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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 = 69547 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 = 70731 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 = 67921 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 = 71804 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025	(SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2023 as c ON c.league_id = l.id WHERE (c.datateam1 = 742 or c.datateam2 = 742) AND l.year = 2023 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0034	(SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 742 or c.datateam2 = 742) AND l.year = 2023 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0027	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2023 as c ON c.league_id = l.id INNER JOIN events2023 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 742 or c.datateam2 = 742) AND l.year = 2023)
0.0033	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=742 AND l.year in (2022,2023,2024) 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 (75607,74803,72100,71432,70410,69547,67921,67749,63059) 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.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 75607 AND teamId = 742
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 742
0.0027	SELECT count(id) as num_players from rel_players WHERE league_id = 67749 AND teamId = 742
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 63059 AND teamId = 742
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 72100 AND teamId = 742
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 74803 AND teamId = 742
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 69547 AND teamId = 742
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 67921 AND teamId = 742
0.0116	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 742
0.0020	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68871 AND t.round = 6 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 events2023 e ON e.player_id = p.id AND e.league_id = 68871 WHERE rp.league_id = 68871 AND rp.teamId = 742 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.0036	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 events2023 e ON e.player_id = p.id AND e.league_id = 68871 WHERE rp.league_id = 68871 AND rp.teamId = 742 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 events2023 e ON e.player_id = p.id AND e.league_id = 68871 WHERE rp.league_id = 68871 AND rp.teamId = 742 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 742 AND rp.league_id = 68871 AND l.year= 2023 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0023	SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6537562 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6537562
0.0022	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537562 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0022	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537562 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537562 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0020	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537562 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0023	SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2023 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6537562 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC
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 = 68871 ORDER BY nameShow LIMIT 100

CFR Cluj

Información sobre CFR Cluj

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Partidos del CFR Cluj

Estadísticas

Plantilla del CFR Cluj Temporada 2022/2023

Noticias del CFR Cluj

CFR Cluj

Selecciona un equipo

Competiciones que juega

RIVALES EN Fase Previa Cham.

RIVALES EN Fase Previa Conf.

RIVALES EN Conference Leagu.

RIVALES EN Fase Previa Copa.

RIVALES EN Copa Rumanía

RIVALES EN Supercopa Rumaní.

RIVALES EN Liga Rumana