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

Academica do Lobito

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Sagrada	21	31	9	46
2	Lunda	21	29	12	45
3	Petro Luanda	19	42	8	44
4	Kabuscorp	20	21	16	31
5	Primeiro	19	25	18	29
6	Desportivo	20	16	14	29
7	Wiliete FC	19	24	16	28
8	Bravos	20	19	20	28
9	Interclube	21	20	24	24
10	Salvador	21	17	27	22
11	Academica	19	9	18	21
12	Santa Rita	19	18	29	20
13	Sporting	21	18	45	16
14	Uniao	21	13	31	15
15	Recreativo	21	10	25	14
16	Isaac	0	0	0	0

TEMPORADA 2022/2023

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Petro Luanda	29	61	19	69
2	Primeiro	29	40	17	62
3	Sagrada	29	48	22	58
4	Interclube	29	44	19	56
5	Wiliete FC	29	39	20	56
6	Bravos	29	35	26	39
7	Desportivo	29	30	28	36
8	Academica	29	29	35	36
9	Santa Rita	29	20	31	36
10	Recreativo	29	28	34	35
11	Lunda	29	28	33	32
12	Sporting	27	17	40	27
13	Isaac	29	19	38	23
14	Sporting	29	21	52	23
15	Cuando	16	11	17	15
16	Dragão	28	11	50	10

TEMPORADA 2021/2022

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Petro Luanda	30	74	17	75
2	Primeiro	30	55	21	61
3	Sagrada	30	49	22	60
4	Interclube	30	41	28	50
5	Bravos	30	34	31	46
6	Desportivo	30	40	34	45
7	Recreativo	30	30	19	42
8	Academica	30	38	31	40
9	Recreativo	30	28	31	37
10	Cuando	30	22	33	36
11	Wiliete FC	30	38	40	34
12	Sporting	30	20	37	33
13	Lunda	30	24	30	32
14	Kabuscorp	30	31	40	20
15	Progresso	30	22	61	19
16	Sporting	30	15	86	9

TEMPORADA 2020/2021

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Petro Luanda	29	47	16	67
2	Sagrada	29	42	12	65
3	Primeiro	29	50	22	61
4	Bravos	30	43	23	55
5	Interclube	30	37	23	45
6	Recreativo	29	29	19	43
7	Wiliete FC	30	38	33	41
8	Academica	30	30	31	38
9	Desportivo	30	25	30	34
10	Progresso	30	29	37	34
11	Recreativo	29	21	31	34
12	Cuando	30	31	31	33
13	Sporting	30	25	40	33
14	Baixa	30	28	43	32
15	Santa Rita	30	18	29	29
16	Ferroviário	29	4	77	1

TEMPORADA 2019/2020

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Petro Luanda	24	41	10	54
2	Primeiro	23	42	13	51
3	Bravos	23	26	22	40
4	Desportivo	22	24	16	37
5	Sagrada	23	21	16	34
6	Academica	22	21	18	33
7	Recreativo	24	25	30	32
8	Interclube	23	24	23	31
9	Wiliete FC	23	20	26	28
10	Recreativo	22	16	22	27
11	Progresso	23	16	29	22
12	Sporting	19	20	24	21
13	Cuando	23	17	27	20
14	Ferroviário	23	9	25	20
15	Santa Rita	23	16	37	16
16	Primeiro	0	0	0	0

TEMPORADA 2018/2019

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Primeiro	30	51	9	70
2	Petro Luanda	30	40	15	64
3	Desportivo	31	37	25	53
4	Kabuscorp	30	35	26	49
5	Interclube	31	26	23	42
6	Sagrada	30	31	26	41
7	Progresso	31	34	30	41
8	Recreativo	30	31	30	39
9	Recreativo	30	29	33	37
10	Bravos	30	28	27	34
11	Santa Rita	30	32	41	32
12	Academica	30	23	29	31
13	Sporting	30	30	43	30
14	ASA Luanda	31	26	48	27
15	Cuando	30	30	51	26
16	Saurimo	30	20	47	21

TEMPORADA 2017/2018

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Primeiro	28	31	8	57
2	Petro Luanda	28	38	15	54
3	Interclube	28	33	24	42
4	Recreativo	28	28	26	40
5	Academica	28	21	21	38
6	Desportivo	28	17	18	36
7	Sagrada	28	29	28	35
8	Bravos	28	23	27	34
9	Kabuscorp	28	42	38	32
10	Sporting	28	21	26	32
11	Cuando	28	18	28	31
12	Recreativo	28	22	36	31
13	Progresso	28	26	25	30
14	Domant FC	28	24	38	25
15	Primeiro	28	23	38	22
16	Desportivo	0	0	0	0

TEMPORADA 2016/2017

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Primeiro	30	44	14	65
2	Petro	30	46	20	62
3	Sagrada	30	34	23	53
4	Kabuscorp	30	40	29	50
5	Recreativo	30	41	23	48
6	Interclube	30	34	19	48
7	Desportivo	30	23	28	41
8	Progresso	30	34	30	41
9	Recreativo	30	24	27	41
10	Primeiro	30	40	49	40
11	Bravos	30	19	26	33
12	Progresso	30	28	39	32
13	Academica	30	39	52	30
14	Desportivo	30	26	55	30
15	ASA Luanda	30	20	37	26
16	Santa Rita	30	24	45	20

TEMPORADA 2015/2016

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Primeiro	31	62	25	68
2	Petro	30	37	14	64
3	Recreativo	30	49	26	60
4	Progresso	30	25	20	46
5	Kabuscorp	30	30	24	46
6	Luanda	30	29	24	44
7	Interclube	30	28	32	41
8	Sagrada	30	25	23	39
9	Progresso	30	23	23	39
10	Desportivo	31	30	41	36
11	Recreativo	30	27	26	34
12	Academica	30	26	38	34
13	ASA Luanda	30	28	43	33
14	4 de Abril	30	21	27	31
15	Primeiro	30	24	44	29
16	Porcelana	30	14	48	18

TEMPORADA 2014/2015

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Primeiro	30	51	23	60
2	Recreativo	30	44	20	60
3	Luanda	30	35	23	53
4	Kabuscorp	30	33	23	48
5	Interclube	30	34	24	45
6	Progresso	30	31	31	40
7	Desportivo	30	24	33	39
8	Petro	30	26	30	38
9	ASA Luanda	30	32	40	38
10	Sagrada	30	22	28	37
11	Recreativo	30	28	25	36
12	Progresso	30	35	38	35
13	Academica	30	34	37	33
14	Bravos	30	28	40	31
15	Sporting	30	31	46	31
16	Domant FC	30	28	55	19

TEMPORADA 2010/2011

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Recreativo	30	49	26	57
2	Kabuscorp	30	47	30	56
3	Petro	30	46	28	51
4	Interclube	30	31	17	48
5	Recreativo	30	37	34	48
6	Primeiro	30	37	28	45
7	Sagrada	30	26	25	41
8	Bravos	30	36	41	38
9	ASA Luanda	30	29	29	37
10	Académica	30	26	28	37
11	Santos FC	30	34	40	36
12	Progresso	30	28	37	36
13	Luanda	30	33	36	35
14	Cabinda	30	25	30	33
15	Primeiro	30	30	42	30
16	Academica	30	19	62	13

TEMPORADA 2008/2009

LIGA ANGOLA GIRABOLA
Equipo		PJ	GF	GC	Puntos
1	Petro	26	44	21	56
2	Recreativo	26	48	29	48
3	Luanda	26	42	32	47
4	Primeiro	26	47	30	45
5	Académica	25	33	34	39
6	Santos FC	26	29	29	36
7	ASA Luanda	26	34	28	35
8	Interclube	26	33	26	33
9	Recreativo	26	28	30	33
10	Bravos	26	24	33	32
11	Desportivo	26	22	30	31
12	Kabuscorp	25	35	39	26
13	Primeiro	26	20	39	23
14	Academica	26	14	53	17

Competiciones que juega

Grupo 1

Liga Angola Girabola

Pos	Equipos		Pts
1		Sagrada Esperança	46
2		CD Lunda Sul	45
3		Petro de Luanda	44
4		Kabuscorp Palanca	31
5		Primeiro de Agosto	29
6		Desportivo da Huíla	29
7		Wiliete FC	28
8		Bravos do Maquis	28
9		Interclube	24
10		Sao Salvador	22
11		Academica do Lobito	21
12		Santa Rita	20
13		Sporting de Cabinda	16
14		Uniao de Malanje	15
15		Recreativo do Libolo	14
16		Isaac de Benguela	0

	Descenso : Uniao de Malanje, Recreativo do Libolo, Isaac de Benguela

RIVALES EN Supercopa de Ang.

RIVALES EN Clasificación Co.

RIVALES EN Copa Confederaci.

RIVALES EN Liga Angola Gira.

USO DE MEMORIA

6,752,664 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.7425
Total Execution Time	0.7437

CADENA URL

/historico/Academica-Do-Lobito

GET DATOS

$_GET['/historico/Academica-Do-Lobito']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0141	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 = 'Academica-Do-Lobito' 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=61679 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=61679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=61679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=61679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=61679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=61679 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0263	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 = 74109
0.0154	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 = 73346
0.0152	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 = 73647
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61679 AND type_rel = 2
0.0130	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=327 AND type_rel = 3
0.0138	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 327 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148	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 (828726,820194,648077,240734,176654) ORDER BY n.cover_points DESC, update_date DESC
0.0147	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 = '61679' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '61679' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 73647 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132	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 = 74109 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0143	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=61679 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0129	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 (74279,74109,73647,73605) 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.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 74109 AND teamId = 61679
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 74279 AND teamId = 61679
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 73605 AND teamId = 61679
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 73647 AND teamId = 61679
0.0137	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74109 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0136	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 = '61679' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61679' and rp.type = 4
0.0137	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 = '61679' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0164	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 = 74109 WHERE rp.league_id = 74109 AND rp.teamId = 61679 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.0140	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 = 74109 WHERE rp.league_id = 74109 AND rp.teamId = 61679 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 74109 WHERE rp.league_id = 74109 AND rp.teamId = 61679 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150	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 = 61679 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74109 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 69597 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.0144	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 = 64788 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.0145	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 = 60366 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.0142	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 = 51088 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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 = 48406 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 42454 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 37770 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0159	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 = 20273 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* `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 = 4045 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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 = 16236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 16238 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 74109 ORDER BY nameShow LIMIT 100


	¿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

Academica do Lobito

Academica do Lobito

Selecciona un equipo

Competiciones que juega

Liga Angola Girabola

RIVALES EN Supercopa de Ang.

RIVALES EN Clasificación Co.

RIVALES EN Copa Confederaci.

RIVALES EN Liga Angola Gira.