4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2017
Temporada Siguiente »
Tercera División 2017 G 10
2016/2017

Andalucia y Ceuta

Tercera División 2017 G 10

  • Betis Deportivo
  • Arcos CF
  • Écija Balompié
  • Algeciras CF
  • San Roque de Lepe
  • Sevilla C
  • Atlético Espeleño
  • Lebrijana
  • AD Ceuta FC
  • Utrera
  • CD Gerena
  • Los Barrios
  • CD Guadalcacín
  • Cabecense
  • Atlético Onubense
  • Castilleja
  • CD Alcalá
  • Atlético Antoniano
  • Coria CF
  • CD San Roque
  • Tercera División:

Clasificación

Equipo PJ GF GC Puntos
1 Betis Deportivo Betis 38 81 35 78
2 Arcos CF Arcos CF 38 76 39 73
3 Écija Balompié Écija 38 69 39 71
4 Algeciras CF Algeciras 38 66 34 69
5 San Roque de Lepe Roque Lepe 38 68 52 66
6 Sevilla C Sevilla C 38 55 39 58
7 Atlético Espeleño Atlético 38 63 56 57
8 Lebrijana Lebrijana 38 45 48 56
9 AD Ceuta FC AD Ceuta FC 38 45 39 56
10 Utrera Utrera 38 49 50 51
11 CD Gerena CD Gerena 38 53 53 49
12 Los Barrios Los Barrios 38 31 44 47
13 CD Guadalcacín Guadalcacín 38 42 57 47
14 Cabecense Cabecense 38 47 64 43
15 Atlético Onubense Atlético 38 45 66 43
16 Castilleja Castilleja 38 44 55 41
17 CD Alcalá CD Alcalá 38 37 65 41
18 Atlético Antoniano Atlético 38 38 59 40
19 Coria CF Coria CF 38 48 66 36
20 CD San Roque Roque 38 37 79 21

  USO DE MEMORIA  
5,626,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3635
Total Execution Time  0.3655
  CADENA URL  
/tercera2017/grupo10/resumen/38
  GET DATOS  
$_GET['/tercera2017/grupo10/resumen/38']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (12)  
0.0258  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera' AND (l.group_code = 10 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2017 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=10 DESC LIMIT 1
0.0131  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 = 33360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0140  SELECT 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 FROM `calendars2017` 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` = 33360 AND c.`round` = 38 ORDER BY shedule ASC LIMIT 200
0.0258  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2017` e INNER JOIN calendars2017 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 38 AND e.real_date IS NOT NULL AND e.league_id = 33360 ORDER BY total DESC LIMIT 100
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 07:48:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0129  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 07:48:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 07:48:46' 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-05-08 07:48:46' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0300  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 events2017 e ON e.player_id = p.id AND e.league_id = 33360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33360 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.0560  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 events2017 e ON e.player_id = p.id AND e.league_id = 33360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33360 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0162  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 events2017 e ON e.player_id = p.id AND e.league_id = 33360 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 33360 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0258  SELECT *,(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 = 33360 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC