4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Cubelles B
Información

Partidos del Cubelles B

Ir al LIVESCORE
28 May 22  Finalizado Cubelles B
3 - 5
Base Marc Bartra B 0
22 May 22  Finalizado Santboia A
5 - 1
Cubelles B 0
14 May 22  Finalizado Cubelles B
2 - 3
Martorell Associacio Es. 0
07 May 22  Finalizado Fundacio Unio Esportiva
5 - 4
Cubelles B 0
30 Abr 22  Finalizado Cubelles B
1 - 1
Santfeliuenc A 0
24 Abr 22  Finalizado Igualada C
4 - 4
Cubelles B 0
09 Abr 22  Finalizado Cubelles B
2 - 2
Escola Gava C 0
02 Abr 22  Finalizado Sporting Gava 2013 Futb.
6 - 5
Cubelles B 0
26 Mar 22  Finalizado Cubelles B
1 - 3
Barcelona C 0
19 Mar 22  Aplazado Ribes CD A
-
Cubelles B 0
12 Mar 22  Finalizado Cubelles B
2 - 3
Viladecans A 0
05 Mar 22  Finalizado Olesa 87 C A
2 - 7
Cubelles B 0
19 Feb 22  Finalizado Cubelles B
3 - 5
Sitges A 0
12 Feb 22  Finalizado Cubelles B
7 - 1
Terlenka Barcelonista 0
05 Feb 22  Finalizado Castelldefels A
4 - 4
Cubelles B 0
02 Feb 22  Finalizado Base Marc Bartra B
2 - 2
Cubelles B 0
22 Ene 22  Finalizado Cubelles B
2 - 1
Santboia A 0
15 Ene 22  Finalizado Martorell Associacio Es.
6 - 2
Cubelles B 0
08 Ene 22  Finalizado Cubelles B
2 - 8
Fundacio Unio Esportiva 0
19 Dic 21  Finalizado Santfeliuenc A
2 - 3
Cubelles B 0
12 Dic 21  Finalizado Cubelles B
0 - 2
Igualada C 0
28 Nov 21  Finalizado Escola Gava C
2 - 0
Cubelles B 0
21 Nov 21  Finalizado Cubelles B
8 - 4
Sporting Gava 2013 Futb. 0
14 Nov 21  Finalizado Barcelona C
1 - 3
Cubelles B 0
06 Nov 21  Finalizado Cubelles B
5 - 0
Ribes CD A 0
31 Oct 21  Finalizado Viladecans A
7 - 4
Cubelles B 0
23 Oct 21  Finalizado Cubelles B
4 - 3
Olesa 87 C A 0
17 Oct 21  Finalizado Sitges A
1 - 2
Cubelles B 0
09 Oct 21  Finalizado Terlenka Barcelonista
2 - 1
Cubelles B 0
02 Oct 21  Finalizado Cubelles B
3 - 3
Castelldefels A 0

Últimas noticias

Ver últimas noticias

El Atalanta acaba con el Empoli y acecha a la Roma

Los goles de Mario Pasalic, de penalti, y de Ademola Lookman sirven al Atalanta para sumar 3 puntos clave ante el Empoli (2-0). Recorta distancias el equipo de Gianpiero Gasperini con la Roma y se queda a solo 2 de los 'giallorossi', que están en la última plaza que da acceso a la Champions League.

El City mantiene la Premier en su mano

El Manchester City respondió al triunfo del Arsenal con una victoria por 0-2 ante el Nottingham Forest. Con cuatro partidos por delante, los de Pep Guardiola, segundos a un punto del líder, dependen de sí mismos, pues cuentan con un partido jugado menos que su rival londinense. Gvardiol y Haaland fueron los autores de los tantos 'sky blues'.

Pellegrini nunca ha ganado el derbi sevillano con el Betis

Vive con nosotros el directo del Betis-Sevilla, encuentro correspondiente a la Jornada 33 de Liga en Primera División 2023-24.

Actualidad del día en el fútbol argentino a 28 de abril de 2024

Las noticias más destacadas del día en el fútbol argentino a 28 de abril de 2024.

Actualidad del día en el fútbol mexicano a 28 de abril de 2024

Noticias destacadas del día en el fútbol mexicano a 28 de abril de 2024.




  USO DE MEMORIA  
4,744,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0036
Controller Execution Time ( Home / Category )  0.3126
Total Execution Time  0.3163
  CADENA URL  
/Cubelles-Cf-B-Benjamin/2022
  GET DATOS  
$_GET['/Cubelles-Cf-B-Benjamin/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0154  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 = 'Cubelles-Cf-B-Benjamin' 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.0145  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=37627 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0147  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=37627 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=37627 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=943 AND type_rel = 3
0.0155  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 = '37627' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151  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 = '37627' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0161  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=37627 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0150  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 (64686) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64686 AND teamId = 37627
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 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 = 64686 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  SELECT rp.team_id as teamId FROM rel_players_base AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 37627 AND rp.league_id = 64686 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1