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

Panachaiki

Entrenador: Giannis Tatsis

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA GRECIA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Iraklis	7	7	4	28
2	PAOK B	6	12	9	27
3	Anagennisi	7	2	5	21
4	Kampaniakos	7	7	7	20
5	Kozani FC	7	8	9	20
6	Aiolikos	6	3	5	15
7	Diagoras	7	7	4	27
8	Egaleo	7	7	3	25
9	Panachaiki	7	8	9	24
10	Panathinaiko	7	4	3	20
11	Giouchtas	7	5	11	17
12	Olympiacos	7	9	10	16

TEMPORADA 2022/2023

SEGUNDA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Kifisia	28	62	16	66
2	Athens	28	54	21	65
3	Apollon	28	37	20	56
4	Chania	28	38	18	51
5	Ierapetra	28	39	25	48
6	Kalamata FC	28	34	17	47
7	Ilioupoli	28	36	32	41
8	Panachaiki	28	32	29	39
9	Olympiacos	28	39	36	34
10	Egaleo	28	27	31	34
11	Athens	28	30	35	29
12	Proodeftiki	28	23	37	29
13	Episkopi	28	17	53	16
14	PAO Rouf	28	25	60	12
15	Irodotos	28	6	69	0

TEMPORADA 2021/2022

TERCERA GRECIA GRUPO 8
Equipo		PJ	GF	GC	Puntos
1	Panachaiki	6	11	5	15
2	Proodeftiki	6	8	3	10
3	Agrotikos	6	9	6	10
4	Kozani FC	6	5	4	9
5	Ilioupoli	6	8	7	7
6	PAO Rouf	6	7	9	7
7	Iraklis	6	4	18	1

TEMPORADA 2020/2021

SEGUNDA GRECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Panachaiki	27	29	29	37
2	Trikala	27	21	25	29
3	Apollon	27	19	27	29
4	Doxa Dramas	27	24	47	28
5	Karaiskakis	27	24	42	24
6	Ierapetra	27	25	36	20

TEMPORADA 2019/2020

SEGUNDA GRECIA
Equipo		PJ	GF	GC	Puntos
1	Giannina	20	44	11	49
2	Apollon	20	36	13	42
3	Levadiakos	20	27	15	38
4	Chania	20	29	13	35
5	Karaiskakis	20	32	29	31
6	Apollon	20	27	25	30
7	Ergotelis	20	31	33	29
8	Panachaiki	20	34	19	28
9	Platanias	20	26	32	26
10	Doxa Dramas	20	25	25	24
11	Apollon	20	8	58	0
12	Kerkyra	20	6	52	0

TEMPORADA 2018/2019

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	Volos	30	59	29	57
2	Apollon	30	44	27	57
3	Platanias	30	53	22	55
4	Ergotelis	30	46	29	49
5	Apollon	30	33	27	49
6	Doxa Dramas	30	43	26	48
7	Panachaiki	30	32	25	48
8	Kerkyra	30	30	25	47
9	Chania	30	40	24	46
10	Iraklis	30	29	24	42
11	Karaiskakis	30	24	28	40
12	Trikala	30	27	30	35
13	Irodotos	30	24	50	31
14	Aittitos	30	18	50	22
15	Aiginiakos	30	24	66	19
16	Sparti	30	18	62	18

TEMPORADA 2017/2018

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	OFI	34	86	14	86
2	Aris	34	65	13	85
3	Panachaiki	34	50	21	73
4	Chania	34	64	32	64
5	Doxa Dramas	34	57	25	63
6	Trikala	34	31	22	58
7	Apollon	34	43	27	53
8	Karaiskakis	34	35	32	48
9	Ergotelis	34	56	47	46
10	Apollon	34	45	54	43
11	Aiginiakos	34	36	54	37
12	Sparti	34	29	46	34
13	Anagennisi	34	32	41	34
14	Panserraikos	34	43	52	27
15	Panegialios	34	29	57	25
16	Athens	34	26	40	21
17	Veria NPS	33	13	70	5
18	Acharnaikos	33	2	95	0

TEMPORADA 2016/2017

TERCERA GRECIA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Panachaiki	28	47	9	65
2	Chalkida	28	34	22	52
3	PAO Vardas	28	36	26	48
4	Ermionidas-E	28	40	31	43
5	Asteras	28	25	30	38
6	AO Thiva	28	32	29	37
7	Fostiras	28	25	20	36
8	Achaiki	28	30	33	36
9	Aiolikos	28	31	25	35
10	Panarkadikos	28	21	25	35
11	Panargiakos	28	24	32	35
12	Pylou	28	24	30	32
13	Loutraki	28	22	35	31
14	Zevgolateio	28	15	37	26
15	Doxa	28	24	46	25

TEMPORADA 2015/2016

FOOTBALL LEAGUE GRECIA
Equipo		PJ	GF	GC	Puntos
1	AE Larisa	34	49	15	78
2	Kerkyra	34	57	24	75
3	Trikala	34	53	22	67
4	Apollon	34	46	19	61
5	Lamia	34	41	24	59
6	Chania	34	29	19	51
7	Athens	34	41	31	49
8	Acharnaikos	34	30	29	45
9	Anagennisi	34	30	34	45
10	Panserraikos	34	39	43	43
11	Agrotikos	34	27	24	43
12	Chania	34	34	37	41
13	Panegialios	34	34	40	41
14	Panelefsinia	34	34	53	35
15	Zakynthos	34	31	32	34
16	Panachaiki	34	26	47	28
17	Olympiakos	33	16	69	10
18	Ergotelis	33	18	73	7

TEMPORADA 2014/2015

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AEK Athens	24	67	10	65
2	Panachaiki	24	41	22	46
3	Apollon	24	32	17	45
4	Chania	24	28	20	42
5	Ermionidas-E	24	30	28	41
6	Panegialios	24	24	12	40
7	Acharnaikos	24	28	22	35
8	Athens	24	25	25	33
9	Episkopi	24	25	34	26
10	Iraklis	24	23	37	23
11	Trachones	24	15	25	21
12	Fostiras	24	20	43	15
13	Paniliakos	24	7	70	1

TEMPORADA 2013/2014

FOOTBALL LEAGUE GRECIA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Olympiakos	26	54	18	56
2	Chania	26	29	13	48
3	Fostiras	26	27	19	46
4	Iraklis	26	32	14	44
5	Panegialios	26	27	19	44
6	Panachaiki	26	28	21	40
7	Athens	26	32	21	39
8	Acharnaikos	26	26	22	37
9	Fokikos	26	33	31	36
10	Paniliakos	26	30	28	35
11	Episkopi	26	30	28	34
12	Asteras	26	26	36	27
13	Glyfada	26	16	62	9
14	Vyzas Megara	26	17	75	8

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 1
Equipo		PJ	GF	GC	Puntos
1	Panachaiki	30	48	20	61
2	Vyzas Megara	30	41	19	57
3	Iraklis	30	41	24	56
4	Rodos	30	38	23	53
5	Platanias	30	42	23	52
6	Korinthos	30	38	24	50
7	Apollon	30	37	25	50
8	Panegialios	30	29	32	43
9	Chania	30	42	40	42
10	Aias	30	34	39	40
11	PAO Rouf	30	34	32	37
12	Paniliakos	30	24	26	37
13	Enosi	30	30	38	34
14	Olympiakos	30	21	32	26
15	Agia	30	13	62	16
16	Keravnos	30	11	64	9

TEMPORADA 2009/2010

TERCERA GRECIA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Vyzas Megara	32	47	19	69
2	Athens	32	54	28	69
3	Panachaiki	32	60	31	66
4	Zakynthos	32	53	41	52
5	PAO Rouf	31	30	21	48
6	Olympiakos	32	31	28	48
7	Enosi	32	37	41	46
8	Agia	32	33	29	44
9	Korinthos	32	31	36	44
10	Panegialios	32	31	33	41
11	Keravnos	32	33	37	41
12	Aias	31	37	30	40
13	Platanias	32	32	36	39
14	Atsalenios	32	33	43	37
15	Panargiakos	32	30	39	35
16	Saronikos	32	32	58	27
17	Chaidari	32	23	77	8

Competiciones que juega

Grupo 2

Segunda Grecia Grupo 4

Pos	Equipos		Pts
1		Iraklis Thessaloniki	28
2		PAOK B	27
3		Diagoras	27
4		Egaleo	25
5		Panachaiki	24
6		Anagennisi Karditsas	21
7		Panathinaikos B	20
8		Kampaniakos Chalastra	20
9		Kozani FC	20
10		Giouchtas	17
11		Olympiacos Piraeus B	16
12		Aiolikos	15

	Descenso : Egaleo, Panachaiki, Anagennisi Karditsas

RIVALES EN Copa Griega

RIVALES EN Segunda Grecia

USO DE MEMORIA

6,710,488 bytes

BENCHMARKS

Loading Time Base Classes	0.0015
Controller Execution Time ( Home / Category )	0.2158
Total Execution Time	0.2174

CADENA URL

/historico/Panachaiki

GET DATOS

$_GET['/historico/Panachaiki']

POST DATOS

No hay datos POST existentes

CONSULTAS (44)

0.0045	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 = 'Panachaiki' 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.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=12443 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=12443 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=12443 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=12443 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0055	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 = 75675
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12443 AND type_rel = 2
0.0021	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12443 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020	SELECT /35 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 (530480) ORDER BY n.cover_points DESC, update_date DESC
0.0029	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 = '12443' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0031	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 = '12443' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025	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 = 73942 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046	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=12443 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020	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 (75675,73551,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.0036	SELECT count(id) as num_players from rel_players WHERE league_id = 75675 AND teamId = 12443
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 73551 AND teamId = 12443
0.0037	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 12443
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 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 = 75675 AND t.round = 7 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022	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 = '12443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '12443' and rp.type = 4
0.0021	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 = '12443' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0049	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 = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 12443 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.0040	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 = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 12443 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 75675 WHERE rp.league_id = 75675 AND rp.teamId = 12443 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0059	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 = 12443 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 75675 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 69285 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.0027	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 = 65487 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.0029	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 = 67312 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0107	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 = 59056 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.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* `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 = 62298 AND t.round = 5 ORDER BY team.conference ASC,t.position 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* `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 = 51252 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.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* `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 = 46942 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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 = 39254 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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 = 36069 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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 = 15462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027	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 = 13425 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 4428 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* `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 = 3486 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0051	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.0020	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 = 13407 AND t.round = 6 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* `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.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* `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 = 24791 AND t.round = 30 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* `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 = 24844 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Panachaiki

Panachaiki

Selecciona un equipo

Competiciones que juega

Segunda Grecia Grupo 4

RIVALES EN Copa Griega

RIVALES EN Segunda Grecia