Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Kawkab Marrakech

Temporada 2023/2024

TEMPORADA 2023/2024

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	CODM Meknes	23	28	17	48
2	Kawkab	23	29	21	40
3	Difaâ	23	21	16	39
4	USM Oujda	23	24	14	37
5	Stade	23	29	26	34
6	Raja Beni M.	23	39	25	33
7	Olympique	23	26	22	32
8	d'El Massira	23	30	31	30
9	Olympique	23	22	24	29
10	Chabab Atlas	23	15	15	28
11	Chabab	23	20	21	27
12	Wydad Fès	23	20	28	25
13	Rapide Oued	23	14	19	24
14	Ittifaq	23	11	24	21
15	Racing	23	20	29	20
16	AS Salé	23	21	37	18

TEMPORADA 2021/2022

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Moghreb	30	47	19	66
2	UTS Rabat	30	40	31	55
3	Olympique	30	28	22	44
4	Renaissance	30	39	32	44
5	d'El Massira	30	25	33	41
6	AS Salé	30	32	33	40
7	Stade	30	36	34	40
8	Ittihad	30	27	32	39
9	Chabab	30	23	24	37
10	Raja Beni M.	30	24	30	37
11	Racing	30	33	39	36
12	Wydad Fès	30	30	33	35
13	Chabab Atlas	30	29	29	34
14	USM Oujda	30	34	36	34
15	Casablanca	30	27	31	34
16	Kawkab	30	27	43	24

TEMPORADA 2020/2021

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Olympique	30	38	25	54
2	JS Soualem	30	36	20	53
3	Wydad Fès	30	40	28	49
4	Olympique	30	40	30	48
5	UTS Rabat	30	39	34	48
6	Ittihad	30	35	33	41
7	Stade	30	37	37	40
8	Chabab	30	34	39	38
9	Racing	30	35	36	37
10	Kawkab	30	32	26	37
11	Chabab Atlas	30	35	39	36
12	Raja Beni M.	30	21	27	36
13	Casablanca	30	35	40	35
14	AS Salé	30	28	36	35
15	KAC Kenitra	30	27	37	35
16	Widad Temara	30	20	45	20

TEMPORADA 2019/2020

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Maghreb Fes	30	40	25	52
2	Mohammédia	30	38	26	51
3	Olympique	30	44	33	48
4	Racing	30	27	18	46
5	JS Soualem	30	25	21	45
6	Widad Temara	30	31	31	41
7	Wydad Fès	30	29	27	40
8	Chabab Atlas	30	27	33	39
9	Ittihad	30	40	43	36
10	KAC Kenitra	30	30	33	36
11	Casablanca	30	29	34	35
12	Kawkab	30	28	31	33
13	Chabab	30	26	32	33
14	AS Salé	30	25	30	33
15	Sidi Kacem	30	28	34	32
16	Chabab	30	24	40	27

TEMPORADA 2018/2019

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Wydad	30	56	30	59
2	Raja	30	56	36	55
3	Hassania	30	30	22	45
4	Olympic Safi	30	37	38	45
5	Ittihad	30	27	30	40
6	RSB Berkane	30	34	34	39
7	Youssoufia	30	36	37	39
8	Difaâ	30	30	32	39
9	FUS Rabat	30	25	25	38
10	Rapide Oued	30	28	31	37
11	Olympique	30	38	42	36
12	Mouloudia	30	31	38	35
13	Moghreb	30	29	32	34
14	FAR Rabat	30	32	32	33
15	Kawkab	30	34	40	30
16	Chabab	30	27	51	27

TEMPORADA 2017/2018

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Ittihad	30	34	23	52
2	Hassania	30	40	22	51
3	Wydad	30	44	26	51
4	FUS Rabat	30	34	26	49
5	Difaâ	30	49	33	48
6	Raja	30	45	33	48
7	Olympic Safi	30	32	28	43
8	FAR Rabat	30	35	34	43
9	RSB Berkane	30	37	34	41
10	Rapide Oued	30	27	31	37
11	Moghreb	30	24	35	36
12	Olympique	30	37	47	35
13	Chabab	30	27	31	33
14	Kawkab	30	29	48	32
15	Chabab Atlas	30	30	41	29
16	Racing	30	23	55	17

TEMPORADA 2016/2017

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Wydad	30	50	24	66
2	Difaâ	30	45	23	59
3	Raja	30	42	17	57
4	RSB Berkane	30	30	16	51
5	Ittihad	30	33	25	45
6	FAR Rabat	30	42	39	44
7	FUS Rabat	30	32	32	40
8	Hassania	30	32	40	38
9	Olympic Safi	30	25	32	36
10	Chabab Atlas	30	26	25	34
11	Olympique	30	34	40	34
12	Moghreb	30	30	37	34
13	Kawkab	30	36	42	33
14	Chabab	30	26	46	31
15	Kasba Tadla	30	25	47	28
16	KAC Kenitra	30	27	50	23

TEMPORADA 2015/2016

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	FUS Rabat	30	40	21	58
2	Wydad	30	34	19	56
3	Ittihad	30	36	23	50
4	Raja	30	48	30	47
5	FAR Rabat	30	40	35	47
6	RSB Berkane	30	24	19	43
7	Moghreb	30	34	43	43
8	Hassania	30	44	46	41
9	Olympic Safi	30	23	27	37
10	Chabab	30	27	34	36
11	KAC Kenitra	30	26	37	35
12	Difaâ	30	26	30	34
13	Olympique	30	26	35	34
14	Kawkab	30	23	30	30
15	Maghreb Fes	30	24	31	29
16	Mouloudia	30	26	41	29

TEMPORADA 2014/2015

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Wydad	30	48	21	59
2	Olympique	30	29	17	56
3	Kawkab	30	31	26	47
4	Moghreb	30	36	29	45
5	FUS Rabat	30	34	28	45
6	Hassania	30	42	46	40
7	Difaâ	30	26	23	39
8	Raja	30	37	34	38
9	Maghreb Fes	30	34	35	36
10	RSB Berkane	30	25	25	35
11	FAR Rabat	30	31	26	34
12	Olympic Safi	30	20	35	34
13	KAC Kenitra	30	25	29	33
14	Chabab Atlas	30	23	37	32
15	Chabab	30	26	43	32
16	Ittihad	30	27	40	29

TEMPORADA 2013/2014

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Moghreb	30	36	25	58
2	Raja	30	40	15	55
3	FUS Rabat	30	31	21	48
4	Kawkab	30	30	19	48
5	Difaâ	30	29	20	45
6	Wydad	30	34	29	43
7	FAR Rabat	30	30	30	39
8	Hassania	30	36	43	38
9	RSB Berkane	30	24	22	35
10	Chabab	30	24	31	35
11	Olympic Safi	30	28	30	33
12	KAC Kenitra	30	21	31	32
13	Maghreb Fes	30	27	36	31
14	Olympique	30	20	35	31
15	AS Salé	30	25	33	29
16	Wydad Fès	30	26	41	26

TEMPORADA 2012/2013

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Kawkab	30	44	12	65
2	AS Salé	30	30	13	57
3	Ittihad	30	25	26	50
4	Mouloudia	30	30	20	49
5	Rachad	30	27	22	45
6	Melloul	30	26	25	44
7	Youssoufia	30	34	38	39
8	USM Oujda	30	29	32	36
9	Union	30	27	28	35
10	Kasba Tadla	30	19	22	35
11	Racing	30	26	33	35
12	Laayoune	30	26	32	34
13	Ittihad	30	28	35	33
14	US Temara	30	23	31	32
15	Casablanca	30	17	27	32
16	Olympique	30	25	40	22

TEMPORADA 2011/2012

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Raja Beni M.	30	25	15	48
2	RSB Berkane	30	29	27	47
3	Casablanca	30	32	27	46
4	Union	30	38	27	43
5	Kawkab	30	29	19	42
6	AS Salé	30	32	24	41
7	Melloul	30	37	40	40
8	Racing	30	27	24	39
9	Youssoufia	30	33	34	39
10	Mouloudia	30	26	31	39
11	Kasba Tadla	30	22	27	35
12	Ittihad	30	21	26	34
13	Rachad	30	26	33	33
14	US Temara	30	15	20	32
15	Chabab	30	22	32	31
16	Stade	30	26	34	29

TEMPORADA 2010/2011

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	45	23	60
2	Maghreb Fes	30	34	23	53
3	Wydad	30	31	18	51
4	Olympique	30	31	20	50
5	Olympic Safi	30	31	25	49
6	FAR Rabat	30	28	27	40
7	FUS Rabat	30	22	21	38
8	Moghreb	30	26	28	36
9	Hassania	30	22	24	36
10	Difaâ	30	25	25	35
11	Laayoune	30	24	35	34
12	Chabab	30	21	24	33
13	KAC Kenitra	30	16	24	32
14	Wydad Fès	30	21	30	31
15	Kawkab	30	19	25	28
16	Kasba Tadla	30	17	41	20

TEMPORADA 2009/2010

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Wydad	30	36	22	54
2	Raja	30	39	26	52
3	Difaâ	30	30	17	50
4	Kawkab	30	27	19	44
5	Olympique	30	30	26	43
6	Hassania	30	33	31	41
7	FAR Rabat	30	21	20	40
8	Maghreb Fes	30	29	26	39
9	KAC Kenitra	30	28	30	38
10	Moghreb	30	18	18	36
11	Wydad Fès	30	33	41	36
12	FUS Rabat	30	24	30	36
13	Laayoune	30	26	33	34
14	Ittihad	30	15	22	33
15	Olympic Safi	30	29	37	33
16	AS Salé	30	15	35	24

TEMPORADA 2008/2009

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	44	17	61
2	Difaâ	30	32	20	54
3	FAR Rabat	30	39	17	53
4	Wydad	30	26	17	50
5	Olympique	30	26	25	46
6	Moghreb	30	29	28	41
7	Maghreb Fes	30	28	27	40
8	AS Salé	30	27	29	40
9	Hassania	30	30	30	38
10	Kawkab	30	28	31	36
11	Olympic Safi	30	25	28	34
12	Laayoune	30	31	41	34
13	Ittihad	30	22	29	33
14	KAC Kenitra	30	24	34	31
15	Mouloudia	30	21	37	28
16	SCCM	30	16	38	21

TEMPORADA 2007/2008

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	FAR Rabat	30	36	23	53
2	Ittihad	30	34	22	50
3	Raja	30	32	23	48
4	Hassania	30	23	14	46
5	Difaâ	30	29	27	46
6	Olympique	30	32	26	43
7	Moghreb	30	29	19	42
8	Wydad	30	28	23	40
9	Laayoune	30	27	28	38
10	Maghreb Fes	30	27	29	37
11	Olympic Safi	30	31	31	36
12	Kawkab	30	23	31	33
13	KAC Kenitra	30	20	33	31
14	Mouloudia	30	29	48	31
15	FUS Rabat	30	23	30	26
16	CODM Meknes	30	24	40	24

TEMPORADA 2006/2007

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Olympique	30	38	16	62
2	FAR Rabat	30	31	17	55
3	Moghreb	30	37	31	54
4	Wydad	30	30	20	47
5	Difaâ	30	29	19	42
6	Kawkab	30	23	17	42
7	Ittihad	30	24	23	42
8	Laayoune	30	21	21	37
9	Hassania	30	22	23	36
10	Mouloudia	30	25	35	36
11	Raja	30	23	20	35
12	Olympic Safi	30	22	31	32
13	CODM Meknes	30	17	24	31
14	Maghreb Fes	30	19	34	29
15	Ittihad	30	21	30	26
16	AS Salé	30	21	42	21

TEMPORADA 2004/2005

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	FAR Rabat	30	35	9	62
2	Raja	30	42	17	60
3	Wydad	30	32	14	50
4	Olympic Safi	30	25	22	41
5	Laayoune	30	26	25	39
6	Ittihad	30	18	21	37
7	Hassania	30	19	21	36
8	Olympique	30	24	29	36
9	UTS Rabat	30	27	33	36
10	AS Salé	30	25	33	35
11	SCCM	30	18	24	34
12	Mouloudia	30	21	27	33
13	CODM Meknes	30	16	22	33
14	Ittihad	30	19	28	33
15	Maghreb Fes	30	22	26	32
16	Kawkab	30	17	35	27

