4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Gornal Gornal 23 85 31 50
2 Sant Genis-Penitentes CD Sant 23 63 25 48
3 Sporting Gava 2013 Sporting 22 59 35 46
4 Levante Las Planas Levante 22 48 25 46
5 At. Iberia At. Iberia 22 69 46 45
6 Martinenc B Martinenc B 22 50 30 42
7 Montsant de La Peira Montsant 22 53 34 41
8 Turó Peira Turó Peira 22 37 33 40
9 PB Sant Vicenç H. Sant Vicenç 22 48 52 30
10 APA Poble Sec Poble 23 38 47 29
11 Veterans Catalunya A Veterans 23 53 65 27
12 FP Júpiter FP Júpiter 22 38 39 25
13 Besòs Barón de Viver Besòs 21 33 43 24
14 L'Esquerra FC A L'Esquerra 23 37 49 24
15 Olympia II CE Olympia 23 46 64 21
16 Vista Alegre B Vista Alegre 22 26 72 16
17 Vallvidrera Senglars A Vallvidrera 23 23 67 14
18 Unió Esportiva Poble Sec Unió 20 18 67 4
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Almeda Almeda 34 88 33 75
2 At. Iberia At. Iberia 34 91 51 73
3 Terlenka Terlenka 34 74 31 73
4 Gornal Gornal 34 101 50 70
5 Sant Genis-Penitentes CD Sant 34 82 48 68
6 Santa Eulàlia Santa 34 80 56 60
7 Turó Peira Turó Peira 34 61 63 50
8 Veterans Catalunya A Veterans 34 77 75 48
9 Carmelo CD Carmelo CD 34 69 73 44
10 Dinamic Batllo Esportiu Dinamic 33 56 59 41
11 Ciudad Cooperativa Ciudad 34 43 51 40
12 Sitges B Sitges B 33 58 70 40
13 Martinenc B Martinenc B 34 59 68 38
14 Unió Esportiva Poble Sec Unió 34 58 91 32
15 APA Poble Sec Poble 34 37 78 31
16 La Florida La Florida 34 46 98 27
17 Chacarita CF Chacarita 34 42 97 27
18 L'Esquerra FC A L'Esquerra 34 48 78 23
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Turó Peira Turó Peira 32 75 36 71
2 Pubilla Casas Pubilla 32 76 46 67
3 Sector Montserratina Sector 32 100 48 64
4 Terlenka Terlenka 32 64 35 62
5 Almeda Almeda 32 66 43 55
6 Can Buxeres Can Buxeres 32 58 52 53
7 Sants B Sants B 32 70 50 52
8 EJ Can Pi EJ Can Pi 32 75 61 51
9 At. Iberia At. Iberia 32 77 73 50
10 Ciudad Cooperativa Ciudad 32 67 58 47
11 L'Esquerra FC A L'Esquerra 32 48 47 44
12 Pujadas Pujadas 32 49 87 29
13 La Florida La Florida 32 51 82 29
14 Santa Eulalia B Santa 32 51 87 28
15 Veterans Catalunya A Veterans 32 50 78 26
16 Can Clota A Can Clota A 32 54 90 25
17 Canyelles B Canyelles B 32 39 97 19
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Prat B Prat B 32 80 41 73
2 Terlenka Terlenka 32 66 31 73
3 Pubilla Casas Pubilla 32 79 45 69
4 Iberiana 2013 Iberiana 32 92 56 65
5 Can Buxeres Can Buxeres 32 62 43 54
6 Sants B Sants B 32 65 49 51
7 Almeda Almeda 32 69 48 51
8 MBD Lions MBD Lions 32 49 58 42
9 L'Esquerra FC A L'Esquerra 32 43 51 37
10 Juv. 25 Setembre Juv. 32 45 52 37
11 Levante Las Planas Levante 32 43 76 35
12 Sarria B Sarria B 32 47 70 34
13 Espluguenc B Espluguenc 32 48 69 32
14 Can Roca 74 Can Roca 74 32 37 56 32
15 La Florida La Florida 32 45 65 29
16 Barceloneta Barceloneta 32 40 79 28
17 Vinyets Moli-Vell Vinyets 32 43 64 27
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Atletic Prat Atletic Prat 34 104 39 86
2 Dinamic Batllo Esportiu Dinamic 34 99 39 77
3 Catalonia UB Catalonia 34 88 44 69
4 Terlenka Terlenka 34 65 35 62
5 Santa Eulàlia Santa 34 85 45 57
6 Inter FM Inter FM 34 89 73 55
7 Levante Las Planas Levante 34 68 61 55
8 Pubilla Casas Pubilla 34 80 63 55
9 MBD Lions MBD Lions 34 74 70 51
10 Can Buxeres Can Buxeres 34 70 57 49
11 At. Iberia At. Iberia 34 79 65 48
12 Espluguenc B Espluguenc 34 60 60 46
13 Almeda Almeda 34 73 78 44
14 Unificació Ciutat Meridiana Unificació 34 51 67 33
15 Vinyets Moli-Vell B Vinyets 34 48 93 33
16 At. Hospitalense Hospitalense 34 63 78 31
17 Sant Just Desvern Sant Just D. 34 43 99 23
18 Don Bosco CF A Bosco 34 33 206 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Fontsanta Fatjo Fontsanta 34 92 33 85
2 Europa B Europa B 34 105 36 83
3 Levante Las Planas Levante 34 70 46 61
4 Can Buxeres Can Buxeres 34 82 61 52
5 At. Iberia At. Iberia 34 87 76 52
6 Santa Eulàlia Santa 34 82 90 52
7 Inter FM Inter FM 34 77 64 51
8 Atletic Prat Atletic Prat 34 55 47 49
9 At. Hospitalense Hospitalense 34 64 72 49
10 Pubilla Casas Pubilla 34 66 69 48
11 Pastrana-Baix Carmel Pastrana-Bai 34 69 76 47
12 Sant Just Desvern Sant Just D. 34 49 59 47
13 Almeda Almeda 34 55 69 40
14 Sant Pere Nord Sant Pere N. 34 75 93 36
15 Trinidad Trinidad 34 56 80 36
16 Fenicia-Fundacio Fenicia-Fund 34 50 74 33
17 Racing Vallbona Racing 34 55 90 26
18 Montbau Montbau 34 60 114 26

  USO DE MEMORIA  
5,719,784 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0730
Total Execution Time  0.0749
  CADENA URL  
/tercera_catalana2020/grupo10/historico
  GET DATOS  
$_GET['/tercera_catalana2020/grupo10/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera_catalana' AND (l.group_code = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2020 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 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 = 50752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 10 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022  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 `tables2020` 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 = 50752 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 44425 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2018` 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 = 39008 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 34089 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 16693 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 3968 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 05:51:30' 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=2 AND last_update > '2024-05-05 05:51:30' 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-05-05 05:51:30' 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=3 AND last_update > '2024-05-05 05:51:30' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 50752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50752 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.0020  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 events2020 e ON e.player_id = p.id AND e.league_id = 50752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50752 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  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 events2020 e ON e.player_id = p.id AND e.league_id = 50752 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50752 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0052  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2020` 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 = 50752 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC