4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Don Bosco CF B
TEMPORADA 2022/2023
2ª CATALANA CADETE GRUPO 18
Equipo PJ GF GC Puntos
1 Singuerlin CF A Singuerlin 30 148 26 81
2 Barceloneta A Barceloneta 29 145 26 77
3 Imperio A Imperio A 29 161 29 71
4 Daumar Associacio Club A Daumar 30 183 48 69
5 Trinidad B Trinidad B 30 143 45 67
6 Diagonal Club Esportiu A Diagonal 30 132 47 58
7 Sants D Sants D 30 62 78 41
8 SarriÀ C SarriÀ C 30 87 104 41
9 L'hospitalet Centre Esports L'hospitalet 30 65 64 40
10 Pª Barc. Villaverde-Peniten Barc. 29 120 104 39
11 Padua Assoc. Club A Padua Assoc. 30 80 91 37
12 Vila Olimpica E Vila 30 67 122 25
13 Pª Barc Barcino C Barc Barcino 30 69 141 24
14 Valldoreix B Valldoreix 30 30 151 13
15 Don Bosco CF B Bosco 29 21 197 6
16 Penya Blaugrana Trinitat Ve Penya 28 25 255 1
TEMPORADA 2021/2022
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 CD Granadal Figueroa B Granadal 28 75 24 65
2 Lucecor B Lucecor B 28 90 36 59
3 Don Bosco CF B Bosco 28 87 41 58
4 Villafranca Villafranca 28 109 61 56
5 CD de Futbol Juanin Y Diego Futbol 28 72 50 50
6 Rud La Carlota B Carlota 28 99 58 48
7 CD Posadas CF Posadas 28 67 49 45
8 Ciudad Jardin CD Ciudad 28 66 51 42
9 Fundacion Lucena FC A Fundacion 28 67 77 42
10 Atlético Seneca B Atlético 28 67 63 41
11 Salerm Cosmetics Puente Gen Salerm 28 59 73 32
12 Peñarroya Pueblonuevo CF Peñarroya 28 38 70 22
13 CD Colonia de Fuente Palmer Colonia 28 32 83 22
14 Atlético Villanueva FB Atlético 28 34 91 15
15 A.D. Apademar B A.D. 28 25 160 4
16 CD Rute Calidad CF Rute Calidad 0 0 0 0
TEMPORADA 2020/2021
3ª ANDALUZA CORDOBA CADETE GRUPO 1
Equipo PJ GF GC Puntos
1 Salvador Allende Salvador 8 21 5 20
2 Don Bosco CF B Bosco 9 26 14 19
3 Ciudad Jardin CD Ciudad 8 15 11 14
4 CD AD Miralbaida Miralbaida 7 23 8 13
5 A.D. Apademar A A.D. 10 25 30 11
6 Peñarroya Pueblonuevo CF Peñarroya 7 17 20 10
7 Villa del Rio Servicio Depo Villa 7 15 31 6
8 Bujalance Futbol Base AD Bujalance 7 9 20 2
9 CD Deportivo Cordoba CF Deportivo 5 5 17 1
TEMPORADA 2019/2020
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Menciano Atletico Menciano 21 57 27 44
2 Don Bosco CF B Bosco 20 57 25 43
3 CD Colonia de Fuente Palmer Colonia 20 78 51 43
4 Atlético Villanueva FB Atlético 21 71 40 42
5 Palma del Rio Atlético Palma 21 72 35 41
6 Palomera-Naranjo CDCultural Palomera-Nar 21 73 48 39
7 Fundacion Lucena FC A Fundacion 20 70 48 35
8 Ciudad Jardin CD Ciudad 21 58 47 30
9 Bujalance Futbol Base AD Bujalance 20 37 31 30
10 CD Posadas CF Posadas 21 69 73 30
11 Salvador Allende Salvador 20 42 43 24
12 Montemayor Atletico CD Montemayor 20 23 65 14
13 CD Deportivo Cordoba CF Deportivo 21 24 85 11
14 CD Futbol Juanin Y Diego B Futbol 21 26 79 7
15 Salerm Cosmetics Puente Gen Salerm 20 27 87 7
16 Peñarroya Pueblonuevo CF Peñarroya 0 0 0 0
TEMPORADA 2018/2019
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Figueroa CD B Figueroa 28 92 21 71
2 CD Futbol Juanin Y Diego B Futbol 28 87 42 65
3 La Rambla de Futbol Base Rambla 28 64 35 58
4 Baenense Atletico Baenense 28 83 47 57
5 Don Bosco CF B Bosco 28 48 34 51
6 Palomera Naranjo Cultural Palomera 28 72 61 49
7 Bujalance Futbol Base AD Bujalance 28 70 61 41
8 CD Posadas CF Posadas 28 74 77 39
9 Montalbeño Montalbeño 28 40 47 34
10 CD Deportivo Cordoba CF Deportivo 28 48 59 32
11 CD Colonia de Fuente Palmer Colonia 28 49 80 30
12 Salerm Cosmetics Puente Gen Salerm 28 44 68 28
13 Ciudad de Cordoba Los Abeto Ciudad 28 40 80 16
14 A.D. Apademar B A.D. 28 47 88 16
15 Santaella 2010 Santaella 28 22 80 12
16 Prieguense Prieguense 0 0 0 0
TEMPORADA 2017/2018
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Pozoblanco Pozoblanco 30 109 21 81
2 Juanin Y Diego Sub 16 Juanin Diego 30 116 38 70
3 Palma del Rio Atlético Palma 30 109 34 69
4 A.D. Apademar A A.D. 30 99 31 60
5 CD Apedem A CD Apedem A 30 92 48 57
6 CD Los Califas Balompie Califas 30 75 45 50
7 Don Bosco CF B Bosco 30 59 65 49
8 Rud La Carlota A Carlota 30 53 51 48
9 Futbol Base Egabrense Futbol Base 30 60 50 44
10 Salvador Allende Salvador 30 48 42 37
11 Alcazar CD Alcazar CD 30 40 45 36
12 Fundacion Lucena Fundacion 30 49 74 36
13 Palomera Naranjo Cultural Palomera 30 39 86 23
14 CD Colonia de Fuente Palmer Colonia 30 35 134 18
15 Baenense Atletico Baenense 30 50 136 13
16 Montalbeño Montalbeño 30 23 156 0
TEMPORADA 2016/2017
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Salerm Cosmetics Puente Gen Salerm 30 147 25 80
2 Futbol Base Egabrense Futbol Base 30 85 35 67
3 Pozoblanco Pozoblanco 30 91 42 63
4 Salvador Allende Salvador 30 107 33 61
5 Don Bosco CF B Bosco 30 67 50 57
6 CD Apedem A CD Apedem A 30 67 53 46
7 Rud La Carlota A Carlota 30 77 69 46
8 Palma del Rio Atlético Palma 30 59 59 46
9 CD Los Califas Balompie Califas 30 66 56 44
10 Montalbeño Montalbeño 30 67 77 42
11 A.D. Apademar A A.D. 30 73 92 30
12 Palomera Naranjo Cultural Palomera 30 53 98 29
13 CD Colonia de Fuente Palmer Colonia 30 51 100 24
14 Sporting de Benameji Sporting 30 46 104 18
15 Villafranca Villafranca 30 45 129 17
16 Atletico Aguilarense Atletico 30 34 113 12
TEMPORADA 2015/2016
2ª ANDALUZA CÓRDOBA CADETE
Equipo PJ GF GC Puntos
1 Córdoba CF B Córdoba 30 126 28 77
2 CD Deportivo Cordoba CF Deportivo 30 86 23 75
3 CD Apedem A CD Apedem A 30 69 31 70
4 Futbol Base Egabrense Futbol Base 30 112 55 63
5 Pozoblanco Pozoblanco 30 80 43 62
6 Lucena Lucena 30 109 57 57
7 CD Los Califas Balompie Califas 30 77 46 55
8 Salerm Cosmetics Puente Gen Salerm 30 68 74 36
9 Palma del Rio Atlético Palma 30 51 65 36
10 Don Bosco CF B Bosco 30 42 71 33
11 Salvador Allende Salvador 30 45 88 31
12 Montalbeño Montalbeño 30 44 87 29
13 Sporting de Benameji Sporting 30 52 105 23
14 Palomera Naranjo Cultural Palomera 30 36 98 17
15 Atlético Villanueva FB Atlético 30 34 86 16
16 Parque Cruz Conde Parque Cruz 30 42 116 12
TEMPORADA 2014/2015
3ª ANDALUZA CORDOBA CADETE
Equipo PJ GF GC Puntos
1 Sporting Benameji Sporting 30 132 43 78
2 Don Bosco CF B Bosco 30 119 44 63
3 Deportivo Cordoba Deportivo 30 84 32 60
4 La Rambla de Futbol Base Rambla 30 84 59 58
5 Parque Cruz Conde Parque Cruz 30 79 51 57
6 Rud La Carlota A Carlota 30 81 57 55
7 CD Colonia de Fuente Palmer Colonia 30 92 61 54
8 Villa del Rio Servicio Depo Villa 30 105 86 44
9 CD Los Califas Balompie Califas 30 56 52 42
10 CD Hinojosa CD Hinojosa 30 75 87 39
11 La Ribera del Guadalquivir Ribera 30 112 123 35
12 Villafranca Villafranca 30 57 102 27
13 CD Castro Del Rio-Cajasol Castro 30 46 100 25
14 Salvador Allende Salvador 30 51 114 22
15 Almodóvar del Río C.F. Almodóvar 30 50 100 16
16 Atletico Baenense Atletico 30 68 180 10

  USO DE MEMORIA  
5,606,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.6741
Total Execution Time  0.6762
  CADENA URL  
/historico/Don-Bosco-Cf-B-Cadete
  GET DATOS  
$_GET['/historico/Don-Bosco-Cf-B-Cadete']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0168  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 = 'Don-Bosco-Cf-B-Cadete' 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.0200  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 = 'Don-Bosco-Cf-B-Cadete' 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.0145  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0146  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=130403 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0151  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 = 70329
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=130403 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=747 AND type_rel = 3
0.0147  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 = '130403' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0146  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 = '130403' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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 = 70329 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=130403 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (70329,66048) 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.0144  SELECT count(id) as num_players from rel_players_base WHERE league_id = 70329 AND teamId = 130403
0.0144  SELECT count(id) as num_players from rel_players_base WHERE league_id = 66048 AND teamId = 130403
0.0145  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 70329 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0146  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 = '130403' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '130403' and rp.type = 4
0.0146  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 = '130403' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0148  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 = 130403 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0181  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 = 70329 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.0149  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 = 66048 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.0147  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 = 59535 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.0150  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 = 53883 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.0148  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 = 45932 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 40490 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 34341 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 17366 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 4867 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 70329 ORDER BY nameShow LIMIT 100