4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Camping La Bota
TEMPORADA 2019/2020
PRIMERA ANDALUZA GRUPO 5
Equipo PJ GF GC Puntos
1 Bollullos CF Bollullos 24 70 19 64
2 Ayamonte Ayamonte 24 59 20 62
3 Camping La Bota Camping Bota 24 49 15 55
4 CD Cerreño CD Cerreño 24 47 27 40
5 Ol. Valverdeña Valverdeña 24 38 40 36
6 Pinzón CD Pinzón CD 24 36 44 35
7 Punta Umbria Punta Umbria 24 36 33 34
8 Los Rosales AD Rosales 24 44 48 31
9 Atl.Calañas Atl.Calañas 24 30 35 27
10 Rociana CD Rociana CD 24 40 46 27
11 Zalamea Zalamea 24 28 32 26
12 CD Canela CD Canela 24 36 46 25
13 CD Bonares CD Bonares 24 34 40 23
14 Riotinto Balompié Riotinto 24 26 56 18
15 Almonte Balompié Almonte 24 26 52 17
16 Gibraleón Gibraleón 24 15 61 9
TEMPORADA 2018/2019
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Ayamonte Ayamonte 33 80 32 69
2 Aroche CF Aroche CF 33 66 34 69
3 Almonte Balompié Almonte 33 71 37 67
4 Bollullos CF Bollullos 34 64 33 64
5 CD Cerreño CD Cerreño 33 55 44 58
6 Camping La Bota Camping Bota 34 57 37 55
7 Zalamea Zalamea 34 58 46 53
8 Gibraleón Gibraleón 33 48 46 50
9 CD Canela CD Canela 34 57 63 49
10 Los Rosales AD Rosales 33 41 50 44
11 CD Bonares CD Bonares 33 37 42 42
12 Atl. Cortegana Atl. 33 42 59 38
13 Mazagon CF Mazagon CF 33 53 71 38
14 UD Punta del Caiman Punta Caiman 33 46 82 35
15 Atlético Cruceño Atlético 34 35 51 34
16 San Roque de Lepe B Roque Lepe 33 46 57 30
17 Moguer CD Moguer CD 33 35 52 28
18 CD Rubias CD Rubias 22 8 63 1
TEMPORADA 2017/2018
PRIMERA ANDALUZA GRUPO 4
Equipo PJ GF GC Puntos
1 Pinzón CD Pinzón CD 34 74 30 76
2 Ayamonte Ayamonte 34 71 36 72
3 Camping La Bota Camping Bota 34 73 36 69
4 Aroche CF Aroche CF 34 65 28 68
5 Bollullos CF Bollullos 34 61 41 59
6 UD Punta del Caiman Punta Caiman 34 54 49 58
7 Almonte Balompié Almonte 34 84 66 50
8 CD Cerreño CD Cerreño 34 58 52 45
9 Moguer CD Moguer CD 34 46 52 44
10 Gibraleón Gibraleón 34 47 59 44
11 Los Rosales AD Rosales 34 63 62 44
12 Atl. Cortegana Atl. 34 47 51 41
13 CD Bonares CD Bonares 34 48 66 37
14 Atlético Cruceño Atlético 34 38 51 34
15 Riotinto Balompié Riotinto 34 48 73 33
16 Atlético Tharsis Atlético 34 42 61 30
17 Aljaraque CD Aljaraque 34 31 73 21
18 Rosal CF Rosal CF 34 32 96 18
TEMPORADA 2016/2017
PRIMERA ANDALUZA GRUPO 7
Equipo PJ GF GC Puntos
1 Isla Cristina Isla 34 81 36 76
2 CD Cerreño CD Cerreño 34 80 48 68
3 Camping La Bota Camping Bota 34 69 34 66
4 Ayamonte Ayamonte 33 68 41 63
5 Atl. Cortegana Atl. 33 69 47 58
6 Almonte Balompié Almonte 33 87 70 53
7 Rosal CF Rosal CF 33 55 41 52
8 Bollullos B Bollullos B 34 71 69 50
9 Aroche CF Aroche CF 34 69 67 48
10 CD Bonares CD Bonares 34 73 68 46
11 UD Punta del Caiman Punta Caiman 34 77 75 45
12 Los Rosales AD Rosales 32 54 66 41
13 Moguer CD Moguer CD 34 44 58 41
14 UD Aracena UD Aracena 34 38 67 36
15 Atlético Tharsis Atlético 33 61 88 34
16 CD Canela CD Canela 34 51 62 32
17 CD Iliplense Iliplense 31 40 92 24
18 Trigueros Trigueros 34 45 103 18
TEMPORADA 2015/2016
3ª ANDALUZA HUELVA GRUPO 1
Equipo PJ GF GC Puntos
1 Camping La Bota Camping Bota 26 57 23 57
2 Manzanilla Manzanilla 26 42 32 52
3 Gibraleón Gibraleón 25 58 34 52
4 La Palma La Palma 26 71 50 42
5 Rociana CD Rociana CD 26 64 40 41
6 Trigueros Trigueros 23 44 32 41
7 CD Canela CD Canela 24 48 31 37
8 Villablanca C.D. Villablanca 26 63 64 34
9 San Silvestre C.F. Silvestre 24 43 56 29
10 Aljaraque CD Aljaraque 25 51 55 28
11 Recr. Paterna Recr. 25 35 66 28
12 S. Bartolome Bartolome 26 33 60 25
13 C.D. Atlético Plus Ultra C.D. 23 27 59 22
14 Matalascañas Matalascaña 23 30 64 6
15 Las Colonias C.D. Colonias 0 0 0 0
TEMPORADA 2014/2015
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Isla Cristina Isla 32 68 27 69
2 AD Cartaya AD Cartaya 32 57 24 66
3 CD Iliplense Iliplense 32 59 39 59
4 Pinzón CD Pinzón CD 32 55 37 59
5 Atlético Tharsis Atlético 32 59 42 57
6 CD San Juan CD San Juan 32 57 39 55
7 Almonte Balompié Almonte 32 69 58 54
8 CD Bonares CD Bonares 32 55 44 54
9 Punta Umbria Punta Umbria 33 54 49 54
10 CD Cerreño CD Cerreño 33 53 57 44
11 Atl. Cortegana Atl. 32 54 56 42
12 Moguer CD Moguer CD 32 64 62 41
13 Ayamonte Ayamonte 32 42 47 40
14 UD Punta del Caiman Punta Caiman 32 67 66 39
15 Zalamea Zalamea 33 41 53 33
16 Camping La Bota Camping Bota 32 31 48 29
17 Repilado CD Repilado CD 33 34 86 24
18 Nerva CF Nerva CF 32 33 78 20
19 Aljaraque CD Aljaraque 32 34 74 19
TEMPORADA 2008/2009
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Almonte Almonte 30 76 33 64
2 Gibraleón Gibraleón 30 49 29 57
3 Moguer CD Moguer CD 30 50 24 56
4 CD Pozo Del Camino Pozo Camino 30 65 53 54
5 San Roque de Lepe B Roque Lepe 30 43 31 51
6 CD San Juan CD San Juan 30 43 32 50
7 Camping La Bota Camping Bota 30 46 37 48
8 Pinzón CD Pinzón CD 30 49 45 42
9 Riotinto Balompié Riotinto 30 34 34 42
10 Atl.Calañas Atl.Calañas 30 36 43 42
11 Aroche CF Aroche CF 30 35 42 37
12 Atlético Cruceño Atlético 30 33 39 35
13 Hinojos Hinojos 30 37 69 31
14 Herrerías Herrerías 30 33 48 27
15 La Orden La Orden 30 29 47 24
16 CD Canela CD Canela 30 23 75 13
TEMPORADA 2007/2008
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Ebrosala Ebrosala 30 59 27 63
2 Isla Cristina Isla 30 66 35 60
3 La Orden La Orden 30 53 39 52
4 Almonte Almonte 30 52 39 49
5 Gibraleón Gibraleón 30 35 27 49
6 Aroche CF Aroche CF 30 52 45 49
7 Hinojos Hinojos 30 43 38 49
8 Camping La Bota Camping Bota 30 44 43 41
9 Moguer CD Moguer CD 30 52 41 39
10 Riotinto Balompié Riotinto 30 36 36 37
11 CD Canela CD Canela 30 40 43 37
12 Pinzón CD Pinzón CD 30 35 58 36
13 Cd Valdelamusa Valdelamusa 30 40 50 31
14 Trigueros Trigueros 30 30 48 29
15 Aljaraque CD Aljaraque 30 48 59 28
16 Bollullos CF Bollullos 30 25 82 9
TEMPORADA 2006/2007
2ª ANDALUZA HUELVA
Equipo PJ GF GC Puntos
1 Ol. Valverdeña Valverdeña 32 87 22 79
2 Atlético Cruceño Atlético 32 55 26 72
3 Atlético Tharsis Atlético 32 72 27 70
4 Almonte Almonte 32 62 27 62
5 Aljaraque CD Aljaraque 32 54 34 54
6 Isla Cristina Isla 32 50 37 51
7 Moguer CD Moguer CD 32 52 41 49
8 Ebrosala Ebrosala 32 51 41 48
9 Camping La Bota Camping Bota 32 40 38 48
10 Pinzón CD Pinzón CD 32 50 42 46
11 CD Canela CD Canela 32 63 70 41
12 Riotinto Balompié Riotinto 32 33 45 41
13 Atl.Calañas Atl.Calañas 32 43 46 36
14 San Roque de Lepe B Roque Lepe 32 45 77 29
15 Minerva Fc Minerva Fc 32 25 79 21
16 Repilado CD Repilado CD 32 21 100 10
17 Zalamea Zalamea 32 23 74 9

  USO DE MEMORIA  
6,027,232 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.6301
Total Execution Time  0.6314
  CADENA URL  
/historico/Camping-La-Bota
  GET DATOS  
$_GET['/historico/Camping-La-Bota']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (40)  
0.0130  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 = 'Camping-La-Bota' 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.0138  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 = 'Camping-La-Bota' 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.0138  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=13921 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=13921 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=13921 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=13921 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=13921 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=13921 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=13921 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=13921 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=13921 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=13921 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=13921 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0132  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 = 51258
0.0133  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 = 56987
0.0138  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13921 AND type_rel = 2
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 = '13921' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '13921' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = '13921' 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 = 51258 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=13921 AND l.year in (2019,2020,2021) 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 (56987) 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.0126  SELECT count(id) as num_players from rel_players WHERE league_id = 56987 AND teamId = 13921
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 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 = 51258 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
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 = '13921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '13921' 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 = '13921' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0141  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 events2020 e ON e.player_id = p.id AND e.league_id = 51258 WHERE rp.league_id = 51258 AND rp.teamId = 13921 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.0134  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 events2020 e ON e.player_id = p.id AND e.league_id = 51258 WHERE rp.league_id = 51258 AND rp.teamId = 13921 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 events2020 e ON e.player_id = p.id AND e.league_id = 51258 WHERE rp.league_id = 51258 AND rp.teamId = 13921 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127  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 = 13921 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 51258 AND t.round = 24 ORDER BY team.conference ASC,t.position 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 `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 = 44623 AND t.round = 34 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 `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 = 39327 AND t.round = 34 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 = 34215 AND t.round = 34 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 `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 = 16905 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 4107 AND t.round = 34 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 `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 = 2911 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 `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 = 2910 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 `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 = 2909 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC