4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Sporting San Francisco
TEMPORADA 2022/2023
PREFERENTE BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Pla de na Tesa Tesa 33 115 36 76
2 Platges de Calvia B Platges 33 60 34 60
3 Alaro Alaro 34 70 49 59
4 Constancia B Constancia 34 73 55 58
5 Serverense Sub 19 Serverense 34 58 45 57
6 Ciutat de Palma SA Ciutat Palma 34 59 44 55
7 SD La Salle B Salle 33 63 50 54
8 CD Felanitx Sub 19 Felanitx 33 78 64 53
9 Arenal Arenal 34 70 53 52
10 Recreativo Son Caliu Recreativo 34 66 54 51
11 Sporting San Francisco Sporting 33 72 52 50
12 UE Petra UE Petra 34 55 53 49
13 Espanya Espanya 33 60 58 48
14 Binissalem A Binissalem 34 53 57 46
15 Montaura Montaura 33 56 83 36
16 La Unión Sub 19 Unión 33 39 69 28
17 Atlético Rafal B Atlético 34 34 115 9
18 Genova Genova 34 25 135 8
TEMPORADA 2021/2022
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 SD La Salle B Salle 33 83 26 76
2 CD Manacor B Manacor 32 70 25 76
3 Andratx Sub 19 Andratx 33 78 46 72
4 Patronato A Patronato A 32 98 47 67
5 UE Alcúdia A Alcúdia 33 90 39 64
6 AD Penya Arrabal Sub 19 B Penya 32 72 35 60
7 Atlético Rafal B Atlético 33 59 51 52
8 Alaro Alaro 32 67 50 49
9 Constancia B Constancia 33 86 71 49
10 Sporting San Francisco Sporting 33 64 46 44
11 San Francisco C Francisco 33 58 68 39
12 Son Sardina A Sardina 33 65 82 38
13 UE Petra UE Petra 32 47 66 33
14 Genova Genova 33 69 97 31
15 Santa Monica Santa Monica 33 66 108 30
16 Calvià Atlético Sub 19 Calvià 32 45 112 24
17 Murense Murense 33 53 123 20
18 CE Algaida CE Algaida 33 32 110 10
TEMPORADA 2020/2021
PREFERENTE BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Baleares Sub 19 B Atlético 17 59 17 42
2 UE Petra UE Petra 17 42 23 37
3 St. Catalina At. Sub 19 Catalina 16 45 20 35
4 Joventut Mallorca A Joventut 16 59 29 33
5 Son Sardina A Sardina 17 47 56 24
6 Sporting San Francisco Sporting 17 30 35 22
7 Espanya Espanya 17 27 44 19
8 Cide B Cide B 17 27 37 17
9 Independiente Camp Redó Independient 17 34 51 17
10 SD La Salle B Salle 17 19 31 16
11 Atletico Marratxi Atletico 17 36 59 14
12 CF Sóller A Sóller 17 29 52 13
TEMPORADA 2019/2020
1ª BALEAR JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Collerense Collerense 26 118 46 62
2 Porto Cristo A Porto Cristo 26 83 43 62
3 Sporting San Francisco Sporting 26 69 39 54
4 Genova Genova 26 96 47 52
5 Atº De Paguera Atº Paguera 26 91 57 48
6 Es Pla Es Pla 26 79 47 47
7 Sineu Sineu 26 60 48 47
8 Pla de NA Tesa Atº Del PDNT Tesa Atº PD. 26 84 70 46
9 Rotlet Molinar A Rotlet 26 62 51 45
10 Manacor C Manacor C 26 68 56 43
11 Asoc.Dep.Marroquis Asoc.Dep.Mar 26 69 55 42
12 Margaritense At. Margaritense 26 61 66 36
13 Cardassar Cardassar 26 63 71 23
14 Poblense B Poblense B 25 33 56 23
15 Arta Arta 26 45 81 23
16 Binissalem B Binissalem 26 35 63 22
17 Juventud Udso B Juventud 26 38 97 17
18 Interpla DT Interpla DT 26 39 98 16
19 Santanyi Del At.B A Santanyi 25 32 66 13
20 Sp. Sant Marçal Sant Marçal 26 43 111 9
TEMPORADA 2018/2019
1ª BALEAR JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 CF Sóller A Sóller 38 146 38 95
2 CE Campos CE Campos 38 150 50 93
3 UE Petra UE Petra 37 147 57 85
4 CE Algaida CE Algaida 38 109 75 73
5 Arta Arta 38 127 84 68
6 Recreativo La Victoria Recreativo 38 95 79 68
7 Sporting San Francisco Sporting 38 101 44 66
8 Espanya Espanya 38 119 76 63
9 La Union B La Union B 38 101 88 61
10 Porto Cristo A Porto Cristo 36 93 73 59
11 Es Pla Es Pla 38 92 91 53
12 Atletico Marratxi Atletico 37 84 99 47
13 San Cayetano Cayetano 38 78 94 47
14 Poblense B Poblense B 38 87 90 46
15 Interpla Interpla 38 72 85 46
16 Son Sardina B Sardina 38 65 100 36
17 Juv C'an Picafort C'an 38 56 111 25
18 Madre Alberta Madre 38 59 115 22
19 Sant Marçal Atlético Dspsm Sant Marçal 38 70 177 19
20 Unión Latina Unión 38 40 255 0
TEMPORADA 2017/2018
2ª BALEAR JUVENIL
Equipo PJ GF GC Puntos
1 Santanyi FB Santanyi FB 23 129 39 59
2 Sporting San Francisco Sporting 24 94 30 56
3 Atlético Manacor Atlético 23 89 28 54
4 Binissalem B Binissalem 22 65 24 54
5 Sant Marçal Atlético Dspsm Sant Marçal 23 84 34 51
6 Poblense B Poblense B 23 78 38 47
7 Juv C'an Picafort C'an 23 65 43 47
8 CD Arenal B CD Arenal B 22 57 51 35
9 Margaritense Atlétic Margaritense 23 53 53 35
10 Establiments Establiments 23 37 43 32
11 Unión Latina Unión 24 42 56 28
12 Pilares la Soledad Pilares 24 55 89 24
13 Platges de Calvia C Platges 24 49 95 21
14 Santa Catalina Santa 23 43 91 16
15 Cala D'or Cala D'or 24 22 74 15
16 Son Sardina B Sardina 23 31 87 13
17 Unió Esportiva Sta Maria Unió 23 35 77 11
18 Sant Jordi B Sant Jordi 24 21 97 4

  USO DE MEMORIA  
5,317,864 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1025
Total Execution Time  0.1037
  CADENA URL  
/historico/Sp-San-Francisco-B-Juvenil
  GET DATOS  
$_GET['/historico/Sp-San-Francisco-B-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0025  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 = 'Sp-San-Francisco-B-Juvenil' 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.0034  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 = 'Sp-San-Francisco-B-Juvenil' 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.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=139270 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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 = 69171
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=139270 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=827 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 827 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (824282,275951) ORDER BY n.cover_points DESC, update_date DESC
0.0022  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 = '139270' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '139270' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020  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 = '139270' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 69171 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=139270 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (69171) 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.0018  SELECT count(id) as num_players from rel_players_base WHERE league_id = 69171 AND teamId = 139270
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2023` 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 = 69171 AND t.round = 34 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0022  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 = '139270' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '139270' and rp.type = 4
0.0020  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 = '139270' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 139270 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0024  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 = 69171 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.0024  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 = 63720 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.0027  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 = 59333 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025  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 = 54118 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 44646 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 39370 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 69171 ORDER BY nameShow LIMIT 100