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

Dubrava Tim kabel

Entrenador: Petra Mandic

Temporada 2023/2024
TEMPORADA 2023/2024
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Zrinski Osječko Zrinski 28 44 13 69
2 HNK Sibenik HNK Sibenik 28 57 17 67
3 Vukovar '91 Vukovar '91 28 46 29 52
4 NK Jarun NK Jarun 28 32 40 37
5 NK Sesvete NK Sesvete 28 32 32 36
6 NK Dugopolje Dugopolje 28 33 37 33
7 Dubrava Tim kabel Dubrava 28 28 39 32
8 HNK Cibalia HNK Cibalia 28 28 46 30
9 NK Croatia Zmijavci Croatia 28 32 40 29
10 Bijelo Brdo Bijelo Brdo 28 27 36 27
11 HNK Orijent Rijeka Orijent 28 31 46 26
12 NK Solin NK Solin 28 25 40 20
TEMPORADA 2022/2023
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Rudes NK Rudes 33 56 26 64
2 Vukovar '91 Vukovar '91 33 57 25 63
3 HNK Cibalia HNK Cibalia 33 37 26 54
4 Bijelo Brdo Bijelo Brdo 33 41 37 44
5 NK Jarun NK Jarun 33 43 57 44
6 HNK Orijent Rijeka Orijent 33 45 45 43
7 NK Croatia Zmijavci Croatia 33 37 44 43
8 NK Solin NK Solin 33 47 55 43
9 Dubrava Tim kabel Dubrava 33 38 39 42
10 NK Dugopolje Dugopolje 33 30 35 41
11 NK Kustošija Kustošija 33 35 50 34
12 Hrvatski Dragovoljac Hrvatski 33 32 59 22
TEMPORADA 2021/2022
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Varazdin NK Varazdin 30 56 29 63
2 NK Rudes NK Rudes 30 56 27 56
3 Inter Zapresic Inter 30 34 29 48
4 NK Jarun NK Jarun 30 46 38 44
5 NK Kustošija Kustošija 30 39 35 42
6 HNK Cibalia HNK Cibalia 30 44 42 41
7 Dinamo Zagreb II Dinamo 30 37 44 41
8 NK Solin NK Solin 30 41 41 40
9 HNK Orijent Rijeka Orijent 30 44 49 40
10 NK Dugopolje Dugopolje 30 40 46 40
11 Bijelo Brdo Bijelo Brdo 30 30 41 39
12 Dubrava Tim kabel Dubrava 30 39 39 39
13 NK Croatia Zmijavci Croatia 30 32 43 38
14 NK Sesvete NK Sesvete 30 37 41 34
15 NK Osijek II Osijek 30 25 36 34
16 NK Opatija NK Opatija 30 27 47 25
TEMPORADA 2020/2021
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 34 49 39 59
2 NK Rudes NK Rudes 34 52 41 57
3 Bijelo Brdo Bijelo Brdo 34 52 40 55
4 HNK Cibalia HNK Cibalia 34 50 43 51
5 NK Kustošija Kustošija 34 43 38 51
6 NK Sesvete NK Sesvete 34 62 59 51
7 NK Opatija NK Opatija 34 42 41 50
8 NK Dugopolje Dugopolje 34 49 45 48
9 Dubrava Tim kabel Dubrava 34 45 46 46
10 HNK Orijent Rijeka Orijent 34 52 49 45
11 Inter Zapresic Inter 34 49 41 45
12 NK Croatia Zmijavci Croatia 34 52 53 44
13 Dinamo Zagreb II Dinamo 34 45 41 43
14 NK Osijek II Osijek 34 42 42 42
15 Hajduk Split II Hajduk Split 34 58 60 41
16 NK Solin NK Solin 34 45 56 38
17 Junak Sinj Junak Sinj 34 46 58 34
18 Medjimurje Cakovec Medjimurje 34 44 85 34
TEMPORADA 2019/2020
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Sibenik HNK Sibenik 19 26 15 41
2 NK Croatia Zmijavci Croatia 19 28 17 33
3 HNK Orijent Rijeka Orijent 19 26 23 33
4 NK Sesvete NK Sesvete 19 28 22 29
5 NK Rudes NK Rudes 19 25 20 29
6 Hajduk Split II Hajduk Split 19 29 23 27
7 NK Osijek II Osijek 19 26 19 26
8 Dinamo Zagreb II Dinamo 19 20 21 26
9 Hrvatski Dragovoljac Hrvatski 19 21 26 26
10 NK Dugopolje Dugopolje 19 30 31 25
11 Medjimurje Cakovec Medjimurje 19 26 26 23
12 Dubrava Tim kabel Dubrava 19 21 24 23
13 NK Kustošija Kustošija 19 19 27 23
14 Bijelo Brdo Bijelo Brdo 19 18 23 22
15 NK Solin NK Solin 19 22 27 19
16 HNK Cibalia HNK Cibalia 19 13 34 13
TEMPORADA 2018/2019
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 93 37 80
2 Dubrava Tim kabel Dubrava 34 82 36 74
3 HNK Orijent Rijeka Orijent 34 72 47 68
4 NK Trnje NK Trnje 34 61 41 58
5 Kurilovec Kurilovec 34 64 41 55
6 NK HASK Zagreb HASK Zagreb 34 52 42 51
7 NK Dugo Selo Dugo Selo 34 49 60 50
8 NK Opatija NK Opatija 34 55 50 48
9 Jadran Jadran 34 55 61 47
10 Krk Krk 34 52 54 45
11 NK Ponikve NK Ponikve 34 42 56 44
12 Vrbovec Vrbovec 34 48 61 43
13 NK Maksimir NK Maksimir 34 54 58 42
14 Zagorec Zagorec 34 55 60 40
15 NK Špansko NK Špansko 34 47 75 38
16 NK Jarun NK Jarun 34 46 62 37
17 Novigrad Novigrad 34 50 66 33
18 NK Zagreb NK Zagreb 34 26 96 15
TEMPORADA 2017/2018
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 34 73 26 74
2 NK Opatija NK Opatija 34 55 28 69
3 Dubrava Tim kabel Dubrava 34 65 45 61
4 Vrbovec Vrbovec 34 53 38 58
5 Zagorec Zagorec 34 64 56 55
6 NK Maksimir NK Maksimir 34 57 50 49
7 Kurilovec Kurilovec 34 54 52 49
8 Krk Krk 34 45 54 45
9 NK Zagreb NK Zagreb 34 46 51 44
10 NK Trnje NK Trnje 34 52 57 42
11 NK HASK Zagreb HASK Zagreb 34 63 56 41
12 Jadran Jadran 34 46 49 41
13 NK Špansko NK Špansko 34 43 52 41
14 NK Dugo Selo Dugo Selo 34 38 49 41
15 NK Pazinka NK Pazinka 34 40 51 40
16 Vrapče Vrapče 34 52 54 39
17 NK Rudar Labin Rudar Labin 34 31 69 33
18 Segesta Segesta 34 36 76 31
TEMPORADA 2016/2017
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Vinogradar Vinogradar 30 69 19 66
2 NK Kustošija Kustošija 30 59 35 54
3 NK Trnje NK Trnje 30 44 24 54
4 Krk Krk 30 47 36 50
5 NK Opatija NK Opatija 30 58 51 49
6 Vrapče Vrapče 30 49 38 44
7 Jadran Jadran 30 50 53 43
8 NK HASK Zagreb HASK Zagreb 30 51 49 41
9 Dubrava Tim kabel Dubrava 30 38 46 41
10 NK Maksimir NK Maksimir 30 35 40 36
11 Segesta Segesta 30 45 53 36
12 Vrbovec Vrbovec 30 45 54 33
13 NK Dugo Selo Dugo Selo 30 33 51 33
14 Zagorec Zagorec 30 37 59 32
15 Samobor Samobor 30 29 37 28
16 Stupnik Stupnik 30 47 91 23
TEMPORADA 2015/2016
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Novigrad Novigrad 30 59 19 75
2 Vinogradar Vinogradar 30 65 23 60
3 NK Trnje NK Trnje 30 44 29 55
4 Samobor Samobor 30 49 37 48
5 Zagorec Zagorec 30 40 35 48
6 Krk Krk 30 41 28 47
7 Vrapče Vrapče 30 44 41 46
8 NK Maksimir NK Maksimir 30 40 34 43
9 NK Opatija NK Opatija 30 39 45 43
10 Rijeka II Rijeka II 30 43 49 42
11 Dubrava Tim kabel Dubrava 30 35 39 33
12 NK HASK Zagreb HASK Zagreb 30 22 43 30
13 NK Dugo Selo Dugo Selo 30 37 47 29
14 Vrbovec Vrbovec 30 20 43 24
15 Stupnik Stupnik 30 24 54 24
16 NK Špansko NK Špansko 30 23 59 20
TEMPORADA 2014/2015
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Dinamo Zagreb II Dinamo 30 90 17 68
2 Rijeka II Rijeka II 30 51 21 62
3 NK Dugo Selo Dugo Selo 30 52 31 61
4 Dubrava Tim kabel Dubrava 30 55 24 60
5 Novigrad Novigrad 30 70 23 59
6 Istra 1961 II Istra 1961 30 48 42 46
7 Zagorec Zagorec 30 44 45 41
8 NK Trnje NK Trnje 30 44 48 41
9 NK HASK Zagreb HASK Zagreb 30 44 42 39
10 Vrapče Vrapče 30 32 39 37
11 NK Maksimir NK Maksimir 30 33 50 33
12 NK Špansko NK Špansko 30 46 60 31
13 Samobor Samobor 30 36 67 30
14 Vrbovec Vrbovec 30 27 74 26
15 Stupnik Stupnik 30 24 49 25
16 NK Zelina NK Zelina 30 18 82 14
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Maksimir NK Maksimir 30 59 40 59
2 NK Dugo Selo Dugo Selo 30 64 30 58
3 Bistra Donja Bistra Donja 30 49 21 58
4 Stupnik Stupnik 30 63 38 54
5 Vrbovec Vrbovec 30 49 26 54
6 Zagorec Zagorec 30 54 39 54
7 NK Trnje NK Trnje 30 63 38 53
8 Dubrava Tim kabel Dubrava 30 55 34 48
9 NK HASK Zagreb HASK Zagreb 30 47 30 46
10 Vrapče Vrapče 30 34 26 45
11 NK Špansko NK Špansko 30 41 67 35
12 Samobor Samobor 30 40 49 33
13 Kurilovec Kurilovec 30 29 48 28
14 NK Libertas NK Libertas 30 38 79 20
15 Klas Micevec Klas Micevec 30 19 59 18
16 NK Karlovac 1919 Karlovac 30 13 93 4
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Segesta Segesta 30 80 35 68
2 NK Dugo Selo Dugo Selo 30 60 32 58
3 NK Trnje NK Trnje 30 62 45 53
4 Vrapče Vrapče 30 41 26 51
5 Samobor Samobor 30 46 36 48
6 Stupnik Stupnik 30 53 50 46
7 Bistra Donja Bistra Donja 30 37 37 46
8 Kurilovec Kurilovec 30 53 39 44
9 NK Maksimir NK Maksimir 30 39 36 44
10 Dubrava Tim kabel Dubrava 30 41 32 42
11 Vrbovec Vrbovec 30 48 53 39
12 Tekstilac Ravnice Tekstilac 30 37 46 38
13 Lekenik Lekenik 30 35 45 36
14 NK Trešnjevka Trešnjevka 30 24 52 23
15 Gaj Mače Gaj Mače 30 22 67 19
16 Sava Strmec Sava Strmec 30 29 76 11
TEMPORADA 2011/2012
TERCERA CROACIA 3. NL GRUPO 4
Equipo PJ GF GC Puntos
1 Vrapče Vrapče 34 51 15 69
2 NK Zelina NK Zelina 34 65 30 69
3 NK Dugo Selo Dugo Selo 34 56 35 60
4 NK Opatija NK Opatija 34 39 38 54
5 Jadran Jadran 34 48 35 53
6 Segesta Segesta 34 44 47 48
7 Vrbovec Vrbovec 34 47 37 44
8 Novalja Novalja 34 43 43 43
9 NK Buje NK Buje 34 38 45 43
10 Grobničan Grobničan 34 54 54 41
11 Nehaj Nehaj 34 26 42 41
12 Dubrava Tim kabel Dubrava 34 49 55 40
13 Krk Krk 34 46 54 39
14 HNK Orijent Rijeka Orijent 34 38 48 39
15 Stupnik Stupnik 34 54 62 38
16 Crikvenica Crikvenica 34 38 49 38
17 Rovinj Rovinj 34 29 46 35
18 Vinodol Vinodol 34 41 71 32
TEMPORADA 1993/1994
LIGA CROATA HNL
Equipo PJ GF GC Puntos
1 HNK Hajduk Split Hajduk Split 34 84 36 50
2 NK Zagreb NK Zagreb 34 58 30 49
3 Dinamo Zagreb Dinamo 34 98 34 48
4 Inter Zapresic Inter 34 48 34 42
5 NK Varazdin NK Varazdin 34 51 31 41
6 HNK Rijeka HNK Rijeka 34 40 27 39
7 HNK Cibalia HNK Cibalia 34 37 27 35
8 NK Osijek NK Osijek 34 56 58 35
9 Segesta Segesta 34 48 44 34
10 NK Istra 1961 Istra 1961 34 40 36 34
11 Zadar Zadar 34 24 36 33
12 Belisce Belisce 34 55 51 32
13 HNK Sibenik HNK Sibenik 34 36 42 32
14 Pomorac Pomorac 34 42 54 29
15 NK Pazinka NK Pazinka 34 51 67 25
16 HNK Dubrovnik Dubrovnik 34 26 60 23
17 Dubrava Tim kabel Dubrava 34 28 63 23
18 HNK Gorica HNK Gorica 34 17 109 8

  USO DE MEMORIA  
6,680,000 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1362
Total Execution Time  0.1374
  CADENA URL  
/historico/Dubrava-Zagreb
  GET DATOS  
$_GET['/historico/Dubrava-Zagreb']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0031  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 = 'Dubrava-Zagreb' 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.0018  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=60655 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60655 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=60655 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 72476
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=60655 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=366 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 366 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1262952,1261457,1261159,1242003,953936) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '60655' ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '60655' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '60655' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0020  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 = 72476 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=60655 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 (72476,71432,68391) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72476 AND teamId = 60655
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68391 AND teamId = 60655
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 60655
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 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 = 72476 AND t.round = 29 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 = '60655' 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 = '60655' 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 = '60655' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0036  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 = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 60655 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.0038  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 = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 60655 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2024 e ON e.player_id = p.id AND e.league_id = 72476 WHERE rp.league_id = 72476 AND rp.teamId = 60655 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 60655 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72476 AND t.round = 29 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 `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 = 68279 AND t.round = 33 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 `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 = 63277 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.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 = 57734 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.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 `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 = 50115 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 `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 = 44727 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 39730 AND t.round = 34 ORDER BY team.conference 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 `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 = 34138 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 = 15854 AND t.round = 30 ORDER BY team.conference 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 `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 = 9295 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2014` 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 = 24834 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029  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 `tables2013` 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 = 24823 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables2012` 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 = 24805 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0041  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 `tables1994` 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 = 10221 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC