4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Divina Pastora Sanluqueña
TEMPORADA 2021/2022
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Grupo Empresa Bazán CF Grupo 33 92 36 74
2 Barbate Barbate 34 81 30 71
3 Castellar UD Castellar 34 73 43 67
4 RB Linense B Linense 33 80 40 65
5 Chipiona CF Chipiona CF 33 55 43 57
6 CD El Torno 2009 Torno 2009 34 66 51 54
7 Ciudad De Cadiz PCD Ciudad Cadiz 34 55 58 51
8 Aficion Xerecista Aficion 33 52 49 49
9 CD Vejer Balompié Vejer 34 37 40 47
10 J. Sanluqueña Sanluqueña 33 51 62 47
11 Tarifa UD Tarifa UD 33 49 61 44
12 Federico Mayo C.F. Federico 33 49 61 40
13 Nextstars Nextstars 33 53 55 38
14 Divina Pastora Sanluqueña Divina 33 50 80 34
15 Sherry Atlético Sherry 33 42 71 30
16 San Jose Obrero UD Jose Obrero 33 50 70 27
17 Alcalá del Valle Alcalá 22 16 47 18
18 Novo Chiclana Novo 33 21 75 11
TEMPORADA 2020/2021
2ª ANDALUZA CÁDIZ GRUPO 1
Equipo PJ GF GC Puntos
1 Rayo Sanluqueño Rayo 16 37 12 36
2 CD Jédula CD Jédula 15 31 13 28
3 Castellar UD Castellar 16 29 22 28
4 Aficion Xerecista Aficion 16 24 20 24
5 San Jose Obrero UD Jose Obrero 16 20 22 20
6 Ud Bornense Ud Bornense 16 24 26 19
7 Divina Pastora Sanluqueña Divina 16 28 34 18
8 J. Sanluqueña Sanluqueña 15 21 27 18
9 Alma de África Alma África 16 17 55 7
TEMPORADA 2019/2020
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Guadiaro Guadiaro 25 79 17 69
2 Los Cortijillos Cortijillos 25 53 20 55
3 UD Algaida UD Algaida 25 56 24 48
4 Xerez Deportivo B Xerez 25 65 34 47
5 CD Jédula CD Jédula 25 45 33 41
6 San Fernando CD B Fernando 25 42 34 41
7 CD Rivera CD Rivera 25 36 30 40
8 RC Portuense Portuense 25 42 32 39
9 Divina Pastora Sanluqueña Divina 25 28 41 31
10 Amigos Cruz Roja Jerez Amigos Cruz 25 39 45 28
11 J. Sanluqueña Sanluqueña 25 39 46 28
12 Medina Balompié Medina 25 36 41 27
13 Estrella Portuense FC Estrella 25 23 39 25
14 Rayo Sanluqueño Rayo 25 21 40 25
15 Alcalá del Valle Alcalá 25 27 53 24
16 Espera C.F. Espera C.F. 25 22 54 23
17 Cañorrera Cañorrera 25 18 65 21
18 San Jose Obrero UD Jose Obrero 25 30 53 20
TEMPORADA 2018/2019
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 San Bernardo Bernardo 34 73 41 76
2 Puerto Real CF Puerto Real 34 75 36 74
3 Chipiona CF Chipiona CF 34 67 33 72
4 Barbate Barbate 33 75 46 69
5 Los Cortijillos Cortijillos 34 62 34 63
6 Espera C.F. Espera C.F. 34 62 37 56
7 CD Jédula CD Jédula 34 68 44 56
8 At. Sanluqueño B Sanluqueño 34 57 40 51
9 Medina Balompié Medina 33 59 48 50
10 San Jose Obrero UD Jose Obrero 34 51 63 40
11 Rayo Sanluqueño Rayo 34 55 76 39
12 C.D. La Salle C.D. Salle 34 36 57 38
13 Estrella Portuense FC Estrella 34 34 60 34
14 Juventud Jerez Industrial Juventud 34 47 68 33
15 Divina Pastora Sanluqueña Divina 34 52 76 31
16 San Jose Atletico Jose 34 44 70 30
17 Facinas Facinas 34 37 86 26
18 Prado del Rey Prado 34 40 79 19
TEMPORADA 2017/2018
2ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Alcalá del Valle Alcalá 33 69 31 72
2 Tarifa UD Tarifa UD 34 87 44 68
3 Ubrique UD Ubrique UD 32 67 23 67
4 C.D. La Salle C.D. Salle 33 75 33 66
5 Algeciras CF B Algeciras 32 69 34 65
6 San Bernardo Bernardo 31 63 46 59
7 Puerto Real CF Puerto Real 33 64 49 55
8 Medina Balompié Medina 32 58 59 43
9 Los Cortijillos Cortijillos 32 44 45 43
10 Prado del Rey Prado 32 45 62 41
11 Barbate Barbate 30 42 44 37
12 Divina Pastora Sanluqueña Divina 33 40 61 32
13 Espera C.F. Espera C.F. 32 30 46 31
14 CD Rivera CD Rivera 33 41 76 31
15 Facinas Facinas 33 44 65 29
16 At. Sanluqueño B Sanluqueño 31 53 78 27
17 Alma de África Alma África 32 42 78 20
18 Federico Mayo C.F. Federico 26 33 92 10
TEMPORADA 2016/2017
3ª ANDALUZA CÁDIZ
Equipo PJ GF GC Puntos
1 Alcalá del Valle Alcalá 17 50 19 35
2 Medina Balompié Medina 17 29 19 32
3 Facinas Facinas 17 37 29 30
4 Divina Pastora Sanluqueña Divina 17 45 28 29
5 Alma de África Alma África 17 35 24 29
6 Xerez Balompié Xerez 17 33 31 28
7 Ud Bornense Ud Bornense 17 20 30 21
8 Juventud Jerez Industrial Juventud 17 40 33 15
9 Federico Mayo B Federico 17 17 48 12
10 Español de Vejer Español 9 6 51 0

  USO DE MEMORIA  
5,333,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.3914
Total Execution Time  0.3926
  CADENA URL  
/historico/Cd-Divina-Pastora-Sanluquena-Senior
  GET DATOS  
$_GET['/historico/Cd-Divina-Pastora-Sanluquena-Senior']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=91135 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=279 AND type_rel = 3
0.0138  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 279 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0140  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1242683,1162357,687224,674140,635729) ORDER BY n.cover_points DESC, update_date DESC
0.0126  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 = '91135' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '91135' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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=91135 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0130  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 (64158) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 64158 AND teamId = 91135
0.0126  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 = '91135' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '91135' and rp.type = 4
0.0127  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 = '91135' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64158 WHERE rp.league_id = 64158 AND rp.teamId = 91135 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64158 WHERE rp.league_id = 64158 AND rp.teamId = 91135 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0125  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 64158 WHERE rp.league_id = 64158 AND rp.teamId = 91135 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 91135 AND l.year <= 2022 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0252  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` 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 = 64158 AND t.round = 34 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 `tables2021` 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 = 59425 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 `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 = 51363 AND t.round = 25 ORDER BY team.conference ASC,t.position 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 `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 = 45002 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133  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 = 39686 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 34315 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC