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

Senglea Athletic

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA MALTA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Melita	10	24	3	28
2	Zabbar	10	17	11	18
3	Marsa FC	10	12	13	12
4	Pieta	10	12	18	11
5	Zurrieq FC	10	9	19	8
6	Senglea	10	8	18	6

TEMPORADA 2022/2023

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	Senglea	20	53	8	53
2	Mgarr United	20	56	11	50
3	Zabbar	20	53	10	48
4	Kalkara	20	39	25	36
5	Xghajra	20	30	28	32
6	Birzebbuga	20	35	29	28
7	Qormi FC	20	30	42	22
8	Pembroke	20	29	51	21
9	Mellieha	20	21	42	16
10	St. Venera	20	20	50	14
11	Ta' Xbiex	20	10	80	1
12	Msida Joseph	18	52	11	43
13	Luqa	18	35	17	33
14	Gharghur	18	34	17	31
15	Rabat Ajax	18	24	16	31
16	Kirkop	18	29	19	29
17	Georges	18	30	24	29
18	Ghaxaq	18	19	21	25
19	Siggiewi	18	11	31	12
20	Dingli	18	12	32	9
21	Mdina	18	11	69	6

TEMPORADA 2021/2022

SEGUNDA MALTA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Zebbug	20	46	15	45
2	Pieta	20	39	19	40
3	Tarxien	20	45	24	38
4	Marsa FC	20	35	22	33
5	Fgura United	20	35	27	31
6	Saint	20	36	30	28
7	Qrendi	20	30	37	24
8	Swieqi	20	21	29	24
9	Senglea	20	24	50	15
10	Mgarr United	20	11	36	14
11	Luqa	20	9	42	10

TEMPORADA 2020/2021

LIGA MALTA
Equipo		PJ	GF	GC	Puntos
1	Hamrun	23	56	20	56
2	Hibernians	23	53	20	51
3	Gzira United	23	49	21	46
4	Birkirkara	23	45	25	44
5	Sliema	23	39	31	40
6	Mosta	23	41	36	36
7	Valletta FC	23	27	35	33
8	Santa Lucía	23	38	35	29
9	Sirens	23	27	35	28
10	Balzan FC	23	31	29	27
11	Gudja United	23	29	35	27
12	Floriana FC	23	26	34	27
13	Zejtun	23	28	40	24
14	Tarxien	23	25	48	21
15	Lija	23	25	46	20
16	Senglea	23	13	62	2

TEMPORADA 2019/2020

LIGA MALTA
Equipo		PJ	GF	GC	Puntos
1	Floriana FC	20	38	15	41
2	Valletta FC	20	32	22	38
3	Hibernians	20	34	20	37
4	Sirens	20	30	26	35
5	Birkirkara	20	30	20	33
6	Gzira United	20	35	19	32
7	Balzan FC	20	33	29	28
8	Mosta	20	29	35	28
9	Hamrun	20	24	25	25
10	Sliema	20	24	22	24
11	Gudja United	20	24	30	24
12	Santa Lucía	20	24	33	23
13	Senglea	20	21	39	16
14	Tarxien	20	18	61	4

TEMPORADA 2018/2019

LIGA MALTA
Equipo		PJ	GF	GC	Puntos
1	Valletta FC	26	61	18	58
2	Hibernians	26	54	27	58
3	Gzira United	26	42	21	50
4	Hamrun	26	35	20	46
5	Sliema	26	37	26	45
6	Balzan FC	26	41	31	43
7	Birkirkara	26	33	26	39
8	Floriana FC	26	28	25	32
9	Mosta	26	30	45	29
10	Senglea	26	33	46	26
11	Tarxien	26	29	58	26
12	Saint	26	25	45	24
13	Qormi FC	26	25	51	20
14	Pieta	26	25	59	13

TEMPORADA 2017/2018

LIGA MALTA
Equipo		PJ	GF	GC	Puntos
1	Valletta FC	26	40	11	58
2	Balzan FC	26	42	19	55
3	Gzira United	26	52	33	51
4	Birkirkara	26	44	28	47
5	Hibernians	26	43	16	46
6	Floriana FC	26	48	18	46
7	Sliema	26	35	26	40
8	Hamrun	26	39	33	35
9	Mosta	26	28	52	26
10	Senglea	26	29	47	26
11	Saint	26	21	41	24
12	Tarxien	26	34	56	23
13	Naxxar Lions	26	27	41	22
14	Lija	26	23	84	6

TEMPORADA 2016/2017

SEGUNDA MALTA
Equipo		PJ	GF	GC	Puntos
1	Lija	26	63	34	54
2	Senglea	26	57	21	53
3	Naxxar Lions	26	57	37	51
4	Qormi FC	26	36	26	46
5	Mqabba FC	26	39	32	44
6	Pieta	26	48	38	41
7	Vittoriosa	26	50	37	40
8	Sirens	26	40	44	34
9	Melita	26	29	39	31
10	Zebbug	26	40	47	30
11	Rabat Ajax	26	33	54	27
12	Marsa FC	26	35	49	25
13	Gharghur	26	30	65	18
14	Fgura United	26	20	54	16

TEMPORADA 2015/2016

SEGUNDA MALTA
Equipo		PJ	GF	GC	Puntos
1	Gzira United	26	58	13	64
2	Hamrun	26	57	17	61
3	Senglea	26	47	21	52
4	Pieta	26	32	28	44
5	Lija	26	40	28	40
6	Vittoriosa	26	39	31	37
7	Mqabba FC	26	44	33	35
8	Zebbug	26	30	32	32
9	Rabat Ajax	26	28	37	32
10	Fgura United	26	24	35	30
11	Melita	26	24	48	28
12	San Gwann	26	30	50	27
13	Georges	26	20	46	19
14	Gudja United	26	22	76	9

TEMPORADA 2014/2015

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	San Gwann	26	59	16	59
2	Hamrun	26	65	22	56
3	Senglea	26	71	24	55
4	Gharghur	26	41	31	44
5	Zabbar	26	47	32	43
6	Zejtun	26	30	26	43
7	Siggiewi	26	45	45	39
8	Mellieha	26	30	35	38
9	Sirens	26	45	44	35
10	Swieqi	26	35	40	33
11	Marsa FC	26	36	47	28
12	Dingli	26	25	52	19
13	Ghaxaq	26	17	57	15
14	Xghajra	26	15	90	5

TEMPORADA 2013/2014

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	Mqabba FC	26	48	26	52
2	Fgura United	26	36	15	49
3	Pembroke	26	46	32	49
4	Zabbar	26	45	20	46
5	San Gwann	26	52	37	46
6	Gharghur	26	46	38	39
7	Mellieha	26	32	26	37
8	Senglea	26	45	35	33
9	Marsa FC	26	37	49	31
10	Dingli	26	35	34	29
11	Siggiewi	26	36	56	28
12	Marsaskala	26	28	46	27
13	Kirkop	26	24	57	20
14	Mdina	26	27	66	10

TEMPORADA 2011/2012

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	Gzira United	26	58	16	60
2	Gudja United	26	57	20	54
3	Mellieha	26	51	27	52
4	Gharghur	26	57	37	44
5	Zebbug	26	47	30	43
6	San Gwann	26	43	35	39
7	Msida Joseph	26	42	29	36
8	Kirkop	26	44	52	35
9	St. Venera	26	27	45	33
10	Zurrieq FC	26	26	40	29
11	Siggiewi	26	31	51	27
12	Attard	26	30	56	25
13	Senglea	26	34	71	15
14	Luqa	26	24	62	15

TEMPORADA 2010/2011

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	Zejtun	22	42	11	52
2	Rabat Ajax	22	45	12	41
3	Naxxar Lions	22	43	26	40
4	Birzebbuga	22	31	28	37
5	Mellieha	22	30	20	36
6	Zabbar	22	31	32	36
7	San Gwann	22	33	40	31
8	Zebbug	22	30	40	27
9	Zurrieq FC	22	27	41	23
10	Senglea	22	32	42	19
11	Gzira United	22	33	51	18
12	Mgarr United	22	16	50	13

TEMPORADA 2009/2010

TERCERA MALTA
Equipo		PJ	GF	GC	Puntos
1	Lija	22	48	22	48
2	Saint	22	44	20	46
3	Gzira United	22	35	28	41
4	Birzebbuga	22	42	28	39
5	Mellieha	22	42	29	33
6	Rabat Ajax	22	40	33	30
7	Zebbug	22	36	35	27
8	Zurrieq FC	22	18	25	26
9	Senglea	22	17	26	25
10	St. Venera	22	26	42	21
11	Gharghur	22	24	49	15
12	Gozo	22	24	59	10

TEMPORADA 2008/2009

SEGUNDA MALTA
Equipo		PJ	GF	GC	Puntos
1	Dingli	18	35	18	34
2	Vittoriosa	18	34	21	34
3	Pieta	18	36	25	33
4	Georges	18	34	32	27
5	Zabbar	18	24	24	27
6	Mqabba FC	18	28	24	24
7	Mosta	18	20	22	22
8	San Gwann	18	31	38	22
9	Rabat Ajax	18	20	36	17
10	Senglea	18	18	40	8

TEMPORADA 2007/2008

SEGUNDA MALTA
Equipo		PJ	GF	GC	Puntos
1	Tarxien	18	32	17	39
2	Mosta	18	34	18	37
3	Qormi FC	18	37	22	37
4	Senglea	18	32	23	31
5	Dingli	18	34	27	27
6	Vittoriosa	18	33	29	25
7	Georges	18	27	33	21
8	Zabbar	18	21	27	16
9	Mellieha	18	21	43	13
10	Marsa FC	18	23	55	10

TEMPORADA 2006/2007

SEGUNDA MALTA
Equipo		PJ	GF	GC	Puntos
1	Hamrun	18	34	11	39
2	Mqabba FC	18	33	25	34
3	Tarxien	18	30	25	28
4	Zabbar	18	31	23	27
5	Senglea	18	27	22	27
6	Qormi FC	18	32	26	25
7	Vittoriosa	18	27	27	22
8	Mosta	18	26	32	22
9	San Gwann	18	20	39	11
10	Naxxar Lions	18	20	50	9

Competiciones que juega

Grupo 1

Segunda Malta Grupo 1

Pos	Equipos		Pts
1		Zabbar St. Patrick	33
2		Melita	31
3		Senglea Athletic	29
4		Marsa FC	28
5		Pieta Hotspurs	27
6		Zurrieq FC	27
7		Fgura United FC	26
8		Lija	22
9		Swieqi United	21
10		Tarxien Rainbows	17
11		Zejtun Corinthians FC	17
12		Luqa St. Andrew's	16
13		Saint Andrews	11
14		Zebbug Rangers	10
15		Attard	8
16		Msida St Joseph	6

	Playoff Ascenso : Zabbar St. Patrick, Melita, Senglea Athletic, Marsa FC, Pieta Hotspurs, Zurrieq FC
	Playoff Descenso : Fgura United FC, Lija, Swieqi United, Tarxien Rainbows, Zejtun Corinthians FC, Luqa St. Andrew's, Saint Andrews, Zebbug Rangers, Attard, Msida St Joseph

RIVALES EN Copa Malta

RIVALES EN Segunda Malta

USO DE MEMORIA

6,913,344 bytes

BENCHMARKS

Loading Time Base Classes	0.0014
Controller Execution Time ( Home / Category )	0.7858
Total Execution Time	0.7872

CADENA URL

/historico/Senglea-Athletic

GET DATOS

$_GET['/historico/Senglea-Athletic']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0170	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 = 'Senglea-Athletic' 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.0147	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=61354 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=61354 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=61354 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145	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=61354 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	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=61354 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61354 AND type_rel = 2
0.0149	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=422 AND type_rel = 3
0.0177	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 = '61354' ORDER BY l.year DESC,cat.coefficient DESC
0.0171	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 = '61354' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0171	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 = '61354' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0198	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=61354 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146	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 (75331,74508,71432,71427) 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.0147	SELECT count(id) as num_players from rel_players WHERE league_id = 75331 AND teamId = 61354
0.0146	SELECT count(id) as num_players from rel_players WHERE league_id = 71427 AND teamId = 61354
0.0150	SELECT count(id) as num_players from rel_players WHERE league_id = 74508 AND teamId = 61354
0.0151	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 61354
0.0148	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 = '61354' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0145	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61354' and rp.type = 4
0.0148	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 = '61354' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166	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 = 72395 WHERE rp.league_id = 72395 AND rp.teamId = 61354 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.0159	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 = 72395 WHERE rp.league_id = 72395 AND rp.teamId = 61354 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 = 72395 WHERE rp.league_id = 72395 AND rp.teamId = 61354 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0153	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 = 61354 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 = 72395 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148	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 = 75331 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.0152	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 = 68505 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.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* `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 = 63552 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.0154	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 = 57798 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 50107 AND t.round = 20 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154	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 = 43574 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 38894 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153	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 = 33787 AND t.round = 26 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* `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 = 15727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169	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 = 9433 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 16093 AND t.round = 26 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* `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 = 16095 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155	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 = 16096 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 16097 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 16036 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 16037 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	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 = 16038 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 72395 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

Senglea Athletic

Senglea Athletic

Selecciona un equipo

Competiciones que juega

Segunda Malta Grupo 1

RIVALES EN Copa Malta

RIVALES EN Segunda Malta