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

KAC Kenitra

Temporada 2023/2024

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 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 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 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 PRO
Equipo		PJ	GF	GC	Puntos
1	Moghreb	30	41	13	61
2	FUS Rabat	30	32	16	57
3	Wydad	30	32	18	51
4	Raja	30	34	24	51
5	Difaâ	30	35	27	48
6	FAR Rabat	30	32	29	41
7	Maghreb Fes	30	35	26	41
8	Olympic Safi	30	34	43	36
9	Olympique	30	27	32	35
10	CODM Meknes	30	19	26	35
11	KAC Kenitra	30	29	40	35
12	Hassania	30	22	31	35
13	Chabab	30	31	27	33
14	Wydad Fès	30	26	39	30
15	Laayoune	30	24	42	28
16	Ittihad	30	12	32	24

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 2
Equipo		PJ	GF	GC	Puntos
1	FUS Rabat	30	32	14	55
2	KAC Kenitra	30	37	21	53
3	Chabab	30	26	18	47
4	UTS Rabat	30	27	21	43
5	Sidi Kacem	30	27	27	42
6	Rachad	30	22	14	41
7	SCCM	30	20	24	39
8	US Temara	30	30	27	37
9	Racing	30	27	27	37
10	Youssoufia	30	18	21	36
11	Union	30	23	28	36
12	Settat	30	25	30	35
13	Casablanca	30	26	38	33
14	Hilal Nador	30	19	29	32
15	Stade	30	19	28	31
16	RSB Berkane	30	22	33	28

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

RIVALES EN Copa Marruecos

USO DE MEMORIA

6,889,760 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1282
Total Execution Time	0.1302

CADENA URL

/historico/Kac-Kenitra

GET DATOS

$_GET['/historico/Kac-Kenitra']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0028	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 = 'Kac-Kenitra' 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.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=1432 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=1432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0042	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.0019	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1432 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1432 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	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 (43517) ORDER BY n.cover_points DESC, update_date DESC
0.0026	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 = '1432' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '1432' 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 = 75598 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027	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=1432 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 (75598) 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 = 75598 AND teamId = 1432
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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 1432 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.0019	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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 1432 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 = 75598 WHERE rp.league_id = 75598 AND rp.teamId = 1432 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027	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 = 1432 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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.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* `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.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 = 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.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* `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.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 = 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.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* `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.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* `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.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* `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.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* `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 = 1585 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* `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.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* `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.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* `tables2009` 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 = 1055 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* `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.0043	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 = 8687 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* `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.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* `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

KAC Kenitra

KAC Kenitra

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa Marruecos