4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Neusiedl
TEMPORADA 2023/2024
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Rapid Wien II Rapid Wien 26 59 23 56
2 Donaufeld Donaufeld 25 57 30 46
3 Kremser SC Kremser SC 26 40 28 46
4 Leobendorf Leobendorf 25 48 30 45
5 SC Wiener Viktoria Wiener 26 45 38 40
6 Marchfeld Marchfeld 26 40 39 40
7 Austria Wien II Austria Wien 25 40 32 36
8 Wiener SC Wiener SC 26 43 38 36
9 FCM Traiskirchen Traiskirchen 26 55 44 35
10 Elektra Elektra 26 29 35 32
11 Neusiedl Neusiedl 26 35 51 32
12 Oberwart / Rotenturm Oberwart 26 30 47 30
13 Favoritner AC Favoritner 26 28 43 28
14 Ardagger Ardagger 26 17 33 21
15 Mauerwerk Mauerwerk 25 22 51 19
16 Drassburg Drassburg 26 32 58 19
TEMPORADA 2022/2023
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 Stripfing Stripfing 30 86 20 72
2 Elektra Elektra 30 55 32 59
3 Donaufeld Donaufeld 30 56 41 52
4 Wiener SC Wiener SC 30 43 30 49
5 FCM Traiskirchen Traiskirchen 30 44 37 47
6 Marchfeld Marchfeld 30 56 52 47
7 Kremser SC Kremser SC 30 47 51 44
8 Leobendorf Leobendorf 30 38 39 42
9 Mauerwerk Mauerwerk 30 52 63 41
10 SC Wiener Viktoria Wiener 30 47 51 39
11 Drassburg Drassburg 30 40 49 39
12 Neusiedl Neusiedl 30 49 45 38
13 Siegendorf Siegendorf 30 35 43 36
14 Scheiblingkirchen-Warth Scheiblingki 30 44 48 34
15 Wiener Neustadt Wiener 30 37 67 22
16 Bruck/Leitha Bruck/Leitha 30 19 80 12
TEMPORADA 2021/2022
TERCERA AUSTRIA GRUPO 5
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 26 52 18 58
2 Stripfing Stripfing 26 60 19 54
3 Wiener SC Wiener SC 26 48 32 46
4 Leobendorf Leobendorf 26 45 37 45
5 Neusiedl Neusiedl 26 39 37 41
6 Elektra Elektra 26 33 31 41
7 Marchfeld Marchfeld 26 44 41 40
8 SC Wiener Viktoria Wiener 26 36 36 38
9 FCM Traiskirchen Traiskirchen 26 41 42 35
10 Bruck/Leitha Bruck/Leitha 26 43 44 27
11 Mauerwerk Mauerwerk 26 29 56 23
12 Admira Wacker II Admira 26 33 53 19
13 Wiener Neustadt Wiener 26 31 55 19
14 Drassburg Drassburg 26 22 55 16
TEMPORADA 2020/2021
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Wiener SC Wiener SC 8 13 4 19
2 Bruck/Leitha Bruck/Leitha 9 24 11 18
3 Leobendorf Leobendorf 7 16 9 18
4 FCM Traiskirchen Traiskirchen 9 20 9 16
5 Team Wiener Linien Team Wiener 8 14 7 15
6 Stripfing Stripfing 6 10 4 15
7 Marchfeld Marchfeld 8 13 12 11
8 Admira Wacker II Admira 7 10 9 11
9 SC Wiener Viktoria Wiener 10 8 21 7
10 Mauerwerk Mauerwerk 8 7 18 6
11 Neusiedl Neusiedl 8 6 17 6
12 Drassburg Drassburg 9 12 22 5
13 Wiener Neustadt Wiener 7 2 12 4
TEMPORADA 2019/2020
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Marchfeld Marchfeld 18 34 15 42
2 Rapid Wien II Rapid Wien 18 32 13 37
3 Ebreichsdorf Ebreichsdorf 18 28 11 34
4 Wiener SC Wiener SC 18 37 27 30
5 Stripfing Stripfing 18 24 16 30
6 Team Wiener Linien Team Wiener 18 23 20 27
7 SC Wiener Viktoria Wiener 18 31 30 27
8 Mattersburg II Mattersburg 18 30 25 25
9 Drassburg Drassburg 18 25 30 25
10 Wiener Neustadt Wiener 18 29 34 23
11 Neusiedl Neusiedl 18 25 35 23
12 Mauerwerk Mauerwerk 18 25 32 20
13 Bruck/Leitha Bruck/Leitha 18 24 35 19
14 FCM Traiskirchen Traiskirchen 18 25 34 16
15 Admira Wacker II Admira 18 20 28 14
16 Leobendorf Leobendorf 18 11 38 9
TEMPORADA 2018/2019
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Ebreichsdorf Ebreichsdorf 30 90 20 72
2 Karabakh Wien Karabakh 30 64 29 65
3 Marchfeld Marchfeld 30 61 36 57
4 Wiener SC Wiener SC 30 57 47 55
5 Leobendorf Leobendorf 30 43 27 51
6 Rapid Wien II Rapid Wien 30 53 38 47
7 Neusiedl Neusiedl 30 52 55 42
8 FCM Traiskirchen Traiskirchen 30 52 56 40
9 Bruck/Leitha Bruck/Leitha 30 45 57 40
10 Mattersburg II Mattersburg 30 45 57 36
11 Admira Wacker II Admira 30 45 59 36
12 Team Wiener Linien Team Wiener 29 43 49 34
13 Parndorf Parndorf 30 43 52 32
14 St. Pölten II Pölten 29 34 56 26
15 Stadlau Stadlau 30 37 68 23
16 Schwechat Schwechat 30 22 80 10
TEMPORADA 2017/2018
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Horn Horn 31 62 25 68
2 Ebreichsdorf Ebreichsdorf 31 58 27 63
3 SKU Amstetten Amstetten 31 69 30 62
4 Austria Wien II Austria Wien 31 61 36 60
5 Karabakh Wien Karabakh 31 65 46 59
6 Rapid Wien II Rapid Wien 31 58 48 49
7 Marchfeld Marchfeld 31 50 46 49
8 FCM Traiskirchen Traiskirchen 31 37 46 44
9 Bruck/Leitha Bruck/Leitha 31 49 57 40
10 Stadlau Stadlau 31 35 43 35
11 Admira Wacker II Admira 31 44 53 32
12 Neusiedl Neusiedl 30 38 58 32
13 Parndorf Parndorf 31 37 61 30
14 St. Pölten II Pölten 31 37 52 29
15 Wiener SC Wiener SC 31 40 63 29
16 Schwechat Schwechat 31 26 69 18
17 First Vienna First Vienna 15 17 23 13
TEMPORADA 2016/2017
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 28 61 20 65
2 Ritzing Ritzing 28 59 37 51
3 Austria Wien II Austria Wien 28 41 29 50
4 Stadlau Stadlau 28 39 24 44
5 Marchfeld Marchfeld 28 47 45 44
6 Ebreichsdorf Ebreichsdorf 28 51 53 41
7 SKU Amstetten Amstetten 28 42 32 39
8 FCM Traiskirchen Traiskirchen 28 39 40 38
9 Parndorf Parndorf 28 38 41 37
10 Rapid Wien II Rapid Wien 28 49 44 36
11 Admira Wacker II Admira 28 39 42 28
12 Wiener SC Wiener SC 28 30 33 28
13 Neusiedl Neusiedl 28 33 58 25
14 St. Pölten II Pölten 28 30 62 24
15 Schwechat Schwechat 28 25 63 20
TEMPORADA 2015/2016
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Horn Horn 30 80 28 69
2 First Vienna First Vienna 30 63 21 67
3 Ritzing Ritzing 30 58 30 52
4 SKU Amstetten Amstetten 30 51 30 52
5 Ebreichsdorf Ebreichsdorf 30 42 40 44
6 Stadlau Stadlau 30 42 40 43
7 Parndorf Parndorf 30 58 46 42
8 Austria Wien II Austria Wien 30 45 39 39
9 St. Pölten II Pölten 30 32 41 39
10 Admira Wacker II Admira 30 47 55 36
11 Sollenau Sollenau 30 35 57 32
12 Rapid Wien II Rapid Wien 30 38 57 31
13 Neusiedl Neusiedl 30 44 60 29
14 Wiener SC Wiener SC 30 37 54 29
15 Schwechat Schwechat 30 33 64 26
16 Oberwart Oberwart 30 29 72 23
TEMPORADA 2014/2015
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Ritzing Ritzing 30 60 34 61
2 Parndorf Parndorf 30 64 36 55
3 SKU Amstetten Amstetten 30 60 38 48
4 First Vienna First Vienna 30 46 32 48
5 Neusiedl Neusiedl 30 43 46 45
6 Schwechat Schwechat 30 44 32 44
7 Admira Wacker II Admira 30 48 44 42
8 Sollenau Sollenau 30 50 49 42
9 Rapid Wien II Rapid Wien 30 50 42 39
10 Austria Wien II Austria Wien 30 52 46 39
11 St. Pölten II Pölten 30 46 51 38
12 Wiener SC Wiener SC 30 53 55 37
13 Mattersburg II Mattersburg 30 42 48 36
14 SV Stegersbach Stegersbach 30 33 49 36
15 Donaufeld Donaufeld 30 44 61 31
16 Neuberg Neuberg 30 23 95 9
TEMPORADA 2013/2014
CUARTA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Parndorf II Parndorf II 30 52 23 67
2 Neusiedl Neusiedl 30 67 42 54
3 Marz Marz 30 58 45 53
4 St. Georgen St. Georgen 30 46 37 49
5 Horitschon Horitschon 30 44 39 47
6 Klingenbach Klingenbach 30 46 40 45
7 Drassburg Drassburg 30 76 59 44
8 Purbach Purbach 30 50 38 44
9 Baumgarten Baumgarten 30 47 54 38
10 St. Margarethen Margarethen 30 45 56 37
11 Jennersdorf Jennersdorf 30 52 48 36
12 Pinkafeld Pinkafeld 30 52 68 36
13 Forchtenstein Forchtenstei 30 66 81 35
14 Stinatz Stinatz 30 29 50 33
15 Güssing Güssing 30 30 57 27
16 Sigleß Sigleß 30 38 61 24
TEMPORADA 2012/2013
CUARTA AUSTRIA GRUPO 4
Equipo PJ GF GC Puntos
1 Neuberg Neuberg 30 75 27 76
2 Purbach Purbach 30 59 40 53
3 Stinatz Stinatz 30 49 41 51
4 Horitschon Horitschon 30 52 40 49
5 Marz Marz 30 74 43 48
6 Drassburg Drassburg 30 76 57 47
7 Jennersdorf Jennersdorf 30 48 36 47
8 Neusiedl Neusiedl 30 48 38 47
9 Klingenbach Klingenbach 30 43 38 46
10 St. Margarethen Margarethen 30 49 49 45
11 Parndorf II Parndorf II 30 45 46 45
12 Baumgarten Baumgarten 30 55 51 41
13 Güssing Güssing 30 46 40 38
14 Sigleß Sigleß 30 39 50 27
15 Winden Winden 30 28 85 12
16 SC Buchschachen Buchschachen 30 24 129 9
TEMPORADA 2011/2012
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Horn Horn 30 70 23 64
2 Rapid Wien II Rapid Wien 30 58 25 62
3 Austria Wien II Austria Wien 30 60 38 49
4 Parndorf Parndorf 30 46 39 45
5 Wiener SC Wiener SC 30 48 51 43
6 SV Stegersbach Stegersbach 30 56 54 41
7 Ritzing Ritzing 30 37 53 41
8 Sollenau Sollenau 30 75 67 40
9 FAC Wien FAC Wien 30 36 29 40
10 SKU Amstetten Amstetten 30 43 54 39
11 Mattersburg II Mattersburg 30 46 49 38
12 Schwechat Schwechat 30 39 39 37
13 Simmeringer SC Simmeringer 30 40 48 37
14 Admira Wacker II Admira 30 45 58 37
15 Neusiedl Neusiedl 30 47 58 36
16 Columbia Floridsdorf Columbia 30 27 88 15
TEMPORADA 2010/2011
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 81 34 57
2 Horn Horn 30 64 39 56
3 Austria Wien II Austria Wien 30 52 29 56
4 Sollenau Sollenau 30 51 47 46
5 Ritzing Ritzing 30 47 52 46
6 Wiener SC Wiener SC 30 55 49 45
7 Rapid Wien II Rapid Wien 30 63 50 44
8 Neusiedl Neusiedl 30 49 45 43
9 FAC Wien FAC Wien 30 40 36 43
10 Mattersburg II Mattersburg 30 49 40 42
11 Waidhofen Waidhofen 30 43 45 42
12 Admira Wacker II Admira 30 45 60 40
13 Schwechat Schwechat 30 37 48 39
14 Columbia Floridsdorf Columbia 30 33 50 37
15 Ostbahn XI Ostbahn XI 30 32 79 17
16 Baumgarten Baumgarten 30 40 78 16
TEMPORADA 2009/2010
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 Waidhofen Waidhofen 30 57 31 58
2 Admira Wacker II Admira 30 45 34 55
3 Parndorf Parndorf 30 63 32 54
4 Horn Horn 30 51 30 54
5 Rapid Wien II Rapid Wien 30 49 30 50
6 Ostbahn XI Ostbahn XI 30 44 32 48
7 Neusiedl Neusiedl 30 52 44 47
8 Wiener SC Wiener SC 30 59 50 46
9 Mattersburg II Mattersburg 30 51 46 41
10 Baumgarten Baumgarten 30 41 60 41
11 FAC Wien FAC Wien 30 49 53 40
12 Schwechat Schwechat 30 36 35 39
13 Wienerberg Wienerberg 30 46 49 39
14 Gaflenz Gaflenz 30 27 74 23
15 Würmla Würmla 30 33 66 17
16 Zwettl Zwettl 30 32 69 17
TEMPORADA 2008/2009
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 First Vienna First Vienna 30 60 27 63
2 Horn Horn 30 51 26 60
3 Parndorf Parndorf 30 49 23 56
4 Wiener SC Wiener SC 30 53 42 54
5 Waidhofen Waidhofen 30 40 32 53
6 Rapid Wien II Rapid Wien 30 54 40 49
7 Wienerberg Wienerberg 30 45 47 43
8 Admira Wacker II Admira 30 51 47 41
9 FAC Wien FAC Wien 30 44 42 41
10 Mattersburg II Mattersburg 30 59 53 38
11 Zwettl Zwettl 30 36 62 31
12 Würmla Würmla 30 41 58 29
13 Neusiedl Neusiedl 30 37 50 27
14 Ostbahn XI Ostbahn XI 30 39 71 27
15 SKU Amstetten Amstetten 30 44 61 26
16 SV Stegersbach Stegersbach 30 43 65 26
TEMPORADA 2007/2008
TERCERA AUSTRIA GRUPO 3
Equipo PJ GF GC Puntos
1 SKN St. Polten Polten 30 58 21 73
2 FAC Wien FAC Wien 30 59 31 65
3 Rapid Wien II Rapid Wien 30 60 34 57
4 Wiener SC Wiener SC 30 50 24 56
5 First Vienna First Vienna 30 43 34 49
6 Horn Horn 30 54 45 46
7 Würmla Würmla 30 48 49 46
8 Neusiedl Neusiedl 30 40 47 41
9 Admira Admira 30 50 43 40
10 Wienerberg Wienerberg 30 34 36 37
11 Waidhofen Waidhofen 30 39 44 37
12 Mattersburg II Mattersburg 30 43 46 34
13 Zwettl Zwettl 30 47 58 33
14 Schwechat Schwechat 30 32 47 32
15 Baumgarten Baumgarten 30 35 73 19
16 Eisenstadt SC Eisenstadt 30 13 73 11
TEMPORADA 2006/2007
TERCERA AUSTRIA GRUPO 2
Equipo PJ GF GC Puntos
1 Schwadorf Schwadorf 30 66 20 72
2 PSV Wien PSV Wien 30 63 25 65
3 First Vienna First Vienna 30 67 36 60
4 Wiener SC Wiener SC 30 70 26 59
5 SKN St. Polten Polten 30 71 27 56
6 Rapid Wien II Rapid Wien 30 60 36 53
7 Waidhofen Waidhofen 30 41 40 45
8 Neusiedl Neusiedl 30 40 41 38
9 Zwettl Zwettl 30 45 62 38
10 Baumgarten Baumgarten 30 34 46 32
11 Eisenstadt SC Eisenstadt 30 43 80 32
12 Würmla Würmla 30 36 46 29
13 Schwechat Schwechat 30 31 61 29
14 Kremser SC Kremser SC 30 33 71 24
15 Admira Wacker II Admira 30 25 75 19
16 Ritzing Ritzing 30 27 60 15
TEMPORADA 2005/2006
TERCERA AUSTRIA GRUPO 1
Equipo PJ GF GC Puntos
1 Parndorf Parndorf 30 52 23 65
2 SKN St. Polten Polten 30 65 33 64
3 First Vienna First Vienna 30 56 21 62
4 PSV Wien PSV Wien 30 41 33 50
5 Admira Wacker II Admira 30 48 47 46
6 Wiener SC Wiener SC 30 49 51 43
7 Waidhofen Waidhofen 30 46 50 41
8 Würmla Würmla 30 36 43 38
9 Ritzing Ritzing 30 32 42 37
10 Kremser SC Kremser SC 30 36 42 36
11 Zwettl Zwettl 30 44 46 33
12 Neusiedl Neusiedl 30 41 49 31
13 Schwechat Schwechat 30 27 38 31
14 Eisenstadt SC Eisenstadt 30 33 47 31
15 Kottingbrunn Kottingbrunn 30 31 51 27
16 Donau Donau 30 23 44 27
TEMPORADA 1983/1984
BUNDESLIGA AUSTRIA
Equipo PJ GF GC Puntos
1 Austria Wien Austria Wien 30 85 29 47
2 Rapid Wien Rapid Wien 30 71 18 47
3 LASK LASK 30 54 25 42
4 SSW Innsbruck Innsbruck 30 54 31 37
5 Sturm Graz Sturm Graz 30 51 44 37
6 FC Admira Wacker Admira 30 47 36 36
7 Austria Klagenfurt Austria 30 55 38 34
8 Grazer AK Grazer AK 30 45 37 32
9 Wiener SC Wiener SC 30 54 51 27
10 Salzburg Salzburg 30 39 46 27
11 Eisenstadt SC Eisenstadt 30 39 49 25
12 FC Linz FC Linz 30 35 47 25
13 Favoritner AC Favoritner 30 35 52 25
14 Sankt Veit Sankt Veit 30 37 59 21
15 Union Wels Union Wels 30 22 69 14
16 Neusiedl Neusiedl 30 10 102 4

  USO DE MEMORIA  
7,659,432 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.9251
Total Execution Time  0.9263
  CADENA URL  
/historico/Neusiedl-At
  GET DATOS  
$_GET['/historico/Neusiedl-At']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0204  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 = 'Neusiedl-At' 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.0152  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=17528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=17528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=17528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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=17528 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0305  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 = 72560
0.0171  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 = 72330
0.0151  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17528 AND type_rel = 2
0.0151  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=338 AND type_rel = 3
0.0156  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 338 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0162  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 (1268188,1267669,1162598,981042,744718) ORDER BY n.cover_points DESC, update_date DESC
0.0172  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 = '17528' ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '17528' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0178  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 = '17528' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0165  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 = 72330 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0157  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 = 72560 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0175  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=17528 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0154  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 (72560,72330,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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 72560 AND teamId = 17528
0.0172  SELECT count(id) as num_players from rel_players WHERE league_id = 72330 AND teamId = 17528
0.0176  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17528
0.0163  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 = 72560 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153  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 = '17528' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17528' and rp.type = 4
0.0155  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 = '17528' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0163  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17528 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.0155  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17528 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 72560 WHERE rp.league_id = 72560 AND rp.teamId = 17528 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0157  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 = 17528 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0153  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 = 72560 AND t.round = 26 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 `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 = 68180 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.0163  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 = 63404 AND t.round = 26 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 `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 = 57018 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 50222 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.0161  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 = 44212 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 38882 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 33374 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 15761 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 4154 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 = 3584 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 27170 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 24530 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 `tables2011` 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 = 24533 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 `tables2010` 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 = 24536 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2009` 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 = 24539 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0164  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 `tables2008` 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 = 24542 AND t.round = 30 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 `tables2007` 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 = 27599 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables2006` 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 = 27587 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 `tables1984` 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 = 10050 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC