4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Chambishi
TEMPORADA 2022/2023
PREMIER LEAGUE ZAMBIA
Equipo PJ GF GC Puntos
1 Power Dynamos Power 34 48 19 65
2 MUZA MUZA 34 41 29 57
3 Zesco United Zesco United 34 46 27 55
4 Green Buffaloes Green 34 41 29 55
5 NAPSA Stars FC NAPSA Stars 34 40 26 51
6 Red Arrows Red Arrows 34 45 34 51
7 Green Eagles Green Eagles 34 36 34 50
8 Forest Rangers Forest 34 30 24 48
9 Nkana FC Nkana FC 34 32 27 48
10 Kansanshi Dynamos Kansanshi 34 33 31 48
11 Kabwe Warriors Kabwe 34 37 27 46
12 Prison Leopards Prison 34 35 36 45
13 Zanaco Zanaco 34 32 32 41
14 Nkwazi Nkwazi 34 30 33 39
15 Nchanga Rangers Nchanga 34 32 43 37
16 Lumwana Radiants Lumwana 34 32 40 34
17 Chambishi Chambishi 34 34 60 32
18 Buildcon FC Buildcon FC 34 16 89 10
TEMPORADA 2021/2022
PREMIER LEAGUE ZAMBIA
Equipo PJ GF GC Puntos
1 Red Arrows Red Arrows 34 52 28 70
2 Zesco United Zesco United 34 39 22 63
3 Green Eagles Green Eagles 34 34 22 57
4 Nkana FC Nkana FC 34 35 29 52
5 Power Dynamos Power 34 38 27 50
6 Zanaco Zanaco 34 31 28 49
7 Kansanshi Dynamos Kansanshi 34 26 27 48
8 Kabwe Warriors Kabwe 34 34 30 46
9 Prison Leopards Prison 34 33 30 46
10 Buildcon FC Buildcon FC 34 38 37 46
11 Forest Rangers Forest 34 37 35 44
12 Green Buffaloes Green 34 46 46 44
13 Nkwazi Nkwazi 34 25 31 38
14 Chambishi Chambishi 34 23 38 38
15 Lusaka Dynamos Lusaka 34 27 38 31
16 Kafue Celtic FC Kafue Celtic 34 27 40 31
17 Indeni Indeni 34 20 46 31
18 Konkola Blades Konkola 34 27 38 30
TEMPORADA 2008/2009
PREMIER LEAGUE ZAMBIA
Equipo PJ GF GC Puntos
1 Zanaco Zanaco 30 50 18 63
2 Zesco United Zesco United 30 36 16 63
3 Power Dynamos Power 30 34 22 54
4 City of Lusaka City Lusaka 30 29 25 48
5 Choma Eagles Choma Eagles 30 30 25 45
6 Green Buffaloes Green 30 31 28 45
7 Red Arrows Red Arrows 30 33 22 43
8 Forest Rangers Forest 30 29 30 41
9 Konkola Blades Konkola 30 27 28 39
10 Roan United Roan United 30 33 36 37
11 Kabwe Warriors Kabwe 30 20 23 37
12 Lusaka Dynamos Lusaka 30 26 26 36
13 Chambishi Chambishi 30 23 33 33
14 Zamtel Zamtel 30 13 31 27
15 Nakambala Leopards Nakambala 30 17 39 22
16 Young Arrows Young Arrows 30 18 47 15
TEMPORADA 2007/2008
PREMIER LEAGUE ZAMBIA
Equipo PJ GF GC Puntos
1 Zesco United Zesco United 30 33 14 51
2 Red Arrows Red Arrows 30 30 16 48
3 Green Buffaloes Green 30 33 23 47
4 Zanaco Zanaco 30 32 33 45
5 Power Dynamos Power 30 31 23 44
6 Kabwe Warriors Kabwe 30 29 28 43
7 Young Arrows Young Arrows 30 29 23 42
8 City of Lusaka City Lusaka 30 24 23 40
9 Konkola Blades Konkola 30 24 24 37
10 Chambishi Chambishi 30 22 35 37
11 Roan United Roan United 30 31 37 36
12 Lusaka Dynamos Lusaka 30 17 19 35
13 Nchanga Rangers Nchanga 30 21 29 35
14 Nkana FC Nkana FC 30 25 34 33
15 Nkwazi Nkwazi 30 20 30 32
16 Green Eagles Green Eagles 30 31 41 30
TEMPORADA 2005/2006
PREMIER LEAGUE ZAMBIA
Equipo PJ GF GC Puntos
1 Zanaco Zanaco 30 57 18 71
2 Green Buffaloes Green 30 44 24 57
3 Power Dynamos Power 30 40 30 51
4 Kabwe Warriors Kabwe 31 34 25 45
5 Forest Rangers Forest 30 24 20 45
6 Konkola Blades Konkola 30 28 21 44
7 Lusaka Dynamos Lusaka 31 37 40 41
8 Nakambala Leopards Nakambala 30 30 37 40
9 Zesco United Zesco United 29 24 21 38
10 Red Arrows Red Arrows 30 44 40 37
11 National Assembly National 30 30 31 37
12 Nkwazi Nkwazi 30 28 37 36
13 Nchanga Rangers Nchanga 29 25 33 35
14 Lusaka Celtic Lusaka 30 20 38 26
15 Kitwe United Kitwe United 30 9 31 23
16 Chambishi Chambishi 30 16 44 19

  USO DE MEMORIA  
5,311,208 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0838
Total Execution Time  0.0850
  CADENA URL  
/historico/Chambishi
  GET DATOS  
$_GET['/historico/Chambishi']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0042  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 = 68729
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=65361 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=480 AND type_rel = 3
0.0026  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 480 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022  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 (1221330,590567,574279) ORDER BY n.cover_points DESC, update_date 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 = '65361' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '65361' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 68729 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0024  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=65361 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 (68729) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68729 AND teamId = 65361
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 = '65361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '65361' 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 = '65361' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 events2023 e ON e.player_id = p.id AND e.league_id = 68729 WHERE rp.league_id = 68729 AND rp.teamId = 65361 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.0024  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 events2023 e ON e.player_id = p.id AND e.league_id = 68729 WHERE rp.league_id = 68729 AND rp.teamId = 65361 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 68729 WHERE rp.league_id = 68729 AND rp.teamId = 65361 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 65361 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0023  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 = 68729 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.0023  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 = 64191 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 `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 = 16299 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2008` 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 = 16300 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 `tables2006` 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 = 16302 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC