17 Mar 22	Finalizado	Basel	1 - 2	Olympique Marseille	185
10 Mar 22	Finalizado	Olympique Marseille	2 - 1	Basel	56
09 Dic 21	Finalizado	Basel	3 - 0	Qarabağ	28
25 Nov 21	Finalizado	Kairat Almaty	2 - 3	Basel	217
04 Nov 21	Finalizado	Omonia Nicosia	1 - 1	Basel	115
21 Oct 21	Finalizado	Basel	3 - 1	Omonia Nicosia	35
30 Sep 21	Finalizado	Basel	4 - 2	Kairat Almaty	7
16 Sep 21	Finalizado	Qarabağ	0 - 0	Basel	51

Partidos Amistosos »

04 May 22	Finalizado	Basel	2 - 3	Dynamo Kyiv	48
24 Mar 22	Finalizado	Karlsruher SC	6 - 1	Basel	8
22 Ene 22	Finalizado	Basel	3 - 1	Neuchâtel Xamax	0
19 Ene 22	Finalizado	Basel	3 - 0	Lausanne Sports	3
12 Ene 22	Finalizado	FC Lugano	1 - 2	Basel	8
17 Jul 21	Finalizado	Hamburger SV	1 - 0	Basel	0
10 Jul 21	Finalizado	Basel	3 - 3	Aarau	3
09 Jul 21	Finalizado	Strasbourg	0 - 1	Basel	10
06 Jul 21	Finalizado	Basel	1 - 0	Grasshopper	9
01 Jul 21	Finalizado	Basel	4 - 4	Dynamo Kyiv	33

Fase Previa Conference League »

26 Ago 21	Finalizado	Hammarby IF	3 - 1	Basel	52
19 Ago 21	Finalizado	Basel	3 - 1	Hammarby IF	84
12 Ago 21	Finalizado	Basel	4 - 0	Újpest FC	5
05 Ago 21	Finalizado	Újpest FC	1 - 2	Basel	17
29 Jul 21	Finalizado	Partizani Tirana	0 - 2	Basel	5
22 Jul 21	Finalizado	Basel	3 - 0	Partizani Tirana	12

Liga Suiza »

22 May 22	Finalizado	Basel	2 - 1	FC Lugano	16
19 May 22	Finalizado	Servette	0 - 0	Basel	129
12 May 22	Finalizado	Basel	1 - 1	Grasshopper	276
08 May 22	Finalizado	Lausanne Sports	0 - 0	Basel	30
01 May 22	Finalizado	Basel	0 - 2	Zurich	69
24 Abr 22	Finalizado	Basel	3 - 0	Luzern	14
18 Abr 22	Finalizado	Sion	0 - 0	Basel	47
10 Abr 22	Finalizado	St. Gallen	2 - 2	Basel	3
03 Abr 22	Finalizado	Basel	2 - 2	Young Boys	53
20 Mar 22	Finalizado	Grasshopper	2 - 4	Basel	9
13 Mar 22	Finalizado	Basel	2 - 0	Servette	16
06 Mar 22	Finalizado	FC Lugano	0 - 2	Basel	41
03 Mar 22	Finalizado	Basel	2 - 2	St. Gallen	201
27 Feb 22	Finalizado	Zurich	4 - 2	Basel	18
19 Feb 22	Finalizado	Basel	3 - 0	Lausanne Sports	18
13 Feb 22	Finalizado	Young Boys	3 - 1	Basel	16
06 Feb 22	Finalizado	Basel	3 - 3	Sion	32
30 Ene 22	Finalizado	Luzern	0 - 3	Basel	111
19 Dic 21	Finalizado	Basel	2 - 2	Grasshopper	63
15 Dic 21	Finalizado	Young Boys	1 - 1	Basel	65
12 Dic 21	Finalizado	Servette	2 - 2	Basel	13
05 Dic 21	Finalizado	Basel	1 - 1	Lausanne Sports	85
28 Nov 21	Finalizado	Luzern	1 - 3	Basel	14
07 Nov 21	Finalizado	Basel	0 - 1	St. Gallen	33
30 Oct 21	Finalizado	Zurich	3 - 3	Basel	48
24 Oct 21	Finalizado	Basel	2 - 0	FC Lugano	12
17 Oct 21	Finalizado	Sion	0 - 1	Basel	54
03 Oct 21	Finalizado	Basel	1 - 1	Luzern	28
26 Sep 21	Finalizado	Basel	3 - 1	Zurich	10
22 Sep 21	Finalizado	St. Gallen	0 - 2	Basel	11
12 Sep 21	Finalizado	FC Lugano	1 - 1	Basel	3
29 Ago 21	Finalizado	Basel	1 - 1	Young Boys	27
22 Ago 21	Finalizado	Lausanne Sports	2 - 2	Basel	42
08 Ago 21	Finalizado	Basel	5 - 1	Servette	9
01 Ago 21	Finalizado	Basel	6 - 1	Sion	15
25 Jul 21	Finalizado	Grasshopper	0 - 2	Basel	11

Copa Suiza »

27 Oct 21	Finalizado	Etoile Carouge	1 - 0	Basel	3
19 Sep 21	Finalizado	FC Rorschach-Goldach 17	0 - 3	Basel	0
15 Ago 21	Finalizado	Schönenwerd-Niedergösg	0 - 7	Basel	1

Estadísticas

GOLEADORES

AMARILLAS

Plantilla del Basel Temporada 2021/2022

		Edad	Altura	Peso
Portero
13	D. Nikolic	27	195	91	-	-	-
46	F. Gebhardt	22	188	83	-	-	-
1	H. Lindner	33	187	80	-	-	-
44	Tim Spycher	20	187	-	-	-	-
Defensa
21	Andy Pelmard	24	180	66	-	-	1
19	Darian Males	22	188	76	-	-	-
4	Eray Cömert	26	183	80	-	-	1
3	Gonçalo Cardoso	23	186	83	-	-	-
5	Michael Lang	33	185	79	2	-	-
6	N. Djiga	21	187	77	-	-	1
28	R. Petretta	27	176	70	-	-	-
22	Sergio López	25	179	69	-	-	-
30	Tomas Tavares	23	182	77	-	-	-
Centrocampista
29	Adrian Durrer	22	188	78	-	-	-
20	Fabian Frei	35	183	80	-	-	2
8	J. Quintillà	30	181	70	-	-	-
40	L. Chipperfield	20	178	-	-	-	-
35	M. Palacios	21	171	70	-	-	-
7	P. Kasami	31	188	84	2	-	2
34	T. Xhaka	33	172	75	-	-	-
14	V. Stocker	35	178	65	-	-	1
23	Wouter Burger	23	191	73	-	-	1
Delantero
10	Arthur	25	186	82	5	-	1
27	Dan Ndoye	23	184	74	1	-	-
99	Edon Zhegrova	25	181	63	2	-	-
96	Joelson Fernandes	21	172	63	-	-	1
17	Liam Millar	24	181	68	2	-	1
9	S. Esposito	21	183	75	-	-	-
24	Tician Tushi	23	180	71	-	-	-

Noticias del Basel

Ver últimas noticias

Sorteada la tercera ronda previa de Champions League

Sergio Álvarez - Viernes, 17 Julio 2015

0 3.602

La UEFA ha anunciado hoy los enfrentamientos entre equipo de la tercera ronda de los que ya se conocen los equipos y también qué enfrentamientos habrá entre los vencedores de la segunda fase.

Kuzmanovic regresa a Suiza con el Basilea

BeSoccer - Martes, 30 Junio 2015

0 235

El centrocampista de 27 años Zdravko Kuzmanovic regresa a su país para incorporarse al Basilea procedente del Inter de Milán y permanecerá en el club azulgrana hasta 2017.

Sio continuará con su carrera en el Rennes

BeSoccer - Lunes, 29 Junio 2015

0 79

El club del noroeste de Francia, ha anunciado de manera oficial mediante las redes sociales la contratación de Giovanni Sio. El futbolista procede del Basilea suizo.

El Basilea ficha a Marc Janko por un año

BeSoccer - Jueves, 25 Junio 2015

0 172

El delantero anunció en su página de Facebook que jugará la próxima temporada en el Basilea suizo.

El portugués Paulo Sousa, nuevo entrenador del Fiorentina

BeSoccer - Domingo, 21 Junio 2015

0 203

El portugués Paulo Sousa será el entrenador del Fiorentina, informó hoy el club italiano en un comunicado.

Ver más noticias del equipo»

Competiciones que juega

Conference League Grupo 8

Pos	Equipos		Pts
1		Basel	14
2		Qarabağ	11
3		Omonia Nicosia	4
4		Kairat Almaty	2

	Siguiente Ronda : Basel
	: Qarabağ

RIVALES EN Conference Leagu.

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Suiza

RIVALES EN Liga Suiza

USO DE MEMORIA

6,690,168 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.2235
Total Execution Time	0.2255

CADENA URL

/Basel/2022

GET DATOS

$_GET['/Basel/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (52)

0.0018	SELECT type FROM routes WHERE alias = 'basel'
0.0041	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 = 'Basel' AND l.year = 2022 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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=10035 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 = 64017
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 = 66139
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 = 63179
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 = 62617
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 = 63331
0.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=10035 AND type_rel = 2
0.0025	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 10035 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021	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 (236,665,916,1062,2898) ORDER BY n.cover_points DESC, update_date DESC
0.0036	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 = '10035' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0065	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 = '10035' 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 = 66139 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 = 62617 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 = 63331 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 = 63179 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	(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 calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 10035 or c.datateam2 = 10035) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0033	(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 calendars2022 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 = 10035 or c.datateam2 = 10035) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0032	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 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 = 10035 or c.datateam2 = 10035) AND l.year = 2022)
0.0037	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=10035 AND l.year in (2021,2022,2023) 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 (70410,68166,67779,67758,67320,58772) 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 = 67779 AND teamId = 10035
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 70410 AND teamId = 10035
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 58772 AND teamId = 10035
0.0025	SELECT count(id) as num_players from rel_players WHERE league_id = 67758 AND teamId = 10035
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 68166 AND teamId = 10035
0.0154	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 10035
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 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 = 64017 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021	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 = '10035' 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 = '10035' and rp.type = 4
0.0024	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 = '10035' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0019	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '10035' and rp.type = 4
0.0042	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 events2022 e ON e.player_id = p.id AND e.league_id = 64017 WHERE rp.league_id = 64017 AND rp.teamId = 10035 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.0040	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 events2022 e ON e.player_id = p.id AND e.league_id = 64017 WHERE rp.league_id = 64017 AND rp.teamId = 10035 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021	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 events2022 e ON e.player_id = p.id AND e.league_id = 64017 WHERE rp.league_id = 64017 AND rp.teamId = 10035 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033	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 = 10035 AND rp.league_id = 64017 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0025	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=6463947 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0019	SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6463947
0.0025	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6463947 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.0024	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6463947 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0024	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6463947 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6463947 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0025	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 events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6463947 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC

Resultados de Fútbol

Basel

Información sobre Basel

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

Liga Suiza Grupo 1

Copa Suiza

Europa League Grupo 3

Champions League Grupo 1

Fase Previa Champions League Grupo 4

Partidos Amistosos

Fase Previa Europa League Grupo 5

Fase Previa Conference League Grupo 2

Copa de Ferias

Conference League Grupo 8

Copa Intertoto

Recopa de Europa

Amistosos Selecciones Sub 23

Partidos del Basel

Estadísticas

Plantilla del Basel Temporada 2021/2022

Noticias del Basel

Sorteada la tercera ronda previa de Champions League

Kuzmanovic regresa a Suiza con el Basilea

Sio continuará con su carrera en el Rennes

El Basilea ficha a Marc Janko por un año

El portugués Paulo Sousa, nuevo entrenador del Fiorentina

Basel

Selecciona un equipo

Competiciones que juega

Conference League Grupo 8

RIVALES EN Conference Leagu.

RIVALES EN Fase Previa Conf.

RIVALES EN Copa Suiza

RIVALES EN Liga Suiza


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos