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

Partidos del Canet B

Ir al LIVESCORE
12 May 19  Finalizado Tavernes Blanques C Tavernes Blanques C
5 - 1
Canet B Canet B 0
05 May 19  Finalizado Canet B Canet B
0 - 1
C.D. Massamagrell C C.D. Massamagrell C 0
27 Abr 19  Finalizado La Creu Pobla Farnals B La Creu Pobla Farnals B
2 - 12
Canet B Canet B 0
14 Abr 19  Finalizado Canet B Canet B
12 - 0
Puzol D Puzol D 0
05 Abr 19  Finalizado Rafelbuñol B Rafelbuñol B
3 - 2
Canet B Canet B 0
31 Mar 19  Finalizado Canet B Canet B
4 - 0
Caxton College C Caxton College C 0
23 Mar 19  Finalizado Foios Atletic C Foios Atletic C
0 - 6
Canet B Canet B 0
10 Mar 19  Finalizado Canet B Canet B
6 - 2
Sagunto C Sagunto C 0
02 Mar 19  Finalizado El Puig B El Puig B
0 - 8
Canet B Canet B 0
16 Feb 19  Finalizado Biensa B Biensa B
0 - 11
Canet B Canet B 0
03 Feb 19  Finalizado Acero B Acero B
4 - 1
Canet B Canet B 0
26 Ene 19  Finalizado Canet B Canet B
2 - 2
Sporting Almassera B Sporting Almassera B 0
19 Ene 19  Finalizado Canet B Canet B
2 - 4
Tavernes Blanques C Tavernes Blanques C 0
12 Ene 19  Finalizado C.D. Massamagrell C C.D. Massamagrell C
7 - 1
Canet B Canet B 0
22 Dic 18  Finalizado Canet B Canet B
10 - 0
La Creu Pobla Farnals B La Creu Pobla Farnals B 0
15 Dic 18  Finalizado Puzol D Puzol D
0 - 11
Canet B Canet B 0
08 Dic 18  Finalizado Canet B Canet B
1 - 2
Rafelbuñol B Rafelbuñol B 0
01 Dic 18  Finalizado Caxton College C Caxton College C
1 - 9
Canet B Canet B 0
24 Nov 18  Finalizado Canet B Canet B
3 - 0
Foios Atletic C Foios Atletic C 0
18 Nov 18  Finalizado Sagunto C Sagunto C
0 - 9
Canet B Canet B 0
10 Nov 18  Finalizado Canet B Canet B
5 - 1
El Puig B El Puig B 0
06 Nov 18  Finalizado Canet B Canet B
2 - 3
Acero B Acero B 0
03 Nov 18  Finalizado Canet B Canet B
9 - 0
Biensa B Biensa B 0
13 Oct 18  Finalizado Sporting Almassera B Sporting Almassera B
3 - 2
Canet B Canet B 0

Noticias de Campeonato Alevín Valencia

Ver últimas noticias

No era una broma: el 'regalo' del Leicester por el fichaje de Iborra

Se trata del Fútbol Base de Alfara del Patriarca, en Valencia. El modesto club de la ciudad del Turia se ha visto beneficiado por el traspaso de Iborra desde el Sevilla al Leicester...

El Villarreal levanta el trofeo del torneo alevín 'LaLiga Promises'

El 'XXV Torneo LaLiga Promises' fue a parar a manos del Villarreal. Los amarillos vencieron en la final a un Atlético de Madrid al que no dieron oportunidad. El Villarreal, anfitrión del campeonato, fue físicamente muy superior.

Descubre al equipo que lucirá una frase de Simeone en su camiseta

El 'cholismo' sigue expandiéndose. El técnico del Atlético de Madrid y su filosofía han cautivado a un equipo, que no ha dudado y llevará una de sus míticas frases en su camiseta.

El Sevilla se proclama campeón de la Danone Nations Cup frente al Valencia

La edición número 17 de la Danone Nations Cup España ya tiene ganador: el Sevilla. Los de Nervión ganaron 2-1 al Valencia en la final celebrada hoy en el RCDE Stadium.




  USO DE MEMORIA  
4,609,136 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0031
Controller Execution Time ( Home / Category )  0.3571
Total Execution Time  0.3602
  CADENA URL  
/Cd-De-Futbol-Canet-B-Alevin/
  GET DATOS  
$_GET['/Cd-De-Futbol-Canet-B-Alevin/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0135  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 = 'Cd-De-Futbol-Canet-B-Alevin' 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.0149  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 = 'Cd-De-Futbol-Canet-B-Alevin' 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.0128  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=47432 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=47432 AND type_rel = 2
0.0132  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1160 AND type_rel = 3
0.0137  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1160 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0138  SELECT /*53 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 (369804,77180,75412,72746) ORDER BY n.cover_points DESC, update_date DESC
0.0140  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 = '47432' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0131  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 = '47432' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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=47432 AND l.year in (2018,2019,2020) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (55139,46670) 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.0129  SELECT count(id) as num_players from rel_players_base WHERE league_id = 46670 AND teamId = 47432
0.0130  SELECT count(id) as num_players from rel_players_base WHERE league_id = 55139 AND teamId = 47432
0.0134  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 = 47432 AND rp.league_id = 46670 AND l.year= 2019 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1