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

NK Solin

Entrenador: Luka Bonacic

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
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Varazdin NK Varazdin 26 40 30 51
2 HNK Sibenik HNK Sibenik 26 38 25 46
3 NK Osijek II Osijek 26 37 26 44
4 Hajduk Split II Hajduk Split 26 36 29 43
5 NK Dugopolje Dugopolje 26 29 25 43
6 NK Sesvete NK Sesvete 26 38 26 40
7 Dinamo Zagreb II Dinamo 26 31 26 37
8 Zadar Zadar 26 36 40 34
9 Bijelo Brdo Bijelo Brdo 26 31 37 28
10 NK Solin NK Solin 26 24 31 28
11 NK Kustošija Kustošija 26 20 28 28
12 Hrvatski Dragovoljac Hrvatski 26 23 29 27
13 Medjimurje Cakovec Medjimurje 26 26 42 25
14 Lučko Lučko 26 16 31 24
TEMPORADA 2017/2018
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Gorica HNK Gorica 33 44 29 62
2 NK Varazdin NK Varazdin 33 50 32 61
3 Dinamo Zagreb II Dinamo 33 43 25 61
4 NK Sesvete NK Sesvete 33 46 38 54
5 Hajduk Split II Hajduk Split 33 44 32 50
6 NK Dugopolje Dugopolje 33 34 37 46
7 HNK Sibenik HNK Sibenik 33 39 43 42
8 NK Kustošija Kustošija 33 34 39 40
9 Hrvatski Dragovoljac Hrvatski 33 37 48 34
10 Lučko Lučko 33 27 40 34
11 NK Solin NK Solin 33 31 48 34
12 Novigrad Novigrad 33 32 50 31
TEMPORADA 2016/2017
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Rudes NK Rudes 33 43 28 60
2 HNK Gorica HNK Gorica 33 53 31 57
3 NK Solin NK Solin 33 40 36 55
4 NK Sesvete NK Sesvete 33 53 36 52
5 Dinamo Zagreb II Dinamo 33 39 32 47
6 NK Dugopolje Dugopolje 33 36 32 46
7 HNK Sibenik HNK Sibenik 33 32 33 45
8 Novigrad Novigrad 33 28 35 42
9 Lučko Lučko 33 34 48 38
10 Hrvatski Dragovoljac Hrvatski 33 30 39 36
11 Imotski Imotski 33 36 58 31
12 NK Zagreb NK Zagreb 33 34 50 29
TEMPORADA 2015/2016
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Solin NK Solin 34 46 26 68
2 Neretvanac Neretvanac 34 61 40 63
3 Val Kaštel Stari Kaštel 34 57 52 55
4 NK Kamen NK Kamen 34 52 51 51
5 Hajduk Split II Hajduk Split 34 49 36 50
6 Zmaj Blato Zmaj Blato 34 64 57 50
7 Hrvace Hrvace 34 55 43 49
8 NK Omiš NK Omiš 34 39 33 46
9 NK Otok NK Otok 34 40 45 46
10 Junak Sinj Junak Sinj 34 42 38 45
11 Primorac Stobrec Primorac 34 39 47 44
12 Neretva Neretva 34 39 49 44
13 Zmaj Makarska Zmaj 34 42 45 42
14 NK Croatia Zmijavci Croatia 34 52 60 42
15 Primorac Biograd Primorac 34 36 42 41
16 Zagora Unešić Zagora 34 42 54 39
17 NK Jadran LP Jadran 34 31 49 39
18 Mosor Mosor 34 37 56 35
TEMPORADA 2014/2015
TERCERA CROACIA 3. NL GRUPO 2
Equipo PJ GF GC Puntos
1 HNK Sibenik HNK Sibenik 34 78 25 74
2 NK Solin NK Solin 34 63 30 68
3 Mosor Mosor 34 48 26 67
4 Neretvanac Neretvanac 34 65 40 61
5 Hajduk Split II Hajduk Split 34 65 42 59
6 Hrvace Hrvace 34 46 46 54
7 Neretva Neretva 34 53 57 46
8 Junak Sinj Junak Sinj 34 45 47 45
9 Zmaj Blato Zmaj Blato 34 46 54 43
10 Primorac Stobrec Primorac 34 65 70 42
11 Zagora Unešić Zagora 34 43 57 40
12 NK Jadran LP Jadran 34 36 54 39
13 Val Kaštel Stari Kaštel 34 37 54 37
14 NK Omiš NK Omiš 34 39 58 37
15 NK Croatia Zmijavci Croatia 34 43 72 37
16 Zmaj Makarska Zmaj 34 43 52 35
17 NK Kamen NK Kamen 34 46 58 35
18 GOŠK DBK GOŠK DBK 34 31 50 33
TEMPORADA 2013/2014
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
TEMPORADA 2012/2013
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 30 39 25 53
2 NK Solin NK Solin 30 43 39 51
3 NK Rudes NK Rudes 30 47 30 50
4 HNK Sibenik HNK Sibenik 30 42 31 48
5 Vinogradar Vinogradar 30 43 39 48
6 NK Zelina NK Zelina 30 46 30 46
7 Pomorac Pomorac 30 51 39 46
8 NK Dugopolje Dugopolje 30 39 42 46
9 Lučko Lučko 30 31 28 45
10 HNK Gorica HNK Gorica 30 40 35 40
11 NK Sesvete NK Sesvete 30 42 43 40
12 Mosor Mosor 30 31 40 38
13 Junak Sinj Junak Sinj 30 34 43 36
14 Imotski Imotski 30 26 41 31
15 Primorac Stobrec Primorac 30 25 43 28
16 NK HASK Zagreb HASK Zagreb 30 24 55 15
TEMPORADA 2011/2012
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Dugopolje Dugopolje 28 50 27 57
2 Pomorac Pomorac 28 63 30 56
3 Mosor Mosor 28 36 16 52
4 Vinogradar Vinogradar 28 47 32 50
5 Imotski Imotski 28 26 21 42
6 NK Rudes NK Rudes 28 42 33 41
7 HNK Gorica HNK Gorica 28 27 24 40
8 Hrvatski Dragovoljac Hrvatski 28 36 37 40
9 NK Sesvete NK Sesvete 28 34 31 39
10 Junak Sinj Junak Sinj 28 29 27 39
11 NK Solin NK Solin 28 35 45 35
12 Marsonia Marsonia 28 25 50 30
13 Medjimurje Cakovec Medjimurje 28 31 60 22
14 NK HASK Zagreb HASK Zagreb 28 33 52 21
15 NK Croatia Sesvete Croatia 28 23 52 15
TEMPORADA 2010/2011
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 HNK Gorica HNK Gorica 30 54 21 64
2 Lučko Lučko 30 54 28 59
3 Pomorac Pomorac 30 50 23 56
4 NK Rudes NK Rudes 30 52 39 52
5 Imotski Imotski 30 35 32 48
6 NK Solin NK Solin 30 35 33 45
7 Medjimurje Cakovec Medjimurje 30 53 49 42
8 NK Dugopolje Dugopolje 30 39 30 41
9 Junak Sinj Junak Sinj 30 40 34 40
10 Vinogradar Vinogradar 30 43 38 40
11 NK Croatia Sesvete Croatia 30 37 41 40
12 Croatia Slavonski Croatia 30 42 42 39
13 NK HASK Zagreb HASK Zagreb 30 40 42 38
14 Mosor Mosor 30 32 41 34
15 Vukovar '91 Vukovar '91 30 21 83 20
16 Suhopolje Suhopolje 30 22 73 17
TEMPORADA 2009/2010
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Split Split 26 56 26 53
2 Pomorac Pomorac 26 41 24 47
3 Hrvatski Dragovoljac Hrvatski 26 35 23 42
4 Lučko Lučko 26 38 28 42
5 NK Solin NK Solin 26 29 22 40
6 Vinogradar Vinogradar 26 38 37 37
7 NK Rudes NK Rudes 26 38 38 37
8 Junak Sinj Junak Sinj 26 29 31 35
9 Imotski Imotski 26 40 49 34
10 Mosor Mosor 26 26 34 33
11 Suhopolje Suhopolje 26 29 31 31
12 Vukovar '91 Vukovar '91 26 31 39 31
13 Moslavina Moslavina 26 25 44 24
14 Segesta Segesta 26 17 46 16
TEMPORADA 2008/2009
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 30 46 20 60
2 NK Karlovac 1919 Karlovac 30 50 24 59
3 Lokomotiva Lokomotiva 30 50 30 59
4 Slavonac Slavonac 29 38 16 57
5 Medjimurje Cakovec Medjimurje 30 61 34 50
6 Hrvatski Dragovoljac Hrvatski 30 38 36 49
7 NK Solin NK Solin 30 37 31 47
8 Vinogradar Vinogradar 30 40 50 40
9 Imotski Imotski 30 31 45 34
10 Suhopolje Suhopolje 30 33 37 33
11 Segesta Segesta 30 33 47 33
12 Junak Sinj Junak Sinj 30 35 51 33
13 Mosor Mosor 30 25 44 30
14 Pomorac Pomorac 29 27 44 29
15 Moslavina Moslavina 30 33 51 28
16 Trogir Trogir 30 32 49 21
TEMPORADA 2007/2008
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 30 60 28 64
2 NK Croatia Sesvete Croatia 29 65 25 63
3 NK Istra 1961 Istra 1961 30 42 14 58
4 Pomorac Pomorac 29 42 26 49
5 Vinogradar Vinogradar 30 42 43 44
6 Slavonac Slavonac 30 44 51 44
7 Segesta Segesta 30 39 37 43
8 Trogir Trogir 30 40 37 42
9 Moslavina Moslavina 30 51 42 41
10 Imotski Imotski 30 49 53 40
11 Mosor Mosor 30 27 42 38
12 NK Solin NK Solin 30 46 48 37
13 Marsonia Marsonia 30 34 58 31
14 Kamen Ingrad Velika Kamen Ingrad 30 26 49 28
15 Vukovar '91 Vukovar '91 29 29 51 24
16 Belisce Belisce 29 21 53 13
TEMPORADA 2006/2007
PRIMERA CROACIA 1. NL
Equipo PJ GF GC Puntos
1 Inter Zapresic Inter 30 60 28 68
2 Zadar Zadar 30 55 25 65
3 NK Croatia Sesvete Croatia 30 67 38 59
4 Hrvatski Dragovoljac Hrvatski 30 60 25 58
5 NK Solin NK Solin 30 58 33 53
6 Imotski Imotski 30 41 44 44
7 Belisce Belisce 30 46 40 42
8 Pomorac Pomorac 30 53 51 42
9 Vukovar '91 Vukovar '91 30 40 42 35
10 NK HASK Zagreb HASK Zagreb 30 44 49 35
11 Mosor Mosor 30 37 46 35
12 Marsonia Marsonia 30 38 50 34
13 Moslavina Moslavina 29 40 56 30
14 NK Koprivnica Koprivnica 30 42 66 29
15 Bjelovar Bjelovar 29 24 62 18
16 NK Cakovec NK Cakovec 30 37 87 16
TEMPORADA 2004/2005
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 Hrvatski Dragovoljac Hrvatski 22 45 26 43
2 Novalja Novalja 22 33 19 38
3 NK Solin NK Solin 22 41 39 38
4 HNK Sibenik HNK Sibenik 22 30 16 37
5 Mosor Mosor 22 38 25 37
6 Segesta Segesta 22 38 26 35
7 Pomorac Pomorac 22 30 29 31
8 Naftas Ivanic Naftas 22 29 40 24
9 Imotski Imotski 22 23 36 23
10 NK Croatia Sesvete Croatia 22 27 38 21
11 GOŠK DBK GOŠK DBK 22 17 41 20
12 NK Uskok Klis Uskok Klis 22 18 34 15
TEMPORADA 2003/2004
PRIMERA CROACIA 1. NL GRUPO 2
Equipo PJ GF GC Puntos
1 NK Istra 1961 Istra 1961 22 38 19 43
2 NK Solin NK Solin 22 39 25 39
3 Pomorac Pomorac 22 36 26 39
4 HNK Sibenik HNK Sibenik 22 36 28 37
5 Segesta Segesta 22 32 27 36
6 Novalja Novalja 22 29 25 34
7 NK Uskok Klis Uskok Klis 22 35 33 34
8 Imotski Imotski 22 28 33 25
9 Hrvatski Dragovoljac Hrvatski 22 20 26 25
10 NK Croatia Sesvete Croatia 22 29 38 24
11 GOŠK DBK GOŠK DBK 22 20 38 20
12 HNK Orijent Rijeka Orijent 22 15 39 8

  USO DE MEMORIA  
7,104,760 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1318
Total Execution Time  0.1332
  CADENA URL  
/historico/Solin
  GET DATOS  
$_GET['/historico/Solin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
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 = 'Solin' 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=13155 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=13155 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=13155 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13155 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13155 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0021  SELECT /*35 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 (777207) ORDER BY n.cover_points DESC, update_date DESC
0.0031  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 = '13155' ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '13155' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '13155' 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.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=13155 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0021  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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72476 AND teamId = 13155
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68391 AND teamId = 13155
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 13155
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 = 72476 AND t.round = 29 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '13155' 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 = '13155' and rp.type = 4
0.0020  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 = '13155' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 13155 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.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 = 13155 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 = 13155 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 13155 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 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.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 `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.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 `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.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 `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.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 `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 = 44241 AND t.round = 26 ORDER BY team.conference 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 `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 = 38803 AND t.round = 33 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 `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 = 15853 AND t.round = 34 ORDER BY team.conference 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 `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 = 9294 AND t.round = 34 ORDER BY team.conference 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 `tables2005` 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 = 8716 AND t.round = 22 ORDER BY team.conference 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 `tables2004` 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 = 8720 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 72476 ORDER BY nameShow LIMIT 100