4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Flacăra Făleşti
TEMPORADA 2023/2024
SEGUNDA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Sheriff II Sheriff 7 28 5 19
2 Olimp Comrat Olimp Comrat 7 17 8 15
3 Speranis Nisporeni Speranis 7 10 6 13
4 FCM Ungheni FCM Ungheni 7 12 15 11
5 Flacăra Făleşti Flacăra 7 11 17 10
6 Iskra Rîbniţa Iskra 7 10 10 9
7 Real Succes Real Succes 7 11 17 4
8 Dinamo-Auto Cioburciu Dinamo-Auto 7 0 21 0
TEMPORADA 2022/2023
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Florești Florești 10 15 8 21
2 Flacăra Făleşti Flacăra 10 22 16 19
3 FC Sheriff II Sheriff 10 28 6 18
4 Ungheni Ungheni 10 20 15 16
5 Speranis Nisporeni Speranis 10 17 27 10
6 Sucleia Sucleia 10 10 40 3
7 FC Victoria Bardar Victoria 10 41 9 24
8 Spartanii Selemet Spartanii 10 25 11 24
9 Speranța Drochia Speranța 10 14 14 13
10 Văsieni Văsieni 10 13 24 12
11 Olimp Comrat Olimp Comrat 10 12 28 8
12 Real Succes Real Succes 10 13 32 7
TEMPORADA 2021/2022
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Flacăra Făleşti Flacăra 24 82 29 58
2 Sîngerei Sîngerei 24 65 31 53
3 FC Edinet FC Edinet 24 46 22 52
4 Cruiz Cruiz 24 55 30 49
5 Inter Soroca Inter Soroca 24 52 45 40
6 EFA Visoca EFA Visoca 24 38 36 33
7 FC Olimpia FC Olimpia 24 46 52 30
8 Codru Călărași II Codru 24 53 54 28
9 Pepeni Pepeni 24 27 44 28
10 FC Visoca FC Visoca 24 33 49 18
11 Grănicerul Grănicerul 24 23 53 18
12 CF Riscani CF Riscani 24 33 67 16
13 Ocniţa Ocniţa 24 29 70 16
14 Teleneşti Teleneşti 0 0 0 0
TEMPORADA 2020/2021
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Bălți FC Bălți 26 85 17 69
2 Cahul Cahul 26 70 23 57
3 FC Sheriff II Sheriff 26 46 24 54
4 Spartanii Selemet Spartanii 26 57 42 46
5 Sucleia Sucleia 26 64 38 46
6 Speranța Drochia Speranța 26 49 41 42
7 Olimp Comrat Olimp Comrat 26 51 44 38
8 Iskra Rîbniţa Iskra 26 53 49 35
9 FC Tighina FC Tighina 26 42 61 30
10 Real Succes Real Succes 26 44 35 28
11 FC Victoria Bardar Victoria 26 61 65 26
12 Grănicerul Grănicerul 26 25 61 22
13 Flacăra Făleşti Flacăra 26 40 92 18
14 Sireți Sireți 26 26 121 9
TEMPORADA 2018/2019
TRANSICIÓN TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Edinet FC Edinet 18 78 17 46
2 Flacăra Făleşti Flacăra 18 49 21 46
3 Inter Soroca Inter Soroca 18 47 32 36
4 Pepeni Pepeni 18 41 34 33
5 Intersport Sănătăuca Intersport 18 28 37 22
6 CF Riscani CF Riscani 18 34 55 21
7 Cruiz Cruiz 18 30 35 16
8 Academia Viitorul Academia 18 25 41 16
9 Rezina Rezina 18 16 51 12
10 Natalievca Natalievca 18 30 55 9
TEMPORADA 2016/2017
TRANSICIÓN TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 FC Florești Florești 18 57 19 44
2 Dava Soroca Dava Soroca 18 41 21 39
3 Intersport Sănătăuca Intersport 18 46 19 37
4 FCM Ungheni FCM Ungheni 18 60 24 36
5 Speranța Drochia Speranța 18 48 30 29
6 Maiak Cioropcani Maiak 18 33 33 21
7 Zaria II Zaria II 18 30 38 21
8 CF Riscani CF Riscani 18 26 59 19
9 Cruiz Cruiz 18 14 59 10
10 Flacăra Făleşti Flacăra 18 7 60 4
TEMPORADA 2015/2016
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Sîngerei Sîngerei 18 63 21 43
2 FC Florești Florești 18 49 17 42
3 Intersport Sănătăuca Intersport 18 30 16 35
4 Grănicerul Grănicerul 18 39 16 34
5 Drochia Drochia 18 36 22 30
6 Flacăra Făleşti Flacăra 18 33 32 26
7 Dava Soroca Dava Soroca 18 25 53 17
8 Cotiujănii Mari Cotiujănii 18 19 56 14
9 CF Riscani CF Riscani 18 22 49 12
10 Teleneşti Teleneşti 18 7 41 6
TEMPORADA 2014/2015
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spicul Chișcăreni Spicul 21 95 18 61
2 Iskra Rîbniţa Iskra 22 70 24 47
3 Sîngerei Sîngerei 22 48 28 46
4 Intersport Sănătăuca Intersport 22 35 31 41
5 FC Florești Florești 22 41 39 31
6 Flacăra Făleşti Flacăra 22 43 45 30
7 Dava Soroca Dava Soroca 22 40 53 28
8 Cotiujănii Mari Cotiujănii 22 44 73 26
9 Drochia Drochia 21 32 40 24
10 Grănicerul Grănicerul 22 22 42 18
11 Teleneşti Teleneşti 22 19 53 12
12 CF Riscani CF Riscani 22 24 67 9
TEMPORADA 2013/2014
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Budăi Budăi 18 43 11 43
2 Sîngerei Sîngerei 18 28 11 37
3 FC Florești Florești 18 33 28 29
4 Dava Soroca Dava Soroca 18 24 34 25
5 Iskra Iskra 18 30 32 24
6 Ungheni Ungheni 18 39 32 23
7 Flacăra Făleşti Flacăra 18 21 30 21
8 Teleneşti Teleneşti 18 15 20 16
9 Drochia Drochia 18 16 38 16
10 Grănicerul Grănicerul 18 29 42 14
TEMPORADA 2012/2013
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 CF Riscani CF Riscani 16 43 16 36
2 Ungheni Ungheni 16 40 21 31
3 FC Florești Florești 16 27 27 26
4 Teleneşti Teleneşti 16 25 15 25
5 Flacăra Făleşti Flacăra 16 20 25 25
6 Drochia Drochia 16 23 19 21
7 Sîngerei Sîngerei 16 22 28 15
8 Dava Soroca Dava Soroca 16 20 40 12
9 Grănicerul Grănicerul 16 19 48 5
TEMPORADA 2011/2012
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Veris Veris 20 84 2 60
2 FC Edinet FC Edinet 20 41 22 38
3 Drochia Drochia 20 34 29 31
4 CF Riscani CF Riscani 20 36 41 30
5 Grănicerul Grănicerul 20 51 49 29
6 Dava Soroca Dava Soroca 20 24 26 28
7 FC Florești Florești 20 32 40 23
8 Flacăra Făleşti Flacăra 20 24 45 23
9 Teleneşti Teleneşti 20 22 31 19
10 Sîngerei Sîngerei 20 26 45 19
11 Moldova 03 Ungheni Moldova 20 24 68 12
TEMPORADA 2010/2011
TERCERA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Orhei Star Orhei Star 18 28 10 40
2 Grănicerul Grănicerul 18 31 23 32
3 Dava Soroca Dava Soroca 18 30 21 31
4 FC Florești Florești 18 25 16 30
5 Teleneşti Teleneşti 18 24 20 28
6 Nisporeni Nisporeni 18 33 27 25
7 CF Riscani CF Riscani 18 21 19 25
8 Drochia Drochia 18 21 33 19
9 Flacăra Făleşti Flacăra 18 15 33 13
10 Codru Lozova Codru Lozova 18 14 40 6

  USO DE MEMORIA  
5,880,424 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6662
Total Execution Time  0.6675
  CADENA URL  
/historico/Flacara-Falesti
  GET DATOS  
$_GET['/historico/Flacara-Falesti']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0163  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 = 'Flacara-Falesti' 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.0128  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=61689 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61689 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61689 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0128  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=61689 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0268  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 = 73215
0.0153  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 = 74915
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61689 AND type_rel = 2
0.0129  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=376 AND type_rel = 3
0.0135  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 376 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0131  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 (15930) ORDER BY n.cover_points DESC, update_date DESC
0.0149  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 = '61689' ORDER BY l.year DESC,cat.coefficient DESC
0.0150  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 = '61689' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0156  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 = '61689' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0140  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 = 73520 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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 = 73215 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  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=61689 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 (74915,73520,71604) 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 = 74915 AND teamId = 61689
0.0127  SELECT count(id) as num_players from rel_players WHERE league_id = 71604 AND teamId = 61689
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73520 AND teamId = 61689
0.0126  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 = '61689' 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 = '61689' 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 = '61689' 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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61689 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.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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61689 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0128  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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61689 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135  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 = 61689 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0140  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 = 73215 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0139  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 = 74915 AND t.round = 7 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0140  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 = 68584 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 64140 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.0132  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 = 49572 AND t.round = 18 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 `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 = 34770 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 `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 = 39920 AND t.round = 18 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 `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 = 15831 AND t.round = 18 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 `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 = 9505 AND t.round = 22 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 `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 = 24994 AND t.round = 18 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 = 24997 AND t.round = 18 ORDER BY team.conference 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 `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 = 25000 AND t.round = 22 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 `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 = 25003 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC