4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rinconada C. A
TEMPORADA 2021/2022
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peñaflor Sub 12 Peñaflor 26 149 42 65
2 Rinconada C. A Rinconada 26 128 52 62
3 Villaverde Villaverde 26 131 70 53
4 Brenes Balompie A Brenes 26 111 62 53
5 Minas Minas 26 106 56 51
6 Campana Campana 26 115 73 48
7 Esfubasa Sub 12 Esfubasa 26 115 73 47
8 AD San José Sub 12 José 26 92 79 36
9 Burguillos Burguillos 25 58 76 29
10 CD Multideporte Tocina Los Multideporte 26 74 116 24
11 A. Algabeño A Algabeño 26 51 102 18
12 Lora Lora 25 66 146 16
13 Priorato Juventud de Futbol Priorato 26 54 155 15
14 Alcolea Rio Alcolea Rio 26 33 181 9
TEMPORADA 2018/2019
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 1
Equipo PJ GF GC Puntos
1 Peñaflor Sub 12 Peñaflor 26 243 63 69
2 Rinconada C. A Rinconada 26 177 41 68
3 Villaverde Villaverde 26 187 70 60
4 Brenes Balompie A Brenes 26 176 61 55
5 Priorato Juventud de Futbol Priorato 26 146 70 55
6 A. Algabeño A Algabeño 26 126 81 48
7 Cantillana Cantillana 26 88 119 38
8 Campana Campana 26 86 121 37
9 Burguillos Burguillos 26 106 88 30
10 Lora Lora 26 93 101 30
11 Alcolea Rio Alcolea Rio 26 82 151 24
12 AD San José Sub 12 José 26 46 150 13
13 Minas Minas 26 59 193 10
14 Alcala Rio A Alcala 0 0 0 0
15 Guillena Sub 12 Guillena 26 39 255 0
TEMPORADA 2017/2018
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 2
Equipo PJ GF GC Puntos
1 Esfubasa A Esfubasa A 30 236 58 81
2 Brenes Balompie A Brenes 30 181 52 81
3 Valencina A Valencina A 30 177 49 78
4 M. Aljarafe C Aljarafe 30 190 61 77
5 Rinconada C. A Rinconada 30 139 86 59
6 Mun. Gerena Mun. Gerena 30 121 103 50
7 Alcala Rio B Alcala 30 143 107 48
8 A. Algabeño B Algabeño 30 165 159 45
9 Olivarense A. A Olivarense 30 120 125 42
10 Esp. Tilde B Esp. Tilde 30 119 131 35
11 Aznalcollar Aznalcollar 30 93 128 29
12 Salteras C Salteras C 30 89 177 22
13 Santiponce Sub 12 B Santiponce 30 103 195 22
14 Camas Sub 12 B Camas 30 79 137 19
15 Castilleja B Castilleja 30 81 225 12
16 Guillena Sub 12 Guillena 30 56 255 3
TEMPORADA 2016/2017
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 10
Equipo PJ GF GC Puntos
1 Aficionado de Ecija Sub 12 Aficionado 30 255 33 90
2 CP Bormujos B Bormujos 30 180 64 73
3 San Roque Balompie E Roque 30 176 44 70
4 Alcala Rio A Alcala 29 174 78 70
5 AD San José Sub 12 José 30 166 67 63
6 Villaverde Villaverde 30 116 74 58
7 Rinconada C. A Rinconada 30 127 77 54
8 Cantillana Cantillana 30 87 97 39
9 Campana Campana 30 84 121 37
10 A. Algabeño A Algabeño 30 76 144 30
11 Mun. Gerena Mun. Gerena 29 73 107 28
12 Espartinas Tilde Espartinas 30 78 155 28
13 Brenes B. Brenes B. 30 88 134 27
14 Alcolea Rio Alcolea Rio 30 73 143 27
15 Minas Minas 30 41 255 5
16 Aznalcollar Aznalcollar 30 42 253 4
TEMPORADA 2015/2016
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Alcolea Rio Alcolea Rio 24 215 39 64
2 Carmona Sub 12 Carmona 24 155 30 57
3 Lora Lora 24 125 58 56
4 Esfubasa A Esfubasa A 24 150 32 55
5 Camino Viejo A Camino Viejo 24 131 73 42
6 Alcala del Rio Alcala 24 133 88 39
7 Villaverde Villaverde 24 104 62 35
8 Campana Campana 24 91 59 35
9 San Jose A San Jose A 24 83 75 34
10 Brenes B. Brenes B. 24 58 123 16
11 Espartinas Tilde Espartinas 24 30 165 13
12 A. Algabeño A Algabeño 24 36 255 3
13 Minas Minas 24 20 255 3
14 M. Aljarafe A Aljarafe 0 0 0 0
15 Peña Betica de Tocina Peña Betica 0 0 0 0
16 Rinconada C. A Rinconada 0 0 0 0
TEMPORADA 2014/2015
4ª ANDALUZA SEVILLA ALEVÍN GRUPO 5
Equipo PJ GF GC Puntos
1 Cantillana Cantillana 22 153 27 59
2 Alcolea Rio Alcolea Rio 22 192 55 49
3 La Negrilla A Negrilla 22 166 64 46
4 San Jose A San Jose A 22 163 66 43
5 Villaverde Villaverde 22 161 77 40
6 Esfubasa Sub 12 Esfubasa 22 107 53 40
7 Campana Campana 22 112 66 40
8 Brenes B. Brenes B. 22 126 61 35
9 C. Claret C C. Claret C 22 59 182 14
10 A. Algabeño B Algabeño 22 49 231 12
11 Alcala Rio B Alcala 22 52 230 10
12 Rinconada C. A Rinconada 22 22 250 1
13 R. Forja XXI Forja 0 0 0 0

  USO DE MEMORIA  
5,177,792 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3861
Total Execution Time  0.3881
  CADENA URL  
/historico/Cd-Rinconada-Cantera-A-Alevin
  GET DATOS  
$_GET['/historico/Cd-Rinconada-Cantera-A-Alevin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0294  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 = 64770
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=44461 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1118 AND type_rel = 3
0.0146  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 = '44461' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 64770 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  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=44461 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (64770) 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.0145  SELECT count(id) as num_players from rel_players_base WHERE league_id = 64770 AND teamId = 44461
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 FROM `tables2022` 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 = 64770 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '44461' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0147  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 = '44461' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 44461 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 64770 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.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 `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 = 45198 AND t.round = 30 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_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 = 42163 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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_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 = 35009 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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_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 = 17917 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 6912 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC