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

Raja Beni Mellal

Temporada 2023/2024

TEMPORADA 2023/2024

BOTOLA 2
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2022/2023

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Renaissance	30	29	15	54
2	Stade	30	38	27	52
3	Youssoufia	30	34	26	52
4	Rapide Oued	30	40	28	49
5	Olympique	30	38	27	47
6	USM Oujda	30	21	23	41
7	Chabab	30	26	19	40
8	Chabab Atlas	30	33	38	37
9	d'El Massira	29	36	38	36
10	Ittifaq	30	31	33	36
11	Racing	30	28	31	36
12	AS Salé	30	39	43	34
13	Wydad Fès	30	30	38	34
14	Raja Beni M.	29	23	34	31
15	Ittihad	30	18	30	28
16	Widad Temara	30	20	34	23

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 PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	43	23	60
2	Wydad	30	52	28	59
3	RSB Berkane	30	35	23	57
4	FUS Rabat	30	39	30	49
5	Mouloudia	30	35	28	48
6	FAR Rabat	30	45	34	45
7	Moghreb	30	30	27	40
8	Rapide Oued	30	30	30	36
9	Youssoufia	30	33	44	36
10	Hassania	30	34	38	36
11	Difaâ	30	26	28	35
12	Renaissance	30	40	41	34
13	Olympic Safi	30	25	34	33
14	Ittihad	30	20	36	32
15	Olympique	30	24	38	28
16	Raja Beni M.	30	13	42	12

TEMPORADA 2018/2019

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Renaissance	30	33	14	53
2	Raja Beni M.	30	38	27	53
3	Olympique	30	49	33	50
4	KAC Kenitra	30	44	33	46
5	Maghreb Fes	30	39	30	46
6	Racing	30	43	34	42
7	Ittihad	30	34	29	40
8	Widad Temara	30	29	30	40
9	Chabab Atlas	30	23	34	37
10	JS Soualem	30	34	36	36
11	Wydad Fès	30	24	27	35
12	Sidi Kacem	30	34	41	35
13	Chabab	30	27	32	33
14	AS Salé	30	32	43	32
15	Laayoune	30	26	43	27
16	Kasba Tadla	30	21	44	21

TEMPORADA 2017/2018

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Mouloudia	30	48	27	60
2	Youssoufia	30	43	21	56
3	Raja Beni M.	30	38	23	56
4	Chabab	30	32	26	47
5	Olympique	30	27	28	42
6	Wydad Fès	30	26	22	41
7	Maghreb Fes	30	38	29	40
8	Laayoune	30	29	31	39
9	Sidi Kacem	30	27	33	34
10	AS Salé	30	33	32	33
11	KAC Kenitra	30	19	29	32
12	Ittihad	30	29	36	31
13	Widad Temara	30	23	32	31
14	Kasba Tadla	30	23	38	29
15	Rachad	30	24	38	27
16	USM Oujda	30	23	37	24

TEMPORADA 2016/2017

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Racing	26	33	27	43
2	Rapide Oued	26	29	22	40
3	Mouloudia	26	29	22	38
4	Laayoune	26	24	21	38
5	AS Salé	26	34	36	37
6	Maghreb Fes	26	34	26	37
7	Youssoufia	26	26	25	36
8	Ittihad	26	27	25	35
9	Raja Beni M.	26	20	25	33
10	Widad Temara	26	19	20	32
11	Melloul	26	20	21	30
12	Olympique	26	26	29	30
13	Sidi Kacem	26	20	26	30
14	Rachad	26	29	34	28
15	Wydad Fès	26	28	34	27
16	US Temara	26	22	27	27

TEMPORADA 2015/2016

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Chabab Atlas	30	30	21	49
2	Kasba Tadla	30	24	20	49
3	AS Salé	30	32	29	42
4	Rachad	30	31	27	41
5	US Temara	30	31	29	41
6	Youssoufia	30	27	25	41
7	Racing	30	37	38	41
8	Olympique	30	20	21	39
9	Raja Beni M.	30	24	29	39
10	Laayoune	30	35	32	38
11	Ittihad	30	23	22	38
12	Widad Temara	30	26	22	37
13	Melloul	30	29	28	37
14	Wydad Fès	30	28	32	37
15	Olympique	30	24	28	37
16	CODM Meknes	30	24	42	31

TEMPORADA 2014/2015

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Ittihad	30	22	11	54
2	Mouloudia	30	32	22	49
3	Melloul	30	39	24	48
4	Kasba Tadla	30	29	22	48
5	Youssoufia	30	34	25	46
6	Raja Beni M.	30	21	16	39
7	Laayoune	30	24	24	37
8	AS Salé	30	23	26	37
9	US Temara	30	33	37	36
10	CODM Meknes	30	28	29	35
11	Widad Temara	30	23	26	35
12	Racing	30	27	35	35
13	Olympique	30	24	32	33
14	Wydad Fès	30	19	28	33
15	Chabab	30	23	31	31
16	Union	30	22	35	28

TEMPORADA 2013/2014

BOTOLA 2
Equipo		PJ	GF	GC	Puntos
1	Ittihad	30	34	13	57
2	Chabab Atlas	30	36	13	53
3	Ittihad	30	33	21	48
4	CODM Meknes	30	34	31	46
5	Tihad Temara	30	26	25	44
6	Raja Beni M.	30	38	33	41
7	Union	30	23	27	39
8	Kasba Tadla	30	31	29	36
9	Youssoufia	30	24	28	36
10	Mouloudia	30	25	30	35
11	Chabab	30	30	37	35
12	Laayoune	30	23	34	35
13	Racing	30	25	28	34
14	Melloul	30	23	33	30
15	Rachad	30	21	31	29
16	USM Oujda	30	23	36	28

TEMPORADA 2012/2013

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	56	24	66
2	FAR Rabat	30	34	18	62
3	Maghreb Fes	30	36	27	48
4	Wydad	30	31	22	48
5	Moghreb	30	40	28	46
6	FUS Rabat	30	31	27	41
7	RSB Berkane	30	30	31	40
8	Chabab	30	28	31	36
9	Difaâ	30	28	32	35
10	Hassania	30	24	26	34
11	Wydad Fès	30	25	32	33
12	Olympic Safi	30	36	48	32
13	Olympique	30	27	33	30
14	KAC Kenitra	30	23	35	27
15	CODM Meknes	30	25	40	25
16	Raja Beni M.	30	22	42	24

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 2001/2002

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Hassania	30	41	9	65
2	Wydad	30	38	12	62
3	Raja	30	42	18	55
4	Maghreb Fes	30	31	16	52
5	Olympique	30	32	22	47
6	FAR Rabat	30	27	24	42
7	Casablanca	30	24	26	41
8	Ittihad	30	22	29	35
9	d'El Massira	30	32	45	35
10	CODM Meknes	30	18	25	34
11	Settat	30	20	34	32
12	Kawkab	30	25	30	31
13	FUS Rabat	30	17	22	31
14	Ittihad	30	27	35	31
15	Stade	30	21	41	30
16	Raja Beni M.	30	18	47	20

TEMPORADA 2000/2001

BOTOLA PRO
Equipo		PJ	GF	GC	Puntos
1	Raja	30	33	12	64
2	FUS Rabat	30	32	17	55
3	Maghreb Fes	30	33	22	48
4	Settat	30	26	19	48
5	Olympique	30	25	19	42
6	Wydad	30	34	25	41
7	Kawkab	30	24	21	41
8	FAR Rabat	30	25	35	37
9	Ittihad	30	24	31	35
10	Casablanca	30	26	38	33
11	CODM Meknes	30	21	25	32
12	Hassania	30	21	29	31
13	d'El Massira	30	27	33	30
14	Raja Beni M.	30	26	32	30
15	Mohammédia	30	21	30	30
16	Racing	30	13	23	26

Competiciones que juega

RIVALES EN Botola 2

RIVALES EN Copa Marruecos

USO DE MEMORIA

6,589,688 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6935
Total Execution Time	0.6947

CADENA URL

/historico/Raja-Beni-Mellal

GET DATOS

$_GET['/historico/Raja-Beni-Mellal']

POST DATOS

No hay datos POST existentes

CONSULTAS (37)

0.0165	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 = 'Raja-Beni-Mellal' 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.0147	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=11216 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0148	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=11216 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150	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=11216 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0318	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 = 73593
0.0186	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 = 75598
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11216 AND type_rel = 2
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=409 AND type_rel = 3
0.0151	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 409 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0149	SELECT /53 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 (975843,911464,803650,73999) ORDER BY n.cover_points DESC, update_date DESC
0.0151	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 = '11216' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '11216' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146	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 = 73593 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148	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 = 75598 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149	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=11216 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145	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) 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.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 73593 AND teamId = 11216
0.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 75598 AND teamId = 11216
0.0158	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 = 11216 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.0154	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 = 11216 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156	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 = 11216 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151	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 = 11216 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0146	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 = 24 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 69255 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.0149	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.0149	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.0148	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 = 50017 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.0151	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 = 44516 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 38717 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157	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 = 34135 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164	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 = 15522 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0168	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 = 4197 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 2934 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 2213 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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.0150	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* `tables2002` 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 = 23631 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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* `tables2001` 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 = 23635 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Raja Beni Mellal

Raja Beni Mellal

Selecciona un equipo

Competiciones que juega

RIVALES EN Botola 2

RIVALES EN Copa Marruecos