4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Lora CF Sub 8
TEMPORADA 2023/2024
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 28 244 16 84
2 UD Tomares Sub 8 Tomares 28 153 57 71
3 Real Betis Balompie Sub 8 Real Betis. 27 175 46 69
4 San Roque Balompie Sub 8 Roque 28 120 67 56
5 AAVV Centro Histórico Sub 8 AAVV Centro 27 107 79 55
6 Castilleja Sub 8 Castilleja 28 80 81 45
7 Coria CF Sub 8 Coria 28 92 109 45
8 Umbrete Sub 8 Umbrete 28 82 96 41
9 Camas Sub 8 Camas Sub 8 26 70 77 33
10 AD Dani Triana Sub 8 Dani Triana 28 79 116 30
11 Lora CF Sub 8 Lora 28 75 129 23
12 Calavera CF Sub 8 Calavera 28 53 107 22
13 Loreto Sub 8 Loreto 28 54 143 20
14 Atlético Algabeño Sub 8 Atlético 28 44 121 16
15 Colegio Claret Sub 8 Colegio 28 71 173 16
16 Juventud Dva. Gines Sub 8 Juventud 28 40 122 12
TEMPORADA 2022/2023
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 30 255 11 90
2 UD Tomares Sub 8 Tomares 29 156 80 70
3 Sevilla Sub 8 B Sevilla 30 136 74 63
4 San Roque Balompie Sub 8 Roque 30 143 69 57
5 Umbrete Sub 8 Umbrete 30 107 82 57
6 Camas Sub 8 Camas Sub 8 30 114 77 55
7 Loreto Sub 8 Loreto 30 92 70 51
8 Coria CF Sub 8 Coria 30 137 102 49
9 David Castedo 3 (DC 3) David 30 110 128 43
10 Lora CF Sub 8 Lora 30 89 128 37
11 Montequinto Sub 8 Montequinto 30 98 104 36
12 Castilleja Sub 8 Castilleja 30 82 128 28
13 SAM-CAM Dos Hermanas Sub 8 SAM-CAM 30 84 145 26
14 Cud Santiponce Sub 10 Santiponce 29 69 182 13
15 Municipal de Gerena Sub 10 Municipal 30 49 230 9
16 CD Esfubasa Sub 10 Esfubasa 30 52 203 7
TEMPORADA 2021/2022
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 32 234 9 96
2 Real Betis Balompie Sub 8 Real Betis. 32 226 35 85
3 San Roque Balompie Sub 8 Roque 32 159 47 80
4 Loreto Sub 8 Loreto 32 139 75 70
5 Tomares A Tomares A 32 115 76 61
6 Camas Sub 8 Camas Sub 8 32 146 102 56
7 Castilleja Sub 8 Castilleja 32 107 113 48
8 David Castedo 3 (DC 3) David 32 96 105 44
9 Coria CF Sub 8 Coria 32 92 122 42
10 Sededos Sub 8 Sededos 32 92 132 40
11 San Alberto Magno Alberto 32 93 117 39
12 Montequinto Sub 8 Montequinto 32 92 135 38
13 Club Polideportivo Bormujos Club 32 54 95 33
14 Lora CF Sub 8 Lora 32 71 150 33
15 Salteras A Salteras A 32 76 142 24
16 La Liara Balompie Liara 32 36 216 6
17 Mairena del Aljarafe Sub 10 Mairena 32 31 188 4
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA BENJAMIN GRUPO 5
Equipo PJ GF GC Puntos
1 Real Betis Balompie Sub 8 Real Betis. 10 81 8 30
2 Sevilla A Sevilla A 10 81 13 24
3 Castilleja Sub 8 Castilleja 10 38 36 22
4 Tomares A Tomares A 10 29 28 18
5 Coria CF Sub 8 Coria 10 27 30 11
6 San Roque Balompie A Roque 10 26 32 11
7 CD San Pablo Pino Montano A Pablo Pino. 10 16 34 11
8 Lora CF Sub 8 Lora 10 28 60 9
9 AAVV Centro Histórico Sub 8 AAVV Centro 10 15 64 4
10 Torreblanca Torreblanca 10 15 51 3
TEMPORADA 2019/2020
2ª SEVILLA BENJAMIN (2ª FASE) GRUPO 3
Equipo PJ GF GC Puntos
1 Lora CF Sub 8 Lora 9 50 14 27
2 Alcala Alcala 9 45 24 17
3 Mairena Mairena 9 42 22 16
4 Montequinto Sub 8 Montequinto 9 34 27 16
5 Club Polideportivo Bormujos Club 9 40 31 15
6 San Alberto Magno Alberto 9 32 30 11
7 Andalucia Este CF A Andalucia 9 14 37 3
8 Municipal de Gerena Sub 10 Municipal 9 8 80 0
TEMPORADA 2018/2019
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 1
Equipo PJ GF GC Puntos
1 Sevilla Sub 8 Sevilla 28 255 7 84
2 Municipal de Gerena Sub 10 Municipal 28 128 50 64
3 Lora CF Sub 8 Lora 28 149 70 62
4 San Roque Balompie Sub 8 Roque 28 110 62 61
5 Atlético Algabeño Sub 10 Atlético 28 121 81 52
6 San Jeronimo Jeronimo 28 120 85 48
7 CD San Pablo Pino Montano B Pablo Pino. 28 123 105 47
8 Rinconada Cantera Rinconada 28 84 78 39
9 Peñaflor Sub 10 Peñaflor 28 91 132 38
10 Aznalcollar A Aznalcollar 28 89 108 36
11 Manantial Manantial 28 57 98 30
12 Brenes Balompie Brenes 28 48 155 14
13 Guillena Sub 10 Guillena 28 61 179 13
14 Atletico Dos Hermanas A Atletico 28 37 177 10
15 Altair Altair 28 44 223 7
16 Los Mares Los Mares 0 0 0 0
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 30 255 14 90
2 La Barrera A Barrera 30 188 39 84
3 CD San Pablo Pino Montano B Pablo Pino. 30 184 63 70
4 Lora CF Sub 8 Lora 30 146 80 67
5 Peñaflor Sub 10 Peñaflor 30 155 95 63
6 Brenes Balompie Brenes 30 92 103 53
7 Calavera CF Sub 8 Calavera 30 135 97 52
8 Los Mares Los Mares 30 84 110 44
9 San Jeronimo Jeronimo 30 75 98 42
10 Vista Hermosa Vista 30 67 130 28
11 Guillena Sub 10 Guillena 30 81 140 26
12 AD Dani Triana Ar-Rabad B Dani Triana 30 93 208 25
13 El Pilar El Pilar 30 72 203 23
14 Alcala del Rio Sub 10 Alcala 30 77 183 20
15 Alcolea del Rio Alcolea 30 44 134 19
16 Villaverde Villaverde 30 57 226 3
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 Sevilla A Sevilla A 30 255 18 90
2 Torreblanca Torreblanca 30 142 43 82
3 Atlético Algabeño Sub 10 Atlético 30 160 93 69
4 Lora CF Sub 8 Lora 30 138 80 63
5 Villaverde Villaverde 30 106 88 59
6 Alcala del Rio A Alcala 30 146 106 58
7 San Pablo Norte A Pablo Norte 30 114 90 48
8 Vista Hermosa Vista 30 91 134 39
9 La Barrera B Barrera 30 72 111 37
10 Los Mares Los Mares 30 73 142 29
11 Alcolea del Rio Alcolea 30 109 191 29
12 Brenes Balompie Brenes 30 81 152 28
13 San Jeronimo A Jeronimo 30 82 171 24
14 Circulo Don Bosco Circulo 30 82 145 23
15 Rinconada Cantera Rinconada 30 50 162 17
16 AD San Jose AD San Jose 30 42 216 8
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 3
Equipo PJ GF GC Puntos
1 CD Esfubasa Sub 10 Esfubasa 30 151 67 81
2 Diez Sanlucar Diez 30 110 41 71
3 Municipal de Gerena Sub 10 Municipal 30 107 77 58
4 Camas A Camas A 30 135 81 58
5 Betisevilla Betisevilla 30 121 74 56
6 Gelves Gelves 30 99 79 53
7 San Martin San Martin 30 91 64 52
8 Lora CF Sub 8 Lora 30 111 86 50
9 Espartinas Tilde Espartinas 30 101 91 43
10 Bormujos Bormujos 30 76 88 35
11 Guillena Sub 10 Guillena 30 86 122 33
12 Mairena del Aljarafe B Mairena 30 80 110 33
13 Atlético Algabeño Sub 10 Atlético 30 92 123 30
14 Tor del Rey de Pilas Pilas 30 84 138 24
15 Alcolea del Rio Alcolea 30 67 123 20
16 Olivarense Atletico Olivarense 30 43 190 3
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA BENJAMIN GRUPO 2
Equipo PJ GF GC Puntos
1 Sevilla F B Sevilla F B 30 238 46 85
2 Real Betis Balompie B Real Betis. 30 202 47 74
3 Viso Graphenstone Viso 30 184 59 74
4 Mairena del Aljarafe B Mairena 30 181 69 68
5 Camas Sub 10 B Camas 30 136 75 62
6 Circulo Don Bosco Circulo 30 122 82 57
7 Lora CF Sub 8 Lora 30 113 81 50
8 CD Antonio Puerta A Antonio 30 127 97 46
9 Andalucia Este CF A Andalucia 30 86 81 45
10 Sevilla Este Sevilla Este 30 61 103 36
11 Estepa Industrial Sub 8 Estepa 30 115 137 33
12 Guillena Sub 10 Guillena 30 91 136 33
13 Tabladilla Tabladilla 30 78 186 16
14 Torreblanca Torreblanca 30 49 206 11
15 Barrios Unidos Barrios 30 59 226 7
16 El Tinte de Utrera Tinte Utrera 30 32 243 4

  USO DE MEMORIA  
5,718,824 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5370
Total Execution Time  0.5382
  CADENA URL  
/historico/Lora-Cf-Benjamin
  GET DATOS  
$_GET['/historico/Lora-Cf-Benjamin']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0171  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 = 'Lora-Cf-Benjamin' 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.0130  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=33036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0130  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=33036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0266  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 = 74452
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=33036 AND type_rel = 2
0.0139  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=855 AND type_rel = 3
0.0130  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 = '33036' ORDER BY l.year DESC,cat.coefficient DESC
0.0131  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 = '33036' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0128  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 = '33036' 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 = 74452 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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=33036 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 (74452) 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_base WHERE league_id = 74452 AND teamId = 33036
0.0126  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 = 74452 AND t.round = 28 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 = '33036' 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 = '33036' 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 = '33036' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
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 = 33036 AND l.year <= 2024 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 `tables2024_base` 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 = 74452 AND t.round = 28 ORDER BY team.conference ASC,t.position 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 `tables2023_base` 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 = 69680 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.0137  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_base` 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 = 64499 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.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_base` 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 = 60679 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.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_base` 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 = 60779 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_base` 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 = 62291 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.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_base` 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 = 54034 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.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_base` 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 = 53311 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 `tables2020_base` 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 = 55281 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.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_base` 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 = 45045 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 `tables2018_base` 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 = 42872 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 `tables2017_base` 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 = 34853 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 `tables2016_base` 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 = 18301 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 = 5986 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC