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

Anagennisi

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA CHIPRE GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Halkanoras	29	44	15	61
2	Anagennisi	29	49	28	60
3	Spartakos	29	44	19	52
4	APEA	29	43	18	50
5	Ethnikos	29	48	39	47
6	Iraklis	29	35	32	36
7	Kedros Agia	29	34	45	33
8	Ormideia	29	28	56	29

TEMPORADA 2022/2023

SEGUNDA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Xylotympou	12	23	11	21
2	Ermis	13	18	14	20
3	Anagennisi	12	19	22	20
4	Digenis	13	33	20	19
5	PAEEK	12	19	14	17
6	Ayia Napa	12	12	15	17
7	Olympiada	12	13	32	7
8	Alki	2	1	10	0

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 2
Equipo		PJ	GF	GC	Puntos
1	Ermis	14	31	8	38
2	Onisilos	14	24	14	26
3	Othellos	14	21	17	20
4	Digenis	14	18	20	18
5	Anagennisi	14	12	13	15
6	Akritas	14	19	26	15
7	Xylotympou	14	14	22	13
8	AE Zakakiou	14	11	30	9

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

LIGA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	APOEL	26	62	16	62
2	AEK Larnaca	26	54	19	58
3	Apollon	26	56	19	57
4	Limassol	26	40	22	51
5	Omonia	26	56	37	50
6	Anorthosis	26	39	27	39
7	Ermis	26	35	41	35
8	Nea Salamis	26	22	33	31
9	Ethnikos	26	42	46	30
10	Karmiotissa	26	30	53	27
11	Aris	26	30	52	24
12	Doxa	26	20	38	20
13	AE Zakakiou	26	20	63	11
14	Anagennisi	26	18	58	7

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

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Pafos	26	55	19	62
2	Enosis Neon	26	55	14	60
3	Aris	26	35	25	52
4	AE Zakakiou	26	29	19	44
5	Karmiotissa	26	36	29	38
6	Anagennisi	26	27	26	38
7	Olympiakos	26	34	42	35
8	Elpida	26	29	34	34
9	ENAD	26	30	30	29
10	N&S Erimis	26	35	48	29
11	Omonia	26	35	37	28
12	Parekklisias	26	28	38	28
13	Digenis	26	16	49	18
14	APEP	26	18	52	14

TEMPORADA 2013/2014

SEGUNDA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Ayia Napa	28	58	29	63
2	Othellos	28	55	25	55
3	Anagennisi	28	67	36	51
4	Omonia	28	41	33	45
5	N&S Erimis	28	48	49	33
6	Olympiakos	28	36	43	23
7	APEP	28	22	61	19
8	Pafos	28	24	75	0

TEMPORADA 2012/2013

SEGUNDA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Aris	26	64	21	55
2	Ermis	26	41	23	52
3	AE Kouklion	26	55	28	50
4	Anagennisi	26	28	23	43
5	APEP	26	35	25	42
6	N&S Erimis	26	37	33	41
7	Omonia	26	40	40	35
8	Othellos	26	28	35	34
9	PAEEK	26	35	37	33
10	AE Zakakiou	26	34	45	32
11	Halkanoras	26	34	42	29
12	Onisilos	26	21	32	29
13	Akritas	26	23	42	14
14	Ethnikos	26	25	74	12

TEMPORADA 2011/2012

LIGA CHIPRE GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Limassol	26	33	7	60
2	Omonia	26	47	16	57
3	APOEL	26	39	13	56
4	Anorthosis	26	30	12	52
5	AEK Larnaca	26	33	21	42
6	Nea Salamis	26	33	41	36
7	Alki	26	32	40	34
8	Apollon	26	31	39	34
9	Olympiakos	26	29	34	30
10	Ethnikos	26	21	23	29
11	Enosis Neon	26	17	24	29
12	Aris	26	27	35	27
13	Anagennisi	26	16	45	11
14	Ermis	26	12	50	7

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

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Halkanoras	26	74	24	59
2	Adonis	26	47	28	47
3	Anagennisi	26	42	29	46
4	AE Zakakiou	26	42	41	37
5	AE Kouklion	26	37	39	35
6	ENAD	26	38	37	34
7	Elpida	26	25	32	34
8	Spartakos	26	41	36	33
9	Ethnikos	26	32	40	32
10	Iraklis	26	40	50	32
11	Digenis	26	36	50	31
12	Kissos	26	31	36	29
13	THOI	26	37	48	27
14	Ahironas	26	20	52	21

TEMPORADA 2008/2009

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Akritas	26	46	23	54
2	Frenaros	26	52	29	48
3	Othellos	26	35	23	46
4	AE Zakakiou	26	42	35	39
5	Digenis	26	36	32	39
6	AEK Kouklia	26	33	27	38
7	Kissos	26	36	38	38
8	Spartakos	26	48	37	37
9	Adonis	26	39	31	36
10	Elpida	26	34	40	33
11	Anagennisi	26	32	35	32
12	Anagennisi	26	38	51	31
13	Orfeas	26	24	44	25
14	Olympos	26	26	76	7

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

Tercera Chipre Grupo 1

Pos	Equipos		Pts
1		Anagennisi	32
2		Halkanoras	31
3		Spartakos Kitiou	27
4		Ormideia	27
5		APEA	26
6		Ethnikos Latsion	25
7		Kedros Agia Marina	23
8		Iraklis Yerolakkou	21
9		Omonia Psevda	21
10		Kouris Erimi	19
11		Geroskipou	19
12		ASPIS Pylas	17
13		AEP Polemidion	12
14		Olympiada Lympion	11
15		APEP	9
16		Ethnikos Assias	9

	Playoff Ascenso : Anagennisi, Halkanoras, Spartakos Kitiou, Ormideia, APEA, Ethnikos Latsion, Kedros Agia Marina, Iraklis Yerolakkou
	Playoff Descenso : Omonia Psevda, Kouris Erimi, Geroskipou, ASPIS Pylas, AEP Polemidion, Olympiada Lympion, APEP, Ethnikos Assias

RIVALES EN Tercera Chipre

USO DE MEMORIA

6,626,792 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	1.9543
Total Execution Time	1.9564

CADENA URL

/historico/Anagennisi-Der

GET DATOS

$_GET['/historico/Anagennisi-Der']

POST DATOS

No hay datos POST existentes

CONSULTAS (40)

0.2163	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 = 'Anagennisi-Der' 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.0027	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=5859 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=5859 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=5859 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0052	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 = 73512
0.0045	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 = 75146
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5859 AND type_rel = 2
0.0079	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=578 AND type_rel = 3
0.0903	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 = '5859' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.3579	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 = '5859' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0252	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 = 75146 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0955	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=5859 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0133	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 (75146,70915,67320) 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.0554	SELECT count(id) as num_players from rel_players WHERE league_id = 70915 AND teamId = 5859
0.0414	SELECT count(id) as num_players from rel_players WHERE league_id = 75146 AND teamId = 5859
0.0314	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 5859
0.0528	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 = 73512 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0899	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 = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 5859 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.0720	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 = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 5859 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0476	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 = 73512 WHERE rp.league_id = 73512 AND rp.teamId = 5859 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.1163	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 = 5859 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0458	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 = 73512 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.0144	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 = 75146 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.0483	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 = 69228 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.0223	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 = 70915 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.0391	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.0246	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.0218	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 = 51094 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.0370	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.0095	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.0183	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 = 33682 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0281	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.0413	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 = 4169 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0268	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 = 8748 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0201	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 = 8746 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0305	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 = 1377 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0316	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.0261	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 = 23921 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0176	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 = 23922 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0209	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

Anagennisi

Anagennisi

Selecciona un equipo

Competiciones que juega

Tercera Chipre Grupo 1

RIVALES EN Tercera Chipre