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

Erzeni Shijak

Entrenador: Alfred Deliallisi

Temporada 2023/2024

TEMPORADA 2023/2024

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	KF Egnatia	33	50	34	60
2	Vllaznia	33	39	29	55
3	Partizani	33	45	29	54
4	Skënderbeu	33	31	36	47
5	Dinamo City	33	42	40	47
6	KF Tirana	33	53	48	46
7	Teuta	33	31	35	41
8	Laçi	33	33	30	39
9	Erzeni	33	26	47	31
10	Kukësi	33	28	50	26

TEMPORADA 2022/2023

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Partizani	36	56	37	67
2	KF Tirana	36	56	33	67
3	KF Egnatia	36	46	32	52
4	Vllaznia	36	39	37	50
5	Laçi	36	45	46	48
6	Teuta	36	33	40	48
7	Kukësi	36	31	35	45
8	Erzeni	36	36	48	40
9	Bylis Ballsh	36	31	42	38
10	Kastrioti	36	26	49	35

TEMPORADA 2021/2022

PRIMERA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Bylis Ballsh	30	51	18	69
2	Erzeni	30	57	18	67
3	Korabi	30	35	22	59
4	Apolonia	30	44	25	51
5	Tërbuni	30	21	16	47
6	Tomori Berat	30	45	31	44
7	Lushnja	30	31	27	42
8	Burreli	30	30	24	41
9	Besa Kavajë	30	36	40	40
10	Besëlidhja	30	45	54	39
11	Pogradeci	30	32	37	38
12	Turbina	30	31	44	37
13	Butrinti	30	32	36	34
14	Maliqi	30	32	62	23
15	Vora	30	32	54	21
16	Shkumbini	30	30	76	18

TEMPORADA 2020/2021

PRIMERA ALBANIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Besëlidhja	24	32	26	36
2	Erzeni	24	29	22	34
3	Oriku	24	18	21	31
4	Partizani	24	26	38	24
5	Veleçiku	24	17	46	11
6	Lushnja	20	21	25	28
7	Turbina	20	23	24	25
8	Flamurtari	20	14	30	17
9	KF Elbasani	20	13	40	11
10	Luftëtari	0	0	0	0

TEMPORADA 2019/2020

PRIMERA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kastrioti	17	21	6	38
2	Besëlidhja	17	21	12	31
3	Korabi	17	18	16	28
4	Burreli	18	19	19	27
5	Erzeni	17	18	11	25
6	KF Egnatia	17	14	13	20
7	Tërbuni	17	12	17	16
8	Veleçiku	17	13	23	16
9	Dinamo City	18	10	27	13
10	Shkumbini	11	10	12	11
11	Pogradeci	18	30	15	39
12	Apolonia	18	36	14	37
13	Lushnja	18	30	18	35
14	Besa Kavajë	18	28	24	27
15	Devolli	18	29	30	24
16	Oriku	18	12	15	24
17	KF Iliria	18	18	23	18
18	Shenkolli	18	17	28	17
19	Turbina	18	14	26	16
20	KF Elbasani	18	14	35	13

TEMPORADA 2018/2019

PRIMERA ALBANIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vllaznia	8	12	3	19
2	Dinamo City	8	11	6	14
3	Besëlidhja	8	9	9	13
4	Korabi	8	5	9	5
5	Erzeni	8	3	13	3
6	Bylis Ballsh	8	22	3	24
7	Besa Kavajë	8	12	14	13
8	Oriku	8	12	13	11
9	Lushnja	8	8	14	7
10	KF Egnatia	8	11	21	1

TEMPORADA 2017/2018

PRIMERA ALBANIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kastrioti	7	13	3	39
2	Besëlidhja	8	6	10	32
3	KF Egnatia	7	10	9	27
4	Erzeni	7	9	10	25
5	Dinamo City	7	4	10	2
6	KF Tirana	7	18	6	42
7	Bylis Ballsh	7	8	9	29
8	Apolonia	7	6	10	23
9	Pogradeci	8	10	15	22
10	Tomori Berat	7	10	12	8

TEMPORADA 2016/2017

PRIMERA ALBANIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Besëlidhja	8	14	3	20
2	Kamza	8	12	6	16
3	Burreli	8	11	12	8
4	Erzeni	8	13	21	5
5	Shenkolli	8	11	19	4
6	Lushnja	8	13	6	20
7	Bylis Ballsh	8	17	5	19
8	Pogradeci	8	10	12	9
9	Shkumbini	8	8	18	5
10	Tomori Berat	8	10	17	3

TEMPORADA 2015/2016

PRIMERA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Kastrioti	27	61	27	63
2	Korabi	27	43	16	62
3	Besëlidhja	27	59	26	54
4	Erzeni	27	47	45	34
5	Burreli	27	29	38	34
6	Kamza	27	33	44	30
7	Besa Kavajë	27	31	40	29
8	KF Iliria	27	34	45	28
9	Mamurrasi	27	22	42	25
10	Velipojë	27	29	65	21
11	Luftëtari	27	53	9	68
12	Pogradeci	27	51	24	63
13	Apolonia	27	42	26	46
14	Dinamo City	27	27	32	33
15	Turbina	27	29	37	31
16	Lushnja	27	26	35	31
17	KF Elbasani	27	27	45	29
18	Shkumbini	27	19	40	29
19	Sopoti	27	30	33	28
20	Butrinti	27	15	38	24

TEMPORADA 2014/2015

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Korabi	24	45	12	67
2	Erzeni	24	65	23	61
3	Partizani	24	43	16	49
4	Luzi 2008	24	34	19	42
5	Vora	24	39	30	34
6	Shenkolli	24	38	33	32
7	Sukthi	24	33	33	31
8	Albpetrol	24	27	29	28
9	Tirana II	24	44	50	27
10	Domosdova	24	26	53	20
11	Teuta	24	28	42	19
12	Olimpiku	24	34	68	16
13	Skrapari	24	22	70	16

TEMPORADA 2013/2014

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	KF Iliria	24	56	15	63
2	Besëlidhja	24	59	8	62
3	Vora	24	35	19	47
4	Sukthi	24	44	20	42
5	Olimpiku	24	38	30	34
6	Partizani	24	36	31	33
7	Turbina	24	29	45	30
8	Erzeni	24	37	44	27
9	Korabi	24	35	44	23
10	Shenkolli	24	29	43	23
11	Domosdova	24	26	75	18
12	KF Egnatia	24	25	47	16
13	Luzi 2008	24	20	48	16

TEMPORADA 2012/2013

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Veleçiku	18	38	18	39
2	Olimpiku	18	30	16	38
3	Sukthi	18	30	17	30
4	Vora	18	28	21	29
5	Turbina	18	24	29	26
6	Korabi	18	20	23	25
7	Luzi 2008	18	25	28	24
8	Domosdova	18	17	22	20
9	Erzeni	18	19	31	18
10	KF Egnatia	18	12	38	4

TEMPORADA 2011/2012

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tërbuni	16	36	9	42
2	Sukthi	16	41	16	38
3	Veleçiku	16	23	19	27
4	Luzi 2008	16	24	23	24
5	Olimpiku	16	24	18	23
6	KF Egnatia	16	13	18	18
7	Korabi	16	15	27	10
8	Erzeni	16	20	38	9
9	Pashtriku	16	15	43	5

TEMPORADA 2010/2011

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kukësi	26	59	22	60
2	KF Iliria	26	45	19	58
3	Skrapari	26	40	26	47
4	Sukthi	26	44	24	45
5	Luzi 2008	26	36	25	45
6	Rubiku	26	36	36	42
7	Veleçiku	26	36	18	41
8	Naftëtari	26	43	26	41
9	Erzeni	26	31	20	37
10	KF Egnatia	26	30	38	31
11	Korabi	26	21	35	28
12	Turbina	26	20	56	19
13	Olimpiku	26	22	49	14
14	Fieri	26	15	84	7

TEMPORADA 2009/2010

SEGUNDA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mamurrasi	24	49	23	54
2	Tërbuni	24	43	14	51
3	Luzi 2008	24	48	18	50
4	Erzeni	24	40	22	42
5	KF Iliria	24	34	29	36
6	Veleçiku	24	38	28	35
7	Sukthi	24	28	31	31
8	Naftëtari	24	29	35	30
9	Olimpiku	24	26	33	28
10	Kukësi	24	24	31	27
11	KF Egnatia	24	17	31	27
12	Korabi	24	19	50	16
13	Fieri	24	11	61	7

Competiciones que juega

Liga Albania

Pos	Equipos		Pts
1		KF Egnatia	60
2		Vllaznia Shkodër	55
3		Partizani Tirana	54
4		Skënderbeu Korçë	47
5		Dinamo City	47
6		KF Tirana	46
7		Teuta Durrës	41
8		Laçi	39
9		Erzeni Shijak	31
10		Kukësi	26

	Previa de Champions : KF Egnatia
	: Vllaznia Shkodër, Partizani Tirana
	Playoff Descenso : Laçi
	Descenso : Erzeni Shijak, Kukësi

RIVALES EN Copa Albania

RIVALES EN Liga Albania

USO DE MEMORIA

6,421,288 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1690
Total Execution Time	0.1702

CADENA URL

/historico/Erzeni-Shijak

GET DATOS

$_GET['/historico/Erzeni-Shijak']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

0.0029	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 = 'Erzeni-Shijak' 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.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=9095 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=9095 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=9095 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041	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 = 73617
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9095 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=182 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 182 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (1289585,1289260,1245206,859242,835971) ORDER BY n.cover_points DESC, update_date DESC
0.0025	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 = '9095' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024	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 = '9095' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 73617 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72060 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=9095 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 (73617,72060,71888) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72060 AND teamId = 9095
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 73617 AND teamId = 9095
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 71888 AND teamId = 9095
0.0024	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 = '9095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '9095' and rp.type = 4
0.0022	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 = '9095' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0047	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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9095 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.0044	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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9095 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0042	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 = 72060 WHERE rp.league_id = 72060 AND rp.teamId = 9095 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039	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 = 9095 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0028	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 = 68114 AND t.round = 36 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 = 63881 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.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* `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 = 60132 AND t.round = 18 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* `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 = 61985 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 55615 AND t.round = 6 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* `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 = 51070 AND t.round = 18 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* `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 = 45026 AND t.round = 18 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* `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 = 49129 AND t.round = 10 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* `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 = 39922 AND t.round = 18 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* `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 = 43047 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0038	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 = 35696 AND t.round = 18 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* `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 = 49153 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0050	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 = 15523 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0053	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 = 9284 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039	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 = 9288 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032	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 = 2233 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 1867 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 14916 AND t.round = 26 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* `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 = 14920 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 72060 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

Erzeni Shijak

Erzeni Shijak

Selecciona un equipo

Competiciones que juega

Liga Albania

RIVALES EN Copa Albania

RIVALES EN Liga Albania