4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del SC Kourou
TEMPORADA 2023/2024
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Etoile Matoury Etoile 17 62 10 47
2 Le Geldar Le Geldar 16 41 12 36
3 SC Kourou SC Kourou 16 32 12 36
4 Matoury Matoury 17 22 11 32
5 Remire Remire 17 33 24 31
6 Grand Santi Grand Santi 16 34 15 27
7 USC Montsinéry Montsinéry 18 29 33 25
8 Saint-Georges Saint-George 18 30 28 21
9 Loyola Loyola 19 23 34 21
10 CSC Cayenne CSC Cayenne 18 20 33 21
11 ASC Karib ASC Karib 19 17 40 18
12 Olympique Cayenne Olympique 17 18 31 17
13 ASL Sport Guyanais Sport 19 15 58 12
14 Balata-Abriba Balata-Abrib 19 13 48 4
TEMPORADA 2022/2023
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Le Geldar Le Geldar 16 50 22 38
2 USC Montsinéry Montsinéry 16 27 14 28
3 Grand Santi Grand Santi 16 31 11 36
4 ASC Karib ASC Karib 16 27 20 31
5 Sinnamary Sinnamary 16 34 28 23
6 Remire Remire 16 26 34 16
7 Olympique Cayenne Olympique 16 22 36 16
8 Charvein Charvein 16 17 41 12
9 Dynamo de Soula Dynamo Soula 16 13 41 5
10 Etoile Matoury Etoile 18 52 12 50
11 SC Kourou SC Kourou 18 28 21 34
12 CSC Cayenne CSC Cayenne 18 48 26 33
13 Agouado Agouado 18 37 37 28
14 Loyola Loyola 18 37 22 27
15 ASC Ouest ASC Ouest 18 33 29 22
16 Saint-Georges Saint-George 17 28 28 22
17 Matoury Matoury 17 25 25 22
18 EF Iracoubo EF Iracoubo 18 22 62 10
19 Montjoly Montjoly 18 18 66 3
TEMPORADA 2021/2022
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Etoile Matoury Etoile 10 25 8 26
2 Le Geldar Le Geldar 10 41 14 25
3 Matoury Matoury 10 22 16 24
4 ASC Karib ASC Karib 9 19 10 21
5 Remire Remire 10 21 15 17
6 Grand Santi Grand Santi 10 25 15 14
7 Oyapock Oyapock 10 26 19 13
8 Agouado Agouado 6 16 9 13
9 CSC Cayenne CSC Cayenne 10 17 13 13
10 Sinnamary Sinnamary 11 13 17 13
11 Olympique Cayenne Olympique 10 9 14 12
12 ASC Ouest ASC Ouest 10 15 29 10
13 SC Kourou SC Kourou 11 19 20 9
14 USC Montsinéry Montsinéry 9 10 13 8
15 Saint-Georges Saint-George 8 9 19 8
16 Loyola Loyola 10 10 34 2
17 EF Iracoubo EF Iracoubo 10 9 41 1
TEMPORADA 2020/2021
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Loyola Loyola 2 6 2 6
2 Olympique Cayenne Olympique 4 7 8 6
3 Etoile Matoury Etoile 2 7 4 4
4 Agouado Agouado 3 9 12 4
5 Sinnamary Sinnamary 2 5 3 3
6 Saint-Georges Saint-George 2 4 4 3
7 Oyapock Oyapock 1 1 3 0
8 SC Kourou SC Kourou 2 5 8 0
9 Le Geldar Le Geldar 2 4 0 6
10 CSC Cayenne CSC Cayenne 3 3 4 4
11 Matoury Matoury 2 6 1 3
12 Grand Santi Grand Santi 1 1 0 3
13 ASC Ouest ASC Ouest 2 3 3 3
14 Remire Remire 1 1 1 1
15 Arc en Ciel Arc en Ciel 3 2 11 0
TEMPORADA 2019/2020
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Olympique Cayenne Olympique 15 36 15 36
2 Le Geldar Le Geldar 15 32 14 30
3 Matoury Matoury 15 22 13 27
4 Oyapock Oyapock 15 29 20 25
5 Grand Santi Grand Santi 15 21 18 24
6 Etoile Matoury Etoile 15 36 23 23
7 Agouado Agouado 14 27 22 23
8 CSC Cayenne CSC Cayenne 15 19 28 19
9 Remire Remire 15 15 21 13
10 SC Kourou SC Kourou 15 18 39 13
11 Saint-Georges Saint-George 14 23 39 10
12 Kourou FC Kourou FC 15 13 39 5
TEMPORADA 2017/2018
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Le Geldar Le Geldar 24 61 24 56
2 Etoile Matoury Etoile 24 49 24 55
3 Matoury Matoury 24 40 19 46
4 Grand Santi Grand Santi 24 42 31 40
5 Sinnamary Sinnamary 24 40 33 37
6 Agouado Agouado 24 51 44 35
7 Saint-Georges Saint-George 24 41 42 32
8 CSC Cayenne CSC Cayenne 24 27 35 30
9 Kourou FC Kourou FC 24 29 38 29
10 Remire Remire 24 45 39 27
11 Olympique Cayenne Olympique 24 24 43 23
12 EF Iracoubo EF Iracoubo 24 15 60 15
13 SC Kourou SC Kourou 24 18 50 11
TEMPORADA 2016/2017
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 67 21 51
2 Remire Remire 22 48 31 45
3 Le Geldar Le Geldar 22 52 21 40
4 CSC Cayenne CSC Cayenne 23 44 42 40
5 Agouado Agouado 22 49 35 37
6 Etoile Matoury Etoile 23 39 26 36
7 Kourou FC Kourou FC 22 43 32 34
8 Grand Santi Grand Santi 22 32 29 33
9 SC Kourou SC Kourou 22 37 54 21
10 Olympique Cayenne Olympique 22 30 68 14
11 Macouria Macouria 22 23 78 14
12 Cosma Cosma 22 15 42 8
TEMPORADA 2015/2016
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 Matoury Matoury 22 46 17 53
2 Le Geldar Le Geldar 22 43 24 44
3 CSC Cayenne CSC Cayenne 22 35 27 39
4 Agouado Agouado 22 45 40 38
5 Etoile Matoury Etoile 22 36 34 32
6 Macouria Macouria 22 39 36 27
7 Grand Santi Grand Santi 22 31 37 27
8 Remire Remire 22 36 38 26
9 SC Kourou SC Kourou 22 28 29 25
10 EF Iracoubo EF Iracoubo 22 32 45 23
11 Montjoly Montjoly 22 23 53 17
12 Cosma Cosma 22 24 38 16
TEMPORADA 2014/2015
LIGA GUAYANA FRANCESA
Equipo PJ GF GC Puntos
1 CSC Cayenne CSC Cayenne 23 40 15 53
2 Matoury Matoury 22 41 19 47
3 Le Geldar Le Geldar 22 38 23 38
4 Kourou FC Kourou FC 22 27 25 31
5 SC Kourou SC Kourou 22 34 35 29
6 Remire Remire 22 34 36 28
7 EF Iracoubo EF Iracoubo 22 25 29 28
8 Cosma Cosma 21 24 26 26
9 Grand Santi Grand Santi 22 26 32 26
10 Macouria Macouria 21 25 32 23
11 Montjoly Montjoly 22 33 52 18
12 Sinnamary Sinnamary 21 15 38 17

  USO DE MEMORIA  
5,594,576 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.5320
Total Execution Time  0.5332
  CADENA URL  
/historico/Sc-Kourou
  GET DATOS  
$_GET['/historico/Sc-Kourou']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0157  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 = 'Sc-Kourou' 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.0146  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=59814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=59814 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59814 AND type_rel = 2
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1503 AND type_rel = 3
0.0159  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 = '59814' ORDER BY l.year DESC,cat.coefficient DESC
0.0157  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 = '59814' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '59814' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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=59814 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (73191,71862) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 73191 AND teamId = 59814
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 71862 AND teamId = 59814
0.0154  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 = '59814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0149  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59814' and rp.type = 4
0.0156  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 = '59814' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0157  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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 59814 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.0156  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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 59814 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158  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 = 73191 WHERE rp.league_id = 73191 AND rp.teamId = 59814 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0148  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 = 59814 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0150  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 = 73191 AND t.round = 21 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 69433 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.0159  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 = 65849 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.0149  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 = 60344 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 51108 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 49111 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 37042 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 15965 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 9122 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC