4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Binningen
TEMPORADA 2023/2024
QUINTA SUIZA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Prishtina Bern Prishtina 23 57 17 53
2 Fc Besa Biel Besa Biel 23 65 37 47
3 Dornach Dornach 22 50 40 39
4 Muri-Gümligen Muri-Gümlig 23 37 26 38
5 Old Boys Old Boys 23 60 56 37
6 FC Bosporus FC Bosporus 23 50 43 35
7 Concordia Lausanne Concordia 23 39 39 32
8 Binningen Binningen 23 32 33 32
9 Ajoie-Monterri Ajoie-Monter 23 35 38 30
10 Liestal Liestal 23 40 39 29
11 Ueberstorf Ueberstorf 23 28 36 26
12 Pratteln Pratteln 23 31 44 25
13 Tavannes / Tramelan Tavannes 22 35 48 23
14 SC Schöftland Schöftland 23 30 46 22
15 FC Erguël FC Erguël 23 23 40 18
16 Bubendorf Bubendorf 23 33 63 18
TEMPORADA 2022/2023
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Muttenz Muttenz 28 68 32 60
2 Dietikon Dietikon 28 65 35 60
3 Old Boys Old Boys 28 68 35 51
4 Red Star Zürich Star Zürich 28 44 22 51
5 Liestal Liestal 28 52 41 47
6 SC Zofingen SC Zofingen 28 45 34 46
7 FC Windisch FC Windisch 28 47 44 42
8 Binningen Binningen 28 40 46 40
9 Unterstrass Unterstrass 28 47 42 39
10 Pratteln Pratteln 28 48 63 36
11 SC Schöftland Schöftland 28 35 55 30
12 Bubendorf Bubendorf 28 40 67 30
13 FC Grenchen FC Grenchen 28 41 58 25
14 Regensdorf Regensdorf 28 43 65 20
15 Mutschellen Mutschellen 28 41 85 11
TEMPORADA 2021/2022
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Dornach Dornach 26 67 38 56
2 Concordia Basel Concordia 26 78 28 53
3 Old Boys Old Boys 26 65 36 51
4 Liestal Liestal 26 54 46 50
5 Ajoie-Monterri Ajoie-Monter 26 39 24 46
6 Muttenz Muttenz 26 59 57 38
7 Tavannes / Tramelan Tavannes 26 35 37 36
8 FC Courtetelle Courtetelle 26 41 57 31
9 Binningen Binningen 26 42 41 30
10 Spiez Spiez 26 46 63 29
11 Bubendorf Bubendorf 26 44 65 28
12 Lerchenfeld Lerchenfeld 26 39 56 24
13 FC Konolfingen Konolfingen 26 29 50 23
14 Moutier Moutier 26 23 63 19
TEMPORADA 2020/2021
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Thun II Thun II 13 45 16 31
2 Ajoie-Monterri Ajoie-Monter 12 20 11 27
3 Spiez Spiez 13 21 24 23
4 FC Konolfingen Konolfingen 13 23 18 22
5 Moutier Moutier 12 17 14 18
6 Old Boys Old Boys 13 29 28 18
7 Binningen Binningen 13 26 28 18
8 Dornach Dornach 13 21 20 17
9 Liestal Liestal 13 21 32 17
10 Tavannes / Tramelan Tavannes 13 20 21 15
11 Lerchenfeld Lerchenfeld 13 21 26 15
12 Bubendorf Bubendorf 13 24 29 14
13 Allschwil Allschwil 13 17 23 10
14 Köniz II Köniz II 13 21 36 8
TEMPORADA 2019/2020
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Moutier Moutier 13 37 11 35
2 Dornach Dornach 13 36 16 29
3 Old Boys Old Boys 13 30 20 25
4 Liestal Liestal 13 24 26 23
5 Bubendorf Bubendorf 13 27 19 22
6 Courgenay Courgenay 12 27 22 19
7 Cornol Cornol 13 21 24 17
8 FC Konolfingen Konolfingen 13 23 29 16
9 Spiez Spiez 13 21 39 15
10 Binningen Binningen 13 25 32 14
11 Allschwil Allschwil 13 24 30 12
12 Tavannes / Tramelan Tavannes 12 15 17 11
13 Lerchenfeld Lerchenfeld 13 19 29 8
14 Köniz II Köniz II 13 18 33 8
TEMPORADA 2018/2019
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Muttenz Muttenz 26 99 32 58
2 Allschwil Allschwil 25 54 48 46
3 Moutier Moutier 26 57 30 45
4 FC Konolfingen Konolfingen 26 54 47 43
5 Dornach Dornach 26 52 42 41
6 Tavannes / Tramelan Tavannes 26 47 42 41
7 Liestal Liestal 26 63 45 39
8 Köniz II Köniz II 25 53 41 38
9 Binningen Binningen 26 42 43 35
10 Cornol Cornol 26 41 43 35
11 Lerchenfeld Lerchenfeld 26 34 41 29
12 FC Prishtina Bern Prishtina 26 46 58 28
13 Timau Basel Timau Basel 26 39 121 18
14 Subingen Subingen 26 21 69 12
TEMPORADA 2017/2018
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Biel-Bienne Biel-Bienne 26 76 30 59
2 Liestal Liestal 26 69 36 56
3 Dornach Dornach 26 41 32 44
4 Allschwil Allschwil 26 48 48 42
5 FC Konolfingen Konolfingen 26 44 41 41
6 Timau Basel Timau Basel 26 54 45 41
7 Binningen Binningen 26 46 42 40
8 Moutier Moutier 26 51 33 39
9 Tavannes / Tramelan Tavannes 26 43 45 36
10 Lerchenfeld Lerchenfeld 26 45 56 32
11 FC Prishtina Bern Prishtina 26 29 51 29
12 Muri-Gümligen Muri-Gümlig 26 34 45 27
13 Reinach Reinach 26 34 59 23
14 Bern 1894 Bern 1894 26 19 70 7
TEMPORADA 2016/2017
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Langenthal Langenthal 26 75 34 58
2 Allschwil Allschwil 26 47 34 45
3 Lerchenfeld Lerchenfeld 26 54 46 43
4 Timau Basel Timau Basel 26 54 55 42
5 Bern 1894 Bern 1894 26 49 43 41
6 FC Prishtina Bern Prishtina 26 66 47 41
7 Moutier Moutier 26 53 49 40
8 Tavannes / Tramelan Tavannes 26 54 41 38
9 Dornach Dornach 26 40 36 38
10 FC Konolfingen Konolfingen 26 46 47 38
11 Binningen Binningen 26 51 50 36
12 Muttenz Muttenz 26 43 50 26
13 Bümpliz Bümpliz 26 40 78 14
14 Grünstern Grünstern 26 29 91 12
TEMPORADA 2015/2016
QUINTA SUIZA GRUPO 3
Equipo PJ GF GC Puntos
1 Bassecourt Bassecourt 26 58 31 50
2 Binningen Binningen 26 48 33 47
3 Dornach Dornach 26 44 35 44
4 Lerchenfeld Lerchenfeld 26 64 42 43
5 Langenthal Langenthal 26 48 40 39
6 Muttenz Muttenz 26 41 48 39
7 Allschwil Allschwil 26 46 35 38
8 Moutier Moutier 26 49 41 36
9 FC Konolfingen Konolfingen 26 51 50 34
10 Liestal Liestal 26 45 49 33
11 Tavannes / Tramelan Tavannes 26 34 55 31
12 Porrentruy Porrentruy 26 35 50 25
13 Concordia Basel Concordia 26 35 70 22
14 Kirchberg BE Kirchberg 26 39 58 20
TEMPORADA 2014/2015
QUINTA SUIZA GRUPO 5
Equipo PJ GF GC Puntos
1 United Zürich United 26 68 17 63
2 Hongg Hongg 26 66 27 53
3 Red Star Zürich Star Zürich 26 54 27 49
4 Allschwil Allschwil 26 71 46 41
5 Dornach Dornach 26 40 31 41
6 Seefeld Seefeld 26 42 31 40
7 Aarau II Aarau II 26 54 50 36
8 Muttenz Muttenz 26 42 56 35
9 Liestal Liestal 26 50 48 33
10 Binningen Binningen 26 47 53 33
11 Kilchberg-Rüschlikon Kilchberg-R 26 27 53 26
12 Dardania Basel Dardania 26 43 77 25
13 FC Blue Stars Zürich Blue Stars. 26 40 63 21
14 FC Beringen FC Beringen 26 36 101 19
TEMPORADA 2013/2014
QUINTA SUIZA GRUPO 5
Equipo PJ GF GC Puntos
1 Dietikon Dietikon 26 72 28 59
2 Seefeld Seefeld 26 50 25 53
3 Red Star Zürich Star Zürich 26 56 32 49
4 Kosova Kosova 26 58 59 40
5 Muttenz Muttenz 26 41 51 37
6 United Zürich United 26 53 44 35
7 Dornach Dornach 26 40 35 35
8 Liestal Liestal 26 49 57 35
9 Allschwil Allschwil 26 50 43 34
10 Kilchberg-Rüschlikon Kilchberg-R 26 35 45 31
11 Binningen Binningen 26 38 46 30
12 Dulliken Dulliken 26 43 60 28
13 Laufen Laufen 26 33 62 18
14 Oerlikon / Polizei Oerlikon 26 29 60 18
TEMPORADA 2008/2009
QUINTA SUIZA GRUPO 4
Equipo PJ GF GC Puntos
1 Laufen Laufen 25 67 28 57
2 Dornach Dornach 26 74 39 53
3 Alle Alle 26 47 23 51
4 Herzogenbuchsee Herzogenbuch 26 38 35 43
5 Liestal Liestal 26 59 48 39
6 Küsnacht Küsnacht 26 41 51 36
7 Seefeld Seefeld 26 46 39 35
8 Porrentruy Porrentruy 26 37 46 32
9 Bülach Bülach 26 36 44 29
10 Nordstern Nordstern 25 34 48 29
11 Langenthal Langenthal 25 38 47 28
12 Moutier Moutier 26 44 60 28
13 Binningen Binningen 25 29 46 27
14 Subingen Subingen 26 29 65 16

  USO DE MEMORIA  
6,266,336 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1141
Total Execution Time  0.1153
  CADENA URL  
/historico/Binningen
  GET DATOS  
$_GET['/historico/Binningen']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (31)  
0.0092  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 = 72775
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60258 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1527 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1527 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  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 (130213) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '60258' 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 = 72775 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0027  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=60258 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (74875,72775) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 72775 AND teamId = 60258
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 74875 AND teamId = 60258
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 FROM `tables2024` 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 = 72775 AND t.round = 23 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0020  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 = '60258' 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 = '60258' and rp.type = 4
0.0021  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 = '60258' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2024 e ON e.player_id = p.id AND e.league_id = 72775 WHERE rp.league_id = 72775 AND rp.teamId = 60258 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.0030  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 events2024 e ON e.player_id = p.id AND e.league_id = 72775 WHERE rp.league_id = 72775 AND rp.teamId = 60258 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0025  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 events2024 e ON e.player_id = p.id AND e.league_id = 72775 WHERE rp.league_id = 72775 AND rp.teamId = 60258 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 60258 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0022  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` 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 = 72775 AND t.round = 23 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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` 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 = 68402 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.0022  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 = 63977 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 57522 AND t.round = 26 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 `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 = 50505 AND t.round = 24 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 `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 = 44264 AND t.round = 26 ORDER BY team.conference 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 `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 = 39723 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 34003 AND t.round = 26 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 `tables2016` 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 = 15880 AND t.round = 26 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 `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 = 9204 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 `tables2014` 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 = 27116 AND t.round = 26 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 `tables2009` 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 = 27157 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC