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

Tarxien Rainbows

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA MALTA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Swieqi	9	16	7	17
2	Zebbug	8	24	7	16
3	Saint	8	10	6	14
4	Tarxien	8	11	5	13
5	Fgura United	9	7	7	11
6	Luqa	8	8	13	11
7	Zejtun	8	7	5	10
8	Attard	9	8	13	10
9	Lija	8	5	15	10
10	Msida Joseph	9	7	25	2

TEMPORADA 2022/2023

SEGUNDA MALTA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Swieqi	28	53	38	50
2	Fgura United	28	57	39	41
3	Saint	28	37	40	40
4	Lija	28	51	54	39
5	Attard	28	39	45	37
6	Marsa FC	28	40	42	35
7	San Gwann	28	33	45	34
8	Qrendi	28	38	52	31
9	Marsaskala	28	50	57	29
10	Vittoriosa	28	27	57	22
11	Mqabba FC	28	29	56	22
12	Mtarfa	28	21	45	21

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

LIGA MALTA
Equipo		PJ	GF	GC	Puntos
1	Hibernians	33	64	31	71
2	Balzan FC	33	66	40	64
3	Birkirkara	33	64	30	62
4	Valletta FC	33	51	29	59
5	Floriana FC	33	51	37	54
6	Sliema	33	47	37	52
7	Gzira United	33	43	51	37
8	Saint	33	45	51	37
9	Tarxien	33	38	48	35
10	Hamrun	33	44	61	33
11	Mosta	33	29	71	21
12	Pembroke	33	28	84	18

TEMPORADA 2015/2016

LIGA MALTA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Valletta FC	22	49	21	53
2	Hibernians	22	53	25	50
3	Balzan FC	22	42	21	45
4	Birkirkara	22	41	20	42
5	Floriana FC	22	36	25	39
6	Tarxien	22	37	17	37
7	Mosta	22	29	33	30
8	Pembroke	22	33	39	25
9	Sliema	22	31	36	24
10	Naxxar Lions	22	22	54	14
11	Qormi FC	22	19	49	9
12	Saint	22	14	66	5

TEMPORADA 2014/2015

LIGA MALTA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Hibernians	10	28	8	56
2	Valletta FC	10	22	13	44
3	Birkirkara	10	18	8	43
4	Floriana FC	10	17	10	33
5	Sliema	10	23	23	26
6	Naxxar Lions	10	13	15	25
7	Qormi FC	10	17	12	24
8	Tarxien	10	11	19	23
9	Mosta	10	13	28	20
10	Pieta	10	11	19	16
11	Zebbug	10	11	29	12

TEMPORADA 2013/2014

LIGA MALTA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Birkirkara	22	51	19	56
2	Valletta FC	22	52	14	53
3	Hibernians	22	57	27	47
4	Sliema	22	43	24	43
5	Mosta	22	44	35	38
6	Floriana FC	22	30	36	28
7	Balzan FC	22	24	31	28
8	Naxxar Lions	22	27	39	27
9	Vittoriosa	22	24	47	18
10	Qormi FC	22	28	45	16
11	Tarxien	22	27	46	16
12	Rabat Ajax	22	17	61	6

TEMPORADA 2012/2013

LIGA MALTA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Valletta FC	22	49	15	46
2	Hibernians	22	47	24	45
3	Birkirkara	22	47	19	43
4	Tarxien	22	39	32	38
5	Sliema	22	34	22	37
6	Mosta	22	39	33	34
7	Qormi FC	22	32	34	30
8	Balzan FC	22	34	36	27
9	Floriana FC	22	26	31	22
10	Hamrun	22	24	58	15
11	Melita	22	18	56	14
12	Rabat Ajax	22	16	45	11

TEMPORADA 2011/2012

LIGA MALTA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Qormi FC	10	18	11	33
2	Mosta	10	22	12	27
3	Tarxien	10	19	10	27
4	Hamrun	10	16	19	25
5	Mqabba FC	10	15	12	24
6	Marsaxlokk	10	9	35	8

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,361,504 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.7039
Total Execution Time	0.7061

CADENA URL

/historico/Tarxien-Rainbows

GET DATOS

$_GET['/historico/Tarxien-Rainbows']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0259	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 = 72395
0.0133	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 = 75332
0.0135	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 = 74508
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9972 AND type_rel = 2
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=422 AND type_rel = 3
0.0140	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 = '9972' ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '9972' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '9972' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129	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 = 74508 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0125	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 = 75332 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131	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=9972 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0138	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 (75332,74508,71432) 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 = 75332 AND teamId = 9972
0.0129	SELECT count(id) as num_players from rel_players WHERE league_id = 74508 AND teamId = 9972
0.0152	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 9972
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '9972' 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 = '9972' and rp.type = 4
0.0129	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 = '9972' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141	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 = 9972 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.0138	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 = 9972 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 9972 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 9972 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0134	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.0141	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 = 75332 AND t.round = 9 ORDER BY team.conference ASC,t.position 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* `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 = 68504 AND t.round = 17 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 = 70907 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.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* `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 = 70908 AND t.round = 11 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* `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.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 = 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.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* `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.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* `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.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* `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.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* `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 = 33788 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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 = 23097 AND t.round = 11 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 = 15493 AND t.round = 22 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* `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 = 3868 AND t.round = 22 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* `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 = 10165 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 16055 AND t.round = 10 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* `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 = 2987 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 16042 AND t.round = 10 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* `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 = 8610 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 16057 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Tarxien Rainbows

Tarxien Rainbows

Selecciona un equipo

Competiciones que juega

Segunda Malta Grupo 1

RIVALES EN Copa Malta

RIVALES EN Segunda Malta