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

« Temporada Anterior

Temporada 1990

Temporada Siguiente »

1989/1990

Segunda División B 1990

Segunda División B:

Segunda División B 1990

La temporada finalizó el Domingo, 27 Mayo 1990.

04 Mar 90 Finalizado	Real Avilés Industrial	Real Avilés Industrial - Arosa 1990-03-04T00:00:00 Román Suárez Puerta 2-0	Arosa	más información Jugadas destacadas ...
	28' Joaquín	1-0
	44' Calvo	2-0
04 Mar 90 Finalizado	CD Colonia Moscardó	CD Colonia Moscardó - Pontevedra 1990-03-04T00:00:00 Román Valero 1-2	Pontevedra	más información Jugadas destacadas ...
		0-1	34' Rafa Sáez
		0-2	64' Carlos Santiago
	83' Jesús	1-2
04 Mar 90 Finalizado	Lalín	Lalín - As Pontes 1990-03-04T00:00:00 Manuel Anxo Cortizo 1-1	As Pontes	más información Jugadas destacadas ...
		0-1	13' Fernández
	51' Acevedo	1-1
04 Mar 90 Finalizado	Racing Ferrol	Racing Ferrol - Sporting Atlético 1990-03-04T00:00:00 A Malata 0-0	Sporting Atlético	más información ...
04 Mar 90 Finalizado	Cambados	Cambados - CD Lugo 1990-03-04T00:00:00 CAMPO MUNICIPAL DE BURGANS - VILARIÑO -CAMBADOS 1-0	CD Lugo	más información Jugadas destacadas ...
	14' Miguel Soro	1-0
04 Mar 90 Finalizado	Galáctico Pegaso	Galáctico Pegaso - Getafe 1990-03-04T00:00:00 Foresta 0-1	Getafe	más información Jugadas destacadas ...
		0-1	84' Sebas I
04 Mar 90 Finalizado	RSD Alcalá	RSD Alcalá - Ponferradina 1990-03-04T00:00:00 Municipal Virgen del Val 0-0	Ponferradina	más información ...
04 Mar 90 Finalizado	Langreo	Langreo - CD Ourense 1990-03-04T00:00:00 Nuevo Ganzábal 0-0	CD Ourense	más información ...
04 Mar 90 Finalizado	Leganés	Leganés - Real Ávila 1990-03-04T00:00:00 Municipal de Butarque 1-1	Real Ávila	más información Jugadas destacadas ...
		0-1	39' Frías
	85' Mariano	1-1
