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

RC Portuense

Temporada 2021/2022

TEMPORADA 2021/2022

PRIMERA ANDALUZA GRUPO 15
Equipo		PJ	GF	GC	Puntos
1	Balón	28	70	27	67
2	UD Algaida	28	54	26	61
3	Xerez	28	59	33	57
4	Portuense	28	52	25	53
5	Roteña	28	40	34	43
6	Fernando	28	48	47	40
7	Trebujena	28	37	37	40
8	CD Jédula	28	37	49	38
9	Villamartín	28	35	41	35
10	Recreativo	28	32	47	28

TEMPORADA 2020/2021

2ª ANDALUZA CÁDIZ GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Fernando	14	32	16	29
2	Portuense	14	26	11	27
3	Sherry	13	24	15	25
4	Linense	13	42	15	24
5	Federico	13	28	17	21
6	Novo	14	12	28	9
7	Alcalá	14	12	39	8
8	Alcalat	13	13	48	6
9	CD Benalup	0	0	0	0

TEMPORADA 2019/2020

2ª ANDALUZA CÁDIZ
Equipo		PJ	GF	GC	Puntos
1	Guadiaro	25	79	17	69
2	Cortijillos	25	53	20	55
3	UD Algaida	25	56	24	48
4	Xerez	25	65	34	47
5	CD Jédula	25	45	33	41
6	Fernando	25	42	34	41
7	CD Rivera	25	36	30	40
8	Portuense	25	42	32	39
9	Divina	25	28	41	31
10	Amigos Cruz	25	39	45	28
11	Sanluqueña	25	39	46	28
12	Medina	25	36	41	27
13	Estrella	25	23	39	25
14	Rayo	25	21	40	25
15	Alcalá	25	27	53	24
16	Espera C.F.	25	22	54	23
17	Cañorrera	25	18	65	21
18	Jose Obrero	25	30	53	20

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	38	65	27	76
2	Córdoba	38	59	22	75
3	Coria CF	38	64	37	68
4	Mairena	38	47	28	65
5	AD Ceuta FC	38	63	38	63
6	Cabecense	38	52	35	59
7	CD Alcalá	38	49	39	58
8	Roque	38	47	56	53
9	Atlético	38	57	57	50
10	Portuense	38	36	35	49
11	Cádiz	38	36	47	47
12	Conil	38	46	56	45
13	Sevilla C	38	40	46	44
14	San Juan	38	35	44	43
15	Pozoblanco	38	30	50	41
16	Arcos CF	38	37	59	41
17	Ayamonte	38	35	61	40
18	Atlético	38	34	51	40
19	Los Barrios	38	30	55	38
20	Montilla	38	37	56	33

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

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	CD Alcalá	38	68	21	80
2	Mairena	38	54	30	70
3	Ayamonte	38	63	33	69
4	Marinaleda	38	52	34	66
5	RB Linense	38	50	32	63
6	Pozoblanco	38	44	33	62
7	Los Barrios	38	42	41	57
8	Atlético	38	61	47	56
9	Córdoba	38	38	37	55
10	Cádiz	38	42	41	54
11	Palacios	38	40	45	53
12	Coria CF	38	56	47	50
13	Puerto Real	38	33	39	49
14	Sevilla C	38	42	39	49
15	Algeciras	38	48	53	46
16	Sanluqueño	38	36	41	44
17	Portuense	38	39	56	43
18	Murallas	38	28	42	39
19	Hermanas	38	24	92	19
20	AD Cartaya	38	25	82	18

TEMPORADA 2008/2009

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Cádiz	38	71	42	79
2	Real Jaén	38	44	21	71
3	Poli Ejido	38	60	39	66
4	Marbella FC	38	48	33	64
5	Puertollano	38	56	36	63
6	UD Melilla	38	49	38	62
7	AgD Ceuta	38	59	40	58
8	Conquense	38	55	57	57
9	Guadalajara	38	39	29	56
10	Granada	38	53	52	51
11	Betis	38	52	52	48
12	CD Roquetas	38	44	40	47
13	CD Linares	38	41	54	43
14	Écija	38	37	50	43
15	Antequera	38	43	56	40
16	Lucena	38	47	62	40
17	Fernando	38	46	66	38
18	Granada 74	38	34	61	36
19	RB Linense	38	35	54	34
20	Portuense	38	26	57	30

TEMPORADA 2007/2008

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Écija	38	54	29	72
2	CD Linares	38	61	43	67
3	AgD Ceuta	38	48	30	66
4	Mérida UD	38	59	47	64
5	Granada	38	52	36	63
6	Águilas CF	38	50	38	58
7	UD Melilla	38	47	36	58
8	Cartagena	38	42	33	57
9	Real Jaén	38	30	28	56
10	Lucena	38	40	34	52
11	Lorca	38	38	40	49
12	Betis	38	39	42	49
13	Puertollano	38	36	42	47
14	Portuense	38	34	46	46
15	Marbella FC	38	29	42	46
16	Baza	38	36	44	43
17	Mazarrón	38	37	55	42
18	CD Alcalá	38	32	43	41
19	Talavera CF	38	37	62	35
20	Algeciras	38	31	62	22

TEMPORADA 2006/2007

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	54	22	76
2	CD Linares	38	64	38	73
3	Portuense	38	60	36	71
4	Córdoba CF	38	73	46	69
5	Cartagena	38	63	41	67
6	Real Jaén	38	49	40	62
7	Marbella FC	38	40	34	56
8	Águilas CF	38	48	42	54
9	UD Melilla	38	47	47	52
10	Écija	38	52	47	52
11	AgD Ceuta	38	38	33	52
12	Baza	38	51	46	52
13	Granada	38	39	36	51
14	CD Alcalá	38	45	47	49
15	Mérida UD	38	34	44	48
16	Extremadura	38	39	59	45
17	Cerro Reyes	38	31	59	41
18	Villanueva	38	41	55	35
19	Villanovense	38	39	76	22
20	Malagueño	38	21	80	14

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Portuense	38	55	26	76
2	Fernando	38	59	27	75
3	Arcos CF	38	56	49	63
4	RB Linense	38	55	42	63
5	Sanluqueño	38	53	34	62
6	Betis	38	67	47	61
7	Xerez B	38	62	43	56
8	Cádiz	38	52	44	55
9	Lucena	38	42	43	54
10	Los Barrios	38	57	55	54
11	Chiclana CF	38	49	62	49
12	Palacios	38	33	38	48
13	Puerto Real	38	43	54	48
14	Jerez	38	33	48	44
15	Hermanas	38	42	62	42
16	Mairena	38	38	53	42
17	Córdoba	38	37	42	41
18	Pozoblanco	38	41	50	40
19	Coria CF	38	32	63	34
20	Bollullos	38	29	53	30

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Villanueva	40	72	36	82
2	Los Barrios	40	54	41	76
3	Portuense	40	47	37	67
4	RB Linense	40	68	38	67
5	Palacios	40	63	44	65
6	Pozoblanco	40	54	31	64
7	Fernando	40	54	46	61
8	Betis	40	58	50	59
9	Lucena	40	46	43	52
10	Puerto Real	40	48	55	52
11	Chiclana CF	40	56	63	51
12	Jerez	40	50	52	50
13	Hermanas	40	43	55	48
14	Bollullos	40	49	51	48
15	Coria CF	40	48	57	48
16	Sanluqueño	40	45	54	48
17	Cádiz	40	47	60	46
18	Cerro	40	35	51	46
19	Atlético	40	45	56	44
20	Nueva	40	38	65	36
21	AD Cartaya	40	37	72	29

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Alcalá	38	51	24	70
2	Fernando	38	73	43	68
3	Bollullos	38	61	38	67
4	Villanueva	38	72	41	64
5	RB Linense	38	45	34	63
6	Jerez	38	47	34	62
7	Coria CF	38	49	34	59
8	Los Barrios	38	45	44	57
9	Sanluqueño	38	52	56	53
10	Hermanas	38	47	46	52
11	Chiclana CF	38	35	44	51
12	Atlético	38	50	52	48
13	Portuense	38	45	50	48
14	Lucena	38	37	55	47
15	Nueva	38	37	54	42
16	Cerro	38	38	60	41
17	Córdoba	38	43	51	39
18	Serrallo CF	38	45	67	38
19	AD Cartaya	38	37	64	36
20	Montilla	38	39	57	30

TEMPORADA 2001/2002

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Villanueva	38	68	33	74
2	Jerez	38	67	26	73
3	Atlético	38	80	51	71
4	Atlético	38	53	32	68
5	Lucena	38	55	37	64
6	Ayamonte	38	39	32	63
7	Córdoba	38	62	48	62
8	Montilla	38	46	37	57
9	Los Barrios	38	60	44	56
10	José	38	53	44	55
11	Puerto Real	38	55	54	52
12	Alcalá	38	48	46	51
13	Palacios	38	45	40	50
14	AD Cartaya	38	46	48	48
15	Sanluqueño	38	39	61	47
16	Portuense	38	41	49	46
17	Pozoblanco	38	44	65	39
18	UD Tomares	38	34	69	32
19	Roque Lepe	38	36	74	24
20	Recreativo	38	27	108	12

TEMPORADA 2000/2001

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Sevilla At.	38	84	25	86
2	Betis	38	55	34	67
3	Lucena	38	66	51	63
4	Sanluqueño	38	67	51	61
5	Jerez	38	55	43	60
6	Atlético	38	37	34	57
7	Córdoba	38	46	37	55
8	José	38	54	46	55
9	Palacios	38	46	43	51
10	Pozoblanco	38	44	50	50
11	Ayamonte	38	46	44	49
12	Portuense	38	37	45	47
13	Villanueva	38	30	43	44
14	Puerto Real	38	40	54	42
15	Chiclana CF	38	35	52	42
16	AD Cartaya	38	40	59	41
17	Los Barrios	38	41	61	40
18	UD Tomares	38	33	50	39
19	La Palma	38	44	55	37
20	Serrallo CF	38	36	59	35

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	Algeciras	38	64	32	73
2	Fernando	38	58	31	68
3	Puerto Real	38	62	40	66
4	Portuense	38	44	41	65
5	Palacios	38	54	43	64
6	Sanluqueño	38	61	47	63
7	Pozoblanco	38	62	43	61
8	Lucena	38	45	37	55
9	Atlético	38	45	38	55
10	UD Tomares	38	55	52	55
11	Villanueva	38	43	49	51
12	Córdoba	38	53	54	48
13	AD Cartaya	38	49	54	47
14	La Palma	37	37	45	43
15	Ayamonte	38	35	53	41
16	Los Barrios	38	36	49	40
17	Chiclana CF	38	42	58	39
18	Montilla	38	38	59	38
19	Ceuta	38	43	67	28
20	CD Rota	37	32	66	26

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 10
Equipo		PJ	GF	GC	Puntos
1	RB Linense	38	56	19	81
2	Hermanas	38	67	28	80
3	Coria CF	38	61	18	73
4	Fernando	38	64	35	71
5	Lucena	38	52	21	64
6	Portuense	38	41	34	57
7	Chiclana CF	38	44	36	56
8	Sanluqueño	38	45	42	54
9	Montilla	38	35	35	53
10	UD Tomares	38	43	44	50
11	Palacios	38	52	46	47
12	Pozoblanco	38	37	44	46
13	CD Rota	38	42	55	46
14	Puerto Real	38	40	45	46
15	Ayamonte	38	36	51	43
16	Los Barrios	38	38	55	42
17	La Palma	38	40	50	38
18	Utrera	38	36	62	37
19	Roque Lepe	38	34	68	29
20	Serrallo CF	38	18	93	16

TEMPORADA 1992/1993

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Las Palmas	35	65	20	55
2	Xerez CD	36	45	23	49
3	Granada	36	49	33	48
4	Real Jaén	36	53	30	43
5	Cacereño	36	44	30	40
6	Extremadura	36	53	42	38
7	Sevilla At.	36	38	38	36
8	Recreativo	36	47	44	35
9	Córdoba CF	36	36	35	35
10	Écija	35	33	34	34
11	Mensajero	36	48	52	34
12	Maspalomas	36	32	38	34
13	Estepona	36	25	35	33
14	Poli Ejido	36	31	45	33
15	Roque Lepe	36	31	42	31
16	Betis	36	31	40	30
17	UD Melilla	35	25	31	30
18	RB Linense	36	25	54	27
19	Marino	35	25	70	15
20	Portuense	0	0	0	0

TEMPORADA 1991/1992

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Atlético	38	63	25	56
2	CD Badajoz	38	71	30	53
3	Extremadura	38	65	31	48
4	RB Linense	38	45	29	47
5	Poli Ejido	38	46	36	45
6	Recreativo	38	49	35	44
7	Betis	38	54	34	42
8	Xerez CD	38	49	31	41
9	Granada	38	47	43	40
10	Real Jaén	38	43	36	39
11	Córdoba CF	38	45	34	38
12	Marino	38	38	55	37
13	Estepona	38	33	44	34
14	UD Melilla	38	21	33	34
15	Portuense	38	34	49	33
16	Maspalomas	38	48	46	33
17	Sanluqueño	38	33	51	31
18	Fuengirola	38	26	65	25
19	Boliches	38	32	84	21
20	Villanovense	38	20	71	19

Competiciones que juega

Grupo 1

Primera Andaluza Grupo 2

Pos	Equipos		Pts
1		RC Portuense	37
2		UD Algaida	36
3		Xerez Deportivo B	36
4		San Fernando CD B	27
5		Roteña	26
6		Algeciras CF B	22
7		CD San Roque	19
8		Los Cortijillos	19
9		Chiclana Industrial	12
10		Tesorillo	12

	Playoff Ascenso : RC Portuense, UD Algaida, Xerez Deportivo B, San Fernando CD B, Roteña
	Playoff Descenso : Algeciras CF B, CD San Roque, Los Cortijillos, Chiclana Industrial, Tesorillo

RIVALES EN Primera Andaluza

USO DE MEMORIA

7,777,520 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.7604
Total Execution Time	0.7617

CADENA URL

/historico/Racing-Club-Portuense/2022

GET DATOS

$_GET['/historico/Racing-Club-Portuense/2022']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0137	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 = 'Racing-Club-Portuense' AND l.year = 2022 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=9335 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=9335 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=9335 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=9335 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0259	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 = 64022
0.0154	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 = 67383
0.0129	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=9335 AND type_rel = 2
0.0126	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 9335 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126	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 (687224) ORDER BY n.cover_points DESC, update_date DESC
0.0134	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 = '9335' AND l.year = 2022 ORDER BY l.year DESC,cat.coefficient DESC
0.0133	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 = '9335' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 64022 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0134	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=9335 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (68699,67320,59426) 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.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 68699 AND teamId = 9335
0.0126	SELECT count(id) as num_players from rel_players WHERE league_id = 59426 AND teamId = 9335
0.0128	SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 9335
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 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 = 64022 AND t.round = 18 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 = '9335' 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 = '9335' 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 = '9335' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0128	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 = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 9335 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.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 = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 9335 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126	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 = 64022 WHERE rp.league_id = 64022 AND rp.teamId = 9335 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133	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 = 9335 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 64022 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 67383 AND t.round = 10 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* `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 = 59426 AND t.round = 18 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* `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 = 51363 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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 = 1949 AND t.round = 38 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* `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.0133	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.0139	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 = 844 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 130 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150	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 = 7 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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 = 85 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151	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 = 22122 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	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 = 22103 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0142	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 = 22087 AND t.round = 38 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* `tables2002` 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 = 22055 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143	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* `tables2001` 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 = 22039 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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* `tables2000` 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 = 22023 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139	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* `tables1999` 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 = 22007 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135	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* `tables1993` 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 = 22255 AND t.round = 38 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* `tables1992` 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 = 22252 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	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 = 64022 ORDER BY nameShow LIMIT 100

RC Portuense

RC Portuense

Selecciona un equipo

Competiciones que juega

Primera Andaluza Grupo 2

RIVALES EN Primera Andaluza