TEMPORADA 2003/2004

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	37	18	56
2	FAR Rabat	30	36	17	56
3	AS Salé	30	33	23	51
4	Wydad	30	19	8	49
5	Olympique	30	30	17	48
6	CODM Meknes	30	30	22	48
7	Mouloudia	30	23	29	39
8	Maghreb Fes	30	28	32	38
9	Hassania	30	23	26	37
10	Kawkab	30	24	24	36
11	d'El Massira	30	20	25	35
12	Ittihad	30	15	19	34
13	Mohammédia	30	13	26	31
14	Ittihad	30	17	24	29
15	Settat	30	15	29	27
16	KAC Kenitra	30	14	38	18

TEMPORADA 2002/2003

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Hassania	30	32	12	54
2	Raja	30	36	18	52
3	Wydad	30	25	15	52
4	CODM Meknes	30	25	16	52
5	Maghreb Fes	30	34	20	49
6	Olympique	30	27	24	44
7	Mohammédia	30	23	26	37
8	d'El Massira	30	25	32	34
9	FAR Rabat	30	27	29	33
10	Casablanca	30	23	27	33
11	Ittihad	30	22	30	33
12	Settat	30	19	26	32
13	Kawkab	30	25	34	32
14	KAC Kenitra	30	20	24	31
15	Ittihad	30	22	38	30
16	FUS Rabat	30	13	27	27

Competiciones que juega

Botola 2

Pos	Equipos		Pts
1		CODM Meknes	48
2		Kawkab Marrakech	40
3		Difaâ El Jadida	39
4		USM Oujda	37
5		Stade Marocain	34
6		Raja Beni Mellal	33
7		Olympique Khouribga	32
8		JS d'El Massira	30
9		Olympique Dcheïra	29
10		Chabab Atlas Khenifra	28
11		Chabab Benguerir	27
12		Wydad Fès	25
13		Rapide Oued Zem	24
14		Ittifaq Marrakech	21
15		Racing de Casablanca	20
16		AS Salé	18

	Ascenso : CODM Meknes, Kawkab Marrakech
	Descenso : Racing de Casablanca, AS Salé

RIVALES EN Botola 2

RIVALES EN Copa Marruecos

USO DE MEMORIA

7,670,608 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1372
Total Execution Time	0.1384

CADENA URL

/historico/Kawkab-Marrakech

GET DATOS

$_GET['/historico/Kawkab-Marrakech']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6427 AND type_rel = 2
0.0061	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 = '6427' ORDER BY l.year DESC,cat.coefficient DESC
0.0070	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 = '6427' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0057	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=6427 AND l.year in (2023,2024,2025) 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 (75598,73593,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.0032	SELECT count(id) as num_players from rel_players WHERE league_id = 73593 AND teamId = 6427
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 6427
0.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6427
0.0041	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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 6427 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.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 = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 6427 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 events2024 e ON e.player_id = p.id AND e.league_id = 73593 WHERE rp.league_id = 73593 AND rp.teamId = 6427 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029	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 = 6427 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73593 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 64195 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.0035	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 = 60253 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.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* `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 = 50044 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.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* `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 = 43575 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* `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 = 38664 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* `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 = 34134 AND t.round = 30 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* `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 = 15633 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 3857 AND t.round = 30 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* `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 = 3455 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 8703 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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 = 8702 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 1584 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables2010` 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 = 1056 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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* `tables2008` 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 = 273 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0035	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* `tables2007` 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 = 8684 AND t.round = 30 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* `tables2005` 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 = 8679 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0033	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* `tables2004` 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 = 23624 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* `tables2003` 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 = 23628 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Kawkab Marrakech

Kawkab Marrakech

Selecciona un equipo

Competiciones que juega

Botola 2

RIVALES EN Botola 2

RIVALES EN Copa Marruecos