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

Anagennisi Giannitsa

Temporada 2021/2022

TEMPORADA 2021/2022

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Makedonikos	22	32	10	49
2	Kozani FC	22	35	11	47
3	AEP Kozani	22	28	18	37
4	Edessaikos	22	30	25	36
5	Poseidon	22	28	22	33
6	Alexandros	22	27	22	33
7	Keravnos	22	30	31	33
8	AE Lefkimmi	22	27	25	30
9	Anagennisi	22	15	26	22
10	Agios	22	24	38	22
11	Asteras	22	15	38	14
12	Iraklis	22	18	43	13

TEMPORADA 2020/2021

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Poseidon	14	27	6	38
2	Keravnos	14	23	15	26
3	Thermaikos	14	24	18	25
4	Agrotikos	14	23	21	25
5	Makedonikos	14	27	10	24
6	Anagennisi	14	23	15	22
7	Anagennisi	14	20	12	22
8	Alexandros	14	20	18	21
9	Edessaikos	14	16	19	21
10	Niki	14	15	16	20
11	Kallikrateia	14	15	20	15
12	Aetos	14	21	27	14
13	Ethnikos	14	17	26	11
14	Koufalion	14	8	22	8
15	PAOK	14	11	45	4

TEMPORADA 2019/2020

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Almopos	25	59	10	61
2	Makedonikos	25	33	8	47
3	Poseidon	25	44	26	46
4	Anagennisi	25	34	19	45
5	Thermaikos	25	40	21	43
6	Edessaikos	25	35	15	42
7	Keravnos	24	34	28	39
8	Alexandros	26	25	20	39
9	Agrotikos	23	31	17	37
10	Kallikrateia	24	33	19	35
11	Niki	24	26	19	33
12	Florina	25	27	41	29
13	Astrapi	25	15	58	13
14	Seirína	22	4	70	3
15	Palaiochori	25	3	72	3

TEMPORADA 2018/2019

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Elpis	26	51	15	57
2	Triglia	26	39	19	55
3	Niki	26	31	11	53
4	Palaiochori	26	45	27	52
5	Edessaikos	26	45	14	45
6	Almopos	26	37	18	42
7	Anagennisi	26	31	25	37
8	Makedonikos	26	32	30	36
9	Agrotikos	26	25	29	34
10	Koufalion	26	20	39	22
11	Olympiakos	26	13	33	22
12	Meliteas	26	28	66	18
13	Ermis	26	21	53	13
14	Langadas	26	14	53	13

TEMPORADA 2014/2015

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panserraikos	30	52	15	74
2	Aris	30	51	12	71
3	Kavala	30	54	16	67
4	Doxa Dramas	30	43	26	52
5	Kampaniakos	30	53	34	47
6	Ethnikos	30	40	34	42
7	Iraklis	30	32	30	41
8	Thyella	30	32	31	40
9	Byzantio	30	44	49	40
10	Ethnikos	30	28	28	38
11	Evros Soufli	30	32	34	37
12	Aris	30	32	45	34
13	Apollon	30	26	45	27
14	Orfeas	30	26	43	22
15	Anagennisi	30	19	62	20
16	Kastoria	30	15	75	10

TEMPORADA 2013/2014

FOOTBALL LEAGUE GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kerkyra	26	45	18	59
2	Niki Volos	26	47	12	56
3	Aiginiakos	26	45	15	51
4	Iraklis	26	36	19	48
5	Anagennisi	26	28	20	44
6	Tyrnavos	26	27	22	41
7	Apollon	26	33	32	37
8	Ethnikos	26	23	22	35
9	Zakynthos	26	25	35	31
10	Doxa Dramas	26	22	30	30
11	Pierikos	26	20	34	29
12	Vataniakos	26	20	45	20
13	Kavala	26	18	49	17
14	Anagennisi	26	15	51	12

TEMPORADA 2012/2013

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Apollon	40	50	29	75
2	Ergotelis	40	42	25	74
3	Panaitolikos	40	55	23	73
4	Olympiakos	40	49	23	73
5	Kalloni	40	48	22	73
6	Iraklis	40	49	25	71
7	Niki Volos	40	44	23	68
8	Panserraikos	40	40	29	68
9	AE Larisa	40	42	25	63
10	Doxa Dramas	40	35	27	60
11	Iraklis	40	42	37	55
12	Kavala	40	35	36	53
13	Athens	40	42	44	50
14	Panachaiki	40	32	40	42
15	Ethnikos	40	27	35	41
16	Pierikos	40	33	61	39
17	Fokikos	40	28	51	37
18	Anagennisi	40	35	68	34
19	Vyzas Megara	40	22	49	32
20	Thrasyvoulos	40	23	48	31
21	Anagennisi	40	24	77	15

TEMPORADA 2011/2012

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Panthrakikos	34	49	16	73
2	Veria NPS	34	56	19	72
3	Athens	34	58	32	64
4	Panachaiki	34	55	33	61
5	Platanias	34	41	20	60
6	Kalloni	34	46	29	57
7	Panserraikos	34	39	22	57
8	Pierikos	34	41	30	55
9	Anagennisi	34	42	46	44
10	AE Larisa	34	38	29	43
11	Iraklis	34	29	23	42
12	Thrasyvoulos	34	37	40	42
13	Anagennisi	34	29	44	39
14	Fokikos	34	27	38	35
15	Agrotikos	34	24	41	34
16	Vyzas Megara	34	24	42	34
17	Ethnikos	33	11	62	13
18	Diagoras	33	3	83	3

TEMPORADA 2010/2011

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos

TEMPORADA 2009/2010

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Trikala	32	40	11	64
2	Veria NPS	31	49	21	64
3	Anagennisi	32	60	36	58
4	Anagennisi	31	39	23	58
5	Eordaikos	31	40	20	56
6	Makedonikos	31	35	22	52
7	Pyrsos	32	39	28	49
8	Ethnikos	31	39	35	48
9	Fokikos	32	31	27	47
10	Niki Volos	33	31	38	41
11	Doxa	32	26	30	39
12	Odysseas	32	33	31	37
13	AEP Kozani	33	24	28	36
14	Neon	31	26	38	33
15	Visaltiakos	32	30	42	28
16	Thermaikos	32	25	59	20
17	Kastoria	32	7	85	4

TEMPORADA 2008/2009

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Doxa Dramas	34	68	22	76
2	Panaitolikos	34	56	14	70
3	Eordaikos	33	46	17	65
4	Makedonikos	34	47	25	56
5	Neon	34	44	25	55
6	Zakynthos	34	39	27	54
7	Niki Volos	34	32	26	49
8	Anagennisi	34	35	36	48
9	Odysseas	34	35	30	47
10	Ethnikos	34	33	35	47
11	Pyrsos	34	37	28	46
12	Fokikos	33	38	34	46
13	Thermaikos	32	48	41	45
14	Preveza	34	26	23	44
15	Lamia	34	34	34	42
16	Ethnikos	34	25	68	21
17	Anagennisi	34	15	78	17
18	Enosi Thraki	34	3	98	0

TEMPORADA 2007/2008

TERCERA GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Kavala	32	49	18	72
2	Anagennisi	31	43	19	60
3	Paone	32	42	23	59
4	Olympiakos	31	36	32	53
5	Thermaikos	32	42	31	52
6	Enosi Thraki	32	27	26	47
7	Preveza	32	39	28	45
8	Ethnikos	32	35	27	45
9	Anagennisi	32	46	39	45
10	Niki Volos	32	37	33	44
11	Eordaikos	32	26	29	43
12	Anagennisi	32	39	36	41
13	Lamia	32	30	32	40
14	Polykastro	32	26	41	31
15	Prosotsani	31	25	36	30
16	AE Giannina	31	30	42	24
17	Doxa Dramas	32	6	86	6

Competiciones que juega

Tercera Grecia Grupo 2

Pos	Equipos		Pts
1		Makedonikos Neapolis	49
2		Kozani FC	47
3		AEP Kozani	37
4		Edessaikos	36
5		Poseidon Nea Michaniona	33
6		M. Alexandros Trikala	33
7		Keravnos Angelochoriou	33
8		AE Lefkimmi	30
9		Anagennisi Giannitsa	22
10		Agios Matthaios	22
11		Asteras Kalirachis	14
12		Iraklis Ampelokipoi	13

	Playoff Ascenso : Makedonikos Neapolis
	Descenso : AE Lefkimmi, Anagennisi Giannitsa, Agios Matthaios, Asteras Kalirachis, Iraklis Ampelokipoi

RIVALES EN Copa Griega

RIVALES EN Tercera Grecia

USO DE MEMORIA

6,260,704 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.8626
Total Execution Time	0.8639

CADENA URL

/historico/Anagennisi-Giannitsa

GET DATOS

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

POST DATOS

No hay datos POST existentes

CONSULTAS (58)

0.0132	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-Giannitsa' 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.0151	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-Giannitsa' 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.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16658 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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0129	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=16658 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 65485
0.0134	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 = 64113
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=16658 AND type_rel = 2
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 = '16658' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0128	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 = '16658' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0128	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 = '16658' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0132	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 = 64113 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 65485 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=16658 AND l.year in (2021,2022,2023) 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 (68776,65485) 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.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 65485 AND teamId = 16658
0.0127	SELECT count(id) as num_players from rel_players WHERE league_id = 68776 AND teamId = 16658
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 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 = 65485 AND t.round = 22 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 = '16658' 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 = '16658' and rp.type = 4
0.0126	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 = '16658' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2022 e ON e.player_id = p.id AND e.league_id = 65485 WHERE rp.league_id = 65485 AND rp.teamId = 16658 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.0129	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 events2022 e ON e.player_id = p.id AND e.league_id = 65485 WHERE rp.league_id = 65485 AND rp.teamId = 16658 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 events2022 e ON e.player_id = p.id AND e.league_id = 65485 WHERE rp.league_id = 65485 AND rp.teamId = 16658 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 = 16658 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 65485 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 = 59058 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* `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 = 51442 AND t.round = 27 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 = 45474 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* `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 = 12485 AND t.round = 30 ORDER BY team.conference 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* `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 = 3487 AND t.round = 26 ORDER BY team.conference 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* `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 = 2780 AND t.round = 42 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* `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 = 13406 AND t.round = 34 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* `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 = 24807 AND t.round = 34 ORDER BY team.conference 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* `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 = 24842 AND t.round = 34 ORDER BY team.conference 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* `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 = 24846 AND t.round = 34 ORDER BY team.conference 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* `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 = 24849 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿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

Anagennisi Giannitsa

Anagennisi Giannitsa

Selecciona un equipo

Competiciones que juega

Tercera Grecia Grupo 2

RIVALES EN Copa Griega

RIVALES EN Tercera Grecia