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 Organyà Organyà 23 83 28 55
2 Bellpuig Bellpuig 23 47 22 46
3 Ponts Ponts 23 46 24 46
4 Gerard Gatell A.E. Gerard 23 57 33 44
5 La Seu d' Urgell Urgell 23 44 38 39
6 Torregrossa A Torregrossa 23 39 36 36
7 Pobla de Segur Pobla Segur 23 41 42 36
8 Tremp Tremp 23 32 30 35
9 Oliana Oliana 23 44 42 33
10 Solsona B Solsona B 23 47 48 27
11 Vilanova de L'aguda A Vilanova 23 41 62 27
12 Tora Tora 23 38 48 26
13 Bellcairenc Bellcairenc 23 33 50 26
14 Butsenit A Butsenit A 23 33 48 24
15 Ivars de Urgel A Ivars Urgel 23 30 43 23
16 Vallfogona de Balaguer Vallfogona 23 43 52 22
17 Tornabous Tornabous 23 27 41 22
18 La Fuliola La Fuliola 23 24 62 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Angulària Angulària 34 99 32 79
2 Bellpuig Bellpuig 34 92 41 70
3 La Seu d' Urgell Urgell 34 78 50 65
4 Torregrossa A Torregrossa 34 79 40 65
5 Pobla de Segur Pobla Segur 33 70 47 59
6 Solsona B Solsona B 34 73 55 56
7 Oliana Oliana 34 74 53 54
8 Tremp Tremp 34 53 56 48
9 Tornabous Tornabous 34 48 54 46
10 Ponts Ponts 34 49 54 46
11 Tora Tora 34 67 63 46
12 Ivars de Urgel A Ivars Urgel 34 46 62 41
13 Butsenit A Butsenit A 34 48 72 32
14 Vilanova de L'aguda A Vilanova 34 50 74 31
15 Bellcairenc Bellcairenc 34 46 75 30
16 Rialp F.C. Rialp F.C. 34 58 94 30
17 Guissona B Guissona B 33 47 84 30
18 Verdu-Vall del Corb A Verdu-Vall 34 46 117 18
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Gerard Gatell A.E. Gerard 34 138 37 93
2 Angulària Angulària 34 94 50 76
3 Ponts Ponts 34 69 34 75
4 La Seu d' Urgell Urgell 34 78 49 65
5 Bellcairenc Bellcairenc 34 71 48 61
6 Torregrossa A Torregrossa 34 58 43 60
7 Pobla de Segur Pobla Segur 34 86 56 59
8 Solsona B Solsona B 34 62 50 50
9 Butsenit A Butsenit A 34 57 50 46
10 Tora Tora 34 68 52 45
11 Arbeca Arbeca 34 79 89 44
12 Guissona B Guissona B 34 66 79 41
13 Oliana Oliana 34 40 99 30
14 Verdu-Vall del Corb A Verdu-Vall 33 44 68 29
15 Tornabous Tornabous 34 40 92 26
16 Rialp F.C. Rialp F.C. 34 43 115 24
17 Barbens A Barbens A 34 45 99 21
18 Vilanova de L'aguda A Vilanova 33 46 74 19
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Tremp Tremp 32 79 24 74
2 Vallfogona de Balaguer Vallfogona 32 81 35 69
3 Angulària Angulària 32 83 49 65
4 Bellcairenc Bellcairenc 32 81 56 62
5 Pobla de Segur Pobla Segur 32 69 44 54
6 Guissona B Guissona B 32 60 57 48
7 Vilanova de L'aguda A Vilanova 32 62 59 47
8 Ponts Ponts 32 47 43 46
9 Butsenit A Butsenit A 32 52 46 44
10 Tora Tora 32 72 77 40
11 Solsona B Solsona B 32 51 52 39
12 Tornabous Tornabous 32 39 53 36
13 Escola F.Tarrega Escola 32 65 88 35
14 Verdu-Vall del Corb A Verdu-Vall 32 55 81 33
15 Oliana Oliana 32 53 80 30
16 Cervera B Cervera B 32 47 85 28
17 Rialp F.C. Rialp F.C. 32 41 108 8
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Alcarràs Alcarràs 34 98 31 81
2 Angulària Angulària 34 90 45 77
3 Escola F.Tarrega Escola 34 90 37 77
4 At. Castellserà Castellserà 34 76 37 65
5 Ponts Ponts 34 71 50 59
6 Vallfogona de Balaguer Vallfogona 33 58 50 53
7 Arbeca Arbeca 34 66 66 52
8 Rialp F.C. Rialp F.C. 33 47 58 43
9 Solsona Solsona 34 38 58 42
10 Tremp Tremp 34 61 64 42
11 Pobla de Segur Pobla Segur 34 55 76 41
12 Bellcairenc Bellcairenc 34 69 74 39
13 Cervera B Cervera B 34 56 74 37
14 Verdu-Vall del Corb A Verdu-Vall 34 46 80 36
15 Guissona B Guissona B 34 54 88 35
16 Oliana Oliana 34 47 76 31
17 Tora Tora 34 53 90 30
18 Ivars de Urgel A Ivars Urgel 34 50 71 29
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Bellpuig Bellpuig 32 76 28 75
2 Rialp F.C. Rialp F.C. 32 75 21 65
3 Ponts Ponts 32 76 26 64
4 Bellvis Bellvis 32 58 50 60
5 Arbeca Arbeca 32 73 51 58
6 Pobla de Segur Pobla Segur 32 61 44 56
7 Escola F.Tarrega Escola 32 66 40 52
8 Solsona B Solsona B 32 56 40 50
9 Bellcairenc Bellcairenc 32 52 64 39
10 Vallfogona de Balaguer Vallfogona 32 57 72 36
11 Oliana Oliana 32 48 63 36
12 Miralcamp Miralcamp 32 42 63 32
13 Tora Tora 32 45 82 32
14 San Guim San Guim 32 48 60 31
15 Guissona B Guissona B 32 40 62 30
16 Tornabous Tornabous 32 39 72 26
17 La Fuliola La Fuliola 32 30 104 20

  USO DE MEMORIA  
5,702,296 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4057
Total Execution Time  0.4076
  CADENA URL  
/tercera_catalana2020/grupo14/historico
  GET DATOS  
$_GET['/tercera_catalana2020/grupo14/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0298  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 = 14 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=14 DESC LIMIT 1
0.0147  SELECT id,name,alias,stepParent FROM categories WHERE parentId=685 ORDER BY order_id ASC
0.0154  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 685 AND group_code = 14 and tables = 1 AND year <= 2020 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `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 = 50756 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.0153  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 = 44429 AND t.round = 34 ORDER BY team.conference 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 `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 = 39012 AND t.round = 34 ORDER BY team.conference 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 `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 = 34093 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 16685 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0156  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 = 3972 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 17:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:42:06' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  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 = 50756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50756 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.0148  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 = 50756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50756 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0354  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 = 50756 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50756 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 = 50756 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