4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2023/2024
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem B Levante 25 118 13 73
2 Porqueres Fem Porqueres 27 73 28 66
3 Girona Fem Girona Fem 25 80 24 57
4 Sant Cugat Fem Sant Cugat 26 79 42 47
5 EF Mataró Fem Mataró 25 70 35 47
6 Cerdanyola del Vallès Fem Cerdanyola 27 54 53 38
7 Pallejà Fem Pallejà 26 52 53 37
8 FPFB Reus Fem FPFB Reus 25 51 39 35
9 La Roca Penya Blanc Fem Roca Penya. 25 41 48 33
10 Terrassa Fem Terrassa 26 51 56 32
11 Pontenc Fem Pontenc Fem 26 58 74 29
12 EE Guineueta Fem Guineueta 26 47 50 27
13 Llerona Fem Llerona Fem 26 40 63 26
14 Santa Susanna Fem Santa 25 41 61 25
15 Viladecans Fem Viladecans 25 37 49 22
16 Martinenc Fem Martinenc 25 51 69 20
17 CF Badalona Fem Badalona 24 1 187 0
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Fontsanta-Fatjo Fem Fontsanta-Fa 16 48 22 41
2 Martinenc Fem Martinenc 17 55 16 39
3 Femeni Manu Lanzarote Femeni Manu 17 58 23 32
4 UE Cornellà Fem Cornellà 15 39 17 32
5 Porqueres A Porqueres A 17 30 18 32
6 Blava La Roca A Blava Roca 17 29 26 32
7 Sant Cugat Fem Sant Cugat 17 43 30 31
8 Atletic Vilafranca Atletic 17 29 26 23
9 Aem B Aem B 17 32 20 22
10 Pubilla Casas Pubilla 15 25 23 22
11 Palautordera Palautordera 16 38 25 21
12 Cerdanyola del Vallès Fem Cerdanyola 16 34 31 20
13 Sabadell A Sabadell A 16 36 41 17
14 Manlleu A Manlleu A 17 28 29 15
15 ENFAF Andorra ENFAF 14 13 25 11
16 F. Jupiter A Jupiter 16 15 48 10
17 Llerona Fem Llerona Fem 14 11 37 8
18 Verdu Vall del Corb Verdu Vall. 14 5 111 0
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Levante Las Planas Fem Levante 28 86 26 66
2 Vic Riuprimer Refo Fem Riuprimer 28 82 48 55
3 Terrassa Fem Terrassa 28 69 56 52
4 Sant Cugat B Sant Cugat 28 61 40 50
5 Porqueres A Porqueres A 28 52 39 47
6 Manlleu A Manlleu A 27 53 56 45
7 Femeni L. A Femeni L. A 28 36 28 44
8 Fontsanta Fatjo A A Fontsanta 27 61 47 40
9 Sabadell CE A Sabadell 28 56 58 39
10 Aem B Aem B 28 47 57 35
11 P. Casas A P. Casas A 28 40 70 30
12 Sant Gabriel B B Sant Gabriel 28 49 55 29
13 Fundacio E Atletic Vilafran Fundacio 28 36 60 25
14 Pontenc Fem Pontenc Fem 28 38 77 17
15 Cerdanyola del Vallès Fem Cerdanyola 28 32 81 15
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Fontsanta Fatjo A A Fontsanta 23 74 39 50
2 Pardinyes A A Pardinyes 20 86 33 48
3 Sant Pere Pescador Fem Sant Pere P. 21 65 41 40
4 Cerdanyola Valles A A Cerdanyola 16 49 18 39
5 Atletic Prat Delta A A Atletic Prat 24 47 39 37
6 Porqueres Fem Porqueres 22 45 39 37
7 Sant Andreu A A Sant Andreu 22 52 49 31
8 CE Pontenc CE Pontenc 21 48 56 31
9 Atletic Vilafranca Atletic 18 34 32 26
10 Sant Gabriel B B Sant Gabriel 19 40 41 25
11 Molins de Rei A A Molins 23 39 53 25
12 Aem B B Aem B B 19 38 48 20
13 Escola Esportiva Guineueta Escola 23 46 80 19
14 Femeni Tortosa Ebre A A Femeni 17 27 37 15
15 La Roca Penya Blanc Blava C Roca Penya. 17 23 45 10
16 Camp Clar A A Camp Clar 25 51 114 9
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Sabadell A A Sabadell 30 112 18 78
2 Sant Gabriel B B Sant Gabriel 29 108 26 72
3 Molins de Rei A A Molins 30 99 39 62
4 Sant Pere Pescador Fem Sant Pere P. 29 104 46 58
5 AtlÈtic Prat A A AtlÈtic 29 86 39 58
6 Femeni Tortosa Ebre A A Femeni 30 81 66 54
7 Fontsanta Fatjo A A Fontsanta 30 56 44 51
8 Porqueres Fem Porqueres 30 79 70 41
9 Escola Esportiva Guineueta Escola 30 63 69 41
10 Pardinyes A A Pardinyes 29 62 70 40
11 Camp Clar A A Camp Clar 29 72 69 40
12 Sant Andreu A A Sant Andreu 30 42 71 26
13 Santa Eugenia A A Santa 30 49 97 23
14 Santpedor A A Santpedor 29 31 120 15
15 FP Júpiter FP Júpiter 30 38 131 13
16 PB Lloret de Mar Lloret 28 53 160 7
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Blava La Roca A Blava Roca 30 92 45 68
2 Pallejà Fem Pallejà 30 60 23 62
3 Cerdanyola del Vallès Fem Cerdanyola 30 67 27 58
4 Sant Gabriel C Sant Gabriel 30 62 34 58
5 Sabadell A Sabadell A 30 72 36 57
6 Sant Pere Pescador Fem Sant Pere P. 30 81 44 55
7 Pardinyes A Pardinyes A 29 69 56 54
8 Atletic Prat A Atletic Prat 30 74 44 49
9 Fontsanta-Fatjo Fem Fontsanta-Fa 30 53 54 43
10 Santa Eugenia A Santa 30 64 73 39
11 Tortosa-Ebre A Tortosa-Ebre 29 49 58 28
12 Escola Guineueta A Escola 30 38 83 26
13 Santpedor A Santpedor A 30 56 88 25
14 Sant Quirze Besora A Sant Quirze 30 36 80 20
15 Bonaire A Bonaire A 30 40 85 19
16 Llerona A Llerona A 30 40 123 8

  USO DE MEMORIA  
5,602,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3405
Total Execution Time  0.3424
  CADENA URL  
/preferente_femenina_catalana2024/grupo1/historico
  GET DATOS  
$_GET['/preferente_femenina_catalana2024/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0106  SELECT type FROM routes WHERE alias = 'preferente_femenina_catalana2024'
0.0216  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_femenina_catalana' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=727 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=727 ORDER BY order_id ASC
0.0107  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 = 74133 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0107  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 727 AND group_code = 1 and tables = 1 AND year <= 2024 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0110  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 `tables2024` 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 = 74133 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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` 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 = 64723 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2021` 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 = 61397 AND t.round = 17 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2019` 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 = 48150 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2017` 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 = 35127 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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` 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 = 19598 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 `tables2015` 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 = 4592 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 03:54:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 03:54:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 03:54:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 03:54:47' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'preferente_femenina_catalana' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0107  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74133 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74133 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0106  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74133 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74133 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0117  SELECT e.action, count(e.action) 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 FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 74133 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 74133 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0164  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 74133 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC