4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2024
 
Publicidad 600x120.gif
3ª Catalana
2023/2024

3ª Catalana

  • Cardona
  • Avià
  • Can Trias
  • CE Avinyo
  • Pirinaica B
  • Súria
  • Viladecavalls
  • Joanenc B
  • Fruitosenc
  • Sant Pau Manresa UE A
  • Navas B
  • Sallent
  • Balconada UE
  • Navarcles
  • Calaf
  • Pare Ignasi Puig A
Resultados
« Jornada Anterior
Jornada 27
Jornada Siguiente »
 
27 Abr 24
16:00 Finalizado 		Navarcles Navarcles 1-2 Sant Pau Manresa UE A Sant Pau Manresa UE A más información ...
 
27 Abr 24
16:30 Finalizado 		Pirinaica B Pirinaica B 0-3 Avià Avià más información ...
 
27 Abr 24
16:30 Finalizado 		CE Avinyo CE Avinyo 6-3 Pare Ignasi Puig A Pare Ignasi Puig A más información ...
 
27 Abr 24
17:00 Aplazado 		Fruitosenc Fruitosenc Apl Cardona Cardona más información ...
 
27 Abr 24
18:00 Finalizado 		Can Trias Can Trias 2-1 Navas B Navas B más información ...
 
28 Abr 24
Sin comenzar 		Balconada UE Balconada UE
12:00
 		Joanenc B Joanenc B más información ...
 
28 Abr 24
Sin comenzar 		Súria Súria
16:00
 		Calaf Calaf más información ...
 
28 Abr 24
Sin comenzar 		Viladecavalls Viladecavalls
18:30
 		Sallent Sallent más información ...
Clasificación
« Jornada Anterior
Jornada 27
Jornada Siguiente »
Equipos Puntos J. G. E. P. F. C. Forma
1 Cardona Cardona 66 26 21 3 2 76 27
  • VICTORIA
  • Calaf 0
  • Cardona 2
  • VICTORIA
  • Cardona 4
  • Navas B 0
  • DERROTA
  • Joanenc B 4
  • Cardona 1
  • VICTORIA
  • Cardona 7
  • Pare Ignasi Puig A 0
  • VICTORIA
  • Cardona 3
  • Viladecavalls 2
2 Avià Avià 65 27 20 5 2 87 48
  • VICTORIA
  • CE Avinyo 2
  • Avià 5
  • EMPATE
  • Avià 1
  • Balconada UE 1
  • EMPATE
  • Can Trias 2
  • Avià 2
  • VICTORIA
  • Avià 3
  • Súria 2
  • VICTORIA
  • Pirinaica B 0
  • Avià 3
3 Can Trias Can Trias 51 27 15 6 6 60 38
  • VICTORIA
  • Can Trias 2
  • Sallent 1
  • VICTORIA
  • Sant Pau Manresa U. 2
  • Can Trias 3
  • EMPATE
  • Can Trias 2
  • Avià 2
  • EMPATE
  • Calaf 1
  • Can Trias 1
  • VICTORIA
  • Can Trias 2
  • Navas B 1
4 CE Avinyo CE Avinyo 49 27 14 7 6 64 48
  • DERROTA
  • CE Avinyo 2
  • Avià 5
  • VICTORIA
  • Calaf 1
  • CE Avinyo 2
  • VICTORIA
  • CE Avinyo 3
  • Navas B 0
  • VICTORIA
  • Joanenc B 3
  • CE Avinyo 4
  • VICTORIA
  • CE Avinyo 6
  • Pare Ignasi Puig A 3
5 Pirinaica B Pirinaica B 47 27 14 5 8 58 39
  • EMPATE
  • Viladecavalls 2
  • Pirinaica B 2
  • DERROTA
  • Navarcles 3
  • Pirinaica B 1
  • VICTORIA
  • Pirinaica B 3
  • Sallent 0
  • VICTORIA
  • Sant Pau Manresa U. 0
  • Pirinaica B 1
  • DERROTA
  • Pirinaica B 0
  • Avià 3
6 Súria Súria 44 26 13 5 8 68 49
  • EMPATE
  • Pirinaica B 1
  • Súria 1
  • VICTORIA
  • Súria 2
  • Navarcles 1
  • EMPATE
  • Sallent 2
  • Súria 2
  • VICTORIA
  • Súria 4
  • Sant Pau Manresa U. 2
  • DERROTA
  • Avià 3
  • Súria 2
7 Viladecavalls Viladecavalls 43 26 13 4 9 58 42
  • VICTORIA
  • Joanenc B 1
  • Viladecavalls 2
  • EMPATE
  • Viladecavalls 2
  • Pirinaica B 2
  • VICTORIA
  • Pare Ignasi Puig A 0
  • Viladecavalls 5
  • VICTORIA
  • Viladecavalls 3
  • Navarcles 0
  • DERROTA
  • Cardona 3
  • Viladecavalls 2
8 Joanenc B Joanenc B 41 26 12 5 9 41 36
  • DERROTA
  • Joanenc B 1
  • Viladecavalls 2
  • VICTORIA
  • Pare Ignasi Puig A 0
  • Joanenc B 1
  • VICTORIA
  • Joanenc B 4
  • Cardona 1
  • DERROTA
  • Fruitosenc 2
  • Joanenc B 1
  • DERROTA
  • Joanenc B 3
  • CE Avinyo 4
9 Fruitosenc Fruitosenc 38 25 11 5 9 46 44
  • DERROTA
  • Fruitosenc 0
  • Sant Pau Manresa U. 2
  • DERROTA
  • Avià 2
  • Fruitosenc 1
  • VICTORIA
  • Fruitosenc 6
  • Calaf 2
  • DERROTA
  • Navas B 2
  • Fruitosenc 1
  • VICTORIA
  • Fruitosenc 2
  • Joanenc B 1
10 Sant Pau Manresa UE A Sant Manresa 30 27 9 3 15 43 52
  • EMPATE
  • Balconada UE 1
  • Sant Pau Manresa U. 1
  • DERROTA
  • Sant Pau Manresa U. 2
  • Can Trias 3
  • DERROTA
  • Súria 4
  • Sant Pau Manresa U. 2
  • DERROTA
  • Sant Pau Manresa U. 0
  • Pirinaica B 1
  • VICTORIA
  • Navarcles 1
  • Sant Pau Manresa U. 2
11 Navas B Navas B 28 26 9 1 16 39 55
  • DERROTA
  • Cardona 4
  • Navas B 0
  • VICTORIA
  • Navas B 2
  • Fruitosenc 1
  • DERROTA
  • CE Avinyo 3
  • Navas B 0
  • DERROTA
  • Navas B 0
  • Balconada UE 2
  • DERROTA
  • Can Trias 2
  • Navas B 1
12 Sallent Sallent 28 26 8 4 14 44 55
  • VICTORIA
  • Sallent 1
  • Balconada UE 0
  • DERROTA
  • Can Trias 2
  • Sallent 1
  • EMPATE
  • Sallent 2
  • Súria 2
  • DERROTA
  • Pirinaica B 3
  • Sallent 0
  • VICTORIA
  • Sallent 3
  • Navarcles 2
13 Balconada UE Balconada UE 25 26 6 7 13 38 60
  • DERROTA
  • Sallent 1
  • Balconada UE 0
  • EMPATE
  • Balconada UE 1
  • Sant Pau Manresa U. 1
  • EMPATE
  • Avià 1
  • Balconada UE 1
  • VICTORIA
  • Balconada UE 4
  • Calaf 1
  • VICTORIA
  • Navas B 0
  • Balconada UE 2
14 Navarcles Navarcles 22 27 6 4 17 44 70
  • DERROTA
  • Súria 2
  • Navarcles 1
  • VICTORIA
  • Navarcles 3
  • Pirinaica B 1
  • DERROTA
  • Viladecavalls 3
  • Navarcles 0
  • DERROTA
  • Sallent 3
  • Navarcles 2
  • DERROTA
  • Navarcles 1
  • Sant Pau Manresa U. 2
15 Calaf Calaf 14 26 4 2 20 29 68
  • DERROTA
  • Calaf 0
  • Cardona 2
  • DERROTA
  • Fruitosenc 6
  • Calaf 2
  • DERROTA
  • Calaf 1
  • CE Avinyo 2
  • DERROTA
  • Balconada UE 4
  • Calaf 1
  • EMPATE
  • Calaf 1
  • Can Trias 1
16 Pare Ignasi Puig A Pare Ignasi Puig 6 25 2 0 23 25 89
  • VICTORIA
  • Pare Ignasi Puig A 4
  • Calaf 3
  • DERROTA
  • Pare Ignasi Puig A 0
  • Joanenc B 1
  • DERROTA
  • Pare Ignasi Puig A 0
  • Viladecavalls 5
  • DERROTA
  • Cardona 7
  • Pare Ignasi Puig A 0
  • DERROTA
  • CE Avinyo 6
  • Pare Ignasi Puig A 3
Ascenso : Cardona
Descenso : Navarcles, Calaf, Pare Ignasi Puig


  USO DE MEMORIA  
5,311,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2837
Total Execution Time  0.2856
  CADENA URL  
/tercera_catalana/grupo8
  GET DATOS  
$_GET['/tercera_catalana/grupo8']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0295  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) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=8 DESC LIMIT 1
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 05:34:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0144  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 05:34:19' 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 05:34:19' 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 05:34:19' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0148  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2024` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 73175 AND c.`round` = 27 ORDER BY shedule ASC LIMIT 200
0.0146  SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 73175 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (418851,418852,418856,418857,418854,418855,418853,418850) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0148  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 = 73175 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0155  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 = 73175 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  SELECT data1, data2 FROM services_tags WHERE categoryId=685
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=685 AND year=2024