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

« Temporada Anterior

Temporada Siguiente »

1993/1994

Segunda División B 1994

Segunda División B:

Segunda División B 1994

La temporada finalizó el Domingo, 01 Mayo 1994.

	01 May 94 Finalizado	CD Ourense	CD Ourense - Talavera CF 1994-05-01T00:00:00 O Couto 3-2	Talavera CF	más información Jugadas destacadas ...
		37' Santi	1-0
		44' Santi	2-0
			2-1	57' José Luis Soto
		77' Quecho	3-1
			3-2	84' Paco
	01 May 94 Finalizado	UD Salamanca	UD Salamanca - Atlético B 1994-05-01T00:00:00 Helmántico 3-2	Atlético B	más información Jugadas destacadas ...
		24' Pollo	1-0
			1-1	38' Israel
		59' Medina	2-1
		74' Díaz	3-1
				86' Barbero
			3-2	92' Gonzalo
	01 May 94 Finalizado	Langreo	Langreo - Real Madrid C 1994-05-01T00:00:00 Nuevo Ganzábal 1-3	Real Madrid C	más información Jugadas destacadas ...
			0-1	11' Miguel Ángel
			0-2	37' Arteaga
			0-3	60' Jacquet
		68' Luismi	1-3
	01 May 94 Finalizado	Real Ávila	Real Ávila - Real Oviedo Vetusta 1994-05-01T00:00:00 Estadio Municipal Adolfo Suárez 0-0	Real Oviedo Vetusta	más información ...
	01 May 94 Finalizado	Pontevedra	Pontevedra - Getafe 1994-05-01T00:00:00 Estadio Municipal de Pasarón 2-1	Getafe	más información Jugadas destacadas ...
		20' Couto	1-0
		28' Vera	2-0
			2-1	51' Padilla
	01 May 94 Finalizado	Celta Fortuna	Celta Fortuna - Arosa 1994-05-01T00:00:00 Municipal de Barreiro 2-2	Arosa	más información Jugadas destacadas ...
		17' Míchel Salgado	1-0
		33' Míchel Salgado
		62' Porto	2-0
			2-1	92' Adriano
			2-2	92' Caché
	01 May 94 Finalizado	Real Avilés Industrial	Real Avilés Industrial - Racing Ferrol 1994-05-01T00:00:00 Román Suárez Puerta 2-3	Racing Ferrol	más información Jugadas destacadas ...
			0-1	3' Caneda
		44' Javi Prendes	1-1
			1-2	57' Caneda
			1-3	75' Aguilar
		87' Iñaki	2-3
	01 May 94 Finalizado	Sporting Atlético	Sporting Atlético - CD Lugo 1994-05-01T00:00:00 Campo Pepe Ortiz 2-0	CD Lugo	más información Jugadas destacadas ...
		80' Puente	1-0
		86' Puente	2-0
	01 May 94 Finalizado	Tomelloso	Tomelloso - Cultural Leonesa 1994-05-01T00:00:00 estadio municipal 1-1	Cultural Leonesa	más información Jugadas destacadas ...
			0-1	18' Narciso
				34' Nico
				46' Juan Manuel
		75' Criubaldo	1-1
	01 May 94 Finalizado	UD Sanse	UD Sanse - Ponferradina 1994-05-01T00:00:00 Municipal Nuevo Matapiñonera 2-0	Ponferradina	más información Jugadas destacadas ...
		19' Juan Díaz	1-0
				38' Benítez
		62' Antonio	2-0

Equipos		Puntos	J.	G.	E.	P.	F.	C.	Forma
1	UD Salamanca	56	38	23	10	5	71	26	VICTORIA UD Salamanca 3 Arosa 0 DERROTA Getafe 1 UD Salamanca 0 VICTORIA UD Salamanca 3 Real Oviedo Vetust. 1 EMPATE Real Madrid C 1 UD Salamanca 1 VICTORIA UD Salamanca 3 Atlético B 2
2	Getafe	50	38	17	16	5	53	31	DERROTA CD Ourense 4 Getafe 1 VICTORIA Getafe 1 UD Salamanca 0 EMPATE Langreo 1 Getafe 1 DERROTA Getafe 0 Real Ávila 1 DERROTA Pontevedra 2 Getafe 1
3	CD Ourense	48	38	20	8	10	64	53	VICTORIA CD Ourense 4 Getafe 1 DERROTA Real Oviedo Vetust. 4 CD Ourense 0 EMPATE CD Ourense 2 Real Madrid C 2 DERROTA Atlético B 4 CD Ourense 1 VICTORIA CD Ourense 3 Talavera CF 2
4	Langreo	43	38	16	11	11	60	60	VICTORIA Langreo 3 Racing Ferrol 1 DERROTA Arosa 5 Langreo 0 EMPATE Langreo 1 Getafe 1 VICTORIA Real Oviedo Vetust. 1 Langreo 2 DERROTA Langreo 1 Real Madrid C 3
5	Pontevedra	41	38	14	13	11	51	41	EMPATE Pontevedra 1 Cultural Leonesa 1 EMPATE CD Lugo 2 Pontevedra 2 EMPATE Pontevedra 0 Racing Ferrol 0 VICTORIA Arosa 1 Pontevedra 2 VICTORIA Pontevedra 2 Getafe 1
6	Atlético B	40	38	14	12	12	54	44	VICTORIA Atlético B 3 Real Madrid C 1 DERROTA UD Sanse 2 Atlético B 1 DERROTA Talavera CF 3 Atlético B 1 VICTORIA Atlético B 4 CD Ourense 1 DERROTA UD Salamanca 3 Atlético B 2
7	Real Madrid C	40	38	15	10	13	63	55	DERROTA Atlético B 3 Real Madrid C 1 VICTORIA Real Madrid C 2 Talavera CF 0 EMPATE CD Ourense 2 Real Madrid C 2 EMPATE Real Madrid C 1 UD Salamanca 1 VICTORIA Langreo 1 Real Madrid C 3
8	CD Lugo	38	38	13	12	13	38	42	EMPATE Real Ávila 0 CD Lugo 0 EMPATE CD Lugo 2 Pontevedra 2 DERROTA Celta Fortuna 2 CD Lugo 0 VICTORIA CD Lugo 2 Real Avilés Indust. 0 DERROTA Sporting Atlético 2 CD Lugo 0
9	Real Ávila	37	38	10	17	11	33	42	EMPATE Real Ávila 0 CD Lugo 0 EMPATE Racing Ferrol 1 Real Ávila 1 VICTORIA Real Ávila 1 Arosa 0 VICTORIA Getafe 0 Real Ávila 1 EMPATE Real Ávila 0 Real Oviedo Vetust. 0
10	UD Sanse	37	38	13	11	14	49	48	VICTORIA Sporting Atlético 0 UD Sanse 2 VICTORIA UD Sanse 2 Atlético B 1 EMPATE Tomelloso 0 UD Sanse 0 EMPATE Talavera CF 0 UD Sanse 0 VICTORIA UD Sanse 2 Ponferradina 0
11	Real Oviedo Vet.	37	38	11	15	12	39	38	EMPATE Talavera CF 0 Real Oviedo Vetust. 0 VICTORIA Real Oviedo Vetust. 4 CD Ourense 0 DERROTA UD Salamanca 3 Real Oviedo Vetust. 1 DERROTA Real Oviedo Vetust. 1 Langreo 2 EMPATE Real Ávila 0 Real Oviedo Vetust. 0
12	Sporting	37	38	16	5	17	45	42	DERROTA Sporting Atlético 0 UD Sanse 2 VICTORIA Tomelloso 0 Sporting Atlético 3 VICTORIA Sporting Atlético 2 Ponferradina 1 DERROTA Cultural Leonesa 3 Sporting Atlético 1 VICTORIA Sporting Atlético 2 CD Lugo 0
13	Racing Ferrol	36	38	12	12	14	54	58	DERROTA Langreo 3 Racing Ferrol 1 EMPATE Racing Ferrol 1 Real Ávila 1 EMPATE Pontevedra 0 Racing Ferrol 0 EMPATE Racing Ferrol 1 Celta Fortuna 1 VICTORIA Real Avilés Indust. 2 Racing Ferrol 3
14	Talavera CF	35	38	12	11	15	41	44	EMPATE Talavera CF 0 Real Oviedo Vetust. 0 DERROTA Real Madrid C 2 Talavera CF 0 VICTORIA Talavera CF 3 Atlético B 1 EMPATE Talavera CF 0 UD Sanse 0 DERROTA CD Ourense 3 Talavera CF 2
15	Real Avilés Ind.	34	38	10	14	14	43	55	EMPATE Real Avilés Indust. 1 Tomelloso 1 DERROTA Ponferradina 1 Real Avilés Indust. 0 VICTORIA Real Avilés Indust. 2 Cultural Leonesa 0 DERROTA CD Lugo 2 Real Avilés Indust. 0 DERROTA Real Avilés Indust. 2 Racing Ferrol 3
16	Arosa	33	38	11	11	16	42	48	DERROTA UD Salamanca 3 Arosa 0 VICTORIA Arosa 5 Langreo 0 DERROTA Real Ávila 1 Arosa 0 DERROTA Arosa 1 Pontevedra 2 EMPATE Celta Fortuna 2 Arosa 2
17	Cultural Leonesa	32	38	11	10	17	38	53	EMPATE Pontevedra 1 Cultural Leonesa 1 VICTORIA Cultural Leonesa 3 Celta Fortuna 1 DERROTA Real Avilés Indust. 2 Cultural Leonesa 0 VICTORIA Cultural Leonesa 3 Sporting Atlético 1 EMPATE Tomelloso 1 Cultural Leonesa 1
18	Tomelloso	32	38	8	16	14	29	42	EMPATE Real Avilés Indust. 1 Tomelloso 1 DERROTA Tomelloso 0 Sporting Atlético 3 EMPATE Tomelloso 0 UD Sanse 0 VICTORIA Ponferradina 0 Tomelloso 1 EMPATE Tomelloso 1 Cultural Leonesa 1
19	Ponferradina	28	38	9	10	19	39	56	VICTORIA Celta Fortuna 2 Ponferradina 3 VICTORIA Ponferradina 1 Real Avilés Indust. 0 DERROTA Sporting Atlético 2 Ponferradina 1 DERROTA Ponferradina 0 Tomelloso 1 DERROTA UD Sanse 2 Ponferradina 0
20	Celta Fortuna	26	38	8	10	20	45	73	DERROTA Celta Fortuna 2 Ponferradina 3 DERROTA Cultural Leonesa 3 Celta Fortuna 1 VICTORIA Celta Fortuna 2 CD Lugo 0 EMPATE Racing Ferrol 1 Celta Fortuna 1 EMPATE Celta Fortuna 2 Arosa 2

JUGADORES DESTACADOS

RK		Nombre	Goles	Posición	Equipo
1		Antonio	22	DEL	Ponferradina
2		Juan Carlos	21	DEL	Atlético B
3		Arteaga	21	DEL	Real Madrid C
4		Santi	18	MED	CD Ourense
5		Javi Prendes	18	DEL	Real Avilés Industri.
6		Narciso	15	DEL	Cultural Leonesa
7		Quico	15	DEL	UD Salamanca
8		Jose Peña	15	DEL	Racing Ferrol
9		Juan Luis	15	DEL	Langreo
10		Barbarà	14	DEL	UD Salamanca
11		Couto	14	DEL	Pontevedra
12		Julián Romero	12	DEL	Getafe
13		Joaquín	12	DEL	Real Avilés Industri.
14		Quecho	11	MED	CD Ourense
15		Matias	11	DEL	Real Madrid C
16		Coméndez	11	MED	Arosa
17		Caneda	11	MED	Racing Ferrol
18		Soriano	11	DEL	UD Sanse
19		Juancho	11	DEF	Pontevedra
20		Cima	11	DEL	Langreo

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

20

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,194,248 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.1169
Total Execution Time	0.1188

CADENA URL

/segundab1994/grupo5

GET DATOS

$_GET['/segundab1994/grupo5']

POST DATOS

No hay datos POST existentes

CONSULTAS (24)

0.0018	SELECT type FROM routes WHERE alias = 'segundab1994'
0.0040	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 = 5 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=5 DESC LIMIT 1
0.0020	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 = 21018 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023	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.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 22:50:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 22:50:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 22:50:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 22:50:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	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 = 1994 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0021	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=21018 AND rel.round=38
0.0018	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 = 21018 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0019	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 = 21018 AND esl.points > 0
0.0018	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-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 21018 ORDER BY creation_date DESC LIMIT 0, 10
0.0025	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-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 21018
0.0036	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 `calendars1994` 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` = 21018 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0089	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 events1994 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars1994 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 21018 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 (19949,19950,19951,19952,19953,19954,19955,19956,19957,19958) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0020	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 `events1994` e INNER JOIN calendars1994 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 = 38 AND e.real_date IS NOT NULL AND e.league_id = 21018 ORDER BY total DESC LIMIT 40
0.0053	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 `events1994` e INNER JOIN calendars1994 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 = 21018 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0061	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* `tables1994` 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 = 21018 AND t.round = 37 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	SELECT ,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1994` 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 = 21018 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020	SELECT distinct(shedule), round FROM `calendars1994` as c WHERE c.`league_id` = 21018 AND shedule >= '1994/05/01' AND shedule < '1994/06/01' ORDER BY shedule ASC
0.0026	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-04-28 00:00:00' AND c.`shedule` < '2024-05-02 23:59:59' AND l.id = 21018 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0051	SELECT data1, data2 FROM services_tags WHERE categoryId=3
0.0051	SELECT group_code, extraName from `leagues` WHERE categoryId=3 AND year=1994