4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del CSC 1599 Selimbar

CSC 1599 Selimbar

Entrenador: Claudiu Niculescu

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA RUMANÍA GRUPO 2
Equipo PJ GF GC Puntos
1 Unirea Slobozia Unirea 7 8 3 16
2 FC Buzău FC Buzău 7 7 5 11
3 CS Hunedoara Hunedoara 6 7 5 9
4 Csikszereda Csikszereda 7 7 8 8
5 CSC 1599 Selimbar 1599 6 3 6 4
6 Mioveni Mioveni 7 2 7 3
TEMPORADA 2022/2023
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Csikszereda Csikszereda 6 12 6 39
2 CSC 1599 Selimbar 1599 6 9 7 36
3 CSM Slatina CSM Slatina 6 2 5 34
4 Unirea Slobozia Unirea 6 7 11 34
5 Metaloglobus Metaloglobus 6 12 6 32
6 Minaur Baia Mare Minaur Baia 6 3 4 22
7 ASU Politehnica Timisoara Politehnica 6 5 11 19
8 Brașov Steagul Renaște Brașov 6 23 5 44
9 Concordia Chiajna Concordia 6 8 6 39
10 Dumbrăviţa Dumbrăviţa 6 12 8 33
11 Viitorul Pandurii Viitorul 6 10 11 32
12 Progresul Spartac Progresul 6 15 7 29
13 Unirea Constanța Unirea 6 5 27 18
14 Ripensia Timisoara Ripensia 6 2 11 17
TEMPORADA 2021/2022
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Petrolul Ploiesti Petrolul 19 41 7 49
2 Universitatea Cluj Universitate 19 34 14 42
3 Hermannstadt Hermannstadt 19 41 15 41
4 CSA Steaua Bucuresti Steaua 19 31 13 37
5 Concordia Chiajna Concordia 19 18 10 36
6 Unirea Slobozia Unirea 19 33 13 33
7 Csikszereda Csikszereda 19 32 23 33
8 FC Buzău FC Buzău 19 43 14 32
9 Unirea Dej Unirea Dej 19 17 16 28
10 Metaloglobus Metaloglobus 19 22 23 28
11 Politehnica Iași Politehnica 19 25 21 25
12 Ripensia Timisoara Ripensia 19 18 19 25
13 Viitorul Pandurii Viitorul 19 16 20 24
14 CSC 1599 Selimbar 1599 19 18 26 23
15 ASU Politehnica Timisoara Politehnica 19 19 27 21
16 Brașov Steagul Renaște Brașov 19 16 32 14
17 Unirea Constanța Unirea 19 18 54 11
18 Dunărea Călăraşi Dunărea 19 12 50 7
19 Dacia Unirea Brăila Dacia Unirea 19 7 53 2
20 FC Astra Giurgiu Astra 19 21 32 -1
TEMPORADA 2020/2021
TERCERA RUMANÍA GRUPO 7
Equipo PJ GF GC Puntos
1 CSC 1599 Selimbar 1599 18 43 8 50
2 Măgura Cisnădie Măgura 18 29 19 33
3 Viitorul Dăești Viitorul 18 35 32 27
4 Gaz Metan Medias II Metan Medias 18 33 24 26
5 Gilortul Gilortul 18 29 31 26
6 CSM Deva CSM Deva 18 27 24 25
7 Flacăra Horezu Flacăra 18 39 36 20
8 Jiul Petrosani Jiul 18 18 29 19
9 Hermannstadt II Hermannstadt 18 24 39 17
10 Minerul Costeşti Minerul 18 16 51 7
TEMPORADA 2019/2020
TERCERA RUMANÍA GRUPO 5
Equipo PJ GF GC Puntos
1 Dacia Maramureș Dacia 16 41 17 35
2 Minaur Baia Mare Minaur Baia 16 25 8 33
3 CSC 1599 Selimbar 1599 16 26 19 28
4 Metalurgistul Cugir Metalurgistu 16 22 17 27
5 Luceafărul Oradea Luceafărul 16 37 29 26
6 Sânmartin Sânmartin 16 31 30 25
7 Gloria Bistriţa Gloria 16 17 19 25
8 Avântul Reghin Avântul 16 27 21 22
9 Arieşul Turda Arieşul 16 19 22 22
10 Unirea Dej Unirea Dej 16 19 24 21
11 Sănătatea Cluj Sănătatea 16 22 21 20
12 FC Unirea Alba Iulia Unirea Alba 16 21 22 16
13 SCM Zalău SCM Zalău 16 21 32 15
14 CFR Cluj II CFR Cluj II 16 21 35 15
15 Industria Galda Industria 16 19 35 11
16 Odorheiu Odorheiu 16 11 28 10

  USO DE MEMORIA  
5,496,144 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4320
Total Execution Time  0.4332
  CADENA URL  
/historico/Acs-Viitorul-Selimbar
  GET DATOS  
$_GET['/historico/Acs-Viitorul-Selimbar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0281  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 = 72232
0.0127  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=112191 AND type_rel = 2
0.0148  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 = '112191' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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=112191 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127  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 (75660,73672,71432) 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.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75660 AND teamId = 112191
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 73672 AND teamId = 112191
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 112191
0.0130  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 = '112191' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '112191' and rp.type = 4
0.0129  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 = '112191' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0166  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 = 75660 WHERE rp.league_id = 75660 AND rp.teamId = 112191 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.0179  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 = 75660 WHERE rp.league_id = 75660 AND rp.teamId = 112191 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0140  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 = 75660 WHERE rp.league_id = 75660 AND rp.teamId = 112191 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0129  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 = 112191 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0130  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 = 72232 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.0127  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 = 75660 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130  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 = 68106 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.0129  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 = 71249 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 66963 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131  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 = 63225 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.0148  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 = 58686 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.0130  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 = 51102 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC