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

Resultados de Fútbol

Kabwe Warriors

Temporada 2023/2024

TEMPORADA 2023/2024

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Red Arrows	29	42	15	61
2	Zesco United	29	39	26	51
3	Power	29	34	20	48
4	MUZA	29	31	23	47
5	Nkwazi	29	26	27	44
6	Kabwe	29	27	23	42
7	Green Eagles	29	34	35	41
8	Forest	29	29	28	37
9	Nkana FC	29	23	28	37
10	Green	29	29	31	36
11	Zanaco	29	24	27	36
12	NAPSA Stars	29	22	26	34
13	Konkola	29	20	27	34
14	Mutondo	29	25	30	33
15	Mufulira	29	26	31	31
16	Kansanshi	29	20	30	29
17	Prison	29	22	33	28
18	Trident	29	22	35	21

TEMPORADA 2022/2023

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Power	34	48	19	65
2	MUZA	34	41	29	57
3	Zesco United	34	46	27	55
4	Green	34	41	29	55
5	NAPSA Stars	34	40	26	51
6	Red Arrows	34	45	34	51
7	Green Eagles	34	36	34	50
8	Forest	34	30	24	48
9	Nkana FC	34	32	27	48
10	Kansanshi	34	33	31	48
11	Kabwe	34	37	27	46
12	Prison	34	35	36	45
13	Zanaco	34	32	32	41
14	Nkwazi	34	30	33	39
15	Nchanga	34	32	43	37
16	Lumwana	34	32	40	34
17	Chambishi	34	34	60	32
18	Buildcon FC	34	16	89	10

TEMPORADA 2021/2022

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Red Arrows	34	52	28	70
2	Zesco United	34	39	22	63
3	Green Eagles	34	34	22	57
4	Nkana FC	34	35	29	52
5	Power	34	38	27	50
6	Zanaco	34	31	28	49
7	Kansanshi	34	26	27	48
8	Kabwe	34	34	30	46
9	Prison	34	33	30	46
10	Buildcon FC	34	38	37	46
11	Forest	34	37	35	44
12	Green	34	46	46	44
13	Nkwazi	34	25	31	38
14	Chambishi	34	23	38	38
15	Lusaka	34	27	38	31
16	Kafue Celtic	34	27	40	31
17	Indeni	34	20	46	31
18	Konkola	34	27	38	30

TEMPORADA 2020/2021

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	34	49	31	68
2	Zanaco	34	50	36	55
3	Red Arrows	34	35	28	51
4	Kabwe	34	37	34	51
5	Green Eagles	34	39	30	50
6	Buildcon FC	34	47	39	49
7	Prison	34	40	33	48
8	Lusaka	34	35	31	48
9	Nkwazi	34	30	28	48
10	Green	34	41	32	47
11	Power	34	29	26	47
12	Forest	34	36	35	45
13	Young Green	34	26	37	43
14	Nkana FC	34	41	49	42
15	Indeni	34	39	43	41
16	NAPSA Stars	34	34	47	37
17	Lumwana	34	23	42	33
18	Kitwe United	34	15	45	20

TEMPORADA 2019/2020

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Nkana FC	27	35	18	50
2	Forest	27	32	19	50
3	Green Eagles	27	34	19	48
4	NAPSA Stars	27	36	22	48
5	Zesco United	27	38	23	47
6	Power	27	34	19	44
7	Zanaco	27	37	26	44
8	Kabwe	27	29	29	41
9	Lusaka	27	33	28	40
10	Red Arrows	27	26	28	40
11	Green	27	28	27	38
12	Nkwazi	27	18	20	32
13	Buildcon FC	27	29	35	32
14	Lumwana	27	21	22	31
15	Kansanshi	27	19	24	28
16	Mufulira	27	17	39	17
17	Nakambala	27	15	45	17
18	Kabwe YSA	27	16	54	14

TEMPORADA 2018/2019

PREMIER LEAGUE ZAMBIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Lusaka	18	23	15	34
2	Zesco United	18	35	20	33
3	Zanaco	18	40	28	33
4	Red Arrows	18	25	15	33
5	Kabwe	18	22	13	31
6	Green	18	16	16	20
7	Mufulira	18	15	27	18
8	Nakambala	18	12	24	17
9	Kitwe United	18	14	25	11
10	Prison	18	10	29	9

TEMPORADA 2017/2018

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	38	53	22	80
2	Nkana FC	38	66	27	76
3	Green	38	39	19	74
4	Green Eagles	38	52	29	71
5	Zanaco	38	53	40	67
6	Power	38	48	33	62
7	Kabwe	38	31	27	58
8	Buildcon FC	38	44	37	56
9	Red Arrows	38	34	31	53
10	Nkwazi	38	31	29	51
11	Lusaka	38	47	48	51
12	Forest	38	38	39	51
13	Kitwe United	38	36	37	46
14	NAPSA Stars	38	29	30	45
15	Nakambala	38	18	32	43
16	Lumwana	38	24	40	41
17	National	38	38	55	39
18	Kabwe YSA	38	28	59	27
19	Nchanga	38	16	47	26
20	Monze	38	16	60	18

TEMPORADA 2016/2017

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	38	51	27	74
2	Zanaco	38	57	28	73
3	Nkana FC	38	53	29	71
4	Green	38	47	26	70
5	Lusaka	38	44	33	63
6	Power	38	50	30	62
7	NAPSA Stars	38	43	34	58
8	Buildcon FC	38	33	28	55
9	Lumwana	37	37	29	53
10	Red Arrows	38	42	36	52
11	Forest	38	37	39	49
12	Nkwazi	38	34	40	47
13	Green Eagles	37	31	35	44
14	Kabwe	37	31	33	43
15	Nchanga	38	35	45	43
16	Nakambala	37	22	34	40
17	Mufulira	38	38	53	39
18	Konkola	38	24	51	30
19	Real Nakonde	38	17	53	28
20	City Lusaka	38	30	73	16

TEMPORADA 2015/2016

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zanaco	34	71	16	81
2	Zesco United	34	57	19	72
3	Nkana FC	34	58	31	70
4	Power	34	47	29	61
5	Green	34	38	32	53
6	Kabwe	34	33	28	50
7	Red Arrows	34	27	30	46
8	Nkwazi	34	40	39	45
9	Forest	34	26	33	43
10	NAPSA Stars	34	28	30	42
11	Mufulira	34	26	33	39
12	Nchanga	34	28	36	39
13	Green Eagles	34	26	30	38
14	Lumwana	34	23	31	38
15	Lusaka	34	28	50	36
16	Nakambala	34	24	39	35
17	Lusaka	34	18	49	25
18	Mufulira	34	9	52	12

TEMPORADA 2013/2014

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	30	44	25	59
2	Power	30	55	23	57
3	Zanaco	30	54	28	57
4	Nkana FC	30	50	29	52
5	NAPSA Stars	30	29	21	47
6	Nchanga	30	33	32	42
7	Green Eagles	30	27	25	38
8	Red Arrows	30	31	31	38
9	National	30	33	43	37
10	Green	30	38	38	36
11	Nakambala	30	21	33	36
12	Konkola	30	20	33	36
13	Kabwe	30	24	41	34
14	Konkola Mine	30	27	44	29
15	Indeni	30	26	45	27
16	Roan United	30	21	42	21

TEMPORADA 2012/2013

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Nkana FC	30	45	22	60
2	Zesco United	30	52	22	57
3	Zanaco	30	41	26	49
4	Nchanga	30	34	30	49
5	Red Arrows	30	30	22	47
6	Green	30	34	29	45
7	Roan United	30	33	29	43
8	Power	30	33	28	42
9	Konkola	30	26	29	42
10	Kabwe	30	27	27	40
11	Konkola Mine	30	26	37	38
12	NAPSA Stars	30	28	35	37
13	Nkwazi	30	29	34	34
14	Lime	30	23	49	27
15	Kalulushi	30	24	43	24
16	Forest	30	20	43	18

TEMPORADA 2010/2011

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Power	30	49	18	59
2	Red Arrows	30	41	23	53
3	Konkola	30	28	18	50
4	Nchanga	30	23	18	49
5	Green	30	31	24	48
6	Zesco United	30	33	19	47
7	Nkana FC	30	35	29	46
8	Zanaco	30	37	31	44
9	Forest	30	30	26	42
10	Nakambala	30	24	35	41
11	Green Eagles	30	21	23	38
12	Roan United	30	27	35	34
13	Kabwe	30	22	28	30
14	Lime	30	21	34	30
15	Nkwazi	30	28	53	28
16	Kalewa	30	17	53	17

TEMPORADA 2009/2010

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	29	41	16	60
2	Nchanga	29	34	20	53
3	Green	28	37	17	50
4	Power	30	36	21	50
5	Zanaco	27	37	20	44
6	Nkana FC	28	27	24	42
7	Nkwazi	30	24	37	37
8	Red Arrows	28	31	30	35
9	Konkola	28	25	30	35
10	Kabwe	28	24	23	34
11	Roan United	27	17	26	34
12	Choma Eagles	29	22	24	32
13	Forest	28	21	29	30
14	City Lusaka	27	15	37	24
15	Lusaka	30	20	43	23
16	National	28	24	38	22

TEMPORADA 2008/2009

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zanaco	30	50	18	63
2	Zesco United	30	36	16	63
3	Power	30	34	22	54
4	City Lusaka	30	29	25	48
5	Choma Eagles	30	30	25	45
6	Green	30	31	28	45
7	Red Arrows	30	33	22	43
8	Forest	30	29	30	41
9	Konkola	30	27	28	39
10	Roan United	30	33	36	37
11	Kabwe	30	20	23	37
12	Lusaka	30	26	26	36
13	Chambishi	30	23	33	33
14	Zamtel	30	13	31	27
15	Nakambala	30	17	39	22
16	Young Arrows	30	18	47	15

TEMPORADA 2007/2008

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	30	33	14	51
2	Red Arrows	30	30	16	48
3	Green	30	33	23	47
4	Zanaco	30	32	33	45
5	Power	30	31	23	44
6	Kabwe	30	29	28	43
7	Young Arrows	30	29	23	42
8	City Lusaka	30	24	23	40
9	Konkola	30	24	24	37
10	Chambishi	30	22	35	37
11	Roan United	30	31	37	36
12	Lusaka	30	17	19	35
13	Nchanga	30	21	29	35
14	Nkana FC	30	25	34	33
15	Nkwazi	30	20	30	32
16	Green Eagles	30	31	41	30

TEMPORADA 2006/2007

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zesco United	30	50	15	68
2	Green	30	39	25	53
3	Power	30	41	25	51
4	Kabwe	30	34	22	51
5	Young Arrows	30	38	32	46
6	Lusaka	30	25	25	46
7	Zanaco	30	38	25	45
8	Konkola	30	29	26	40
9	Red Arrows	30	22	26	35
10	Nchanga	30	25	31	34
11	Roan United	30	25	36	34
12	City Lusaka	30	22	33	34
13	Zamtel	30	17	29	29
14	Forest	30	20	30	27
15	Nakambala	30	24	51	25
16	National	30	17	35	23

TEMPORADA 2005/2006

PREMIER LEAGUE ZAMBIA
Equipo		PJ	GF	GC	Puntos
1	Zanaco	30	57	18	71
2	Green	30	44	24	57
3	Power	30	40	30	51
4	Kabwe	31	34	25	45
5	Forest	30	24	20	45
6	Konkola	30	28	21	44
7	Lusaka	31	37	40	41
8	Nakambala	30	30	37	40
9	Zesco United	29	24	21	38
10	Red Arrows	30	44	40	37
11	National	30	30	31	37
12	Nkwazi	30	28	37	36
13	Nchanga	29	25	33	35
14	Lusaka	30	20	38	26
15	Kitwe United	30	9	31	23
16	Chambishi	30	16	44	19

Competiciones que juega

Premier League Zambia

Pos	Equipos		Pts
1		Red Arrows	61
2		Zesco United	51
3		Power Dynamos	48
4		MUZA	47
5		Nkwazi	44
6		Kabwe Warriors	42
7		Green Eagles	41
8		Forest Rangers	37
9		Nkana FC	37
10		Green Buffaloes	36
11		Zanaco	36
12		NAPSA Stars FC	34
13		Konkola Blades	34
14		Mutondo Stars	33
15		Mufulira Wanderers	31
16		Kansanshi Dynamos	29
17		Prison Leopards	28
18		Trident	21

	CAF Champions League : Red Arrows, Zesco United
	Copa Confederaciones : Power Dynamos, MUZA
	Descenso : Kansanshi Dynamos, Prison Leopards, Trident

RIVALES EN Premier League Z.

USO DE MEMORIA

7,054,696 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.5546
Total Execution Time	0.5566

CADENA URL

/historico/Kabwe-Warriors

GET DATOS

$_GET['/historico/Kabwe-Warriors']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0134	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 = 'Kabwe-Warriors' 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.0125	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=16018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16018 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16018 AND type_rel = 2
0.0135	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 = '16018' ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '16018' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '16018' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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=16018 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0125	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 (73188) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 73188 AND teamId = 16018
0.0127	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 = '16018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '16018' and rp.type = 4
0.0126	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 = '16018' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0134	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 = 73188 WHERE rp.league_id = 73188 AND rp.teamId = 16018 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.0129	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 = 73188 WHERE rp.league_id = 73188 AND rp.teamId = 16018 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 73188 WHERE rp.league_id = 73188 AND rp.teamId = 16018 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129	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 = 16018 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130	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 = 73188 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.0130	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 = 68729 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 64191 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 59934 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 53576 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 48825 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 43091 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 38258 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 20871 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 4844 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 3186 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16298 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 8544 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 16299 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 16300 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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 = 16301 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables2006` 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 = 16302 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

Kabwe Warriors

Kabwe Warriors

Selecciona un equipo

Competiciones que juega

Premier League Zambia

RIVALES EN Premier League Z.