4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Levante Las Planas Levante 17 49 14 44
2 Olesa Olesa 17 50 21 43
3 Corbera Corbera 17 51 26 36
4 Pallejà Pallejà 17 31 23 28
5 PR Sant Feliu Ll. Sant Feliu 17 29 35 26
6 Juv. 25 Setembre Juv. 17 36 31 25
7 Sant Andreu de la Barca B Sant Andreu 17 33 36 23
8 Mirasol-Baco Mirasol-Baco 17 32 36 23
9 Esparreguera Esparreguera 17 34 41 22
10 Rubí B Rubí B 17 38 38 20
11 Papiol Papiol 17 32 33 20
12 Sant Esteve Sesrovires Sant Esteve 17 33 39 20
13 Incresa Incresa 17 35 43 20
14 Junior Junior 17 38 38 19
15 Abrera Abrera 17 27 35 18
16 Cervelló Cervelló 17 20 34 17
17 Castellbisbal Castellbisba 17 18 35 17
18 La Palma Cervelló Palma 17 30 58 8
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Terlenka Terlenka 23 61 14 63
2 PR Sant Feliu Ll. Sant Feliu 23 48 25 49
3 Sant Vicenç H. Sant Vicenç 23 54 32 45
4 Prat B Prat B 23 35 29 40
5 Viladecans B Viladecans 23 43 29 39
6 Sector Montserratina Sector 23 57 44 36
7 Vinyets Moli-Vell Vinyets 23 46 40 33
8 PUD Málaga PUD Málaga 23 48 44 33
9 Abrera Abrera 23 38 42 31
10 Ciudad Cooperativa Ciudad 23 41 48 29
11 Sant Esteve Sesrovires Sant Esteve 23 46 50 27
12 Pallejà Pallejà 23 36 44 26
13 Castelldefels B Castelldefel 23 23 30 25
14 Olesa Olesa 23 35 68 24
15 Can Roca 74 Can Roca 74 23 36 56 23
16 Incresa Incresa 23 29 42 20
17 La Palma Cervelló Palma 23 35 48 18
18 Sant Andreu de la Barca B Sant Andreu 23 36 62 17
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Sant Joan Despi UE Sant Joan D. 34 78 30 79
2 Sant Andreu de la Barca Sant Andreu 34 100 34 76
3 PR Sant Feliu Ll. Sant Feliu 34 68 38 72
4 Sant Vicenç H. Sant Vicenç 34 89 46 71
5 Levante Las Planas Levante 34 74 45 68
6 Abrera Abrera 34 79 50 63
7 Olesa Olesa 34 83 61 58
8 Pallejà Pallejà 34 63 51 55
9 Corbera Corbera 34 69 63 45
10 Sector Montserratina Sector 34 59 74 42
11 Incresa Incresa 34 54 61 40
12 Can Roca 74 Can Roca 74 34 51 83 39
13 Vinyets Moli-Vell Vinyets 34 54 75 34
14 Viladecans B Viladecans 34 52 73 34
15 Castelldefels B Castelldefel 34 51 84 32
16 Sant Esteve Sesrovires Sant Esteve 34 40 75 30
17 Torrelles Torrelles 34 39 68 23
18 Vallirana Vallirana 34 35 127 9
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Martorell Martorell 34 100 24 80
2 PUD Málaga PUD Málaga 34 97 42 77
3 Pallejà Pallejà 34 82 38 77
4 PB Sant Vicenç H. Sant Vicenç 34 80 61 57
5 Corbera Corbera 34 89 67 56
6 Vallirana Vallirana 34 71 58 55
7 PR Sant Feliu Ll. Sant Feliu 34 72 57 51
8 Levante Las Planas Levante 34 63 60 50
9 Viladecans B Viladecans 34 70 68 49
10 Sant Andreu de la Barca B Sant Andreu 34 69 82 44
11 Abrera Abrera 34 58 69 40
12 Sant Esteve Sesrovires Sant Esteve 34 85 97 39
13 Castelldefels B Castelldefel 34 62 81 38
14 Olesa Olesa 34 75 98 36
15 Torrelles Torrelles 34 44 80 35
16 Can Roca 74 Can Roca 74 34 52 78 35
17 Cervelló Cervelló 34 46 108 20
18 San Mauro B San Mauro B 34 56 103 18
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Molins de Rei Molins 34 81 33 70
2 Sant Andreu de la Barca Sant Andreu 34 73 32 70
3 Sant Esteve Sesrovires Sant Esteve 34 97 70 65
4 Torrelles Torrelles 34 59 47 60
5 Pallejà Pallejà 34 61 44 58
6 Vallirana Vallirana 34 65 49 56
7 PR Sant Feliu Ll. Sant Feliu 34 62 60 51
8 Sector Montserratina Sector 34 61 57 48
9 Castelldefels B Castelldefel 34 58 60 47
10 Olesa Olesa 34 62 72 47
11 Cervelló Cervelló 34 67 63 45
12 PB Sant Vicenç H. Sant Vicenç 34 70 79 45
13 PUD Málaga PUD Málaga 34 66 59 44
14 Viladecans B Viladecans 34 51 55 43
15 Abrera Abrera 34 67 83 40
16 Martorell B Martorell B 34 57 73 30
17 Esparreguera Athletic Club Esparreguera 34 56 88 25
18 Papiol Papiol 34 32 121 11
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Ciudad Cooperativa Ciudad 34 79 35 73
2 Sant Andreu de la Barca Sant Andreu 34 85 42 73
3 Sector Montserratina Sector 34 84 41 72
4 Molins de Rei Molins 34 64 53 56
5 Olesa Olesa 34 85 72 53
6 Viladecans B Viladecans 34 56 50 50
7 Pallejà Pallejà 34 73 73 49
8 Papiol Papiol 34 55 60 46
9 Sant Esteve Sesrovires Sant Esteve 34 79 90 44
10 Martorell Martorell 34 76 70 43
11 Castelldefels B Castelldefel 34 77 74 42
12 Cervelló Cervelló 34 77 94 42
13 PUD Málaga PUD Málaga 34 81 82 41
14 PR Sant Feliu Ll. Sant Feliu 34 66 98 40
15 Abrera Abrera 34 59 81 37
16 Corbera Corbera 34 70 88 37
17 La Guardia La Guardia 34 60 94 35
18 Vinyets Moli-Vell Vinyets 34 55 84 25
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Vallirana Vallirana 34 91 54 78
2 Torrelles Torrelles 34 69 34 74
3 Molins de Rei Molins 34 74 40 74
4 Olesa Olesa 34 87 49 69
5 La Guardia La Guardia 34 79 64 62
6 Ciudad Cooperativa Ciudad 34 67 51 56
7 PR Sant Feliu Ll. Sant Feliu 34 80 57 52
8 Sant Esteve Sesrovires Sant Esteve 34 62 67 48
9 Papiol Papiol 34 60 64 44
10 Sector Montserratina Sector 34 67 77 44
11 Castelldefels B Castelldefel 34 67 65 42
12 Vinyets Moli-Vell Vinyets 34 63 75 40
13 Corbera Corbera 34 57 72 40
14 Cervelló Cervelló 34 52 73 36
15 Pallejà Pallejà 34 67 72 33
16 La Palma Cervelló Palma 34 73 107 32
17 Incresa Incresa 34 40 92 19
18 Esparreguera Esparreguera 34 39 81 16

  USO DE MEMORIA  
5,862,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3866
Total Execution Time  0.3886
  CADENA URL  
/tercera_catalana2021/grupo8/historico
  GET DATOS  
$_GET['/tercera_catalana2021/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (21)  
0.0257  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 = 8 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=8 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=685 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 685 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (979937,978211,935979,930202,887509) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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 = 58792 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 8 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0137  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 = 58792 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.0129  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 = 50750 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.0129  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 = 44423 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 39006 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 34087 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 16691 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 3966 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 19:36:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 19:36:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 19:36:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 19:36:01' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  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 events2021 e ON e.player_id = p.id AND e.league_id = 58792 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58792 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.0127  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 events2021 e ON e.player_id = p.id AND e.league_id = 58792 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58792 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2021 e ON e.player_id = p.id AND e.league_id = 58792 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 58792 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0135  SELECT *,(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 = 58792 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