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

ASIL Lysi

Entrenador: Artemis Savva

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Omonia	14	26	9	32
2	Omonia 29is	14	28	10	30
3	Olympiakos	14	23	11	24
4	Enosis Neon	14	22	22	21
5	ASIL Lysi	14	20	22	20
6	Digenis	14	19	25	17
7	Ayia Napa	14	18	33	9
8	Peyia	14	9	33	5

TEMPORADA 2022/2023

TERCERA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	ENAD	14	32	14	33
2	Digenis	14	30	11	28
3	ASIL Lysi	14	22	11	26
4	APEA	14	15	15	19
5	Iraklis	14	13	19	17
6	ASPIS Pylas	14	18	31	15
7	Ethnikos	14	15	34	12
8	Polemidion	14	12	22	7

TEMPORADA 2021/2022

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	30	52	20	63
2	Nea Salamis	30	59	24	63
3	Akritas	30	49	26	58
4	Enosis Neon	30	48	24	57
5	Alki	30	36	38	47
6	Ermis	30	43	42	44
7	Othellos	30	40	53	42
8	Xylotympou	30	39	42	38
9	Anagennisi	30	33	40	37
10	Omonia 29is	30	31	33	36
11	Omonia	30	30	44	35
12	Onisilos	30	34	44	33
13	Ayia Napa	30	41	52	31
14	Ahironas	30	28	41	31
15	Olympiada	30	23	44	28
16	ASIL Lysi	30	28	47	23

TEMPORADA 2020/2021

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Aris	34	50	22	70
2	PAEEK	34	68	28	70
3	Othellos	34	55	32	69
4	Ayia Napa	34	51	36	60
5	Alki	34	56	38	53
6	Onisilos	34	61	51	51
7	Omonia	34	55	49	51
8	ASIL Lysi	34	34	34	46
9	Ahironas	34	43	43	45
10	Anagennisi	34	50	50	44
11	Akritas	34	41	47	43
12	Xylotympou	34	42	45	41
13	Kouris Erimi	34	50	56	39
14	Digenis	34	43	53	37
15	Omonia	34	44	62	34
16	AE Zakakiou	34	32	51	34
17	THOI	34	35	68	20
18	Digenis	34	32	77	19

TEMPORADA 2019/2020

SEGUNDA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	6	15	7	15
2	Aris	6	7	4	13
3	Ayia Napa	6	4	2	11
4	Ermis	6	9	8	10
5	Onisilos	6	6	8	7
6	ASIL Lysi	6	3	5	5
7	Othellos	6	7	13	4
8	Anagennisi	6	8	12	3

TEMPORADA 2018/2019

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Ethnikos	30	72	23	71
2	Olympiakos	30	77	29	69
3	Aris	30	62	33	68
4	Othellos	30	66	35	50
5	Anagennisi	30	46	33	46
6	Omonia	30	46	39	45
7	ASIL Lysi	30	43	38	45
8	Onisilos	30	42	49	39
9	Karmiotissa	30	47	64	37
10	AE Zakakiou	30	42	55	37
11	Ayia Napa	30	44	45	35
12	Akritas	30	37	61	35
13	THOI	30	27	57	32
14	MEAP Nisou	30	42	55	28
15	PAEEK	30	35	65	22
16	Digenis	30	28	75	14

TEMPORADA 2017/2018

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Enosis Neon	26	54	20	60
2	Anagennisi	26	53	23	59
3	Othellos	26	45	19	54
4	Ayia Napa	26	43	33	42
5	AE Zakakiou	26	36	26	41
6	Omonia	26	39	33	38
7	Karmiotissa	26	41	36	37
8	ASIL Lysi	26	32	35	32
9	PAEEK	26	33	40	31
10	Digenis	26	30	50	28
11	THOI	26	25	39	26
12	Xylotympou	26	29	44	26
13	Ethnikos	26	22	42	18
14	Halkanoras	26	23	65	12

TEMPORADA 2016/2017

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Alki	26	60	16	64
2	Pafos	26	51	24	57
3	Olympiakos	26	44	23	54
4	Othellos	26	53	33	49
5	Ayia Napa	26	52	28	46
6	Enosis Neon	26	41	32	44
7	THOI	26	32	34	33
8	ASIL Lysi	26	27	33	30
9	PAEEK	26	26	38	24
10	Ethnikos	26	24	52	23
11	Omonia	26	16	30	22
12	Akritas	26	24	45	19
13	ENAD	26	26	52	19
14	Parekklisias	26	28	64	19

TEMPORADA 2015/2016

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Olympiakos	26	51	19	62
2	Karmiotissa	26	54	19	61
3	Anagennisi	26	50	18	59
4	AE Zakakiou	26	47	19	58
5	Othellos	26	55	24	56
6	PAEEK	26	32	29	33
7	ENAD	26	30	32	33
8	THOI	26	44	49	33
9	Omonia	26	28	29	32
10	Parekklisias	26	35	37	27
11	ASIL Lysi	26	32	36	26
12	Elpida	26	24	60	15
13	N&S Erimis	26	13	79	9
14	Digenis	26	16	61	8

TEMPORADA 2014/2015

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	THOI	26	46	17	57
2	ASIL Lysi	26	37	16	46
3	Digenis	26	36	29	41
4	PAEEK	26	36	30	41
5	MEAP Nisou	26	33	32	39
6	Akritas	26	37	37	36
7	Ahironas	26	33	29	35
8	Ethnikos	26	28	31	34
9	Amathous	26	40	46	33
10	Ethnikos	26	30	36	33
11	Chalkanoras	26	37	41	30
12	Ormideia	26	32	38	28
13	Digenis	26	21	37	23
14	Foinikas	26	20	47	13

TEMPORADA 2013/2014

SEGUNDA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	18	40	16	36
2	Parekklisias	18	21	18	31
3	Chalkanoras	18	26	22	27
4	AE Zakakiou	18	17	28	23
5	Digenis	18	20	18	22
6	Onisilos	18	15	23	20
7	PAEEK	18	15	17	19
8	ASIL Lysi	18	14	26	19

TEMPORADA 2012/2013

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Karmiotissa	26	49	19	56
2	Parekklisias	26	54	20	53
3	Digenis	26	40	26	51
4	ASIL Lysi	26	41	22	50
5	ENAD	26	39	22	45
6	Spartakos	26	38	37	41
7	Adonis	26	38	35	37
8	Ethnikos	26	27	34	29
9	Ormideia	26	33	33	27
10	Ahironas	26	26	55	23
11	Digenis	26	27	43	22
12	Elpida	26	22	43	22
13	Frenaros	26	32	52	21
14	Atromitos	26	28	53	20

TEMPORADA 2011/2012

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	AEK Kouklia	26	62	16	61
2	N&S Erimis	26	42	26	53
3	AE Zakakiou	26	43	28	52
4	ASIL Lysi	26	56	26	46
5	Adonis	26	43	33	42
6	ENAD	26	39	33	38
7	Spartakos	26	36	28	37
8	Digenis	26	33	35	33
9	Frenaros	26	29	33	32
10	Elpida	26	26	36	31
11	Ormideia	26	27	33	30
12	Ahironas	26	32	46	28
13	Anagennisi	26	21	38	23
14	Maroniou	26	0	78	0

TEMPORADA 2010/2011

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Aris	26	41	20	50
2	Nea Salamis	26	45	19	48
3	Omonia	26	37	27	47
4	Anagennisi	26	28	25	42
5	Othellos	26	28	22	41
6	Atromitos	26	35	26	40
7	PAEEK	26	36	36	36
8	Akritas	26	34	38	34
9	APEP	26	33	34	33
10	Halkanoras	26	41	44	33
11	Onisilos	26	26	30	32
12	ASIL Lysi	26	20	41	23
13	Digenis	26	24	45	21
14	Adonis	26	24	45	19

TEMPORADA 2009/2010

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Alki	26	44	24	55
2	AEK Larnaca	26	41	20	47
3	Olympiakos	26	45	34	44
4	Othellos	26	31	28	39
5	Atromitos	26	35	31	37
6	Digenis	26	35	33	36
7	Omonia	26	26	28	36
8	PAEEK	26	24	27	36
9	ASIL Lysi	26	29	29	35
10	Onisilos	26	30	31	33
11	Akritas	26	25	26	32
12	Frenaros	26	26	32	28
13	Ayia Napa	26	19	41	20
14	MEAP Nisou	26	19	45	14

TEMPORADA 2008/2009

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Ermis	26	47	26	50
2	Aris	26	56	25	49
3	Nea Salamis	26	38	21	49
4	Olympiakos	26	39	21	48
5	Digenis	26	38	28	44
6	Omonia	26	33	41	37
7	MEAP Nisou	26	25	28	36
8	Onisilos	26	30	36	31
9	Ayia Napa	26	23	31	31
10	ASIL Lysi	26	29	30	30
11	PAEEK	26	27	31	29
12	THOI	26	31	46	25
13	Halkanoras	26	28	48	25
14	Ethnikos	26	30	62	17

TEMPORADA 2007/2008

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Pafos	26	46	22	54
2	APEP	26	45	26	51
3	Digenis	26	44	26	46
4	Atromitos	26	41	23	46
5	Onisilos	26	32	23	38
6	Ermis	26	51	43	38
7	Ayia Napa	26	32	32	34
8	Omonia	26	25	24	33
9	ASIL Lysi	26	20	24	32
10	THOI	26	28	40	31
11	MEAP Nisou	26	32	49	31
12	Anagennisi	26	21	35	30
13	Akritas	26	22	39	22
14	Olympos	26	23	56	16

Competiciones que juega

Grupo 1

Segunda Chipre Grupo 1

Pos	Equipos		Pts
1		Enosis Neon Paralimni	33
2		Olympiakos Nicosia	30
3		Omonia Aradippou	29
4		Omonia 29is	28
5		Peyia	27
6		Digenis Ypsonas	27
7		ASIL Lysi	23
8		Ayia Napa	21
9		Achyronas-Onisilos	19
10		Digenis Morphou	19
11		MEAP Nisou	15
12		Xylotympou	14
13		PAEEK	14
14		Akritas Chlorakas	12
15		ENAD	12
16		Ermis Aradippou	7

	Playoff Ascenso : Enosis Neon Paralimni, Olympiakos Nicosia, Omonia Aradippou, Omonia 29is, Peyia, Digenis Ypsonas, ASIL Lysi, Ayia Napa
	Playoff Descenso : Achyronas-Onisilos, Digenis Morphou, MEAP Nisou, Xylotympou, PAEEK, Akritas Chlorakas, ENAD, Ermis Aradippou

RIVALES EN Segunda Chipre

USO DE MEMORIA

6,612,384 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.1530
Total Execution Time	0.1545

CADENA URL

/historico/Asil-Lysi

GET DATOS

$_GET['/historico/Asil-Lysi']

POST DATOS

No hay datos POST existentes

CONSULTAS (45)

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 = 'Asil-Lysi' 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.0019	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=12549 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=12549 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=12549 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040	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 = 73446
0.0027	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 = 75144
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12549 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 708 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	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 (1267270,1252536,262172,90198,9789) ORDER BY n.cover_points DESC, update_date DESC
0.0024	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 = '12549' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023	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 = '12549' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020	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 = 73446 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=12549 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 (75144,70986) 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 = 75144 AND teamId = 12549
0.0018	SELECT count(id) as num_players from rel_players WHERE league_id = 70986 AND teamId = 12549
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 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 = 73446 AND t.round = 15 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 = '12549' 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 = '12549' 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 = '12549' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034	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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 12549 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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 12549 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 73446 WHERE rp.league_id = 73446 AND rp.teamId = 12549 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025	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 = 12549 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 73446 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.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* `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 = 75144 AND t.round = 14 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* `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 = 69229 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.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* `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 = 70986 AND t.round = 14 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 = 64192 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.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* `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 = 57796 AND t.round = 34 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* `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 = 51093 AND t.round = 14 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 = 55493 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 = 44927 AND t.round = 30 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 = 38801 AND t.round = 26 ORDER BY team.conference 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* `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 = 33687 AND t.round = 26 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* `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 = 15734 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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 = 4165 AND t.round = 26 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* `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 = 2771 AND t.round = 28 ORDER BY team.conference 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* `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 = 23918 AND t.round = 26 ORDER BY team.conference 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* `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 = 23919 AND t.round = 26 ORDER BY team.conference 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* `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 = 8743 AND t.round = 26 ORDER BY team.conference 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* `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 = 8742 AND t.round = 26 ORDER BY team.conference 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* `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 = 8740 AND t.round = 26 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* `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 = 8739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

ASIL Lysi

ASIL Lysi

Selecciona un equipo

Competiciones que juega

Segunda Chipre Grupo 1

RIVALES EN Segunda Chipre