04 Mar 90 Finalizado	Cultural Leonesa	Cultural Leonesa - CD Toledo 1990-03-04T00:00:00 Municipal Reino de León 0-0	CD Toledo	más información ...

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	Real Avilés Ind.	41	26	17	7	2	37	17	VICTORIA Real Avilés Indust. 1 Leganés 0 DERROTA Cultural Leonesa 2 Real Avilés Indust. 0 VICTORIA Real Avilés Indust. 1 Real Ávila 0 VICTORIA CD Ourense 0 Real Avilés Indust. 1 VICTORIA Real Avilés Indust. 2 Arosa 0
2	Getafe	36	26	13	10	3	36	17	VICTORIA Getafe 2 CD Lugo 0 EMPATE CD Toledo 1 Getafe 1 DERROTA Ponferradina 3 Getafe 0 VICTORIA Getafe 1 RSD Alcalá 0 VICTORIA Galáctico Pegaso 0 Getafe 1
3	Cambados	34	26	14	6	6	32	17	VICTORIA Cambados 2 Arosa 0 EMPATE Pontevedra 1 Cambados 1 EMPATE Cambados 1 As Pontes 1 VICTORIA Sporting Atlético 0 Cambados 1 VICTORIA Cambados 1 CD Lugo 0
4	Leganés	33	26	12	9	5	32	19	DERROTA Real Avilés Indust. 1 Leganés 0 VICTORIA Leganés 3 Langreo 2 VICTORIA Leganés 3 CD Toledo 2 EMPATE Cultural Leonesa 0 Leganés 0 EMPATE Leganés 1 Real Ávila 1
5	CD Lugo	31	26	12	7	7	32	24	DERROTA Getafe 2 CD Lugo 0 VICTORIA CD Lugo 1 Ponferradina 0 DERROTA RSD Alcalá 2 CD Lugo 0 VICTORIA CD Lugo 1 Galáctico Pegaso 0 DERROTA Cambados 1 CD Lugo 0
6	Cultural Leonesa	31	26	9	13	4	26	19	VICTORIA CD Colonia Moscard. 1 Cultural Leonesa 2 VICTORIA Cultural Leonesa 2 Real Avilés Indust. 0 DERROTA Langreo 1 Cultural Leonesa 0 EMPATE Cultural Leonesa 0 Leganés 0 EMPATE Cultural Leonesa 0 CD Toledo 0
7	Ponferradina	29	26	12	5	9	42	25	VICTORIA Ponferradina 2 Sporting Atlético 1 DERROTA CD Lugo 1 Ponferradina 0 VICTORIA Ponferradina 3 Getafe 0 DERROTA CD Toledo 3 Ponferradina 1 EMPATE RSD Alcalá 0 Ponferradina 0
8	Real Ávila	27	26	8	11	7	31	31	DERROTA Lalín 2 Real Ávila 1 EMPATE Real Ávila 1 CD Colonia Moscard. 1 DERROTA Real Avilés Indust. 1 Real Ávila 0 VICTORIA Real Ávila 2 Langreo 1 EMPATE Leganés 1 Real Ávila 1
9	Pontevedra	26	26	8	10	8	27	29	DERROTA Galáctico Pegaso 2 Pontevedra 1 EMPATE Pontevedra 1 Cambados 1 EMPATE Racing Ferrol 1 Pontevedra 1 VICTORIA Pontevedra 2 Lalín 1 VICTORIA CD Colonia Moscard. 1 Pontevedra 2
10	Langreo	24	26	9	6	11	28	35	DERROTA Langreo 2 CD Toledo 3 DERROTA Leganés 3 Langreo 2 VICTORIA Langreo 1 Cultural Leonesa 0 DERROTA Real Ávila 2 Langreo 1 EMPATE Langreo 0 CD Ourense 0
11	Galáctico	24	26	6	12	8	23	28	VICTORIA Galáctico Pegaso 2 Pontevedra 1 EMPATE As Pontes 1 Galáctico Pegaso 1 EMPATE Galáctico Pegaso 0 Sporting Atlético 0 DERROTA CD Lugo 1 Galáctico Pegaso 0 DERROTA Galáctico Pegaso 0 Getafe 1
12	CD Ourense	23	26	8	7	11	16	22	VICTORIA Racing Ferrol 0 CD Ourense 2 VICTORIA CD Ourense 2 Lalín 0 DERROTA CD Colonia Moscard. 1 CD Ourense 0 DERROTA CD Ourense 0 Real Avilés Indust. 1 EMPATE Langreo 0 CD Ourense 0
13	Colonia	23	26	6	11	9	23	31	DERROTA CD Colonia Moscard. 1 Cultural Leonesa 2 EMPATE Real Ávila 1 CD Colonia Moscard. 1 VICTORIA CD Colonia Moscard. 1 CD Ourense 0 DERROTA Arosa 3 CD Colonia Moscard. 1 DERROTA CD Colonia Moscard. 1 Pontevedra 2
14	Racing Ferrol	23	26	5	13	8	29	31	DERROTA Racing Ferrol 0 CD Ourense 2 EMPATE Arosa 2 Racing Ferrol 2 EMPATE Racing Ferrol 1 Pontevedra 1 DERROTA As Pontes 1 Racing Ferrol 0 EMPATE Racing Ferrol 0 Sporting Atlético 0
15	RSD Alcalá	23	26	7	9	10	26	26	VICTORIA RSD Alcalá 6 As Pontes 0 VICTORIA Sporting Atlético 0 RSD Alcalá 1 VICTORIA RSD Alcalá 2 CD Lugo 0 DERROTA Getafe 1 RSD Alcalá 0 EMPATE RSD Alcalá 0 Ponferradina 0
16	CD Toledo	20	26	8	4	14	33	41	VICTORIA Langreo 2 CD Toledo 3 EMPATE CD Toledo 1 Getafe 1 DERROTA Leganés 3 CD Toledo 2 VICTORIA CD Toledo 3 Ponferradina 1 EMPATE Cultural Leonesa 0 CD Toledo 0
17	As Pontes	20	26	4	12	10	26	45	DERROTA RSD Alcalá 6 As Pontes 0 EMPATE As Pontes 1 Galáctico Pegaso 1 EMPATE Cambados 1 As Pontes 1 VICTORIA As Pontes 1 Racing Ferrol 0 EMPATE Lalín 1 As Pontes 1
18	Lalín	20	26	7	6	13	24	33	VICTORIA Lalín 2 Real Ávila 1 DERROTA CD Ourense 2 Lalín 0 VICTORIA Lalín 2 Arosa 0 DERROTA Pontevedra 2 Lalín 1 EMPATE Lalín 1 As Pontes 1
19	Sporting	19	26	5	9	12	22	33	DERROTA Ponferradina 2 Sporting Atlético 1 DERROTA Sporting Atlético 0 RSD Alcalá 1 EMPATE Galáctico Pegaso 0 Sporting Atlético 0 DERROTA Sporting Atlético 0 Cambados 1 EMPATE Racing Ferrol 0 Sporting Atlético 0
20	Arosa	13	26	2	9	15	19	41	DERROTA Cambados 2 Arosa 0 EMPATE Arosa 2 Racing Ferrol 2 DERROTA Lalín 2 Arosa 0 VICTORIA Arosa 3 CD Colonia Moscard. 1 DERROTA Real Avilés Indust. 2 Arosa 0

JUGADORES DESTACADOS

RK	Nombre	Goles	Posición	Equipo
1	Rivera	20	DEL	Getafe
2	Soler	19	DEL	Leganés
3	Diego	17	DEL	Real Ávila
4	Luisito	17	DEL	Arosa
5	Velázquez	16	DEL	Real Avilés Industri.
6	Paquito	16	MED	Ponferradina
7	Miguel Soro	15	DEL	Cambados
8	Arturo	15	DEL	RSD Alcalá
9	Miguel Ángel	12	DEL	Racing Ferrol
10	Sebas I	12	DEL	Getafe
11	Tapia	11	MED	CD Lugo
12	Yeli	11	DEL	Real Ávila
13	Nando	11	MED	As Pontes
14	Álvarez	10	MED	Real Ávila
15	Joaquín	10	DEL	Real Avilés Industri.
16	Paco	10	DEL	CD Toledo
17	Santos	10	DEL	CD Colonia Moscardó
18	Juan Luis	9	DEL	Langreo
19	Jorge	9	DEL	Lalín
20	Chus Abad	9	DEL	Ponferradina

Busca la liga de tu equipo

Introduce el nombre de tu equipo y busca rápidamente su competición

NOTICIAS RELACIONADAS

Ver más noticias de la competicion»

Equipos de esta competición

INFORMACIÓN

La Segunda División B de España es también conocida como "Segunda B" o como "El Pozo" popularmente, se trata de la tercera división en importancia del fútbol español y es inmediatamente inferior a la Segunda División A.

Se celebra de forma anual desde 1977, e históricamente la temporada se desarrolla entre los meses de septiembre y junio.

Reglas de la competición

Si al terminar la jornada existe un empate entre dos equipos, se resolverá por la mayor diferencia de goles a favor, sumandos los pro y en contra según el resultados de los dos equipos jugados entre ellos; si así no se dilucidase, se decidirá también por el gol average en la competición, y de ser idéntico, resultará mejor clasificado el que hubiese marcado más tantos. 3)º Si la Igualdad no se resolviese a través de las disposiciones anteriores, se jugará un partido de desempate en la fecha, hora y campo neutral organizado por el órgano competente.
Si el empate se da entre más de dos equipos: a) Por la mejor puntuación de la que a cada uno corresponda a tenor de los resultados entre ellos, sin contar al resto de equipos de la liga. b)Por la mayor diferencia de goles a favor y en contra, considerando unicamente los equipos en situación de empate. c)Por el Gol avereage teniendo en cuenta todos los equipos del campeonato, y si sigue siendo identica el club con mayor número de goles marcados. d)En última instancia, En la divisiones Primera, Segunda, Segunda "B" y cualesquiera otras que se determine, si el eventual empate no se resolviese por las reglas anteriores, se decidirá en favor del club mejor clasificado con arreglo de los baremos del "juego limpio".
Si la Igualdad no se resolviese a través de las disposiciones anteriores, se jugará un partido de desempate en la fecha, hora y campo neutral organizado por el órgano competente.

USO DE MEMORIA

6,016,584 bytes

BENCHMARKS

Loading Time Base Classes	0.0021
Controller Execution Time ( Home / Category )	0.7116
Total Execution Time	0.7137

CADENA URL

/segundab1990/grupo1/jornada26

GET DATOS

$_GET['/segundab1990/grupo1/jornada26']

POST DATOS

No hay datos POST existentes

CONSULTAS (34)

0.0147	SELECT type FROM routes WHERE alias = 'segundab1990'
0.0300	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 21058 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=3 ORDER BY l.group_code ASC
0.0146	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-10 02:07:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-10 02:07:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-10 02:07:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-10 02:07:45' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0161	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'segundab' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1990 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0200	SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (21058) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0156	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (21058) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (261821,672317,260679,271770,261297,671998,261971,672223,261177,672004,256834,261239,261966,256739,261238,672382,672752,261761,671587,672166) ORDER BY rp.in_squad = 1 DESC
0.0246	SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (21058) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0156	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (21058) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (261801,669328,672395,672752,261761,261964,669905,261036,668846,672763,672779,258181,258762,260830,261179,261180,273302,669489,671459,671874) ORDER BY rp.in_squad = 1 DESC
0.0292	SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (21058) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0151	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (21058) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (261801,672189,672395,239685,256739,256834,260830,261231,261297,668348,669328,669876,669905,670610,670629,671998,672145,672331,672753,672762) ORDER BY rp.in_squad = 1 DESC
0.0187	SELECT e.action, count(e.action) as total, e.player_id FROM events1990 e WHERE e.league_id IN (21058) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0148	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (21058) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0147	SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21058 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0146	SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 21058 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0146	SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=21058 AND rel.round=26
0.0145	SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 21058 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146	SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 21058 AND esl.points > 0
0.0152	SELECT fau.user_name, c., NOW() as difference_time,creation_date FROM* (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-04-10" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 21058 ORDER BY creation_date DESC LIMIT 0, 10
0.0159	SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-04-10" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 21058
0.0346	SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars1990` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 21058 AND c.`round` = 26 ORDER BY shedule ASC LIMIT 200
0.0156	SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events1990 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1990 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 21058 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (14070,14069,14068,14067,14066,14065,14064,14071,14072,14073) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0175	SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1990` e INNER JOIN calendars1990 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 26 AND e.real_date IS NOT NULL AND e.league_id = 21058 ORDER BY total DESC LIMIT 40
0.0214	SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events1990` e INNER JOIN calendars1990 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 21058 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0160	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* `tables1990` 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 = 21058 AND t.round = 25 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1990` 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 = 21058 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	SELECT distinct(shedule), round FROM `calendars1990` as c WHERE c.`league_id` = 21058 AND shedule >= '1990/03/01' AND shedule < '1990/04/01' ORDER BY shedule ASC
0.0150	SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-05-10 00:00:00' AND c.`shedule` < '2024-05-14 23:59:59' AND l.id = 21058 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0150	SELECT data1, data2 FROM services_tags WHERE categoryId=3
0.0150	SELECT group_code, extraName from `leagues` WHERE categoryId=3 AND year=1990

Partido televisado en... x

Segunda División B 1990

Segunda División B 1990

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

Reglas de la competición


	¡Vas a denunciar un contenido! x Denuncia sólo contenidos que incumplan nuestras Normas de uso o conducta. Aunque revisamos todas las denuncias que nos llegan, sólo respondemos si procede. El uso indebido de esta herramienta también incumple las normas de conducta. Elige una de las siguientes opciones: Incumplimiento de las normas: Otra:

RK	Nombre	Amarillas	Posición	Equipo
1	Carlos	14	DEF	As Pontes
2	Juanín	12	MED	Lalín
3	Edrosa	12	DEF	CD Lugo
4	Santos	12	DEL	CD Colonia Moscardó
5	Juan Luis	11	DEL	Langreo
6	Flores	11	DEL	Getafe
7	Maito	11	DEF	CD Toledo
8	José Ángel	10	MED	Langreo
9	Juan Carlos	10	DEF	Racing Ferrol
10	Mariano	10	MED	Leganés
11	Toño	10	DEF	Racing Ferrol
12	Muñiz	9	DEF	Sporting Atlético
13	Miguel	9	DEF	Galáctico Pegaso
14	Dorado	9	DEF	Leganés
15	Ramiro	9	MED	Lalín
16	Núñez	9	MED	Pontevedra
17	Argüelles	9	DEF	Cultural Leonesa
18	Fidel	9	DEF	Galáctico Pegaso
19	Richard	9	DEF	Cambados
20	Alberto	9	MED	Sporting Atlético

RK	Nombre	Rojas	Posición	Equipo
1	Carlos	3	DEF	As Pontes
2	Miguel	3	MED	Leganés
3	Edrosa	3	DEF	CD Lugo
4	Juanele	2	MED	Sporting Atlético
5	Álvarez	2	MED	Real Ávila
6	Tapia	2	MED	CD Lugo
7	Dorado	2	DEF	Leganés
8	Iñaki	2	DEF	Real Avilés Industri.
9	Velázquez	2	DEL	Real Avilés Industri.
10	Montoya	2	DEF	CD Colonia Moscardó
11	Juanín	2	MED	Lalín
12	Méndez	2	MED	RSD Alcalá
13	Maito	2	DEF	CD Toledo
14	Ramos	2	MED	Ponferradina
15	Buyo	2	MED	Racing Ferrol
16	Paquito	2	MED	Ponferradina
17	Falo	2	MED	As Pontes
18	Rozada	2	DEF	Langreo
19	Moreno	2	DEF	CD Colonia Moscardó
20	Ortega	2	DEF	Leganés

Partido televisado en... x

Segunda División B 1990

Segunda División B 1990

Busca la liga de tu equipo

NOTICIAS RELACIONADAS

Rubiales también está en el 'caso Koldo': "Le contaré cómo está el tema del Reus"

Jorge Molina confirmó su retirada: "Todo tiene un final..."

Jorge Molina se retira a los 41 años y coge sitio en el banquillo del Granada

El Atlético, de luto: Robi fallece a los 72 años de edad

Ibai Gómez cuelga las botas a los 32 años

LIGAS RELACIONADAS

Equipos de esta competición

INFORMACIÓN

Reglas de la competición