4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
07 Ago 21 BloisBlois 0 - 2 VersaillesVersailles ...
07 Ago 21 ChartresChartres 2 - 1 GranvilleGranville ...
07 Ago 21 Voltigeurs ChâteaubriantVoltigeurs 1 - 3 VannesVannes ...
07 Ago 21 PoissyPoissy 2 - 0 RomorantinRomorantin ...
07 Ago 21 Saint-PryveSaint-Pryve 1 - 0 Saint-MaloSaint-Malo ...
07 Ago 21 Guingamp IIGuingamp 0 - 0 FC Rouen 1899Rouen 1899 ...
07 Ago 21 PlabennecPlabennec 0 - 1 Caen IICaen II ...
07 Ago 21 Lorient IILorient II 1 - 0 VitréVitré ...
Jornada 2
14 Ago 21 PoissyPoissy 0 - 0 FC Rouen 1899Rouen 1899 ...
14 Ago 21 GranvilleGranville 0 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
14 Ago 21 RomorantinRomorantin 2 - 1 ChartresChartres ...
14 Ago 21 Saint-MaloSaint-Malo 1 - 2 BloisBlois ...
14 Ago 21 VersaillesVersailles 0 - 0 Lorient IILorient II ...
14 Ago 21 Caen IICaen II 0 - 0 VannesVannes ...
14 Ago 21 PlabennecPlabennec 1 - 3 Saint-PryveSaint-Pryve ...
14 Ago 21 VitréVitré 0 - 4 Guingamp IIGuingamp ...
Jornada 3
21 Ago 21 BloisBlois 1 - 0 PlabennecPlabennec ...
21 Ago 21 ChartresChartres 1 - 2 FC Rouen 1899Rouen 1899 ...
21 Ago 21 Voltigeurs ChâteaubriantVoltigeurs 3 - 1 RomorantinRomorantin ...
21 Ago 21 PoissyPoissy 3 - 0 VitréVitré ...
21 Ago 21 Saint-PryveSaint-Pryve 2 - 0 Caen IICaen II ...
21 Ago 21 Guingamp IIGuingamp 0 - 3 VersaillesVersailles ...
21 Ago 21 VannesVannes 0 - 0 GranvilleGranville ...
21 Ago 21 Lorient IILorient II 2 - 0 Saint-MaloSaint-Malo ...
Jornada 4
28 Ago 21 Voltigeurs ChâteaubriantVoltigeurs 1 - 0 FC Rouen 1899Rouen 1899 ...
28 Ago 21 RomorantinRomorantin 1 - 2 VannesVannes ...
28 Ago 21 Saint-PryveSaint-Pryve 0 - 1 BloisBlois ...
28 Ago 21 Saint-MaloSaint-Malo 0 - 2 Guingamp IIGuingamp ...
28 Ago 21 VersaillesVersailles 1 - 1 PoissyPoissy ...
28 Ago 21 Caen IICaen II 1 - 1 GranvilleGranville ...
28 Ago 21 PlabennecPlabennec 1 - 1 Lorient IILorient II ...
28 Ago 21 VitréVitré 0 - 1 ChartresChartres ...
Jornada 5
04 Sep 21 BloisBlois 2 - 1 Caen IICaen II ...
04 Sep 21 ChartresChartres 1 - 1 VersaillesVersailles ...
04 Sep 21 Voltigeurs ChâteaubriantVoltigeurs 1 - 0 VitréVitré ...
04 Sep 21 GranvilleGranville 1 - 2 RomorantinRomorantin ...
04 Sep 21 PoissyPoissy 1 - 1 Saint-MaloSaint-Malo ...
04 Sep 21 Guingamp IIGuingamp 2 - 1 PlabennecPlabennec ...
04 Sep 21 VannesVannes 1 - 2 FC Rouen 1899Rouen 1899 ...
04 Sep 21 Lorient IILorient II 2 - 1 Saint-PryveSaint-Pryve ...
Jornada 6
11 Sep 21 BloisBlois 1 - 4 Lorient IILorient II ...
11 Sep 21 FC Rouen 1899Rouen 1899 0 - 2 GranvilleGranville ...
11 Sep 21 Saint-PryveSaint-Pryve 1 - 1 Guingamp IIGuingamp ...
11 Sep 21 Saint-MaloSaint-Malo 2 - 1 ChartresChartres ...
11 Sep 21 VersaillesVersailles 2 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
11 Sep 21 Caen IICaen II 0 - 0 RomorantinRomorantin ...
11 Sep 21 PlabennecPlabennec 0 - 0 PoissyPoissy ...
11 Sep 21 VitréVitré 0 - 1 VannesVannes ...
Jornada 7
18 Sep 21 ChartresChartres 2 - 0 PlabennecPlabennec ...
18 Sep 21 Voltigeurs ChâteaubriantVoltigeurs 4 - 0 Saint-MaloSaint-Malo ...
18 Sep 21 GranvilleGranville 1 - 1 VitréVitré ...
18 Sep 21 PoissyPoissy 0 - 1 Saint-PryveSaint-Pryve ...
18 Sep 21 RomorantinRomorantin 1 - 1 FC Rouen 1899Rouen 1899 ...
18 Sep 21 Guingamp IIGuingamp 2 - 3 BloisBlois ...
18 Sep 21 VannesVannes 0 - 1 VersaillesVersailles ...
18 Sep 21 Lorient IILorient II 0 - 1 Caen IICaen II ...
Jornada 8
25 Sep 21 BloisBlois 1 - 1 PoissyPoissy ...
25 Sep 21 Saint-PryveSaint-Pryve 0 - 2 ChartresChartres ...
25 Sep 21 Saint-MaloSaint-Malo 2 - 2 VannesVannes ...
25 Sep 21 VersaillesVersailles 0 - 0 GranvilleGranville ...
25 Sep 21 Caen IICaen II 2 - 5 FC Rouen 1899Rouen 1899 ...
25 Sep 21 PlabennecPlabennec 1 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
25 Sep 21 VitréVitré 1 - 1 RomorantinRomorantin ...
25 Sep 21 Lorient IILorient II 3 - 0 Guingamp IIGuingamp ...
Jornada 9
09 Oct 21 ChartresChartres 3 - 1 BloisBlois ...
09 Oct 21 Voltigeurs ChâteaubriantVoltigeurs 0 - 1 Saint-PryveSaint-Pryve ...
09 Oct 21 FC Rouen 1899Rouen 1899 1 - 1 VitréVitré ...
09 Oct 21 GranvilleGranville 1 - 0 Saint-MaloSaint-Malo ...
09 Oct 21 PoissyPoissy 1 - 2 Lorient IILorient II ...
09 Oct 21 RomorantinRomorantin 1 - 3 VersaillesVersailles ...
09 Oct 21 Guingamp IIGuingamp 1 - 1 Caen IICaen II ...
09 Oct 21 VannesVannes 1 - 1 PlabennecPlabennec ...
Jornada 10
23 Oct 21 BloisBlois 1 - 1 Voltigeurs ChâteaubriantVoltigeurs ...
23 Oct 21 Saint-PryveSaint-Pryve 1 - 1 VannesVannes ...
23 Oct 21 Saint-MaloSaint-Malo 0 - 2 RomorantinRomorantin ...
23 Oct 21 VersaillesVersailles 1 - 0 FC Rouen 1899Rouen 1899 ...
23 Oct 21 Guingamp IIGuingamp 1 - 1 PoissyPoissy ...
23 Oct 21 Caen IICaen II 1 - 0 VitréVitré ...
23 Oct 21 PlabennecPlabennec 3 - 1 GranvilleGranville ...
23 Oct 21 Lorient IILorient II 3 - 2 ChartresChartres ...
Jornada 11
06 Nov 21 ChartresChartres 1 - 2 Guingamp IIGuingamp ...
06 Nov 21 Voltigeurs ChâteaubriantVoltigeurs 2 - 0 Lorient IILorient II ...
07 Nov 21 FC Rouen 1899Rouen 1899 0 - 1 Saint-MaloSaint-Malo ...
06 Nov 21 GranvilleGranville 2 - 1 Saint-PryveSaint-Pryve ...
06 Nov 21 PoissyPoissy 1 - 0 Caen IICaen II ...
06 Nov 21 RomorantinRomorantin 1 - 0 PlabennecPlabennec ...
06 Nov 21 VitréVitré 1 - 2 VersaillesVersailles ...
07 Nov 21 VannesVannes 2 - 2 BloisBlois ...
Jornada 12
20 Nov 21 BloisBlois 2 - 2 GranvilleGranville ...
20 Nov 21 PoissyPoissy 1 - 1 ChartresChartres ...
20 Nov 21 Saint-PryveSaint-Pryve 1 - 0 RomorantinRomorantin ...
20 Nov 21 Saint-MaloSaint-Malo 1 - 0 VitréVitré ...
20 Nov 21 Guingamp IIGuingamp 2 - 3 Voltigeurs ChâteaubriantVoltigeurs ...
20 Nov 21 Caen IICaen II 1 - 0 VersaillesVersailles ...
20 Nov 21 PlabennecPlabennec 1 - 3 FC Rouen 1899Rouen 1899 ...
20 Nov 21 Lorient IILorient II 1 - 0 VannesVannes ...
Jornada 13
04 Dic 21 ChartresChartres 4 - 0 Caen IICaen II ...
04 Dic 21 Voltigeurs ChâteaubriantVoltigeurs 2 - 1 PoissyPoissy ...
04 Dic 21 FC Rouen 1899Rouen 1899 1 - 1 Saint-PryveSaint-Pryve ...
04 Dic 21 GranvilleGranville 0 - 0 Lorient IILorient II ...
04 Dic 21 RomorantinRomorantin 1 - 1 BloisBlois ...
04 Dic 21 VersaillesVersailles 1 - 0 Saint-MaloSaint-Malo ...
04 Dic 21 VitréVitré 1 - 0 PlabennecPlabennec ...
26 Ene 22 VannesVannes 2 - 0 Guingamp IIGuingamp ...
Jornada 14
11 Dic 21 BloisBlois 2 - 1 FC Rouen 1899Rouen 1899 ...
11 Dic 21 ChartresChartres 0 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
11 Dic 21 PoissyPoissy 1 - 3 VannesVannes ...
11 Dic 21 Saint-PryveSaint-Pryve 1 - 1 VitréVitré ...
11 Dic 21 Guingamp IIGuingamp 1 - 0 GranvilleGranville ...
11 Dic 21 Caen IICaen II 0 - 0 Saint-MaloSaint-Malo ...
11 Dic 21 PlabennecPlabennec 1 - 2 VersaillesVersailles ...
11 Dic 21 Lorient IILorient II 4 - 0 RomorantinRomorantin ...
Jornada 15
14 Ene 22 FC Rouen 1899Rouen 1899 1 - 1 Lorient IILorient II ...
15 Ene 22 GranvilleGranville 2 - 2 PoissyPoissy ...
15 Ene 22 RomorantinRomorantin 2 - 3 Guingamp IIGuingamp ...
29 Ene 22 Saint-MaloSaint-Malo 1 - 1 PlabennecPlabennec ...
15 Ene 22 VersaillesVersailles 3 - 1 Saint-PryveSaint-Pryve ...
29 Ene 22 Caen IICaen II 4 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
15 Ene 22 VitréVitré 4 - 1 BloisBlois ...
29 Ene 22 VannesVannes 2 - 3 ChartresChartres ...
Jornada 16
22 Ene 22 BloisBlois 1 - 0 Saint-MaloSaint-Malo ...
22 Ene 22 ChartresChartres 1 - 0 RomorantinRomorantin ...
22 Ene 22 Voltigeurs ChâteaubriantVoltigeurs 1 - 1 GranvilleGranville ...
22 Ene 22 FC Rouen 1899Rouen 1899 1 - 1 PoissyPoissy 1
22 Ene 22 Saint-PryveSaint-Pryve 2 - 1 PlabennecPlabennec ...
22 Ene 22 Guingamp IIGuingamp 0 - 5 VitréVitré ...
22 Ene 22 VannesVannes 1 - 4 Caen IICaen II ...
22 Ene 22 Lorient IILorient II 1 - 1 VersaillesVersailles ...
Jornada 17
26 Feb 22 FC Rouen 1899Rouen 1899 0 - 1 ChartresChartres ...
05 Feb 22 GranvilleGranville 1 - 2 VannesVannes ...
05 Feb 22 RomorantinRomorantin 1 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
05 Feb 22 Saint-MaloSaint-Malo 2 - 0 Lorient IILorient II ...
05 Feb 22 VersaillesVersailles 1 - 1 Guingamp IIGuingamp ...
05 Feb 22 Caen IICaen II 1 - 4 Saint-PryveSaint-Pryve ...
05 Feb 22 PlabennecPlabennec 2 - 2 BloisBlois ...
05 Feb 22 VitréVitré 1 - 1 PoissyPoissy ...
Jornada 18
12 Feb 22 BloisBlois 2 - 1 Saint-PryveSaint-Pryve ...
12 Feb 22 ChartresChartres 5 - 2 VitréVitré ...
12 Feb 22 FC Rouen 1899Rouen 1899 1 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
12 Feb 22 GranvilleGranville 1 - 1 Caen IICaen II ...
13 Feb 22 PoissyPoissy 0 - 3 VersaillesVersailles ...
12 Feb 22 Guingamp IIGuingamp 0 - 0 Saint-MaloSaint-Malo ...
12 Feb 22 VannesVannes 3 - 1 RomorantinRomorantin ...
12 Feb 22 Lorient IILorient II 1 - 0 PlabennecPlabennec ...
Jornada 19
18 Feb 22 FC Rouen 1899Rouen 1899 0 - 2 VannesVannes ...
19 Feb 22 RomorantinRomorantin 0 - 2 GranvilleGranville ...
19 Feb 22 Saint-PryveSaint-Pryve 1 - 0 Lorient IILorient II ...
19 Feb 22 Saint-MaloSaint-Malo 2 - 0 PoissyPoissy ...
19 Feb 22 VersaillesVersailles 1 - 1 ChartresChartres ...
19 Feb 22 Caen IICaen II 3 - 2 BloisBlois ...
19 Feb 22 PlabennecPlabennec 1 - 0 Guingamp IIGuingamp ...
19 Feb 22 VitréVitré 2 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
Jornada 20
05 Mar 22 ChartresChartres 2 - 1 Saint-MaloSaint-Malo ...
05 Mar 22 Voltigeurs ChâteaubriantVoltigeurs 0 - 3 VersaillesVersailles ...
05 Mar 22 GranvilleGranville 0 - 0 FC Rouen 1899Rouen 1899 ...
05 Mar 22 PoissyPoissy 3 - 2 PlabennecPlabennec ...
05 Mar 22 RomorantinRomorantin 0 - 1 Caen IICaen II ...
05 Mar 22 Guingamp IIGuingamp 1 - 1 Saint-PryveSaint-Pryve ...
05 Mar 22 VannesVannes 3 - 1 VitréVitré ...
05 Mar 22 Lorient IILorient II 0 - 1 BloisBlois ...
Jornada 21
12 Mar 22 BloisBlois 5 - 2 Guingamp IIGuingamp ...
12 Mar 22 FC Rouen 1899Rouen 1899 2 - 1 RomorantinRomorantin ...
12 Mar 22 Saint-PryveSaint-Pryve 2 - 3 PoissyPoissy ...
12 Mar 22 Saint-MaloSaint-Malo 3 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
12 Mar 22 VersaillesVersailles 1 - 0 VannesVannes ...
12 Mar 22 Caen IICaen II 1 - 3 Lorient IILorient II ...
12 Mar 22 PlabennecPlabennec 3 - 0 ChartresChartres ...
12 Mar 22 VitréVitré 1 - 1 GranvilleGranville ...
Jornada 22
18 Mar 22 ChartresChartres 2 - 1 Saint-PryveSaint-Pryve ...
19 Mar 22 Voltigeurs ChâteaubriantVoltigeurs 0 - 0 PlabennecPlabennec ...
19 Mar 22 FC Rouen 1899Rouen 1899 1 - 0 Caen IICaen II ...
19 Mar 22 GranvilleGranville 0 - 2 VersaillesVersailles ...
19 Mar 22 PoissyPoissy 2 - 1 BloisBlois ...
19 Mar 22 RomorantinRomorantin 1 - 1 VitréVitré ...
19 Mar 22 Guingamp IIGuingamp 1 - 2 Lorient IILorient II ...
19 Mar 22 VannesVannes 3 - 2 Saint-MaloSaint-Malo ...
Jornada 23
26 Mar 22 BloisBlois 2 - 4 ChartresChartres ...
26 Mar 22 Saint-PryveSaint-Pryve 1 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
26 Mar 22 Saint-MaloSaint-Malo 1 - 0 GranvilleGranville ...
26 Mar 22 VersaillesVersailles 0 - 0 RomorantinRomorantin ...
26 Mar 22 Caen IICaen II 0 - 2 Guingamp IIGuingamp ...
26 Mar 22 PlabennecPlabennec 1 - 0 VannesVannes ...
26 Mar 22 Lorient IILorient II 3 - 0 PoissyPoissy ...
26 Mar 22 VitréVitré 2 - 2 FC Rouen 1899Rouen 1899 ...
Jornada 24
09 Abr 22 ChartresChartres 2 - 5 Lorient IILorient II ...
09 Abr 22 Voltigeurs ChâteaubriantVoltigeurs 1 - 0 BloisBlois ...
08 Abr 22 FC Rouen 1899Rouen 1899 1 - 1 VersaillesVersailles ...
09 Abr 22 GranvilleGranville 2 - 2 PlabennecPlabennec ...
09 Abr 22 PoissyPoissy 1 - 1 Guingamp IIGuingamp ...
09 Abr 22 RomorantinRomorantin 2 - 1 Saint-MaloSaint-Malo ...
09 Abr 22 VannesVannes 3 - 3 Saint-PryveSaint-Pryve ...
09 Abr 22 VitréVitré 2 - 0 Caen IICaen II ...
Jornada 25
16 Abr 22 BloisBlois 5 - 2 VannesVannes ...
16 Abr 22 Saint-PryveSaint-Pryve 0 - 3 GranvilleGranville ...
16 Abr 22 Saint-MaloSaint-Malo 1 - 4 FC Rouen 1899Rouen 1899 ...
16 Abr 22 VersaillesVersailles 3 - 0 VitréVitré ...
16 Abr 22 Guingamp IIGuingamp 3 - 4 ChartresChartres ...
16 Abr 22 Caen IICaen II 0 - 3 PoissyPoissy ...
16 Abr 22 PlabennecPlabennec 2 - 1 RomorantinRomorantin ...
16 Abr 22 Lorient IILorient II 0 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
Jornada 26
23 Abr 22 ChartresChartres 2 - 2 PoissyPoissy ...
23 Abr 22 Voltigeurs ChâteaubriantVoltigeurs 0 - 2 Guingamp IIGuingamp ...
23 Abr 22 FC Rouen 1899Rouen 1899 3 - 0 PlabennecPlabennec ...
23 Abr 22 GranvilleGranville 4 - 2 BloisBlois ...
23 Abr 22 RomorantinRomorantin 4 - 0 Saint-PryveSaint-Pryve ...
23 Abr 22 VersaillesVersailles 3 - 0 Caen IICaen II ...
23 Abr 22 VannesVannes 0 - 3 Lorient IILorient II ...
23 Abr 22 VitréVitré 2 - 2 Saint-MaloSaint-Malo ...
Jornada 27
30 Abr 22 BloisBlois 2 - 2 RomorantinRomorantin ...
30 Abr 22 PoissyPoissy 0 - 0 Voltigeurs ChâteaubriantVoltigeurs ...
30 Abr 22 Saint-PryveSaint-Pryve 1 - 2 FC Rouen 1899Rouen 1899 ...
30 Abr 22 Saint-MaloSaint-Malo 1 - 2 VersaillesVersailles ...
30 Abr 22 Guingamp IIGuingamp 1 - 0 VannesVannes ...
30 Abr 22 Caen IICaen II 3 - 0 ChartresChartres ...
30 Abr 22 PlabennecPlabennec 2 - 2 VitréVitré ...
29 Abr 22 Lorient IILorient II 0 - 1 GranvilleGranville ...
Jornada 28
14 May 22 Voltigeurs ChâteaubriantVoltigeurs 1 - 2 ChartresChartres ...
13 May 22 FC Rouen 1899Rouen 1899 1 - 0 BloisBlois ...
14 May 22 GranvilleGranville 3 - 4 Guingamp IIGuingamp ...
14 May 22 RomorantinRomorantin 1 - 1 Lorient IILorient II ...
14 May 22 Saint-MaloSaint-Malo 1 - 0 Caen IICaen II ...
14 May 22 VersaillesVersailles 1 - 0 PlabennecPlabennec ...
14 May 22 VannesVannes 1 - 1 PoissyPoissy ...
14 May 22 VitréVitré 0 - 3 Saint-PryveSaint-Pryve ...
Jornada 29
21 May 22 BloisBlois 5 - 4 VitréVitré ...
21 May 22 ChartresChartres 1 - 1 VannesVannes ...
21 May 22 Voltigeurs ChâteaubriantVoltigeurs 0 - 0 Caen IICaen II ...
21 May 22 PoissyPoissy 0 - 0 GranvilleGranville ...
21 May 22 Saint-PryveSaint-Pryve 1 - 0 VersaillesVersailles ...
21 May 22 Guingamp IIGuingamp 1 - 2 RomorantinRomorantin ...
21 May 22 PlabennecPlabennec 0 - 6 Saint-MaloSaint-Malo ...
21 May 22 Lorient IILorient II 1 - 1 FC Rouen 1899Rouen 1899 ...
Jornada 30
28 May 22 FC Rouen 1899Rouen 1899 2 - 1 Guingamp IIGuingamp ...
28 May 22 GranvilleGranville 5 - 1 ChartresChartres ...
28 May 22 RomorantinRomorantin 6 - 0 PoissyPoissy ...
28 May 22 Saint-MaloSaint-Malo 1 - 0 Saint-PryveSaint-Pryve ...
28 May 22 VersaillesVersailles 3 - 1 BloisBlois ...
28 May 22 Caen IICaen II 2 - 2 PlabennecPlabennec ...
28 May 22 VannesVannes 1 - 2 Voltigeurs ChâteaubriantVoltigeurs ...
28 May 22 VitréVitré 0 - 5 Lorient IILorient II ...

Clasificación

Equipo PJ GF GC Puntos
1 Versailles Versailles 30 47 16 64
2 Lorient II Lorient II 30 49 22 56
3 Chartres Chartres 30 53 49 50
4 FC Rouen 1899 Rouen 1899 30 38 28 47
5 Blois Blois 30 52 56 43
6 Saint-Pryve Saint-Pryve 30 37 38 42
7 Vannes Vannes 30 42 43 39
8 Voltigeurs Châteaubriant Voltigeurs 30 29 33 38
9 Granville Granville 30 38 32 38
10 Guingamp II Guingamp II 30 41 48 38
11 Saint-Malo Saint-Malo 30 33 38 36
12 Poissy Poissy 30 33 40 36
13 Romorantin Romorantin 30 37 40 35
14 Caen II Caen II 30 29 41 35
15 Plabennec Plabennec 30 29 45 27
16 Vitré Vitré 30 35 53 25

  USO DE MEMORIA  
6,708,192 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.4074
Total Execution Time  0.4095
  CADENA URL  
/ligue_cfa2022/grupo1/calendario
  GET DATOS  
$_GET['/ligue_cfa2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0125  SELECT type FROM routes WHERE alias = 'ligue_cfa2022'
0.0254  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=220 AND type_rel = 3
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 220 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0128  SELECT /*53 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 (1303338,1286561,1233296,1230274,1161224) ORDER BY n.cover_points DESC, update_date DESC
0.0127  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 63479 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0258  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 63479 ORDER BY round ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-23 23:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-23 23:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-23 23:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-23 23:13:24' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0130  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_cfa' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0201  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63479 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63479 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0246  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63479 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63479 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0138  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 63479 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63479 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0146  SELECT *,(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 = 63479 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