4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Roque Balompie Sub 12
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 28 183 36 73
2 Sevilla Sub 12 B Sevilla 28 167 39 73
3 Doctor Fleming Sub 12 Doctor 28 117 40 65
4 Castilleja Sub 12 Castilleja 28 101 47 65
5 Camas CF Sub 12 Camas 28 115 61 54
6 San Roque Balompie Sub 12 Roque 28 111 72 50
7 Coria Sub 12 Coria 28 126 81 49
8 Juventud Gines Sub 12 Juventud 28 112 83 47
9 Umbrete Sub 12 Umbrete 28 105 89 40
10 Tomares Sub 12 B Tomares 28 90 125 30
11 Atletico Sanlucar Sub 12 Atletico 28 85 89 27
12 Montequinto Sub 12 Montequinto 28 63 136 27
13 Guillena Sub 12 Guillena 28 40 142 16
14 La Liara Sub 12 Liara 28 40 128 15
15 El Pilar Sub 12 Pilar 28 34 167 7
16 Mairena Del Aljarafe Sub 12 Mairena 28 51 205 6
TEMPORADA 2022/2023
1ª ANDALUZA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 30 174 23 86
2 Sevilla Sub 12 Sevilla 30 118 36 80
3 San Roque Balompie Sub 12 Roque 30 122 70 65
4 Cádiz Sub 12 Cádiz 30 122 57 62
5 Córdoba CF Sub 12 Córdoba 30 96 79 59
6 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 30 96 61 57
7 Atletico Seneca Sub 12 Atletico 30 110 78 53
8 Seneca CF Sub 12 Seneca 30 93 82 45
9 SAM-CAM Sub 12 SAM-CAM 30 102 117 30
10 RCR Huelva SAD Sub 12 Huelva 30 58 81 30
11 AD Taraguilla Sub 12 Taraguilla 30 77 142 27
12 Marismas del Polvorin Marismas 30 52 95 25
13 San Fernando Isleño Sub 12 Fernando 30 54 118 25
14 Don Bosco CF Bosco 30 56 123 19
15 Marianistas AD CD Marianistas 30 45 120 16
16 Xerez Deportivo Xerez 30 35 128 14
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 B Real Betis 30 169 24 85
2 San Roque Balompie Sub 12 Roque 29 183 43 76
3 Sevilla Sub 12 Sevilla 30 149 66 66
4 Montequinto Sub 12 Montequinto 30 101 73 54
5 Coria Sub 12 Coria 30 93 67 53
6 Tomares Sub 12 Tomares 30 108 57 52
7 Juventud Gines Sub 12 Juventud 30 104 97 48
8 Castilleja Sub 12 Castilleja 30 94 113 39
9 Camas A Camas A 29 80 112 35
10 C. Claret A C. Claret A 30 88 123 29
11 AD Dani Triana Ar Rabad A Dani Triana 30 67 123 29
12 Umbrete Sub 12 Umbrete 30 60 139 27
13 Bellavista A Bellavista 30 64 149 25
14 Asociación Nervion Sub 12 B Asociación 30 68 123 24
15 Sededos Sededos 28 62 89 23
16 Atlético Antoniano Atlético 30 54 146 18
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 7
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 10 70 3 30
2 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 10 46 13 27
3 Tomares Sub 12 Tomares 10 32 27 19
4 Sevilla Sub 12 B Sevilla 10 32 23 18
5 Tomares Sub 12 B Tomares 10 18 20 14
6 San Roque Balompie Sub 12 Roque 10 23 30 12
7 Castilleja Sub 12 Castilleja 10 19 44 10
8 CD Antonio Puerta Sub 12 Antonio 10 23 52 10
9 Camas A Camas A 10 21 47 4
10 Centro Historico Sub 12 Centro 10 15 40 1
TEMPORADA 2019/2020
2ª SEVILLA ALEVÍN (2ª FASE) GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Sub 12 Real Betis 9 70 6 24
2 Coria Sub 12 Coria 9 28 17 21
3 Asoc. Dva. Nervión Sub 12 Asoc. Dva.. 9 38 15 20
4 Viso Graphenstone Viso 9 27 40 12
5 Mosquito Sub 12 Mosquito 9 27 39 11
6 Centro Historico Sub 12 Centro 9 17 34 7
7 Castilleja Sub 12 Castilleja 9 18 48 7
8 San Roque Balompie Sub 12 Roque 9 12 38 3
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 4
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 B Sevilla 14 116 15 42
2 San Roque Balompie Sub 12 Roque 14 52 36 28
3 Utrera Sub 12 Utrera 14 47 35 26
4 Centro Historico Sub 12 Centro 14 39 37 24
5 Sededos Sededos 14 43 43 20
6 Bellavista Sub 12 Bellavista 14 43 51 16
7 CD Cabecense Cabecense 14 30 67 9
8 Los Caminantes Caminantes 14 19 105 0
TEMPORADA 2017/2018
2ª ANDALUZA SEVILLA ALEVÍN GRUPO 6
Equipo PJ GF GC Puntos
1 Sevilla Sub 12 B Sevilla 14 99 13 42
2 Utrera Sub 12 Utrera 14 58 37 31
3 Real Betis Balompie C Real Betis. 14 40 40 27
4 Sevilla Sub 12 Sevilla 14 49 40 25
5 San Roque Balompie Sub 12 Roque 14 33 52 16
6 Tomares Sub 12 Tomares 14 29 43 11
7 CD Antonio Puerta Sub 12 Antonio 14 30 65 8
8 SAM-CAM Sub 12 SAM-CAM 14 25 73 4

  USO DE MEMORIA  
5,271,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5261
Total Execution Time  0.5273
  CADENA URL  
/historico/San-Roque-Balompie-Alevin
  GET DATOS  
$_GET['/historico/San-Roque-Balompie-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0141  SELECT dt.*,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'San-Roque-Balompie-Alevin' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=92002 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=92002 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=92002 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0257  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74444
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=92002 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2499 AND type_rel = 3
0.0128  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '92002' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '92002' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '92002' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74444 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0130  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74449 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0139  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=92002 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0151  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74449,74444) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0127  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74444 AND teamId = 92002
0.0126  SELECT count(id) as num_players from rel_players_base WHERE league_id = 74449 AND teamId = 92002
0.0128  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '92002' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '92002' and rp.type = 4
0.0133  SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '92002' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0136  SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 92002 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0147  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_base` 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 = 74444 AND t.round = 29 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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_base` 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 = 74449 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `tables2023_base` 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 = 69626 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables2022_base` 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 = 64479 AND t.round = 30 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 `tables2021_base` 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 = 60532 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `tables2021_base` 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 = 62289 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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_base` 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 = 53212 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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_base` 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 = 55287 AND t.round = 14 ORDER BY team.conference ASC,t.position 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 `tables2019_base` 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 = 44977 AND t.round = 14 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_base` 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 = 42083 AND t.round = 14 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 `tables2018_base` 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 = 42862 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC