4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Podravina
TEMPORADA 2023/2024
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 NK Polet NK Polet 14 40 9 36
2 Pitomača Pitomača 14 32 17 29
3 NK Rudar NK Rudar 14 24 13 27
4 Varteks Varteks 14 24 13 22
5 Dinamo Domašinec Dinamo 14 23 22 20
6 Graničar Kotoriba Graničar 14 16 28 17
7 Medjimurje Cakovec Medjimurje 14 20 20 16
8 Podravina Podravina 14 14 23 16
9 NK Koprivnica Koprivnica 14 9 24 10
10 Virovitica Virovitica 14 6 39 3
TEMPORADA 2022/2023
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 NK Križevci Križevci 27 71 27 67
2 NK Polet NK Polet 27 65 17 66
3 Varteks Varteks 27 51 31 51
4 NK Rudar NK Rudar 27 47 44 41
5 Dinamo Domašinec Dinamo 27 36 46 37
6 NK Papuk Orahovica Papuk 27 33 59 32
7 NK Koprivnica Koprivnica 27 30 47 26
8 Virovitica Virovitica 27 36 54 22
9 Podravina Podravina 27 38 59 22
10 Podravac Podravac 27 34 57 21
TEMPORADA 2021/2022
TERCERA CROACIA 3. NL GRUPO 7
Equipo PJ GF GC Puntos
1 NK Polet NK Polet 27 75 22 63
2 Mladost Ždralovi Mladost 27 54 18 62
3 Bjelovar Bjelovar 27 68 33 57
4 NK Križevci Križevci 27 69 35 50
5 Medjimurje Cakovec Medjimurje 27 45 47 42
6 Podravina Podravina 27 39 61 31
TEMPORADA 2020/2021
TERCERA CROACIA 3. NL GRUPO 6
Equipo PJ GF GC Puntos
1 Mladost Ždralovi Mladost 27 65 20 60
2 NK Polet NK Polet 27 64 24 54
3 NK Križevci Križevci 27 50 43 49
4 NK Papuk Orahovica Papuk 27 46 44 43
5 Tehničar 1974 Tehničar 27 32 29 42
6 Podravina Podravina 27 43 40 40
TEMPORADA 2019/2020
TERCERA CROACIA 3. NL GRUPO 3
Equipo PJ GF GC Puntos
1 Mladost Ždralovi Mladost 16 36 13 41
2 NK Polet NK Polet 16 53 15 40
3 NK Križevci Križevci 16 33 25 31
4 Tehničar 1974 Tehničar 16 39 18 30
5 Varteks Varteks 16 41 21 29
6 NK Rudar NK Rudar 16 26 33 22
7 Bjelovar Bjelovar 16 29 28 20
8 Virovitica Virovitica 16 25 34 20
9 Podravac Podravac 16 18 43 16
10 NK Papuk Orahovica Papuk 16 20 32 13
11 Podravina Podravina 16 17 48 7
12 Graničar Đurđevac Graničar 16 17 44 6
TEMPORADA 2015/2016
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Medjimurje Cakovec Medjimurje 30 62 15 66
2 Bjelovar Bjelovar 30 61 29 57
3 Pleternica Pleternica 30 49 35 57
4 Belisce Belisce 30 58 30 54
5 Marsonia Marsonia 30 42 24 54
6 Bijelo Brdo Bijelo Brdo 30 56 40 52
7 Mladost Ždralovi Mladost 30 47 37 52
8 Slavonija Slavonija 30 59 51 43
9 Vukovar '91 Vukovar '91 30 48 50 42
10 Oriolik Oriolik 30 29 38 37
11 NK Varazdin NK Varazdin 30 40 47 34
12 HNK Đakovo Croatia Đakovo 30 34 48 34
13 NK Koprivnica Koprivnica 30 43 56 33
14 Višnjevac Višnjevac 30 46 56 32
15 Podravina Podravina 30 36 74 21
16 Mladost Antin Mladost 30 19 99 5
TEMPORADA 2014/2015
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Pleternica Pleternica 30 62 18 63
2 NK Koprivnica Koprivnica 30 58 27 54
3 Medjimurje Cakovec Medjimurje 30 56 29 54
4 Mladost Ždralovi Mladost 30 49 33 54
5 Mladost Antin Mladost 30 43 25 52
6 Slavonija Slavonija 30 47 43 46
7 Belisce Belisce 30 53 45 43
8 Višnjevac Višnjevac 30 33 37 43
9 HNK Đakovo Croatia Đakovo 30 45 43 42
10 Vukovar '91 Vukovar '91 30 50 47 41
11 NK Varazdin NK Varazdin 30 42 39 39
12 Bjelovar Bjelovar 30 35 42 37
13 Bijelo Brdo Bijelo Brdo 30 46 55 36
14 Podravina Podravina 30 33 49 32
15 Oriolik Oriolik 30 25 53 25
16 Virovitica Virovitica 30 18 110 2
TEMPORADA 2013/2014
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Medjimurje Cakovec Medjimurje 30 90 25 66
2 Bjelovar Bjelovar 30 81 32 65
3 NK Koprivnica Koprivnica 30 96 26 64
4 Mladost Ždralovi Mladost 30 82 21 58
5 Croatia Grabrovnica Croatia 30 81 36 57
6 Podravina Podravina 30 88 43 52
7 NK Varazdin NK Varazdin 30 66 32 50
8 Podravac Podravac 30 60 58 49
9 NK Polet NK Polet 30 52 50 37
10 Virovitica Virovitica 30 48 51 36
11 NK Rudar NK Rudar 30 46 57 36
12 Nedelisce Nedelisce 30 35 67 33
13 Slatina Slatina 30 44 67 30
14 NK Mladost Prelog Mladost 30 42 83 24
15 Graničar Kotoriba Graničar 30 47 87 20
16 NK Cakovec NK Cakovec 30 15 238 2
TEMPORADA 2012/2013
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Mladost Ždralovi Mladost 30 64 22 68
2 Medjimurje Cakovec Medjimurje 30 58 21 67
3 Podravina Podravina 30 79 43 60
4 Croatia Grabrovnica Croatia 30 73 37 55
5 Nedelisce Nedelisce 30 64 45 54
6 Virovitica Virovitica 30 59 42 50
7 Bjelovar Bjelovar 30 48 33 43
8 NK Polet NK Polet 30 40 42 42
9 Graničar Kotoriba Graničar 30 47 56 41
10 NK Koprivnica Koprivnica 30 54 54 39
11 Podravac Podravac 30 38 63 32
12 Ivančica Ivančica 30 55 65 31
13 NK Mladost Prelog Mladost 30 45 86 31
14 Slatina Slatina 30 39 82 28
15 NK Cakovec NK Cakovec 30 39 72 26
16 NK Križevci Križevci 30 33 72 23
TEMPORADA 2011/2012
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Mladost Ždralovi Mladost 30 86 28 67
2 NK Koprivnica Koprivnica 30 69 23 66
3 Bjelovar Bjelovar 30 64 17 65
4 Nedelisce Nedelisce 30 70 48 64
5 Slatina Slatina 30 81 28 61
6 Podravina Podravina 30 73 48 54
7 Croatia Grabrovnica Croatia 30 70 41 53
8 Ivančica Ivančica 30 65 47 48
9 NK Cakovec NK Cakovec 30 64 59 48
10 NK Križevci Križevci 30 54 59 33
11 Nedeljanec Nedeljanec 30 43 59 30
12 Graničar Kotoriba Graničar 30 41 88 29
13 Podravac Podravac 30 40 60 28
14 NK Mladost Prelog Mladost 30 41 82 28
15 NK Papuk Orahovica Papuk 30 16 83 8
16 Polet Pribislavec Polet 30 20 127 4
TEMPORADA 2010/2011
TERCERA CROACIA 3. NL GRUPO 1
Equipo PJ GF GC Puntos
1 Podravina Podravina 34 78 37 70
2 NK Mladost Cernik Mladost 34 70 38 69
3 NK Dakovo NK Dakovo 34 57 38 65
4 Bjelovar Bjelovar 34 65 44 63
5 NK Otok NK Otok 34 58 36 62
6 Graničar Županja Graničar 34 72 49 56
7 Pleternica Pleternica 34 52 40 56
8 Nedelisce Nedelisce 34 70 61 54
9 Belisce Belisce 34 49 48 51
10 NK Križevci Križevci 34 40 51 45
11 NAŠK NAŠK 34 30 45 42
12 NK Lipik NK Lipik 34 49 75 42
13 NK Koprivnica Koprivnica 34 62 75 38
14 NK Olimpija Osijek Olimpija 34 53 68 37
15 Slatina Slatina 34 55 60 36
16 Slobodnica Slobodnica 34 44 68 36
17 HNK Đakovo Croatia Đakovo 34 37 82 31
18 NK Mladost Prelog Mladost 34 46 72 26

  USO DE MEMORIA  
5,734,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5809
Total Execution Time  0.5821
  CADENA URL  
/historico/Podravina-Ludbreg
  GET DATOS  
$_GET['/historico/Podravina-Ludbreg']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0135  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 = 'Podravina-Ludbreg' 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.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=17935 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=17935 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0252  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 = 73582
0.0124  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17935 AND type_rel = 2
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1565 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1565 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1083629,808269,786438,401208,400630) ORDER BY n.cover_points DESC, update_date DESC
0.0128  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 = '17935' ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '17935' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0126  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 = '17935' 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 = 73582 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0127  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=17935 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (73582) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 73582 AND teamId = 17935
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 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 = 73582 AND t.round = 14 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '17935' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17935' and rp.type = 4
0.0126  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 = '17935' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 73582 WHERE rp.league_id = 73582 AND rp.teamId = 17935 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.0126  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 = 73582 WHERE rp.league_id = 73582 AND rp.teamId = 17935 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 = 73582 WHERE rp.league_id = 73582 AND rp.teamId = 17935 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 = 17935 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 = 73582 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 68853 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 64043 AND t.round = 22 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 `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 = 67413 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 58551 AND t.round = 22 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 `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 = 62641 AND t.round = 5 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 51150 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
0.0128  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 = 15852 AND t.round = 30 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 `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 = 9293 AND t.round = 30 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 `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 = 24830 AND t.round = 30 ORDER BY team.conference 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 `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 = 24811 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128  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 = 24796 AND t.round = 30 ORDER BY team.conference 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 `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 = 24788 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0125  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 = 73582 ORDER BY nameShow LIMIT 100