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

Besa Kavajë

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	AF Elbasani	30	66	30	70
2	Bylis Ballsh	30	49	26	67
3	Flamurtari	30	43	24	55
4	Vora	30	58	45	48
5	Apolonia	30	43	27	46
6	Korabi	30	38	31	43
7	Lushnja	30	36	51	34
8	Kastrioti	30	36	45	33
9	Besa Kavajë	30	32	47	31
10	Burreli	30	21	40	31
11	Luzi 2008	30	37	52	27
12	Tomori Berat	30	21	62	17

TEMPORADA 2022/2023

PRIMERA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Skënderbeu	26	37	13	49
2	Dinamo City	26	48	23	47
3	Flamurtari	26	40	16	46
4	Tomori Berat	26	29	27	43
5	Korabi	26	32	24	39
6	Apolonia	26	31	30	38
7	Luzi 2008	26	31	26	38
8	Besa Kavajë	26	32	26	37
9	Lushnja	26	30	42	32
10	Burreli	26	22	29	31
11	Oriku	26	27	33	30
12	Turbina	26	24	45	26
13	Tërbuni	26	16	41	24
14	Besëlidhja	26	17	41	17

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 3
Equipo		PJ	GF	GC	Puntos
1	Dinamo City	22	32	13	47
2	Burreli	22	35	15	44
3	Korabi	22	28	14	43
4	Vora	22	14	36	21
5	KF Egnatia	20	36	10	46
6	Tomori Berat	20	36	20	40
7	Pogradeci	20	32	26	33
8	Besa Kavajë	20	26	26	24

TEMPORADA 2019/2020

PRIMERA ALBANIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kastrioti	6	10	9	47
2	Besëlidhja	6	11	7	39
3	Korabi	6	10	7	36
4	Erzeni	6	7	15	26
5	Apolonia	6	19	12	51
6	Pogradeci	6	9	9	46
7	Lushnja	6	12	11	44
8	Besa Kavajë	6	14	22	31

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 3
Equipo		PJ	GF	GC	Puntos
1	Besa Kavajë	8	13	13	22
2	Korabi	7	9	10	20
3	Burreli	7	6	6	19
4	Tërbuni	7	5	5	19
5	Vllaznia	7	10	9	11
6	KF Iliria	7	11	9	23
7	Shenkolli	8	15	19	22
8	Shkumbini	7	11	9	18
9	Turbina	7	12	13	18
10	Naftëtari	7	9	8	11

TEMPORADA 2016/2017

PRIMERA ALBANIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Apolonia	8	17	9	15
2	Tërbuni	8	7	5	14
3	KF Iliria	8	10	10	13
4	Turbina	8	13	12	11
5	Besa Kavajë	8	8	8	11
6	Mamurrasi	8	8	8	10
7	Dinamo City	8	6	8	10
8	Sopoti	8	8	9	9
9	Kastrioti	8	9	11	9
10	KF Elbasani	8	11	17	7

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

PRIMERA ALBANIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tërbuni	27	55	12	69
2	Besëlidhja	27	56	13	65
3	Mamurrasi	27	57	16	64
4	KF Iliria	27	25	25	33
5	Kastrioti	27	33	36	31
6	Burreli	27	38	45	31
7	Kamza	27	30	47	31
8	Velipojë	27	31	57	27
9	Besa Kavajë	27	25	45	23
10	Veleçiku	27	23	77	5

TEMPORADA 2013/2014

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Skënderbeu	33	52	32	61
2	Kukësi	33	46	34	57
3	Laçi	33	41	28	54
4	Teuta	33	46	35	54
5	Partizani	33	33	26	53
6	KF Tirana	33	36	31	50
7	Flamurtari	33	45	40	48
8	Vllaznia	33	42	36	45
9	Besa Kavajë	33	34	32	39
10	Kastrioti	33	26	46	29
11	Lushnja	33	32	59	26
12	Bylis Ballsh	33	20	54	24

TEMPORADA 2012/2013

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Skënderbeu	26	43	14	58
2	Kukësi	26	49	25	52
3	Teuta	26	32	24	48
4	Flamurtari	26	49	33	46
5	KF Tirana	26	30	23	43
6	Vllaznia	26	30	26	38
7	Laçi	26	32	31	38
8	Kastrioti	26	25	35	34
9	Besa Kavajë	26	23	26	32
10	Bylis Ballsh	26	32	29	30
11	Shkumbini	26	18	33	29
12	Tomori Berat	26	30	50	19
13	Luftëtari	26	24	44	19
14	Apolonia	26	16	40	13

TEMPORADA 2011/2012

PRIMERA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Luftëtari	30	59	22	72
2	Kukësi	30	63	24	67
3	Lushnja	30	49	16	64
4	Besa Kavajë	30	44	33	55
5	Besëlidhja	30	38	16	54
6	KF Elbasani	30	44	48	39
7	Burreli	30	36	43	39
8	Gramshi	30	37	44	38
9	Butrinti	30	32	36	37
10	Velipojë	30	34	35	36
11	KF Iliria	30	38	44	36
12	Mamurrasi	30	35	48	34
13	Himara	30	38	43	32
14	Gramozi	30	25	60	29
15	Vlora	30	24	54	18
16	Skrapari	30	22	52	18

TEMPORADA 2010/2011

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Skënderbeu	33	52	23	73
2	Flamurtari	33	62	27	66
3	Vllaznia	33	41	27	59
4	Laçi	33	44	44	47
5	KF Tirana	33	42	31	44
6	Bylis Ballsh	33	44	48	43
7	Teuta	33	38	40	42
8	Kastrioti	33	40	47	42
9	Shkumbini	33	43	54	42
10	Dinamo City	33	46	50	39
11	Besa Kavajë	33	35	47	39
12	KF Elbasani	33	30	79	12

TEMPORADA 2009/2010

LIGA ALBANIA
Equipo		PJ	GF	GC	Puntos
1	Dinamo City	33	56	42	61
2	Besa Kavajë	33	42	33	53
3	KF Tirana	33	38	32	52
4	Laçi	33	35	28	51
5	Flamurtari	33	42	39	47
6	Vllaznia	33	34	39	46
7	Shkumbini	33	33	33	45
8	Teuta	33	33	40	45
9	Kastrioti	33	33	35	42
10	Skënderbeu	33	41	41	42
11	Apolonia	33	36	43	38
12	Gramozi	33	25	43	26

Competiciones que juega

Primera Albania

Pos	Equipos		Pts
1		AF Elbasani	70
2		Bylis Ballsh	67
3		Flamurtari Vlorë	55
4		Vora	48
5		Apolonia Fier	46
6		Korabi Peshkopi	43
7		Lushnja	34
8		Kastrioti Krujë	33
9		Besa Kavajë	31
10		Burreli	31
11		Luzi 2008	27
12		Tomori Berat	17

RIVALES EN Copa Albania

RIVALES EN Primera Albania

USO DE MEMORIA

6,426,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1288
Total Execution Time	0.1300

CADENA URL

/historico/Besa-Kavaje

GET DATOS

$_GET['/historico/Besa-Kavaje']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0031	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 = 'Besa-Kavaje' 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=5834 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=5834 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=5834 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5834 AND type_rel = 2
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 = '5834' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026	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 = '5834' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019	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 = 73436 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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=5834 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018	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,73436) 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 = 73436 AND teamId = 5834
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 73617 AND teamId = 5834
0.0021	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 = 73436 AND t.round = 31 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020	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 = '5834' 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 = '5834' and rp.type = 4
0.0020	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 = '5834' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032	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 = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 5834 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.0031	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 = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 5834 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026	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 = 73436 WHERE rp.league_id = 73436 AND rp.teamId = 5834 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024	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 = 5834 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 68115 AND t.round = 26 ORDER BY team.conference ASC,t.position 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* `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.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* `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.0021	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 = 62038 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.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* `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.0021	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.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* `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.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* `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.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* `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.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* `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 = 43048 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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.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 = 49154 AND t.round = 10 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* `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.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* `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 = 9276 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 3565 AND t.round = 33 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* `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 = 2042 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* `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 = 1866 AND t.round = 30 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* `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 = 1372 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036	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 = 8871 AND t.round = 33 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

Besa Kavajë

Besa Kavajë

Selecciona un equipo

Competiciones que juega

Primera Albania

RIVALES EN Copa Albania

RIVALES EN Primera Albania