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 Papiol Papiol 21 67 22 53
2 Levante las Planas B Levante 20 58 25 49
3 Cervello A Cervello A 19 81 29 45
4 Sant Vicenç H.-At Vicenci E Sant Vicenç 21 67 35 45
5 Vallirana Vallirana 19 68 34 34
6 Palleja CF B Palleja 19 37 32 32
7 Corbera B Corbera B 20 51 49 32
8 Esparreguera Athletic Club Esparreguera 20 60 45 29
9 Torrelles Torrelles 21 52 43 29
10 Sant Vicenç Dels Horts 2014 Sant Vicenç 20 40 39 25
11 Sant Joan Despi B Sant Joan D. 20 35 67 24
12 La Guardia La Guardia 19 40 53 22
13 Eusebi Guell A Eusebi Guell 21 34 58 17
14 Molins de Rei B Molins 21 37 68 15
15 Blanc Blava Sant Feliu A Blanc Blava 19 22 67 12
16 Sant Just Desvern B Sant Just D. 20 13 96 1
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 PB Sant Vicenç H. Sant Vicenç 29 86 30 71
2 La Palma Cervello A A Palma 29 90 47 66
3 Sant Lluis Associació Espor Sant Lluis. 29 90 50 61
4 Esparreguera Athletic Club Esparreguera 28 81 48 54
5 Sant Just Desvern Sant Just D. 30 68 57 52
6 Molins de Rei B Molins 30 50 49 45
7 Papiol Papiol 28 73 57 41
8 Can Clota A Can Clota A 29 45 62 37
9 Cervello A Cervello A 27 50 51 33
10 Eusebi Guell A Eusebi Guell 30 55 78 31
11 San Pancracio A Pancracio 30 65 91 31
12 Sant Vicenç H.-At Vicenci E Sant Vicenç 28 45 52 30
13 Almeda B Almeda B 30 62 97 29
14 Palleja CF B Palleja 30 48 63 27
15 Corbera B Corbera B 29 56 104 27
16 Abrera B Abrera B 30 41 69 21
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Marina-Escola Joan Murtro Marina-Escol 29 97 35 71
2 Montsant de La Peira Montsant 27 95 31 65
3 Escola Barbera Andalucia B Escola 27 94 29 59
4 Cercle Sabadellès Cercle 29 94 53 57
5 Sabadellenca B Sabadellenca 29 91 52 55
6 Bellaterra A Bellaterra 30 69 54 49
7 Escuela F. Base Ripollet Escuela Base 29 61 42 47
8 Apa Poble Sec B Poble 29 68 59 45
9 Can Mas Can Mas 29 58 83 36
10 Congrés Club Esportiu A Congrés 28 59 71 35
11 Roureda A Roureda A 28 79 74 31
12 Vallvidrera Senglars B Vallvidrera 30 49 98 23
13 San Jorge 23 D'Abril CE A Jorge 27 48 108 20
14 Ath. Barcelona Pubilla B Ath. 28 46 114 18
15 Santa Maria Montcada B Santa Maria 28 44 90 17
16 Piferrer B B Piferrer 25 19 78 12
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Athletic Rubi Club Futbol A Athletic 27 94 26 68
2 LliÇa D'amunt A A LliÇa 27 92 34 60
3 La Llagosta A Llagosta 28 74 37 56
4 Can Mas Can Mas 27 86 43 52
5 Martorelles Martorelles 27 72 56 51
6 Cercle Sabadellès Cercle 28 54 40 51
7 Sentmenat A Sentmenat A 27 74 54 50
8 Roureda A Roureda A 26 80 73 43
9 Montornés Norte Montornés 28 69 65 43
10 Sant Fost A Sant Fost A 28 68 62 38
11 Sabadellenca B Sabadellenca 28 87 78 37
12 Escuela F. Base Ripollet Escuela Base 28 58 82 24
13 Unificación Santa Perpetua Unificación 28 52 85 22
14 Sentmenat A Sentmenat A 28 30 131 4
15 Finsobe A A Finsobe A A 27 15 139 3
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Lourdes A Lourdes A 28 104 29 69
2 Sta. Maria Montcada Sta. Maria. 28 100 42 65
3 Llano de Sabadell B Llano 27 92 40 62
4 Can Mas Can Mas 28 75 37 55
5 La Llagosta A Llagosta 28 71 37 52
6 CF Montornes A Montornes 28 73 38 51
7 Sant Fost A Sant Fost A 28 58 42 51
8 Sabadellenca B Sabadellenca 28 69 61 44
9 Cerdanyola del Valles B Cerdanyola 27 65 61 39
10 Polinya At. Polinya At. 28 72 70 37
11 Sentmenat A Sentmenat A 29 52 66 30
12 Canovelles B Canovelles 28 56 100 24
13 CE Lliça D'Amunt B Lliça 28 31 97 14
14 Lliça D'Amunt CA A Lliça 27 33 98 11
15 Sentmenat A Sentmenat A 26 8 141 1
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Veterans Catalunya A Veterans 28 115 27 75
2 Montcada B Montcada B 28 95 26 68
3 Montornés Norte Montornés 28 85 33 63
4 Besos At. A Besos At. A 28 65 41 56
5 Blaugrana Sant Cugat A Blaugrana 28 83 64 47
6 Blanc Blava la Roca A Blanc Blava 28 67 57 45
7 Lourdes A Lourdes A 28 84 53 44
8 Molletense B Molletense 28 58 73 41
9 La Llagosta A Llagosta 28 58 59 40
10 Sant Fost A Sant Fost A 28 63 53 39
11 CF Montornes A Montornes 28 49 72 32
12 Santa Agnes A Santa Agnes 28 46 74 32
13 Palau Solita i Plegamans B Palau Solita 28 27 92 13
14 Catalonia B Catalonia B 28 24 101 11
15 Polinya B Polinya B 28 17 111 3

  USO DE MEMORIA  
5,521,280 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0034
Controller Execution Time ( Home / Category )  0.1909
Total Execution Time  0.1943
  CADENA URL  
/cuarta_catalana2020/grupo8/historico
  GET DATOS  
$_GET['/cuarta_catalana2020/grupo8/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0085  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'cuarta_catalana' AND (l.group_code = 8 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=8 DESC LIMIT 1
0.0021  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 = 51602 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0025  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 745 AND group_code = 8 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0025  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 = 51602 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0032  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 = 45625 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 39935 AND t.round = 30 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 `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 = 36072 AND t.round = 30 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 `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 = 16965 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 4738 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 08:11:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 08:11:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 08:11:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0068  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 08:11:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0027  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 = 51602 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51602 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.0046  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 = 51602 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51602 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0024  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 = 51602 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 51602 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0055  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 = 51602 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC