4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rangers
TEMPORADA 2023/2024
LIGA REPÚBLICA DEL CONGO DR GRUPO 3
Equipo PJ GF GC Puntos
1 Blessing Blessing 0 0 0 0
2 Groupe Bazano Groupe 0 0 0 0
3 Panda 05 Panda 05 0 0 0 0
4 Sanga Balende Sanga 0 0 0 0
5 Simba Simba 0 0 0 0
6 Tshinkunku Tshinkunku 0 0 0 0
7 Celeste FC Celeste FC 0 0 0 0
8 Etoile de Kivu Etoile Kivu 0 0 0 0
9 Kuya Sport Kuya Sport 0 0 0 0
10 Motema Pembe Motema Pembe 0 0 0 0
11 Rangers Rangers 0 0 0 0
12 Renaissance Renaissance 0 0 0 0
TEMPORADA 2022/2023
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 AS Vita Club Vita Club 11 17 5 31
2 Saint-Eloi Lupopo Saint-Eloi 11 24 11 25
3 Maniema Union Maniema 8 13 3 19
4 TP Mazembe TP Mazembe 9 15 5 15
5 Motema Pembe Motema Pembe 9 10 7 14
6 Celeste FC Celeste FC 9 9 8 14
7 JSK JSK 9 6 5 13
8 Blessing Blessing 7 10 6 11
9 Tshinkunku Tshinkunku 9 10 13 11
10 Rangers Rangers 11 8 13 11
11 Sanga Balende Sanga 6 10 6 10
12 Don Bosco Lubumbashi Bosco 8 7 12 10
13 Groupe Bazano Groupe 8 7 11 9
14 Lubumbashi Sport Lubumbashi 10 8 15 9
15 Panda 05 Panda 05 10 10 18 8
16 Simba Simba 7 7 11 7
17 Etoile de Kivu Etoile Kivu 7 5 10 7
18 Dauphins Noirs Dauphins 7 3 6 6
19 Kuya Sport Kuya Sport 10 11 16 6
20 Renaissance Renaissance 8 3 12 2
TEMPORADA 2021/2022
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 19 40 3 51
2 Saint-Eloi Lupopo Saint-Eloi 20 33 9 49
3 AS Vita Club Vita Club 19 44 13 48
4 Maniema Union Maniema 18 28 10 38
5 Groupe Bazano Groupe 20 24 16 33
6 Don Bosco Lubumbashi Bosco 20 21 16 33
7 Motema Pembe Motema Pembe 19 23 15 29
8 Rangers Rangers 19 18 19 28
9 Panda 05 Panda 05 19 17 19 24
10 Sanga Balende Sanga 21 18 26 23
11 Etoile de Kivu Etoile Kivu 19 13 15 22
12 Lubumbashi Sport Lubumbashi 19 19 23 22
13 Dauphins Noirs Dauphins 19 15 20 20
14 Blessing Blessing 19 13 16 19
15 Kuya Sport Kuya Sport 19 18 28 19
16 Renaissance Renaissance 19 17 27 18
17 Tshinkunku Tshinkunku 19 11 26 15
18 Simba Simba 19 10 29 14
19 JSK JSK 19 6 36 8
20 RCK RCK 19 10 32 7
TEMPORADA 2020/2021
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 29 54 14 66
2 Maniema Union Maniema 29 43 16 66
3 AS Vita Club Vita Club 29 45 15 61
4 Saint-Eloi Lupopo Saint-Eloi 30 31 19 52
5 Sanga Balende Sanga 30 30 24 50
6 Motema Pembe Motema Pembe 30 31 24 46
7 Blessing Blessing 30 25 27 39
8 Rangers Rangers 29 23 41 34
9 Don Bosco Lubumbashi Bosco 30 28 32 33
10 Dauphins Noirs Dauphins 30 28 34 32
11 Renaissance Renaissance 30 27 42 31
12 Simba Simba 30 29 45 31
13 JSK JSK 29 22 27 29
14 Groupe Bazano Groupe 29 19 28 26
15 RCK RCK 30 25 45 24
16 Lubumbashi Sport Lubumbashi 28 18 45 19
TEMPORADA 2019/2020
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 20 48 9 53
2 AS Vita Club Vita Club 23 40 12 48
3 Maniema Union Maniema 20 41 15 43
4 Motema Pembe Motema Pembe 20 37 16 39
5 Renaissance Renaissance 23 32 26 37
6 Groupe Bazano Groupe 19 21 11 37
7 Rangers Rangers 25 27 28 29
8 Don Bosco Lubumbashi Bosco 23 26 23 28
9 RCK RCK 23 25 22 28
10 Lubumbashi Sport Lubumbashi 23 18 20 27
11 Saint-Eloi Lupopo Saint-Eloi 22 24 25 24
12 Simba Simba 22 15 31 22
13 Sanga Balende Sanga 19 17 35 17
14 Dauphins Noirs Dauphins 22 12 35 15
15 Bukavu Bukavu 22 15 48 14
16 Nyuki De Butembo Nyuki 22 15 57 12
TEMPORADA 2018/2019
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 TP Mazembe TP Mazembe 30 82 11 83
2 AS Vita Club Vita Club 30 60 15 74
3 Motema Pembe Motema Pembe 30 47 25 63
4 Maniema Union Maniema 28 40 20 56
5 Sanga Balende Sanga 30 36 30 42
6 Nyuki De Butembo Nyuki 31 31 32 41
7 Saint-Eloi Lupopo Saint-Eloi 29 25 25 40
8 Dauphins Noirs Dauphins 30 30 40 40
9 Rangers Rangers 28 30 30 36
10 Don Bosco Lubumbashi Bosco 29 34 36 35
11 Renaissance Renaissance 28 25 37 35
12 Groupe Bazano Groupe 30 25 30 34
13 Lubumbashi Sport Lubumbashi 30 35 42 32
14 Mont Bleu Mont Bleu 28 22 44 24
15 Dragons Dragons 29 12 50 14
16 Muungano Muungano 30 7 74 4
TEMPORADA 2017/2018
LIGA REPÚBLICA DEL CONGO DR
Equipo PJ GF GC Puntos
1 Renaissance Renaissance 7 8 4 15
2 AS Vita Club Vita Club 6 8 2 12
3 Motema Pembe Motema Pembe 5 7 3 11
4 RCK RCK 6 6 6 7
5 Dragons Dragons 5 5 6 6
6 FC MK FC MK 4 6 6 4
7 Nord Sport Nord Sport 4 3 5 4
8 Rangers Rangers 5 5 9 4
9 Molunge Molunge 4 0 7 1
10 Shark XI Shark XI 0 0 0 0
11 Mont Bleu Mont Bleu 6 10 8 11
12 Maniema Union Maniema 4 6 2 8
13 Virunga Virunga 5 7 4 8
14 Bukavu Bukavu 6 3 4 8
15 Dauphins Noirs Dauphins 4 5 3 7
16 Muungano Muungano 6 3 7 4
17 CS Makiso CS Makiso 3 3 5 3
18 Etoile de Kivu Etoile Kivu 4 3 7 3
19 TP Mazembe TP Mazembe 9 20 3 21
20 Saint-Eloi Lupopo Saint-Eloi 7 10 5 14
21 Sanga Balende Sanga 7 9 7 10
22 Dibumba Dibumba 8 6 8 8
23 Ecofoot Katumbi Ecofoot 6 4 6 8
24 Don Bosco Lubumbashi Bosco 5 3 3 6
25 Tshinkunku Tshinkunku 6 5 8 6
26 Groupe Bazano Groupe 4 2 4 4
27 Lubumbashi Sport Lubumbashi 5 3 6 4
28 Ocean Pacifique Ocean 7 3 15 2

  USO DE MEMORIA  
5,609,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0811
Total Execution Time  0.0823
  CADENA URL  
/historico/Ac-Rangers
  GET DATOS  
$_GET['/historico/Ac-Rangers']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=109014 AND type_rel = 2
0.0022  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 = '109014' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0019  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 = 75248 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=109014 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 (75248) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75248 AND teamId = 109014
0.0021  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 = 75248 AND t.round = 1 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 = '109014' 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 = '109014' 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 = '109014' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0020  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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 109014 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.0020  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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 109014 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0019  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 = 75248 WHERE rp.league_id = 75248 AND rp.teamId = 109014 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 = 109014 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72768 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.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 `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 = 75248 AND t.round = 1 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 `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 = 70082 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 64302 AND t.round = 19 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 `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 = 60011 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 `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 = 51154 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.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 `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 = 46941 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 42099 AND t.round = 8 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC