4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Francs Borains

Francs Borains

Entrenador: Sébastien Grandjean

Temporada 2023/2024
TEMPORADA 2023/2024
SEGUNDA DIVISIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 Beerschot VA Beerschot 30 46 29 56
2 FCV Dender FCV Dender 30 55 32 54
3 Deinze Deinze 30 48 37 53
4 Lommel SK Lommel SK 30 51 31 52
5 Zulte-Waregem Zulte-Warege 30 51 34 51
6 Patro Eisden Patro Eisden 30 40 28 51
7 RFC Liège RFC Liège 30 49 41 49
8 SK Beveren SK Beveren 30 44 40 45
9 Club NXT Club NXT 30 40 49 37
10 Jong Genk Jong Genk 30 46 52 37
11 Lierse Kempenzonen Lierse 30 44 59 35
12 Anderlecht Sub 23 Anderlecht 30 39 47 34
13 KV Oostende KV Oostende 30 32 39 32
14 Francs Borains Francs 30 38 52 32
15 RFC Seraing RFC Seraing 30 33 51 28
16 SL16 FC SL16 FC 30 25 60 17
TEMPORADA 2022/2023
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Patro Eisden Patro Eisden 38 84 23 86
2 RFC Liège RFC Liège 38 99 29 86
3 Francs Borains Francs 38 79 46 77
4 RAAL La Louviere RAAL 38 72 39 73
5 Gent II Gent II 38 59 43 67
6 Heist Heist 38 69 59 61
7 Olympic Charleroi Olympic 38 71 52 60
8 Knokke Knokke 38 65 58 60
9 Visé Visé 38 66 52 56
10 Thes Sport Thes Sport 38 58 52 53
11 Leuven II Leuven II 38 61 68 50
12 Tienen Tienen 38 50 60 46
13 Charleroi II Charleroi 38 41 58 44
14 Dessel Sport Dessel Sport 38 45 65 43
15 KVC Winkel Sport Winkel Sport 38 44 58 42
16 Hoogstraten Hoogstraten 38 46 60 41
17 Antwerp II Antwerp II 38 33 58 39
18 Ninove Ninove 38 39 75 35
19 Rupel Boom Rupel Boom 38 29 83 24
20 Mandel United Mandel 38 16 88 14
TEMPORADA 2021/2022
DIVISIÓN NACIONAL BELGA 1 GRUPO 1
Equipo PJ GF GC Puntos
1 RFC Liège RFC Liège 28 57 23 50
2 Knokke Knokke 28 48 33 48
3 Dessel Sport Dessel Sport 28 47 35 48
4 FCV Dender FCV Dender 28 41 30 46
5 Olympic Charleroi Olympic 28 41 31 46
6 Patro Eisden Patro Eisden 28 28 21 46
7 KVC Winkel Sport Winkel Sport 28 40 36 44
8 Visé Visé 28 45 34 39
9 Heist Heist 28 41 34 39
10 Thes Sport Thes Sport 28 35 35 39
11 Tienen Tienen 28 28 34 35
12 Rupel Boom Rupel Boom 28 26 39 33
13 Francs Borains Francs 28 26 29 32
14 Mandel United Mandel 28 26 50 19
15 La Louvière Centre Louvière 28 13 78 9
TEMPORADA 2020/2021
DIVISIÓN NACIONAL BELGA 1
Equipo PJ GF GC Puntos
1 Thes Sport Thes Sport 3 7 3 9
2 Tienen Tienen 4 5 5 6
3 Heist Heist 2 3 2 4
4 Mandel United Mandel 3 6 4 3
5 KVC Winkel Sport Winkel Sport 2 4 2 3
6 Francs Borains Francs 1 2 1 3
7 Knokke Knokke 2 2 1 3
8 Visé Visé 2 3 3 3
9 Olympic Charleroi Olympic 2 1 1 3
10 Patro Eisden Patro Eisden 1 2 2 1
11 RFC Liège RFC Liège 1 0 0 1
12 Rupel Boom Rupel Boom 2 0 2 1
13 FCV Dender FCV Dender 0 0 0 0
14 Dessel Sport Dessel Sport 0 0 0 0
15 La Louvière Centre Louvière 2 1 5 0
16 KSV Roeselare Roeselare 1 0 5 0
TEMPORADA 2019/2020
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Francs Borains Francs 24 50 17 52
2 Meux Meux 24 46 26 48
3 RAAL La Louviere RAAL 23 38 18 46
4 Rebecq Rebecq 24 41 24 44
5 Hamoir Hamoir 24 48 34 43
6 RES Durbuy RES Durbuy 24 44 39 35
7 Stockay-Warfusée Stockay-Warf 22 43 37 34
8 Givry Givry 24 33 38 33
9 Acren Lessines Acren 24 45 49 28
10 RFC Tilleur RFC Tilleur 23 28 40 26
11 Couvin-Mariembourg Couvin-Marie 23 35 38 25
12 Verlaine Verlaine 22 33 47 24
13 Waremme Waremme 24 30 52 22
14 Union Namur Union Namur 24 29 53 21
15 Solières Sport Solières 23 26 45 21
16 Onhaye Onhaye 24 27 39 21
TEMPORADA 2018/2019
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 La Louvière Centre Louvière 30 83 19 77
2 Visé Visé 30 68 36 61
3 Hamoir Hamoir 30 56 34 59
4 Francs Borains Francs 30 59 42 52
5 Rebecq Rebecq 30 60 44 51
6 RFC Tilleur RFC Tilleur 30 54 45 47
7 RAAL La Louviere RAAL 30 42 30 46
8 Meux Meux 30 51 51 39
9 RES Durbuy RES Durbuy 30 37 50 39
10 Couvin-Mariembourg Couvin-Marie 30 50 51 38
11 Waremme Waremme 30 46 53 35
12 Solières Sport Solières 30 38 56 31
13 Acren Lessines Acren 30 42 53 29
14 Walhain Walhain 30 33 52 28
15 Olympic Charleroi Olympic 30 32 61 24
16 Ciney Ciney 30 22 96 9
TEMPORADA 2017/2018
PROMOCIÓN BÉLGICA GRUPO 1
Equipo PJ GF GC Puntos
1 RAAL La Louviere RAAL 30 74 24 69
2 Francs Borains Francs 30 78 32 66
3 Onhaye Onhaye 30 66 47 56
4 Tournai Tournai 30 45 27 55
5 Couvin-Mariembourg Couvin-Marie 30 62 41 54
6 Racing Jet Wavre Racing Wavre 30 58 47 52
7 Binche Binche 30 56 53 52
8 Entité Manageoise Entité 30 52 50 41
9 RAEC Mons RAEC Mons 30 44 40 39
10 Jeunesse Tamines Jeunesse 30 46 56 37
11 Ganshoren Ganshoren 30 40 54 36
12 Léopold Uccle-Woluwé Léopold 30 47 50 32
13 Stade Brainois Stade 30 35 52 29
14 Spy Spy 30 39 83 22
15 Solre-sur-Sambre Solre-sur-Sa 30 35 67 20
16 Waterloo Waterloo 30 34 88 14
TEMPORADA 2016/2017
PROMOCIÓN BÉLGICA GRUPO 3
Equipo PJ GF GC Puntos
1 RWD Molenbeek Molenbeek 26 72 31 61
2 Rebecq Rebecq 26 58 24 61
3 Francs Borains Francs 26 60 21 58
4 RAEC Mons RAEC Mons 26 54 28 47
5 Tournai Tournai 26 55 46 40
6 Onhaye Onhaye 26 34 44 37
7 Léopold Uccle-Woluwé Léopold 26 44 29 35
8 Entité Manageoise Entité 26 34 35 35
9 Racing Jet Wavre Racing Wavre 26 40 33 31
10 Solre-sur-Sambre Solre-sur-Sa 26 32 59 27
11 Waterloo Waterloo 26 30 49 26
12 Ganshoren Ganshoren 26 36 65 23
13 Jeunesse Tamines Jeunesse 26 29 51 20
14 Profondeville Profondevill 26 18 81 2
TEMPORADA 2015/2016
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Olympic Charleroi Olympic 27 52 23 62
2 KFC Duffel KFC Duffel 28 59 34 52
3 Châtelet Châtelet 28 47 40 50
4 Sterrebeek Sterrebeek 28 50 39 49
5 Charleroi Fleurus Charleroi 28 47 45 48
6 Rebecq Rebecq 28 44 35 43
7 Halle Halle 28 46 28 42
8 RWD Molenbeek Molenbeek 28 43 34 39
9 Léopold Uccle-Woluwé Léopold 28 46 52 39
10 Wolvertem Wolvertem 28 44 49 35
11 Betekom Betekom 28 42 39 34
12 Francs Borains Francs 27 41 52 30
13 Ganshoren Ganshoren 28 34 59 24
14 Tournai Tournai 28 32 57 24
15 Waterloo Waterloo 28 22 63 14
16 Géants Athois Géants 0 0 0 0
TEMPORADA 2014/2015
PROMOCIÓN BÉLGICA GRUPO 2
Equipo PJ GF GC Puntos
1 Tempo Overijse Tempo 30 64 24 67
2 Francs Borains Francs 30 64 33 60
3 Acren Lessines Acren 30 44 40 50
4 Rebecq Rebecq 30 61 48 45
5 Châtelet Châtelet 30 40 31 45
6 Olympia Wijgmaal Olympia 30 59 45 44
7 Pepingen-Halle Pepingen-Hal 30 48 54 42
8 Waterloo Waterloo 30 49 44 41
9 Léopold Uccle-Woluwé Léopold 30 43 50 41
10 Sterrebeek Sterrebeek 30 44 44 40
11 Wolvertem Wolvertem 30 37 38 37
12 Ganshoren Ganshoren 30 39 46 37
13 Solre-sur-Sambre Solre-sur-Sa 30 45 59 36
14 Racing Schaerbeek Racing 30 43 59 31
15 Assesse Assesse 30 45 74 25
16 Binche Binche 30 26 62 22
TEMPORADA 2008/2009
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Standaard Wetteren Standaard 30 68 30 64
2 Woluwe Woluwe 30 46 22 60
3 Francs Borains Francs 30 62 31 55
4 Diegem Sport Diegem Sport 30 43 27 54
5 La Louvière Centre Louvière 30 56 45 45
6 Sottegem Sottegem 30 35 30 45
7 Oudenaarde Oudenaarde 30 43 40 45
8 Racing Waregem Racing 30 40 37 45
9 Sint-Niklaas Sint-Niklaas 30 55 44 43
10 WS Bruxelles Bruxelles 30 44 45 39
11 Eendracht Aalst Eendracht 30 38 50 38
12 Union Saint-Gilloise Union 30 39 43 33
13 RAAL La Louviere RAAL 30 36 61 28
14 Wielsbeke Wielsbeke 30 40 58 27
15 Mouscron Mouscron 30 27 83 27
16 KRC Gent KRC Gent 30 39 65 22
TEMPORADA 2007/2008
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Ronse Ronse 30 49 23 57
2 RAAL La Louviere RAAL 30 41 23 54
3 Mouscron Mouscron 30 49 37 54
4 Racing Waregem Racing 30 42 30 51
5 Racing Mechelen Racing 30 34 28 50
6 Sottegem Sottegem 30 37 34 48
7 Eendracht Aalst Eendracht 30 50 32 46
8 Willebroek-Meerhof Willebroek-M 30 45 39 43
9 Sint-Niklaas Sint-Niklaas 30 46 37 40
10 Francs Borains Francs 30 38 40 39
11 Diegem Sport Diegem Sport 30 31 39 39
12 Oudenaarde Oudenaarde 30 39 43 34
13 Standaard Wetteren Standaard 30 34 51 33
14 Londerzeel Londerzeel 30 34 40 30
15 Torhout Torhout 30 39 70 24
16 Charleroi Fleurus Charleroi 30 29 71 19
TEMPORADA 2006/2007
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Olympic Charleroi Olympic 30 49 29 57
2 Sprimont-Comblain Sprimont-Com 30 34 31 50
3 Union Namur Union Namur 29 55 35 49
4 WS Bruxelles Bruxelles 30 52 42 47
5 Charleroi Fleurus Charleroi 29 37 30 45
6 Tongeren Tongeren 30 50 45 44
7 Bocholt Bocholt 30 47 35 42
8 RFC Seraing RFC Seraing 30 48 40 41
9 Visé Visé 30 38 39 41
10 Verviers Verviers 30 39 41 38
11 RFC Liège RFC Liège 30 22 27 36
12 Francs Borains Francs 30 37 50 36
13 RAAL La Louviere RAAL 30 31 41 35
14 La Calamine La Calamine 30 27 44 35
15 Sporting Hasselt Sporting 30 41 59 31
16 Walhain Walhain 30 34 53 25
TEMPORADA 2005/2006
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Tienen Tienen 29 53 24 59
2 Francs Borains Francs 29 44 29 50
3 La Calamine La Calamine 30 43 48 49
4 Olympic Charleroi Olympic 30 51 32 47
5 Visé Visé 30 40 39 46
6 Sporting Hasselt Sporting 30 43 38 44
7 Union Namur Union Namur 30 43 34 42
8 Sprimont-Comblain Sprimont-Com 30 35 38 40
9 Tongeren Tongeren 30 38 42 39
10 Tournai Tournai 30 38 35 38
11 Verviers Verviers 30 33 43 37
12 Charleroi Fleurus Charleroi 30 37 51 35
13 Bocholt Bocholt 30 34 43 32
14 Leopoldsburg Leopoldsburg 30 34 46 32
15 Walhain Walhain 30 27 39 32
16 R.R.F.C. Montegnée R.R.F.C. 30 42 54 27
TEMPORADA 2004/2005
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 Lommel SK Lommel SK 30 77 22 78
2 OH Leuven OH Leuven 30 62 27 62
3 Tongeren Tongeren 30 51 33 52
4 Sprimont-Comblain Sprimont-Com 30 46 43 49
5 WS Bruxelles Bruxelles 30 44 38 44
6 Walhain Walhain 30 51 52 43
7 Bocholt Bocholt 30 36 35 42
8 Tienen Tienen 30 35 35 39
9 Olympic Charleroi Olympic 30 39 36 37
10 Diegem Sport Diegem Sport 30 52 44 36
11 La Calamine La Calamine 30 37 59 34
12 Francs Borains Francs 30 23 45 33
13 Sporting Hasselt Sporting 30 41 52 31
14 Union Namur Union Namur 30 33 61 30
15 Veldwezelt Veldwezelt 30 32 56 25
16 RFC Seraing RFC Seraing 30 33 54 22
TEMPORADA 2003/2004
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Union Saint-Gilloise Union 30 56 24 60
2 Lommel SK Lommel SK 30 55 33 55
3 OH Leuven OH Leuven 30 43 23 53
4 Bocholt Bocholt 30 48 35 51
5 Veldwezelt Veldwezelt 29 41 38 46
6 Walhain Walhain 30 51 45 44
7 Union Namur Union Namur 30 38 45 37
8 Olympic Charleroi Olympic 30 43 47 36
9 Tongeren Tongeren 30 32 37 36
10 RFC Liège RFC Liège 30 43 43 35
11 Francs Borains Francs 30 33 38 35
12 Diegem Sport Diegem Sport 29 43 50 35
13 Sprimont-Comblain Sprimont-Com 30 39 45 34
14 RFC Seraing RFC Seraing 30 31 49 33
15 Tournai Tournai 30 30 49 31
16 Royal Spa Royal Spa 30 29 54 27
TEMPORADA 2002/2003
DIVISIÓN BELGA 2 GRUPO 1
Equipo PJ GF GC Puntos
1 Berchem Sport Berchem 26 45 23 51
2 KV Oostende KV Oostende 26 51 27 47
3 Eendracht Aalst Eendracht 25 39 37 45
4 Wevelgem City Wevelgem 26 54 33 42
5 Kortrijk Kortrijk 27 38 30 39
6 TK Meldert TK Meldert 26 40 46 36
7 Tournai Tournai 26 37 32 34
8 Cappellen Cappellen 26 32 38 34
9 Maldegem Maldegem 26 42 49 34
10 SK Beveren SK Beveren 26 44 38 33
11 Sint-Niklaas Sint-Niklaas 26 29 37 29
12 Denderhoutem Denderhoutem 26 36 46 29
13 Francs Borains Francs 26 27 38 26
14 Torhout Torhout 26 24 43 24
15 KRC Gent KRC Gent 26 20 41 21
TEMPORADA 2001/2002
DIVISIÓN BELGA 2 GRUPO 2
Equipo PJ GF GC Puntos
1 KAS Eupen KAS Eupen 30 75 32 66
2 Walhain Walhain 30 59 48 55
3 OH Leuven OH Leuven 30 46 27 53
4 Tubize Tubize 30 56 43 49
5 Francs Borains Francs 30 43 33 49
6 Olympic Charleroi Olympic 30 52 46 49
7 Union Saint-Gilloise Union 29 44 39 41
8 Lyra Lyra 30 52 49 40
9 Lommel SK Lommel SK 29 42 63 38
10 Bocholt Bocholt 30 46 48 33
11 Racing Mechelen Racing 30 33 48 33
12 KSL Stade Leuven Stade Leuven 30 42 48 32
13 Tongeren Tongeren 30 44 56 32
14 Racing Jet Wavre Racing Wavre 30 47 56 31
15 Sporting Hasselt Sporting 30 36 53 29
16 Diest Diest 30 32 60 26

  USO DE MEMORIA  
