4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Racing Blanenc B
TEMPORADA 2021/2022
2ª CATALANA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Olimpic Malgrat CE A Olimpic 24 154 19 65
2 Malgrat CD A Malgrat 25 142 22 64
3 Sant Hilari-Font Vella CE A Sant 26 113 45 60
4 Breda UE A Breda UE A 27 88 42 56
5 Cal Aguido B Aguido 25 104 35 54
6 Tossa Unio Esportiva A Tossa Unio. 26 77 42 48
7 Escola Futbol Arbucienca A Escola 26 87 41 46
8 Lloret CF B Lloret CF B 26 72 83 35
9 Palafolls CD A Palafolls 27 56 105 26
10 Farners A Farners A 27 60 77 24
11 Hostalric At.C A Hostalric 25 41 96 23
12 Blanes B Blanes B 25 31 78 20
13 Racing Blanenc B Racing 24 32 77 16
14 Tordera CF B Tordera 25 38 129 10
15 Athletic Club Riells A Athletic 22 12 216 0
TEMPORADA 2015/2016
2ª CATALANA CADETE GRUPO 5
Equipo PJ GF GC Puntos
1 Fundacio Esportiva Palamos Fundacio 30 163 20 83
2 Llagostera B Llagostera 30 135 42 77
3 Base L'Empordanet A Base 30 140 46 72
4 Escola Baix Ter A Escola Baix 30 147 65 67
5 Bisbalenc A Bisbalenc A 30 149 35 67
6 Cristinenc A Cristinenc 30 95 73 53
7 Escola Sant Feliu Guixols B Escola Sant 30 85 75 52
8 Racing Blanenc B Racing 30 69 100 42
9 Tordera C Tordera C 30 60 87 35
10 La Salle Figueres B Salle 30 54 79 34
11 Flaça A Flaça A 30 77 111 32
12 Escola Mfcalonge Santa Anto Escola 30 59 90 27
13 Cassa B Cassa B 29 46 87 27
14 Palafrugell A Palafrugell 29 56 128 23
15 Aro A Aro A 30 22 186 6
16 Vilamalla B Vilamalla B 30 31 164 5

  USO DE MEMORIA  
4,651,928 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.3358
Total Execution Time  0.3370
  CADENA URL  
/historico/Racing-Blanenc-Fc-B-Cadete
  GET DATOS  
$_GET['/historico/Racing-Blanenc-Fc-B-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (15)  
0.0302  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 = 65711
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=75151 AND type_rel = 2
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=747 AND type_rel = 3
0.0147  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 = '75151' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = '75151' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 65711 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0149  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=75151 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (65711) 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.0146  SELECT count(id) as num_players from rel_players_base WHERE league_id = 65711 AND teamId = 75151
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 = 65711 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '75151' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  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 = '75151' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 = 75151 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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_base` 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 = 65711 AND t.round = 30 ORDER BY team.conference ASC,t.position 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 `tables2016_base` 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 = 18113 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC