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

Conil

Entrenador: Juan Antonio Román

Temporada 2023/2024

TEMPORADA 2023/2024

TERCERA FEDERACIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Xerez CD	32	51	21	63
2	Ciudad	32	35	20	62
3	Pozoblanco	32	44	33	59
4	Xerez	32	45	21	58
5	Ceuta	32	46	25	55
6	Salerm	32	46	40	50
7	Utrera	32	47	41	46
8	CD Gerena	32	37	38	46
9	AD Cartaya	32	32	29	42
10	Bollullos	32	26	36	37
11	Coria CF	32	40	50	36
12	Córdoba	32	34	39	36
13	Atlético	32	38	50	35
14	La Palma CF	32	43	49	35
15	Conil	32	27	38	34
16	Sevilla C	32	26	33	32
17	Ayamonte	32	28	46	28
18	Cabecense	32	24	60	27

TEMPORADA 2022/2023

TERCERA FEDERACIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Atlético	30	47	24	60
2	Córdoba	30	44	19	58
3	CD Gerena	30	48	25	54
4	Sevilla C	30	35	26	49
5	Salerm	30	42	35	47
6	Ciudad	30	32	23	47
7	Xerez CD	30	36	29	41
8	Atlético	30	40	40	40
9	Conil	30	32	31	40
10	Pozoblanco	30	29	37	40
11	Ceuta	30	25	29	39
12	Bollullos	30	31	43	36
13	Ayamonte	30	31	43	33
14	AD Cartaya	30	30	46	29
15	Coria CF	30	26	40	24
16	CD Rota	30	15	53	19

TEMPORADA 2021/2022

TERCERA FEDERACIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Recreativo	32	57	20	77
2	Utrera	32	59	26	67
3	Xerez CD	32	50	24	62
4	Ciudad	32	45	25	60
5	CD Gerena	32	53	31	58
6	Córdoba	32	54	33	58
7	Salerm	32	36	41	45
8	Sevilla C	32	40	48	43
9	Ceuta	32	26	39	37
10	Conil	32	30	49	36
11	CD Rota	32	31	45	36
12	Pozoblanco	32	37	49	34
13	Atlético	32	29	35	34
14	AD Cartaya	32	26	30	33
15	UD Tomares	32	27	46	31
16	Cabecense	32	25	51	23
17	Los Barrios	32	26	59	23

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Xerez	18	26	11	37
2	Xerez CD	18	23	11	35
3	AD Ceuta FC	18	26	17	29
4	Los Barrios	18	18	17	24
5	CD Rota	18	15	21	22
6	Atlético	18	15	20	21
7	Conil	18	19	18	20
8	Cabecense	18	15	23	19
9	Arcos CF	18	10	19	17
10	Lebrijana	18	15	25	16
11	Roque Lepe	20	30	18	45
12	Ciudad	20	35	16	40
13	Salerm	20	28	24	33
14	Córdoba	20	31	25	30
15	Utrera	20	26	26	30
16	Pozoblanco	20	22	23	27
17	Sevilla C	20	17	20	26
18	CD Gerena	20	17	25	22
19	Castilleja	20	25	27	21
20	Coria CF	20	14	28	15
21	La Palma CF	20	14	27	13

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	29	68	28	59
2	Ciudad	29	46	24	55
3	Xerez	29	44	24	55
4	Utrera	29	41	22	52
5	AD Ceuta FC	29	50	22	51
6	Sevilla C	29	34	19	51
7	Atlético	29	42	28	51
8	Salerm	29	48	35	50
9	CD Rota	29	47	49	43
10	Coria CF	29	39	36	42
11	Roque Lepe	29	39	31	40
12	Conil	29	34	37	40
13	Lebrijana	29	33	42	34
14	CD Gerena	29	31	37	33
15	Arcos CF	29	30	40	31
16	Los Barrios	29	25	35	30
17	Xerez CD	29	31	43	29
18	Pozoblanco	29	32	51	26
19	Córdoba	29	30	54	23
20	Écija	29	0	87	0

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Cádiz	42	48	18	83
2	AD Ceuta FC	42	68	42	80
3	Utrera	42	59	29	79
4	Algeciras	42	64	35	77
5	Xerez	42	49	24	77
6	Betis	42	93	40	76
7	Los Barrios	42	64	43	76
8	Córdoba	42	67	39	71
9	Ciudad	42	56	53	58
10	Xerez CD	42	45	42	57
11	Salerm	42	52	49	55
12	Lebrijana	42	47	65	52
13	Coria CF	42	53	52	51
14	CD Gerena	42	43	68	50
15	Sevilla C	42	39	49	50
16	Roque Lepe	42	52	61	49
17	Conil	42	47	55	49
18	Arcos CF	42	45	53	49
19	Écija	42	37	48	48
20	Cabecense	42	39	80	30
21	Atlético	42	45	91	29
22	Guadalcacín	42	21	97	14

TEMPORADA 2017/2018

DIVISIÓN HONOR SENIOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Xerez	34	58	18	72
2	Coria CF	34	56	33	65
3	Conil	34	51	30	62
4	Viso UP	34	50	33	53
5	Atlético	34	37	42	50
6	Pozoblanco	34	41	44	49
7	Valverdeña	34	39	46	48
8	Roque	34	46	49	47
9	José	34	47	37	45
10	Isla	34	43	55	44
11	CD Rota	34	50	58	44
12	La Palma CF	34	53	58	44
13	Atlético	34	38	43	44
14	AD Cartaya	34	40	30	43
15	Montilla	34	42	53	34
16	Chiclana	34	35	45	33
17	Estrella	34	33	52	32
18	Ciudad	34	26	59	27

TEMPORADA 2016/2017

DIVISIÓN HONOR SENIOR GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Cádiz	38	83	28	82
2	Salerm	38	72	36	73
3	Xerez CD	38	74	37	72
4	Ciudad	38	60	39	71
5	Estrella	38	59	46	68
6	Xerez	38	65	43	63
7	Conil	38	65	47	60
8	Pozoblanco	38	39	36	58
9	La Palma CF	38	73	58	57
10	Viso UP	38	47	38	54
11	AD Cartaya	38	49	48	54
12	José	38	57	45	53
13	Valverdeña	38	55	74	45
14	CD Rota	38	58	85	44
15	Chiclana CF	38	46	62	42
16	Roteña	38	48	66	41
17	Lora CF	38	48	71	39
18	San Juan	38	58	78	38
19	Pinzón CD	38	45	71	28
20	Almodóvar	38	25	118	13

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Córdoba	40	90	42	85
2	Sanluqueño	40	71	34	79
3	Fernando	40	69	30	75
4	CD Alcalá	40	59	33	73
5	CD Gerena	40	65	46	61
6	AD Ceuta FC	40	47	43	58
7	Arcos CF	40	44	43	58
8	Sevilla C	40	43	44	55
9	Castilleja	40	49	54	55
10	Los Barrios	40	54	56	55
11	Guadalcacín	40	42	50	54
12	Écija	40	58	54	52
13	Utrera	40	70	76	52
14	Roque	40	46	52	50
15	Lebrijana	40	45	59	49
16	Cabecense	40	49	57	49
17	Coria CF	40	38	39	48
18	San Juan	40	42	53	48
19	Conil	40	41	65	39
20	Roteña	40	43	73	36
21	Lucena	40	19	81	13

TEMPORADA 2014/2015

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	42	77	28	100
2	Fernando	42	88	28	91
3	CD Gerena	42	89	38	87
4	Sanluqueño	42	74	40	83
5	AD Ceuta FC	42	50	32	72
6	Lebrijana	42	60	66	60
7	Conil	42	51	60	60
8	Écija	42	49	41	58
9	Sevilla C	42	42	45	58
10	Coria CF	42	48	42	57
11	CD Alcalá	42	40	52	57
12	Roque	42	47	49	56
13	San Juan	42	48	49	52
14	Los Barrios	42	45	50	52
15	Guadalcacín	42	39	48	52
16	Cabecense	42	36	54	49
17	Arcos CF	42	46	74	48
18	Mairena	42	42	55	44
19	PD Rociera	42	40	73	40
20	Cádiz	42	45	54	38
21	La Palma CF	42	35	69	36
22	Atlético	42	34	78	33

TEMPORADA 2013/2014

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Betis	38	70	37	76
2	Roque Lepe	38	60	29	75
3	CD Alcalá	38	78	43	72
4	AD Ceuta FC	38	54	33	69
5	Mairena	38	61	54	61
6	CD Gerena	38	64	40	60
7	Cabecense	38	60	45	58
8	San Juan	38	54	53	56
9	Lebrijana	38	51	49	55
10	Conil	38	41	43	55
11	Cádiz	38	49	46	52
12	Coria CF	38	48	53	51
13	Atlético	38	57	58	50
14	Roque	38	56	54	48
15	Sevilla C	38	43	58	45
16	La Palma CF	38	46	61	44
17	Arcos CF	38	36	53	42
18	Pozoblanco	38	37	68	42
19	Xerez CD	38	41	65	32
20	Ayamonte	38	16	80	0

TEMPORADA 2011/2012

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sanluqueño	38	81	32	89
2	Fernando	38	88	51	74
3	Mairena	38	64	32	71
4	Coria CF	38	72	46	68
5	Sevilla C	38	67	46	66
6	Algeciras	38	57	50	59
7	CD Alcalá	38	57	52	57
8	Atlético	38	59	55	54
9	Cádiz	38	53	53	50
10	Córdoba	38	35	37	45
11	Conil	38	47	68	45
12	Pozoblanco	38	47	49	45
13	Atlético	38	31	45	43
14	Roque	38	53	67	42
15	Puerto Real	38	45	63	40
16	Portuense	38	41	53	39
17	Ayamonte	38	46	72	38
18	Jerez	38	34	51	38
19	Marinaleda	38	39	59	38
20	PD Rociera	38	40	75	35

TEMPORADA 2010/2011

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	RB Linense	38	65	32	76
2	Fernando	38	61	33	72
3	Pozoblanco	38	56	33	71
4	Mairena	38	41	29	63
5	Algeciras	38	44	33	62
6	Portuense	38	44	38	61
7	Puerto Real	38	42	32	59
8	Sanluqueño	38	47	42	56
9	Sevilla C	38	42	40	51
10	Córdoba	38	41	38	49
11	Palacios	38	40	44	49
12	Coria CF	38	57	60	46
13	Jerez	38	36	58	45
14	Atlético	38	40	47	44
15	Conil	38	44	47	43
16	Cádiz	38	52	50	43
17	Marinaleda	38	36	53	42
18	Ayamonte	38	53	62	42
19	Peñarroya	38	35	60	34
20	Los Barrios	38	23	68	20

TEMPORADA 2009/2010

PRIMERA ANDALUZA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Conil	34	55	38	70
2	Fernando	34	74	33	66
3	Arcos CF	34	57	20	65
4	Xerez B	34	68	34	63
5	Valverdeña	34	61	39	56
6	Pastores	34	51	37	55
7	Chiclana CF	34	63	46	53
8	Balón	34	55	47	52
9	La Palma	34	55	45	47
10	Isla	34	52	51	47
11	CD Rota	34	42	47	44
12	Roteña	34	50	57	42
13	Roque	34	40	78	38
14	Atlético	34	44	67	36
15	Gibraleón	34	31	58	36
16	Atl.	34	47	57	35
17	Punta Umbria	34	29	60	25
18	Almonte	34	33	93	17

TEMPORADA 2008/2009

PRIMERA ANDALUZA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Algeciras	34	64	30	69
2	Conil	34	64	39	69
3	Arcos CF	34	70	32	67
4	CD Rota	34	55	48	54
5	Punta Umbria	34	40	42	53
6	Roteña	34	59	48	50
7	La Palma	34	49	44	49
8	Xerez B	34	47	45	47
9	Atl.	34	46	48	42
10	Roque Lepe	34	31	42	41
11	Balón	34	36	41	40
12	Isla	34	34	41	39
13	Valverdeña	34	37	55	39
14	Fernando	34	41	49	38
15	Atlético	34	36	50	38
16	Ud Bornense	34	45	60	32
17	Tesorillo	34	39	56	31
18	Chiclana	34	24	47	31

TEMPORADA 2007/2008

PRIMERA ANDALUZA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Atlético	34	75	19	75
2	Chiclana CF	34	57	28	68
3	Tesorillo	34	67	38	66
4	Conil	34	65	43	66
5	Punta Umbria	34	52	32	64
6	La Palma	34	45	38	56
7	Valverdeña	34	37	31	53
8	CD Rota	34	39	44	43
9	Cortegana	34	40	48	43
10	Atlético	34	40	48	42
11	Fernando	34	63	54	40
12	Cortijillos	34	37	55	38
13	Roteña	34	43	61	37
14	Chiclana	34	45	66	37
15	Atlético	34	36	51	36
16	Barbate	34	36	65	31
17	Pastores	34	40	73	28
18	Chipiona CF	34	31	54	26

TEMPORADA 2006/2007

PRIMERA ANDALUZA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	AD Cartaya	30	64	21	69
2	Roque Lepe	30	60	17	64
3	Punta Umbria	30	57	33	63
4	Tesorillo	30	64	38	52
5	Atlético	30	63	41	52
6	La Palma	30	43	37	46
7	Roteña	30	36	28	36
8	Barbate	30	45	41	36
9	Cortijillos	30	39	42	36
10	Conil	30	33	38	36
11	Chiclana	30	24	45	35
12	Algeciras	30	37	55	34
13	Cortegana	30	39	59	33
14	Bollullos	30	29	46	29
15	Ubrique Ind.	30	25	51	26
16	Hinojos	30	25	91	9

TEMPORADA 2005/2006

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Chiclana	30	52	25	58
2	Conil	30	56	30	55
3	Balón	30	47	38	54
4	CD Rota	30	54	30	52
5	Chipiona CF	30	34	21	51
6	Rayo	30	50	40	44
7	Florida Dst.	30	49	44	44
8	Guadalcacín	30	39	33	43
9	Chiclana B	30	40	43	37
10	Grupo	30	35	44	37
11	Vejer Bpie	30	36	49	37
12	Tarifa UD	30	29	43	36
13	Ud Bornense	30	35	59	34
14	S.Isidro	30	35	53	30
15	Palmones	30	33	57	27
16	Villamartín	30	36	51	23

TEMPORADA 2004/2005

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Tesorillo	30	60	24	68
2	Algeciras	30	66	23	65
3	Ubrique Ind.	30	47	29	51
4	Conil	30	49	31	49
5	Rayo	30	56	41	49
6	Chipiona CF	30	38	26	47
7	Chiclana	30	49	43	44
8	Palmones	30	37	38	39
9	Grupo	30	30	33	35
10	Ud Bornense	30	35	48	35
11	Villamartín	30	34	52	34
12	Guadalcacín	30	37	51	32
13	Atletico	30	32	54	32
14	UD Algaida	30	33	44	31
15	Guadiaro	30	30	68	27
16	Fernando	30	30	58	18

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	UA. Ceutí	42	69	41	79
2	Isla	42	76	40	76
3	Algeciras	42	61	39	72
4	Ayamonte	42	64	38	71
5	Montilla	42	62	51	70
6	Palacios	42	60	44	66
7	Fernando	42	67	57	66
8	Sanluqueño	42	59	53	64
9	Pozoblanco	42	55	49	61
10	CD Rota	42	57	58	59
11	Roque Lepe	42	57	56	57
12	RB Linense	42	57	52	55
13	Cádiz	42	51	55	54
14	La Palma	42	51	54	54
15	Utrera	42	71	49	54
16	Lucena	42	53	69	50
17	Chiclana CF	42	45	59	50
18	Hermanas	42	53	60	50
19	Mairena	42	36	62	37
20	Conil	42	30	77	33
21	Roteña	42	23	90	23

Competiciones que juega

Tercera Federación Grupo 10

Pos	Equipos		Pts
1		Xerez CD	63
2		Ciudad de Lucena	62
3		CD Pozoblanco	59
4		Xerez Deportivo	58
5		AD Ceuta FC B	55
6		Salerm Puente Genil	50
7		Utrera	46
8		CD Gerena	46
9		AD Cartaya	42
10		Bollullos CF	37
11		Coria CF	36
12		Córdoba CF B	36
13		Atlético Espeleño	35
14		La Palma CF	35
15		Conil	34
16		Sevilla C	32
17		Ayamonte	28
18		Cabecense	27

	Ascenso : Xerez CD
	Playoff Ascenso : Ciudad de Lucena, CD Pozoblanco, Xerez Deportivo, AD Ceuta FC B
	Descenso : Sevilla C, Ayamonte, Cabecense

RIVALES EN Tercera Federaci.

USO DE MEMORIA

8,019,624 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6118
Total Execution Time	0.6130

CADENA URL

/historico/Conil

GET DATOS

$_GET['/historico/Conil']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0123	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 = 'Conil' 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.0110	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=825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112	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=825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0110	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=825 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0226	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 = 72269
0.0108	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=825 AND type_rel = 2
0.0111	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 825 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0110	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 (468329,822157,886617,1173626,1252490) ORDER BY n.cover_points DESC, update_date DESC
0.0111	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 = '825' ORDER BY l.year DESC,cat.coefficient DESC
0.0121	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 = '825' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0120	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 = '825' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0125	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=825 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0114	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 (72269,71432,68673) 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.0123	SELECT count(id) as num_players from rel_players WHERE league_id = 72269 AND teamId = 825
0.0118	SELECT count(id) as num_players from rel_players WHERE league_id = 68673 AND teamId = 825
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 825
0.0109	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 = '825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '825' and rp.type = 4
0.0108	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 = '825' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0121	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 = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 825 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.0119	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 = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 825 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0120	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 = 72269 WHERE rp.league_id = 72269 AND rp.teamId = 825 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131	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 = 825 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138	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 = 72269 AND t.round = 33 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 67984 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.0124	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 = 62394 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.0116	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 = 58589 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.0117	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 = 50278 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 44398 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 39236 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0116	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 = 34070 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0118	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 = 15451 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 3919 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 2559 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 1406 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 1136 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 856 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 323 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108	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 = 114 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108	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* `tables2007` 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 = 115 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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* `tables2006` 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 = 2918 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109	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 = 2917 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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* `tables1997` 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 = 21973 AND t.round = 42 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

Conil

Conil

Selecciona un equipo

Competiciones que juega

Tercera Federación Grupo 10

RIVALES EN Tercera Federaci.