7,433,504 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1428
Total Execution Time  0.1440
  CADENA URL  
/historico/Francs-Borains
  GET DATOS  
$_GET['/historico/Francs-Borains']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0028  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 = 'Francs-Borains' 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.0018  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=30670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=30670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=30670 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=30670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30670 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 30670 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0020  SELECT /*35 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 (715313) ORDER BY n.cover_points DESC, update_date DESC
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 = '30670' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '30670' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '30670' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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 = 72091 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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=30670 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73206,72091,71432,68256) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 72091 AND teamId = 30670
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 68256 AND teamId = 30670
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 73206 AND teamId = 30670
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 30670
0.0021  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 = '30670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '30670' and rp.type = 4
0.0019  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 = '30670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0033  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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 30670 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.0029  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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 30670 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 72091 WHERE rp.league_id = 72091 AND rp.teamId = 30670 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 = 30670 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0042  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 = 68256 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  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 = 63431 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` 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 = 58503 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.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 `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 = 50974 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.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 `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 = 44609 AND t.round = 30 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 `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 = 38981 AND t.round = 30 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` 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 = 34028 AND t.round = 26 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` 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 = 15780 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 13374 AND t.round = 30 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 `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 = 24299 AND t.round = 30 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 `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 = 24303 AND t.round = 30 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 `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 = 24307 AND t.round = 30 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 `tables2006` 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 = 24320 AND t.round = 30 ORDER BY team.conference 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 `tables2005` 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 = 24315 AND t.round = 30 ORDER BY team.conference 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 `tables2004` 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 = 24310 AND t.round = 30 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 `tables2003` 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 = 24308 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 `tables2002` 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 = 24300 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC