4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del San Roque Balompie Sub 19
TEMPORADA 2023/2024
LIGA NACIONAL GRUPO 14
Equipo PJ GF GC Puntos
1 Sevilla Sub 19 B Sevilla 28 65 25 75
2 Real Betis Sub 19 B Real Betis 28 62 37 58
3 Calavera Sub 19 B Calavera 28 61 37 53
4 Recreativo Sub 19 Recreativo 28 46 37 44
5 San Roque Balompie Sub 19 Roque 28 39 35 43
6 San Fernando Isleño Sub 19 Fernando 28 45 38 42
7 Córdoba CF Sub 19 B Córdoba 28 38 33 39
8 Coria CF Sub 19 Coria 28 46 45 36
9 San Roque de Lepe Roque Lepe 28 56 61 34
10 Fundación Cádiz Sub 19 Fundación 28 39 44 34
11 Castilleja CF Sub 19 Castilleja 28 36 44 33
12 La Salle Sub 19 Salle 28 28 39 31
13 CD Siempre Alegres Sub 19 Siempre 28 37 53 28
14 Algeciras CF Sub 19 Algeciras 28 19 32 28
15 CD Polillas Ceuta Sub 19 Polillas 28 41 59 26
16 Atl. Sanluqueño Sub 19 Atl. 28 32 71 15
TEMPORADA 2022/2023
DIVISIÓN DE HONOR GRUPO 4
Equipo PJ GF GC Puntos
1 Real Betis Sub 19 Real Betis 34 82 20 86
2 Sevilla Sub 19 Sevilla 34 73 21 84
3 Almería Sub 19 Almería 34 81 28 82
4 Cádiz Sub 19 Cádiz 34 85 44 61
5 Málaga Sub 19 Málaga 34 49 32 61
6 Granada CF Sub 19 Granada 34 61 47 55
7 Calavera CF Sub 19 Calavera 34 55 46 50
8 CD San Félix Sub 19 Félix 34 63 47 48
9 Séneca CF Sub 19 Séneca 34 44 41 45
10 Marbella FC Sub 19 Marbella 34 49 44 45
11 26 De Febrero Sub 19 Febrero 34 40 49 40
12 UD Tomares Sub 19 Tomares 34 56 73 38
13 Recreativo Sub 19 Recreativo 34 46 58 36
14 CD Vázquez Cultural Sub 19 Vázquez 34 41 57 35
15 San Roque Balompie Sub 19 Roque 34 36 62 29
16 CF Rusadir Sub 19 Rusadir 34 36 109 25
17 CD Polillas Ceuta Sub 19 Polillas 34 25 86 20
18 Algeciras CF Sub 19 Algeciras 34 29 87 17
TEMPORADA 2021/2022
LIGA NACIONAL GRUPO 14
Equipo PJ GF GC Puntos
1 Fundación Cádiz Sub 19 Fundación 30 77 29 65
2 Algeciras CF Sub 19 Algeciras 30 76 51 59
3 San Roque Balompie Sub 19 Roque 30 71 30 58
4 San Fernando Isleño Sub 19 Fernando 30 70 33 56
5 Sevilla Sub 19 B Sevilla 30 55 21 54
6 Córdoba CF Sub 19 B Córdoba 30 44 44 46
7 Balón De Cádiz Sub 19 Balón 30 47 42 45
8 Real Betis Sub 19 B Real Betis 30 64 45 44
9 Atlético Antoniano Sub 19 Atlético 30 37 45 41
10 AD Nervión Sub 19 Nervión 30 55 49 39
11 Recreativo Sub 19 B Recreativo 30 41 50 38
12 CD Pozoblanco Sub 19 Pozoblanco 30 48 62 37
13 CD Polillas Ceuta Sub 19 Polillas 30 29 70 29
14 PD Rociera Sub 19 Rociera 30 52 70 27
15 Cartaya AD Sub 19 Cartaya 30 31 77 22
16 Atl. Sanluqueño Sub 19 Atl. 30 17 96 8
TEMPORADA 2020/2021
2ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 San Roque Balompie Sub 19 Roque 7 12 5 17
2 U.D. Moron C.F. U.D. Moron. 8 23 9 16
3 CD Mosquito Sub 19 Mosquito 7 21 7 16
4 CD Asoc. Dva. Nervion Asoc. Dva.. 8 18 11 16
5 Andalucía Este Andalucía 8 12 15 11
6 Centro Histórico AAVV Centro 8 13 19 10
7 Torreblanca CF Sub 19 Torreblanca 8 8 9 9
8 CD Utrera Sub 19 Utrera 8 15 14 8
9 Calavera Sub 19 B Calavera 8 10 15 7
10 Ecija Balompie SAD Ecija 8 6 34 0
TEMPORADA 2019/2020
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 C Atl. Antoniano Atl. 24 50 35 46
2 Sevilla FC SAD Sevilla 23 68 31 43
3 UD Tomares Sub 19 Tomares 24 51 25 43
4 Atletico Libertad Atletico 24 52 30 42
5 San Roque Balompie Sub 19 Roque 24 53 34 42
6 UD Bellavista Sub 19 Bellavista 24 39 35 42
7 Torreblanca CF Sub 19 Torreblanca 23 39 35 40
8 CD Utrera Sub 19 Utrera 23 51 25 39
9 CD Los Caminantes Caminantes 24 38 35 35
10 Centro Histórico AAVV Centro 23 51 40 34
11 CD Cabecense Sub 19 Cabecense 24 32 47 34
12 CD Mosquito Sub 19 Mosquito 23 44 42 33
13 CMD San Juan Juvenil Juan Juvenil 24 30 46 24
14 Calavera Sub 19 B Calavera 24 41 57 22
15 CD Asoc. Dva. Nervion Asoc. Dva.. 24 29 45 20
16 AD Pvo. Sevilla Este Pvo. Sevilla 23 21 54 10
17 CDAtletico Dos Hermanas CF CDAtletico 23 13 86 7
18 Ecija Balompie SAD Ecija 1 0 0 1
TEMPORADA 2018/2019
2ª ANDALUZA SEVILLA JUVENIL
Equipo PJ GF GC Puntos
1 Sevilla FC Juvenil C Sevilla 34 118 23 93
2 PD Rociera Sub 19 Rociera 34 92 36 82
3 C.D. Utrera C.D. Utrera 34 81 22 72
4 Ecija Balompie SAD Ecija 34 59 42 56
5 CD Mosquito Sub 19 Mosquito 34 71 70 53
6 CD Los Caminantes Caminantes 34 62 55 50
7 UD Dos Hermanas Juvenil Hermanas 34 48 60 49
8 San Roque Balompie Sub 19 Roque 34 52 56 46
9 UD Tomares Sub 19 Tomares 34 61 63 45
10 Atlético Antoniano Sub 19 Atlético 34 55 56 43
11 Calavera Sub 19 B Calavera 34 50 54 42
12 Centro Histórico AAVV Centro 34 54 63 41
13 AD Nervión Sub 19 Nervión 34 49 62 40
14 CMD San Juan Juvenil Juan Juvenil 34 42 60 36
15 Andalucía Este Andalucía 34 36 63 36
16 Círculo Don Bosco Círculo 34 28 57 31
17 Tor del Rey de Pilas Pilas 34 41 78 29
18 Marchena Balompie Marchena 34 22 101 18
TEMPORADA 2017/2018
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 UD Tomares Sub 19 Tomares 33 90 46 72
2 San Roque Balompie Sub 19 Roque 34 79 47 71
3 Calavera Sub 19 B Calavera 33 74 46 68
4 Atletico Libertad Atletico 34 93 49 60
5 Coria CF B Coria CF B 33 58 36 60
6 Diablos Rojos CD Diablos 33 61 48 50
7 Club Jorge Juan Antonio Ull Club Jorge. 33 67 70 49
8 Portaceli CD Portaceli 33 48 46 47
9 La Motilla FC Motilla 34 56 68 43
10 Castilleja CF B Castilleja 33 51 47 42
11 Alcolea del Rio FC Alcolea 33 74 89 40
12 Puebla CF Puebla CF 33 47 61 37
13 Olivarense Atlético Olivarense 33 66 100 36
14 La Liara Balompié Sub 19 Liara 34 52 72 34
15 Rociera B Rociera B 33 53 76 34
16 Mairena del Aljarafe A Mairena 33 39 65 34
17 CD Cantera de Utrera Cantera 33 54 84 32
18 AD San José Sub 19 José 21 25 37 13
TEMPORADA 2016/2017
3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Castilleja CF Sub 19 Castilleja 32 106 32 73
2 Tor del Rey de Pilas Pilas 33 101 35 71
3 CD Montequinto Montequinto 33 105 55 67
4 Olivarense Atlético Olivarense 33 118 61 65
5 CD Alcala CD Alcala 33 81 66 54
6 Ecija Balompie SAD Ecija 33 69 73 45
7 San Roque Balompie Sub 19 Roque 33 82 65 44
8 AD San José Sub 19 José 33 63 77 44
9 Diez Sanlucar Diez 33 65 71 43
10 Diablos Rojos CD Diablos 32 59 52 42
11 Coria CF B Coria CF B 33 55 62 42
12 U.P Viso U.P Viso 33 75 98 40
13 Campana Balompie Campana 33 55 89 40
14 Vistahermosa CF Vistahermosa 33 77 123 40
15 Atletico Libertad Atletico 33 71 75 39
16 Circulo Don Bosco Circulo 33 61 80 34
17 Torreblanca CF Sub 19 Torreblanca 33 40 139 16
18 Ecija CF Ecija CF 15 15 45 7
TEMPORADA 2015/2016
3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo PJ GF GC Puntos
1 Andalucía Este Andalucía 32 105 32 82
2 Puebla de Cazalla Puebla 32 137 63 71
3 Club Jorge Juan Antonio Ull Club Jorge. 32 75 44 55
4 Ecija Balompie SAD Ecija 32 60 46 54
5 Portaceli CD Portaceli 32 73 55 52
6 Campana Balompie Campana 32 57 67 47
7 Diablos Rojos CD Diablos 32 63 49 46
8 Circulo Don Bosco Circulo 32 63 63 44
9 Utrera CD Utrera CD 32 75 72 43
10 San Roque Balompie Sub 19 Roque 32 55 55 40
11 CF Torreblanca Torreblanca 32 45 78 40
12 C.D. Pedrera C.D. Pedrera 31 47 56 39
13 Osuna BC Osuna BC 32 48 70 37
14 Marchena Balompie Marchena 32 66 79 37
15 CD Mosquito Sub 19 Mosquito 31 52 87 28
16 AD Nervión B Juvenil Nervión 32 55 93 25
17 La Oliva AF La Oliva AF 32 37 104 23
18 Montellano CD Montellano 0 0 0 0
TEMPORADA 2014/2015
3ª ANDALUZA SEVILLA JUVENIL GRUPO 2
Equipo PJ GF GC Puntos
1 Calavera CF B Calavera 34 81 27 85
2 San Juan CMD Juan 34 105 27 79
3 Cazalla de la Sierra Cazalla 34 88 48 73
4 Atletico Libertad Atletico 34 80 55 69
5 Portaceli CD Portaceli 34 84 45 62
6 Diez Sanlucar Diez 34 60 53 51
7 Rinconada UD Rinconada 34 53 60 50
8 AD Nervión Sub 19 Nervión 34 61 62 48
9 Bellavista UD Bellavista 34 78 63 45
10 Lora CF Lora CF 34 73 70 45
11 La Oliva AF La Oliva AF 34 68 68 45
12 San Roque Balompie Sub 19 Roque 34 74 79 45
13 Circulo Don Bosco Circulo 34 63 70 39
14 Diablos Rojos CD Diablos 34 45 86 28
15 Triana C.F. Triana C.F. 34 34 78 27
16 Atlético Algabeño Atlético 34 49 100 27
17 La Union-08 CD Union-08 34 48 105 25
18 Umbrete CF Umbrete CF 34 37 85 23

  USO DE MEMORIA  
6,160,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1136
Total Execution Time  0.1148
  CADENA URL  
/historico/San-Roque-Balompie-Juvenil
  GET DATOS  
$_GET['/historico/San-Roque-Balompie-Juvenil']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0033  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 = 'San-Roque-Balompie-Juvenil' 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.0019  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=19533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=19533 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19533 AND type_rel = 2
0.0026  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 = '19533' ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '19533' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0026  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 = '19533' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=19533 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (73390,68516) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 68516 AND teamId = 19533
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 73390 AND teamId = 19533
0.0023  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 = '19533' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19533' and rp.type = 4
0.0022  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 = '19533' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0044  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 = 73390 WHERE rp.league_id = 73390 AND rp.teamId = 19533 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.0041  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 = 73390 WHERE rp.league_id = 73390 AND rp.teamId = 19533 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 73390 WHERE rp.league_id = 73390 AND rp.teamId = 19533 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 19533 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0026  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 = 73390 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.0029  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 = 68516 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.0027  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 = 63627 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.0024  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 = 59548 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.0030  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 = 53858 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.0028  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 = 45692 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 39990 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 34225 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 17034 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  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 = 4270 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC