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

Digenis Morphou

Entrenador: Dimitris Dimitriou

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA CHIPRE GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	PAEEK	14	30	10	32
2	Digenis	14	27	13	32
3	Akritas	14	20	11	23
4	MEAP Nisou	14	18	19	18
5	Achyronas-On	13	15	17	16
6	ENAD	13	17	19	13
7	Ermis	14	11	28	13
8	Xylotympou	14	12	33	6

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

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Peyia	26	42	12	57
2	MEAP Nisou	26	41	23	49
3	Digenis	26	41	26	48
4	AE Zakakiou	26	44	26	47
5	Digenis	26	45	25	43
6	Elia	26	35	36	35
7	Iraklis	26	35	40	32
8	Kouris Erimi	26	29	36	29
9	THOI	26	32	35	29
10	APEP	26	32	40	29
11	Ethnikos	26	26	43	28
12	Ormideia	26	27	42	28
13	Halkanoras	26	28	44	25
14	Omonia	26	33	62	21

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 4
Equipo		PJ	GF	GC	Puntos
1	Alki	6	12	5	12
2	AE Zakakiou	6	5	1	12
3	Omonia	6	9	6	11
4	Xylotympou	6	8	6	11
5	Digenis	6	6	7	9
6	Akritas	6	6	7	7
7	Digenis	6	5	11	5
8	Omonia	6	6	14	0

TEMPORADA 2018/2019

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Digenis	30	62	26	62
2	Omonia	30	50	35	58
3	Digenis	30	52	27	53
4	Xylotympou	30	39	25	52
5	ENAD	30	45	35	47
6	Halkanoras	30	52	50	43
7	Ethnikos	30	44	44	43
8	Kouris Erimi	30	39	39	42
9	Ormideia	30	44	39	41
10	Ahironas	30	42	42	40
11	Elpida	30	38	49	39
12	Amathous	30	37	42	38
13	APEA	30	43	50	38
14	Olympiada	30	43	53	33
15	Ethnikos	30	30	52	25
16	Peyia	30	25	77	9

TEMPORADA 2017/2018

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Onisilos	30	60	22	68
2	MEAP Nisou	30	67	31	63
3	Akritas	30	44	22	58
4	Digenis	30	61	45	48
5	ENAD	30	47	35	47
6	Elpida	30	44	36	46
7	Peyia	30	41	48	45
8	APEA	30	35	39	41
9	Ahironas	30	41	47	38
10	Ormideia	30	33	35	38
11	Ethnikos	30	45	55	37
12	Digenis	30	45	47	36
13	Olympiada	30	45	60	35
14	APEP	30	36	46	32
15	Foinikas	30	23	51	20
16	Leivadiakós	30	35	83	15

TEMPORADA 2016/2017

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Xylotympou	30	54	22	70
2	Digenis	30	57	35	57
3	Halkanoras	30	52	39	56
4	Ethnikos	30	59	25	54
5	Olympiada	30	41	45	46
6	Digenis	30	42	45	43
7	Digenis	30	48	48	42
8	Ahironas	30	38	38	39
9	Peyia	30	41	38	38
10	MEAP Nisou	30	34	44	36
11	Ormideia	30	31	36	35
12	APEP	30	32	40	35
13	Leivadiakós	30	44	48	34
14	Iraklis	30	41	48	32
15	Elpida	30	36	54	29
16	Agiou	30	27	72	18

TEMPORADA 2015/2016

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Akritas	30	72	21	67
2	Alki	30	62	25	67
3	Ethnikos	30	64	34	57
4	MEAP Nisou	30	51	33	50
5	Ahironas	30	44	36	49
6	Halkanoras	30	44	34	47
7	Xylotympou	30	36	43	44
8	Digenis	30	31	38	39
9	Iraklis	30	39	41	38
10	Olympiada	30	38	48	38
11	Ormideia	30	37	50	34
12	Digenis	30	44	59	34
13	Ethnikos	30	24	39	33
14	APEP	30	38	55	33
15	Kouris Erimi	30	27	53	20
16	Amathous	30	26	68	17

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

TERCERA CHIPRE
Equipo		PJ	GF	GC	Puntos
1	Elpida	26	43	10	62
2	ENAD	26	59	20	60
3	THOI	26	58	24	54
4	Ahironas	26	42	25	45
5	MEAP Nisou	26	35	40	38
6	Ormideia	26	32	31	36
7	Foinikas	26	41	40	36
8	Ethnikos	26	37	46	35
9	Akritas	26	25	35	32
10	Ethnikos	26	27	38	30
11	Digenis	26	24	40	25
12	Spartakos	26	31	52	25
13	Adonis	26	33	51	17
14	Constantinos	26	31	66	12

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 3

Pos	Equipos		Pts
1		PAEEK	32
2		Digenis Morphou	32
3		Akritas Chlorakas	23
4		MEAP Nisou	18
5		Achyronas-Onisilos	16
6		ENAD	13
7		Ermis Aradippou	13
8		Xylotympou	6

	Descenso : ENAD, Ermis Aradippou, Xylotympou

RIVALES EN Copa de Chipre

RIVALES EN Segunda Chipre

USO DE MEMORIA

6,760,040 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6885
Total Execution Time	0.6897

CADENA URL

/historico/Digenis-Akritas

GET DATOS

$_GET['/historico/Digenis-Akritas']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0143	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 = 'Digenis-Akritas' 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.0128	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=17251 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=17251 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=17251 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131	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=17251 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0269	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.0146	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 = 74229
0.0127	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17251 AND type_rel = 2
0.0126	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=708 AND type_rel = 3
0.0127	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.0128	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.0129	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 = '17251' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0129	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 = '17251' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	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.0129	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=17251 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (75145,74229,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.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 75145 AND teamId = 17251
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 70986 AND teamId = 17251
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 74229 AND teamId = 17251
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 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 = 75145 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0135	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 = 75145 WHERE rp.league_id = 75145 AND rp.teamId = 17251 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.0132	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 = 75145 WHERE rp.league_id = 75145 AND rp.teamId = 17251 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 75145 WHERE rp.league_id = 75145 AND rp.teamId = 17251 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130	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 = 17251 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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.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* `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 = 75145 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.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 = 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.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* `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.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 = 64646 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.0131	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.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* `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.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* `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 = 55494 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.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* `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 = 44928 AND t.round = 30 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 = 39162 AND t.round = 30 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 = 33689 AND t.round = 30 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* `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 = 15847 AND t.round = 30 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 = 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.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* `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 = 3551 AND t.round = 26 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* `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.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* `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.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* `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.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* `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.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* `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.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* `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

Digenis Morphou

Digenis Morphou

Selecciona un equipo

Competiciones que juega

Segunda Chipre Grupo 3

RIVALES EN Copa de Chipre

RIVALES EN Segunda Chipre