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

GKS Katowice

Entrenador: Rafal Gorak

Temporada 2023/2024

TEMPORADA 2023/2024

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Lechia	30	50	26	59
2	Arka Gdynia	30	50	31	58
3	GKS Tychy	30	40	34	51
4	Katowice	30	51	31	50
5	Wisla	30	56	37	49
6	Motor Lublin	30	41	36	49
7	Wisła	30	43	39	48
8	Odra Opole	30	36	30	46
9	Górnik	30	30	26	46
10	Stal Rzeszow	30	45	47	42
11	Miedz	30	39	32	41
12	Znicz	30	28	37	37
13	Termalica	30	43	45	34
14	Chrobry	30	30	47	34
15	Polonia	30	36	44	30
16	Resovia	30	34	54	29
17	Podbeskidzie	30	24	50	22
18	Zagłębie	30	19	49	15

TEMPORADA 2022/2023

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	LKS Lódz	34	58	36	66
2	Ruch	34	48	33	62
3	Termalica	34	55	37	61
4	Wisla	34	61	38	60
5	Puszcza	34	49	36	58
6	Stal Rzeszow	34	57	44	51
7	Podbeskidzie	34	56	47	49
8	Arka Gdynia	34	56	45	48
9	Chrobry	34	44	53	46
10	Katowice	34	41	39	44
11	Zagłębie	34	33	43	42
12	Górnik	34	40	45	40
13	GKS Tychy	34	46	52	39
14	Resovia	34	43	51	38
15	Odra Opole	34	39	48	37
16	SKRA	34	19	50	31
17	Chojniczanka	34	35	57	27
18	Sandecja	34	28	54	27

TEMPORADA 2021/2022

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Miedz	34	56	22	77
2	Widzew	34	53	38	62
3	Arka Gdynia	34	62	39	61
4	Korona	34	46	37	56
5	Odra Opole	34	51	46	51
6	Chrobry	34	43	34	50
7	Sandecja	34	39	36	47
8	Katowice	34	44	47	46
9	Podbeskidzie	34	48	41	45
10	LKS Lódz	34	33	37	45
11	Resovia	34	42	39	44
12	GKS Tychy	34	37	41	44
13	SKRA	34	28	41	38
14	Puszcza	34	41	50	37
15	Zagłębie	34	41	48	36
16	Stomil	34	32	52	35
17	Gornik	34	32	54	29
18	Jastrzębie	34	32	58	25

TEMPORADA 2020/2021

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Gornik	36	70	29	76
2	Katowice	36	67	41	70
3	Chojniczanka	36	63	34	67
4	Wigry	36	51	35	64
5	Kalisz	36	51	40	57
6	SKRA	36	51	42	52
7	Śląsk	36	61	57	52
8	Garbarnia	36	49	50	52
9	Stal Rzeszow	36	58	60	50
10	Motor Lublin	36	48	44	50
11	Sokół	36	50	56	46
12	Hutnik	36	47	61	45
13	Pogon	36	61	62	42
14	Lech Poznań	36	47	58	40
15	Znicz	36	37	55	38
16	Olimpia	36	39	52	37
17	Stargard	36	36	66	36
18	Olimpia	36	42	67	36
19	Bytovia	36	46	65	34

TEMPORADA 2019/2020

TERCERA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Górnik	34	47	37	63
2	Katowice	34	57	40	59
3	Widzew	34	65	37	59
4	Resovia	34	50	32	52
5	Bytovia	34	50	48	52
6	Stal Rzeszow	34	55	44	51
7	Olimpia	34	46	38	50
8	Garbarnia	34	46	40	50
9	Znicz	34	49	52	49
10	Pogon	34	54	53	49
11	Gornik	34	60	47	48
12	Lech Poznań	34	49	47	47
13	Stargard	34	54	53	47
14	SKRA	34	37	44	47
15	Stal Stalowa	34	45	49	46
16	Elana Torun	34	50	54	41
17	Legionovia	34	33	64	24
18	Gryf	34	23	91	14

TEMPORADA 2018/2019

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Raków	34	54	22	70
2	LKS Lódz	34	58	23	69
3	Stal Mielec	34	59	28	64
4	Sandecja	34	35	29	55
5	Jastrzębie	34	43	38	48
6	Podbeskidzie	34	52	46	48
7	GKS Tychy	34	48	41	47
8	Termalica	34	45	46	46
9	Puszcza	34	37	45	44
10	Stomil	34	38	43	43
11	Chojniczanka	34	49	49	42
12	Odra Opole	34	47	58	40
13	Warta Poznan	34	31	43	39
14	Chrobry	34	29	39	39
15	Wigry	34	40	56	37
16	Bytovia	34	45	50	37
17	Katowice	34	34	45	37
18	Garbarnia	34	21	64	21

TEMPORADA 2017/2018

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Miedz	34	53	27	63
2	Zagłębie	34	46	32	58
3	Chojniczanka	34	48	33	56
4	GKS Tychy	34	41	40	55
5	Katowice	34	44	34	54
6	Wigry	34	40	37	52
7	Raków	34	50	40	51
8	Stal Mielec	34	51	46	51
9	Podbeskidzie	34	37	37	46
10	Chrobry	34	46	47	46
11	Odra Opole	34	37	43	45
12	Puszcza	34	38	38	44
13	Bytovia	34	36	45	40
14	Stomil	34	39	50	39
15	Pogon	34	42	50	38
16	Górnik	34	29	42	35
17	Olimpia	34	24	37	31
18	Ruch	34	35	58	27

TEMPORADA 2016/2017

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Sandecja	34	50	29	61
2	Górnik	34	53	34	58
3	Miedz	34	49	27	57
4	Zagłębie	34	53	44	57
5	Olimpia	34	48	35	56
6	Chojniczanka	34	54	48	56
7	Katowice	34	47	32	54
8	Podbeskidzie	34	40	39	53
9	Wigry	34	51	45	52
10	Stal Mielec	34	38	42	45
11	Pogon	34	34	46	44
12	Chrobry	34	50	50	43
13	Stomil	34	48	50	37
14	GKS Tychy	34	42	51	37
15	Bytovia	34	38	47	35
16	Wisla Pulawy	34	33	49	33
17	Znicz	34	35	64	30
18	Kluczbork	34	35	66	25

TEMPORADA 2015/2016

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Arka Gdynia	34	60	29	69
2	Wisła	34	51	28	63
3	Zawisza	34	57	51	52
4	Katowice	34	42	36	52
5	Zagłębie	34	53	53	52
6	Chrobry	34	47	33	51
7	Miedz	34	41	34	51
8	Bytovia	34	46	44	48
9	Sandecja	34	51	43	47
10	Wigry	34	41	35	45
11	Stomil	34	34	42	44
12	Chojniczanka	34	40	45	43
13	Olimpia	34	39	43	42
14	Kluczbork	34	40	55	41
15	Pogon	34	31	46	41
16	Bełchatów	34	35	40	38
17	Rozwoj	34	35	56	35
18	Dolcan Zabki	34	37	67	30

TEMPORADA 2014/2015

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Zaglebie	34	57	20	77
2	Termalica	34	60	26	73
3	Wisła	34	50	25	69
4	Olimpia	34	46	37	53
5	Chojniczanka	34	50	37	50
6	Dolcan Zabki	34	43	39	50
7	Stomil	34	47	47	49
8	Katowice	34	44	41	48
9	Wigry	34	36	37	47
10	Arka Gdynia	34	38	39	43
11	Chrobry	34	41	45	41
12	Miedz	34	44	45	40
13	Bytovia	34	39	45	40
14	Swinoujscie	34	26	46	36
15	Sandecja	34	40	55	35
16	Pogon	34	34	53	30
17	GKS Tychy	34	31	56	28
18	Widzew	34	25	58	22

TEMPORADA 2013/2014

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Bełchatów	34	50	27	63
2	Górnik	34	45	27	61
3	Dolcan Zabki	34	60	39	55
4	Arka Gdynia	34	53	40	54
5	Termalica	34	42	33	53
6	Olimpia	34	38	39	53
7	Wisła	34	37	33	52
8	Katowice	34	44	45	46
9	Miedz	34	42	37	44
10	Kolejarz	34	36	38	44
11	Sandecja	34	29	40	44
12	Swinoujscie	34	29	34	42
13	Chojniczanka	34	35	33	41
14	Stomil	34	38	42	41
15	GKS Tychy	34	39	48	41
16	Energetyk	34	42	52	33
17	Puszcza	34	37	56	33
18	Brzesko	34	18	51	23

TEMPORADA 2012/2013

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Zawisza	34	69	26	66
2	KS Cracovia	34	48	35	64
3	Termalica	34	54	28	63
4	Swinoujscie	34	57	33	63
5	Arka Gdynia	34	46	29	57
6	GKS Tychy	34	44	28	55
7	Dolcan Zabki	34	52	41	54
8	Miedz	34	49	42	53
9	Olimpia	34	39	34	51
10	Katowice	34	43	36	50
11	Kolejarz	34	47	45	50
12	Górnik	34	37	42	46
13	Stomil	34	37	45	38
14	Sandecja	34	35	54	37
15	Brzesko	34	38	54	32
16	Warta Poznan	34	34	57	28
17	Polonia	34	29	64	22
18	LKS Lódz	34	17	82	14

TEMPORADA 2011/2012

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Piast	34	57	40	64
2	Pogon	34	54	30	61
3	Zawisza	34	47	39	59
4	Kolejarz	34	40	34	57
5	Termalica	34	42	26	56
6	Górnik	34	50	37	54
7	Arka Gdynia	34	50	41	51
8	Swinoujscie	34	46	43	49
9	Ruch	34	46	51	48
10	Warta Poznan	34	44	36	46
11	Olimpia	34	46	41	43
12	Sandecja	34	42	46	40
13	Katowice	34	33	38	39
14	Dolcan Zabki	34	40	53	39
15	Polonia	34	37	51	36
16	Wisła	34	39	50	35
17	Gornik	34	40	64	30
18	Olimpia	34	33	66	22

TEMPORADA 2010/2011

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	LKS Lódz	34	59	34	71
2	Podbeskidzie	34	53	23	69
3	Swinoujscie	34	58	34	66
4	Sandecja	34	52	34	56
5	Piast	34	45	31	52
6	Pogon	34	55	42	51
7	Górnik	34	44	39	50
8	Warta Poznan	34	44	43	50
9	Ruch	34	34	32	46
10	Gornik	34	31	39	42
11	Katowice	34	47	57	41
12	Kolejarz	34	30	43	38
13	Dolcan Zabki	34	33	39	37
14	Termalica	34	40	53	37
15	Kluczbork	34	36	44	36
16	KSZO	34	32	43	36
17	Odra	34	29	58	32
18	Warta	34	28	62	29

TEMPORADA 2009/2010

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Widzew	34	62	17	77
2	Górnik	34	47	30	61
3	Sandecja	34	55	42	59
4	LKS Lódz	34	51	45	55
5	Pogon	34	46	35	51
6	Kluczbork	34	43	37	46
7	Swinoujscie	34	33	36	46
8	KSZO	34	37	46	46
9	Warta	34	34	33	45
10	Podbeskidzie	34	45	38	44
11	Warta Poznan	34	49	45	44
12	Górnik	34	38	45	44
13	Katowice	34	41	41	43
14	Dolcan Zabki	34	37	43	42
15	Wisła	34	43	51	40
16	Znicz	34	32	48	39
17	Stal Stalowa	34	32	58	25
18	Motor Lublin	34	27	62	23

TEMPORADA 2008/2009

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Widzew	34	55	23	72
2	Zaglebie	34	68	33	69
3	Korona	34	51	37	61
4	Podbeskidzie	34	58	29	59
5	Górnik	34	49	36	57
6	Znicz	34	42	29	55
7	Swinoujscie	34	43	37	53
8	Dolcan Zabki	34	35	31	49
9	Wisła	34	45	41	47
10	Warta Poznan	34	44	45	46
11	Katowice	34	37	42	44
12	Stal Stalowa	34	33	34	43
13	Jastrzębie	34	37	48	41
14	Warta	34	39	54	36
15	Motor Lublin	34	21	36	32
16	Tur Turek	34	29	56	30
17	Odra Opole	34	22	51	25
18	Kmita	34	11	57	21

TEMPORADA 2007/2008

SEGUNDA POLONIA
Equipo		PJ	GF	GC	Puntos
1	Lechia	34	55	34	69
2	Śląsk	34	55	30	64
3	Arka Gdynia	34	61	30	62
4	Znicz	34	54	28	62
5	Piast	34	45	23	62
6	Podbeskidzie	34	53	27	58
7	Polonia	34	45	36	50
8	Wisła	34	52	51	50
9	Jastrzębie	34	43	51	45
10	Katowice	34	38	39	43
11	Stal Stalowa	34	30	48	40
12	Odra Opole	34	28	39	35
13	Motor Lublin	34	33	55	35
14	Warta Poznan	34	29	45	32
15	Kmita	34	28	40	31
16	Tur Turek	34	23	46	31
17	LKS Łomża	34	32	59	30
18	Pelikan	34	37	60	28

TEMPORADA 2004/2005

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	26	70	23	62
2	Dyskobolia	26	46	28	51
3	Legia	26	42	19	47
4	Wisła	26	35	30	41
5	KS Cracovia	26	37	29	40
6	Amica Wronki	26	29	28	38
7	Górnik	26	36	36	36
8	Lech Poznań	26	34	40	34
9	Pogon	26	34	43	31
10	Polonia	26	27	52	29
11	Górnik	26	27	30	28
12	Zaglebie	26	31	41	28
13	Odra	26	27	41	24
14	Katowice	26	23	58	16

TEMPORADA 2003/2004

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	26	73	30	65
2	Legia	26	56	19	60
3	Amica Wronki	26	47	25	48
4	Dyskobolia	26	59	31	46
5	Wisła	26	41	39	38
6	Lech Poznań	26	43	34	37
7	Górnik	26	26	33	33
8	Górnik	26	22	38	33
9	Odra	26	27	40	28
10	Katowice	26	20	42	26
11	Polonia	26	25	40	25
12	Gornik	26	17	37	23
13	Swit Nowy D.	26	21	42	22
14	Widzew	26	25	52	19

TEMPORADA 2002/2003

LIGA POLACA
Equipo		PJ	GF	GC	Puntos
1	Wisla	30	75	28	68
2	Dyskobolia	30	56	26	62
3	Katowice	30	39	21	61
4	Legia	30	61	29	60
5	Odra	30	55	42	56
6	Amica Wronki	30	43	34	43
7	Górnik	30	46	32	41
8	Polonia	30	37	45	41
9	Wisła	30	29	38	37
10	Widzew	30	29	39	37
11	Lech Poznań	30	41	38	35
12	Zaglebie	30	34	44	32
13	Ruch	30	29	39	32
14	Szczakowiank	30	40	54	32
15	KSZO	30	21	63	15
16	Pogon	30	14	77	9

Competiciones que juega

Segunda Polonia

Pos	Equipos		Pts
1		Lechia Gdansk	59
2		Arka Gdynia	58
3		GKS Tychy	51
4		GKS Katowice	50
5		Wisla Kraków	49
6		Motor Lublin	49
7		Wisła Płock	48
8		Odra Opole	46
9		Górnik Łęczna	46
10		Stal Rzeszow	42
11		Miedz Legnica	41
12		Znicz Pruszkow	37
13		Termalica Nieciecza	34
14		Chrobry Głogów	34
15		Polonia Warszawa	30
16		Resovia Rzeszów	29
17		Podbeskidzie	22
18		Zagłębie Sosnowiec	15

	Ascenso : Lechia Gdansk, Arka Gdynia
	Playoff Ascenso : GKS Tychy, GKS Katowice, Wisla Kraków, Motor Lublin
	Descenso : Resovia Rzeszów, Podbeskidzie, Zagłębie Sosnowiec

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia

USO DE MEMORIA

8,073,896 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.1688
Total Execution Time	0.1700

CADENA URL

/historico/Gks-Katowice

GET DATOS

$_GET['/historico/Gks-Katowice']

POST DATOS

No hay datos POST existentes

CONSULTAS (46)

0.0032	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 = 'Gks-Katowice' 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=13374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=13374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	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=13374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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=13374 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 72233
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13374 AND type_rel = 2
0.0019	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13374 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0019	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 (102762) ORDER BY n.cover_points DESC, update_date DESC
0.0030	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 = '13374' ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '13374' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0025	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 = '13374' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024	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 = 72171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 72233 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024	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=13374 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 (72233,72171,71432) 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.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 72233 AND teamId = 13374
0.0024	SELECT count(id) as num_players from rel_players WHERE league_id = 72171 AND teamId = 13374
0.0026	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13374
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 = '13374' 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 = '13374' 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 = '13374' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038	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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13374 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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13374 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 = 72233 WHERE rp.league_id = 72233 AND rp.teamId = 13374 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0036	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 = 13374 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 72233 AND t.round = 31 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* `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 = 67920 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.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* `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 = 63249 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.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* `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 = 58339 AND t.round = 38 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 = 44126 AND t.round = 34 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* `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 = 38760 AND t.round = 34 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* `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 = 33387 AND t.round = 34 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* `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 = 15593 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* `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 = 3876 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* `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 = 2863 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* `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 = 8850 AND t.round = 34 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 = 8848 AND t.round = 34 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* `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 = 8845 AND t.round = 34 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* `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 = 8842 AND t.round = 34 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* `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 = 8840 AND t.round = 34 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 = 8838 AND t.round = 34 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* `tables2005` 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 = 8790 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* `tables2004` 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 = 8793 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* `tables2003` 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 = 8794 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72233 ORDER BY nameShow LIMIT 100


	¿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

GKS Katowice

GKS Katowice

Selecciona un equipo

Competiciones que juega

Segunda Polonia

RIVALES EN Copa Polonia

RIVALES EN Segunda Polonia