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

Tepecikspor

Entrenador: Bilgin Erdem

Temporada 2023/2024
TEMPORADA 2023/2024
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Karaköprü Bld. Karaköprü 28 51 24 60
2 Erbaaspor Erbaaspor 28 55 21 57
3 Silivrispor Kulübü Silivrispor 28 38 22 51
4 Viven Bornova FK Viven 28 47 33 50
5 Kuşadasıspor Kuşadasısp 28 36 28 45
6 Belediye Kütahyaspor Belediye 28 40 25 44
7 Ağrı Spor Ağrı Spor 28 36 35 39
8 Tepecikspor Tepecikspor 28 29 30 39
9 Fatsa Belediye Fatsa 28 24 27 37
10 Osmaniyespor Kulübü Osmaniyespor 28 29 34 29
11 1922 Konyaspor 1922 28 25 30 28
12 Bayburt Bayburt 28 18 38 28
13 Darica Genclerbirligi Darica 28 18 33 25
14 Akhisar Belediyespor Akhisar 28 25 67 19
15 Sivas Belediyespor Sivas 28 22 46 17
TEMPORADA 1999/2000
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Kirklarelispor Kirklarelisp 31 63 23 70
2 İstanbul Güngörenspor İstanbul 32 63 36 57
3 Alibeykoyspor Alibeykoyspo 32 41 33 53
4 Gebzespor Gebzespor 31 45 39 47
5 Kucukkoyspor Istanbul Kucukkoyspor 31 33 30 46
6 Kartal Belediyespor Kartal 32 48 47 40
7 Bandirmaspor Bandirmaspor 32 33 38 40
8 Tepecikspor Tepecikspor 32 36 50 40
9 Çanspor Çanspor 32 38 35 39
10 Edirnespor Edirnespor 32 45 43 39
11 Tekirdağspor Tekirdağspo 32 34 44 39
12 Beşyüzevlerspor Beşyüzevle 32 31 37 38
13 Lüleburgazspor Lüleburgazs 32 29 37 38
14 Nişantaşıspor Nişantaşı 32 35 47 38
15 Vefa SK Vefa SK 32 42 55 38
16 Altıntepsi Makelspor Altıntepsi 31 42 49 35
17 Cerkezköy Belediyespor Cerkezköy 32 40 55 34
TEMPORADA 1998/1999
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Gaziosmanpasaspor Gaziosmanpas 34 61 24 78
2 Eyupspor Eyupspor 34 75 34 77
3 İstanbul Güngörenspor İstanbul 34 60 33 70
4 Tepecikspor Tepecikspor 34 52 38 52
5 Kirklarelispor Kirklarelisp 34 48 33 47
6 Tekirdağspor Tekirdağspo 34 45 48 45
7 Nişantaşıspor Nişantaşı 34 40 45 44
8 Bandirmaspor Bandirmaspor 34 50 41 43
9 Altıntepsi Makelspor Altıntepsi 34 32 33 43
10 Kucukkoyspor Istanbul Kucukkoyspor 34 43 49 42
11 Çanspor Çanspor 34 38 51 42
12 Vefa SK Vefa SK 34 45 56 41
13 Ayazağaspor Ayazağaspor 34 39 53 40
14 Gönenspor Gönenspor 34 39 54 40
15 Cerkezköy Belediyespor Cerkezköy 34 34 44 38
16 Lüleburgazspor Lüleburgazs 34 33 48 37
17 Küçükçekmecespor Küçükçek 34 31 52 37
18 Bigaspor Bigaspor 34 29 58 26
TEMPORADA 1997/1998
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Corluspor Corluspor 32 57 29 69
2 Çanspor Çanspor 32 65 26 63
3 Gönenspor Gönenspor 31 55 37 63
4 Tepecikspor Tepecikspor 32 50 35 60
5 İstanbul Güngörenspor İstanbul 31 44 32 56
6 Tekirdağspor Tekirdağspo 32 34 29 51
7 Kirklarelispor Kirklarelisp 32 38 38 44
8 Ayvalikgucu Belediyespor Ayvalikgucu 31 42 49 42
9 Eyupspor Eyupspor 32 39 42 41
10 Kucukkoyspor Istanbul Kucukkoyspor 32 32 40 41
11 Cerkezköy Belediyespor Cerkezköy 32 34 43 40
12 Küçükçekmecespor Küçükçek 32 39 45 36
13 Altıntepsi Makelspor Altıntepsi 32 34 40 33
14 Lüleburgazspor Lüleburgazs 31 30 40 32
15 Bigaspor Bigaspor 32 25 37 30
16 Kepezspor Kepezspor 32 35 54 28
17 Keşanspor Keşanspor 32 33 70 20
TEMPORADA 1996/1997
2. LIG GRUPO 8
Equipo PJ GF GC Puntos
1 Kasımpaşa Kasımpaşa 33 58 27 66
2 Kirklarelispor Kirklarelisp 34 64 39 61
3 Keşanspor Keşanspor 34 51 33 58
4 Tekirdağspor Tekirdağspo 34 54 45 57
5 Tepecikspor Tepecikspor 34 58 40 54
6 İstanbul Güngörenspor İstanbul 34 47 30 54
7 Bandirmaspor Bandirmaspor 34 57 41 51
8 Cerkezköy Belediyespor Cerkezköy 34 52 42 51
9 Corluspor Corluspor 33 46 39 51
10 Kepezspor Kepezspor 34 46 33 50
11 Gönenspor Gönenspor 34 48 46 48
12 Çanspor Çanspor 34 47 36 47
13 Kucukkoyspor Istanbul Kucukkoyspor 34 36 38 47
14 Eyupspor Eyupspor 34 43 55 40
15 Lüleburgazspor Lüleburgazs 34 45 58 38
16 Küçükçekmecespor Küçükçek 34 36 56 38
17 Dikilitaşspor Dikilitaşsp 34 30 58 31
18 Edirne DSİ Spor Edirne DSİ 34 0 102 0
TEMPORADA 1995/1996
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Nişantaşıspor Nişantaşı 26 48 16 59
2 Cerkezköy Belediyespor Cerkezköy 26 41 24 51
3 Tepecikspor Tepecikspor 26 42 18 47
4 Küçükçekmecespor Küçükçek 26 32 23 45
5 Tekirdağspor Tekirdağspo 26 40 25 44
6 İstanbul Güngörenspor İstanbul 26 30 22 43
7 Kucukkoyspor Istanbul Kucukkoyspor 26 28 25 43
8 Bandirmaspor Bandirmaspor 26 35 25 39
9 Çanspor Çanspor 26 26 43 28
10 Kirklarelispor Kirklarelisp 26 27 38 26
11 Keşanspor Keşanspor 26 25 40 25
12 Edirne DSİ Spor Edirne DSİ 26 18 37 22
13 Babaeskispor Babaeskispor 26 26 50 22
14 Uzunköprüspor Uzunköprüs 26 24 56 12
TEMPORADA 1994/1995
2. LIG GRUPO 9
Equipo PJ GF GC Puntos
1 Lüleburgazspor Lüleburgazs 26 50 21 55
2 Eyupspor Eyupspor 26 54 25 54
3 İstanbul Güngörenspor İstanbul 26 42 25 50
4 Tekirdağspor Tekirdağspo 26 45 33 43
5 Cerkezköy Belediyespor Cerkezköy 26 18 23 38
6 Babaeskispor Babaeskispor 26 33 36 36
7 Kasımpaşa Kasımpaşa 26 38 35 35
8 Küçükçekmecespor Küçükçek 26 42 33 34
9 Kucukkoyspor Istanbul Kucukkoyspor 25 32 23 34
10 Tepecikspor Tepecikspor 26 43 35 34
11 Uzunköprüspor Uzunköprüs 26 27 41 24
12 Malkara Belediyespor Malkara 26 19 37 24
13 Keşanspor Keşanspor 25 16 34 24
14 Özel İdare İhtisas Özel İdare 26 16 74 8

  USO DE MEMORIA  
5,797,672 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.4895
Total Execution Time  0.4907
  CADENA URL  
/historico/Buyukcekmece-Tepecik-Spor-Kulubu
  GET DATOS  
$_GET['/historico/Buyukcekmece-Tepecik-Spor-Kulubu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0134  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 = 'Buyukcekmece-Tepecik-Spor-Kulubu' 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.0126  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=121675 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=121675 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125  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=121675 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 73221
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=121675 AND type_rel = 2
0.0129  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 = '121675' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '121675' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '121675' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 73221 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=121675 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (74094,73221) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 73221 AND teamId = 121675
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 121675
0.0128  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 = '121675' 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 = '121675' and rp.type = 4
0.0131  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 = '121675' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 121675 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.0161  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 = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 121675 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0176  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 = 73221 WHERE rp.league_id = 73221 AND rp.teamId = 121675 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 121675 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0144  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 = 73221 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.0146  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 `tables2000` 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 = 50714 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `tables1999` 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 = 50734 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145  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 `tables1998` 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 = 50768 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 `tables1997` 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 = 50777 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 `tables1996` 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 = 50808 AND t.round = 26 ORDER BY team.conference 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 `tables1995` 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 = 50819 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC