4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
29 Sep 23 USM AnnabaUSM Annaba 1 - 1 HB Chelghoum LaidChelghoum ...
29 Sep 23 JS Bordj MénaïelBordj 0 - 0 KhroubKhroub 1
29 Sep 23 CA BatnaCA Batna 3 - 0 Olympique AkbouOlympique 2
29 Sep 23 El EulmaEl Eulma 0 - 0 Aïn M'lilaAïn M'lila 3
29 Sep 23 MO ConstantineConstantine 0 - 1 Khemis El KhechnaKhemis 1
30 Sep 23 Oued MagraneOued 1 - 1 GhozlaneGhozlane ...
29 Sep 23 RB OuarglaRB Ouargla 0 - 0 MSP BatnaMSP Batna ...
29 Sep 23 TeleghmaTeleghma 3 - 2 USM El HarrachHarrach ...
Jornada 2
07 Oct 23 CA BatnaCA Batna 1 - 1 MO ConstantineConstantine ...
07 Oct 23 HB Chelghoum LaidChelghoum 2 - 1 Oued MagraneOued ...
07 Oct 23 GhozlaneGhozlane 1 - 1 JS Bordj MénaïelBordj 1
07 Oct 23 USM El HarrachHarrach 1 - 2 MSP BatnaMSP Batna ...
07 Oct 23 Khemis El KhechnaKhemis 2 - 0 RB OuarglaRB Ouargla ...
07 Oct 23 KhroubKhroub 0 - 0 El EulmaEl Eulma ...
26 Dic 23 Aïn M'lilaAïn M'lila 2 - 1 TeleghmaTeleghma ...
07 Oct 23 Olympique AkbouOlympique 5 - 0 USM AnnabaUSM Annaba ...
Jornada 3
13 Oct 23 USM AnnabaUSM Annaba 0 - 0 CA BatnaCA Batna 3
13 Oct 23 JS Bordj MénaïelBordj 2 - 0 HB Chelghoum LaidChelghoum 2
14 Oct 23 El EulmaEl Eulma 2 - 0 GhozlaneGhozlane ...
16 Oct 23 MO ConstantineConstantine 2 - 1 KhroubKhroub 13
13 Oct 23 MSP BatnaMSP Batna 1 - 0 Aïn M'lilaAïn M'lila ...
14 Oct 23 Oued MagraneOued 1 - 4 Olympique AkbouOlympique ...
13 Oct 23 RB OuarglaRB Ouargla 1 - 0 USM El HarrachHarrach ...
13 Oct 23 TeleghmaTeleghma 0 - 0 Khemis El KhechnaKhemis 2
Jornada 4
10 Nov 23 USM AnnabaUSM Annaba 0 - 0 MO ConstantineConstantine 1
10 Nov 23 CA BatnaCA Batna 1 - 0 Oued MagraneOued 4
10 Nov 23 HB Chelghoum LaidChelghoum 5 - 0 El EulmaEl Eulma ...
10 Nov 23 GhozlaneGhozlane 1 - 1 RB OuarglaRB Ouargla ...
10 Nov 23 Khemis El KhechnaKhemis 2 - 0 MSP BatnaMSP Batna ...
10 Nov 23 KhroubKhroub 1 - 2 TeleghmaTeleghma 3
10 Nov 23 Aïn M'lilaAïn M'lila 1 - 1 USM El HarrachHarrach ...
10 Nov 23 Olympique AkbouOlympique 1 - 1 JS Bordj MénaïelBordj ...
Jornada 5
18 Nov 23 JS Bordj MénaïelBordj 0 - 0 CA BatnaCA Batna ...
18 Nov 23 El EulmaEl Eulma 1 - 2 Olympique AkbouOlympique ...
18 Nov 23 USM El HarrachHarrach 1 - 1 Khemis El KhechnaKhemis ...
18 Nov 23 MO ConstantineConstantine 1 - 0 HB Chelghoum LaidChelghoum ...
18 Nov 23 MSP BatnaMSP Batna 3 - 1 KhroubKhroub ...
18 Nov 23 Oued MagraneOued 2 - 0 USM AnnabaUSM Annaba ...
18 Nov 23 RB OuarglaRB Ouargla 1 - 0 Aïn M'lilaAïn M'lila ...
18 Nov 23 TeleghmaTeleghma 1 - 2 GhozlaneGhozlane ...
Jornada 6
24 Nov 23 USM AnnabaUSM Annaba 1 - 2 JS Bordj MénaïelBordj ...
24 Nov 23 CA BatnaCA Batna 3 - 0 El EulmaEl Eulma ...
24 Nov 23 HB Chelghoum LaidChelghoum 1 - 0 RB OuarglaRB Ouargla ...
24 Nov 23 GhozlaneGhozlane 1 - 2 MSP BatnaMSP Batna ...
24 Nov 23 Khemis El KhechnaKhemis 2 - 0 Aïn M'lilaAïn M'lila ...
24 Nov 23 KhroubKhroub 2 - 1 USM El HarrachHarrach ...
24 Nov 23 Olympique AkbouOlympique 2 - 1 MO ConstantineConstantine 1
24 Nov 23 Oued MagraneOued 1 - 0 TeleghmaTeleghma ...
Jornada 7
02 Dic 23 JS Bordj MénaïelBordj 2 - 0 Oued MagraneOued ...
02 Dic 23 El EulmaEl Eulma 1 - 0 Khemis El KhechnaKhemis ...
02 Dic 23 USM El HarrachHarrach 2 - 0 USM AnnabaUSM Annaba ...
02 Dic 23 Aïn M'lilaAïn M'lila 1 - 1 KhroubKhroub ...
02 Dic 23 MO ConstantineConstantine 2 - 1 GhozlaneGhozlane ...
02 Dic 23 MSP BatnaMSP Batna 0 - 0 CA BatnaCA Batna ...
02 Dic 23 RB OuarglaRB Ouargla 0 - 1 Olympique AkbouOlympique ...
02 Dic 23 TeleghmaTeleghma 2 - 1 HB Chelghoum LaidChelghoum ...
Jornada 8
08 Dic 23 USM AnnabaUSM Annaba 0 - 0 El EulmaEl Eulma ...
08 Dic 23 JS Bordj MénaïelBordj 5 - 4 TeleghmaTeleghma ...
08 Dic 23 CA BatnaCA Batna 0 - 0 RB OuarglaRB Ouargla 7
08 Dic 23 HB Chelghoum LaidChelghoum 1 - 0 USM El HarrachHarrach ...
08 Dic 23 GhozlaneGhozlane 2 - 1 Aïn M'lilaAïn M'lila ...
08 Dic 23 KhroubKhroub 3 - 1 Khemis El KhechnaKhemis ...
08 Dic 23 Olympique AkbouOlympique 1 - 0 MSP BatnaMSP Batna ...
08 Dic 23 Oued MagraneOued 1 - 2 MO ConstantineConstantine ...
Jornada 9
29 Dic 23 El EulmaEl Eulma 0 - 2 Oued MagraneOued ...
30 Dic 23 USM El HarrachHarrach 1 - 4 Olympique AkbouOlympique ...
29 Dic 23 Khemis El KhechnaKhemis 4 - 0 GhozlaneGhozlane ...
30 Dic 23 Aïn M'lilaAïn M'lila 0 - 2 CA BatnaCA Batna ...
29 Dic 23 MO ConstantineConstantine 0 - 2 JS Bordj MénaïelBordj 12
29 Dic 23 MSP BatnaMSP Batna 2 - 2 HB Chelghoum LaidChelghoum 2
29 Dic 23 RB OuarglaRB Ouargla 1 - 0 KhroubKhroub 1
30 Dic 23 TeleghmaTeleghma 2 - 1 USM AnnabaUSM Annaba ...
Jornada 10
05 Ene 24 USM AnnabaUSM Annaba 1 - 3 MSP BatnaMSP Batna ...
05 Ene 24 JS Bordj MénaïelBordj 1 - 0 El EulmaEl Eulma 6
05 Ene 24 CA BatnaCA Batna 2 - 1 USM El HarrachHarrach 2
05 Ene 24 HB Chelghoum LaidChelghoum 1 - 1 Khemis El KhechnaKhemis 8
05 Ene 24 GhozlaneGhozlane 2 - 1 KhroubKhroub 5
06 Ene 24 MO ConstantineConstantine 1 - 0 TeleghmaTeleghma 1
05 Ene 24 Olympique AkbouOlympique 3 - 1 Aïn M'lilaAïn M'lila 8
06 Ene 24 Oued MagraneOued 0 - 0 RB OuarglaRB Ouargla 1
Jornada 11
12 Ene 24 El EulmaEl Eulma 1 - 1 MO ConstantineConstantine ...
12 Ene 24 USM El HarrachHarrach 2 - 1 GhozlaneGhozlane 3
12 Ene 24 Khemis El KhechnaKhemis 0 - 0 JS Bordj MénaïelBordj ...
07 Feb 24 KhroubKhroub 0 - 0 CA BatnaCA Batna 13
12 Ene 24 Aïn M'lilaAïn M'lila 2 - 1 HB Chelghoum LaidChelghoum ...
12 Ene 24 MSP BatnaMSP Batna 1 - 1 Oued MagraneOued 2
12 Ene 24 RB OuarglaRB Ouargla 0 - 1 USM AnnabaUSM Annaba 28
12 Ene 24 TeleghmaTeleghma 1 - 2 Olympique AkbouOlympique 1
Jornada 12
16 Ene 24 USM AnnabaUSM Annaba 1 - 0 Aïn M'lilaAïn M'lila ...
16 Ene 24 JS Bordj MénaïelBordj 0 - 2 MSP BatnaMSP Batna 1
16 Ene 24 CA BatnaCA Batna 1 - 0 Khemis El KhechnaKhemis 1
16 Ene 24 HB Chelghoum LaidChelghoum 1 - 0 GhozlaneGhozlane ...
16 Ene 24 El EulmaEl Eulma 0 - 1 TeleghmaTeleghma ...
16 Ene 24 MO ConstantineConstantine 1 - 1 RB OuarglaRB Ouargla ...
16 Ene 24 Olympique AkbouOlympique 0 - 0 KhroubKhroub 9
16 Ene 24 Oued MagraneOued 1 - 0 USM El HarrachHarrach ...
Jornada 13
20 Ene 24 GhozlaneGhozlane 2 - 3 Olympique AkbouOlympique ...
20 Ene 24 USM El HarrachHarrach 1 - 0 JS Bordj MénaïelBordj ...
20 Ene 24 Khemis El KhechnaKhemis 0 - 0 USM AnnabaUSM Annaba 2
20 Ene 24 KhroubKhroub 2 - 1 HB Chelghoum LaidChelghoum ...
20 Ene 24 Aïn M'lilaAïn M'lila 1 - 1 Oued MagraneOued ...
20 Ene 24 MSP BatnaMSP Batna 4 - 0 MO ConstantineConstantine ...
20 Ene 24 RB OuarglaRB Ouargla 3 - 2 El EulmaEl Eulma ...
20 Ene 24 TeleghmaTeleghma 0 - 0 CA BatnaCA Batna ...
Jornada 14
24 Ene 24 USM AnnabaUSM Annaba 1 - 1 KhroubKhroub ...
24 Ene 24 JS Bordj MénaïelBordj 0 - 0 Aïn M'lilaAïn M'lila 4
24 Ene 24 CA BatnaCA Batna 1 - 0 GhozlaneGhozlane 13
24 Ene 24 El EulmaEl Eulma 1 - 3 MSP BatnaMSP Batna ...
24 Ene 24 MO ConstantineConstantine 2 - 0 USM El HarrachHarrach 2
24 Ene 24 Olympique AkbouOlympique 2 - 0 HB Chelghoum LaidChelghoum ...
24 Ene 24 Oued MagraneOued 1 - 0 Khemis El KhechnaKhemis ...
24 Ene 24 TeleghmaTeleghma 1 - 0 RB OuarglaRB Ouargla 1
Jornada 15
28 Ene 24 HB Chelghoum LaidChelghoum 1 - 1 CA BatnaCA Batna ...
28 Ene 24 GhozlaneGhozlane 2 - 2 USM AnnabaUSM Annaba ...
28 Ene 24 USM El HarrachHarrach 4 - 0 El EulmaEl Eulma ...
28 Ene 24 Khemis El KhechnaKhemis 0 - 1 Olympique AkbouOlympique ...
28 Ene 24 KhroubKhroub 3 - 0 Oued MagraneOued ...
28 Ene 24 Aïn M'lilaAïn M'lila 1 - 0 MO ConstantineConstantine ...
28 Ene 24 MSP BatnaMSP Batna 1 - 0 TeleghmaTeleghma ...
28 Ene 24 RB OuarglaRB Ouargla 0 - 3 JS Bordj MénaïelBordj ...
Jornada 16
16 Feb 24 HB Chelghoum LaidChelghoum 0 - 0 USM AnnabaUSM Annaba ...
16 Feb 24 GhozlaneGhozlane 0 - 0 Oued MagraneOued ...
16 Feb 24 USM El HarrachHarrach 3 - 2 TeleghmaTeleghma 2
16 Feb 24 Khemis El KhechnaKhemis 2 - 2 MO ConstantineConstantine ...
16 Feb 24 KhroubKhroub 1 - 1 JS Bordj MénaïelBordj ...
16 Feb 24 Aïn M'lilaAïn M'lila 2 - 1 El EulmaEl Eulma ...
16 Feb 24 MSP BatnaMSP Batna 3 - 0 RB OuarglaRB Ouargla 1
05 Mar 24 Olympique AkbouOlympique 2 - 0 CA BatnaCA Batna ...
Jornada 17
24 Feb 24 USM AnnabaUSM Annaba 0 - 0 Olympique AkbouOlympique ...
24 Feb 24 JS Bordj MénaïelBordj 1 - 0 GhozlaneGhozlane ...
24 Feb 24 El EulmaEl Eulma 1 - 4 KhroubKhroub ...
25 Feb 24 MO ConstantineConstantine 0 - 0 CA BatnaCA Batna ...
24 Feb 24 MSP BatnaMSP Batna 0 - 0 USM El HarrachHarrach ...
24 Feb 24 Oued MagraneOued 3 - 0 HB Chelghoum LaidChelghoum ...
24 Feb 24 RB OuarglaRB Ouargla 1 - 1 Khemis El KhechnaKhemis ...
24 Feb 24 TeleghmaTeleghma 2 - 1 Aïn M'lilaAïn M'lila ...
Jornada 18
01 Mar 24 CA BatnaCA Batna 1 - 0 USM AnnabaUSM Annaba ...
01 Mar 24 HB Chelghoum LaidChelghoum 0 - 0 JS Bordj MénaïelBordj ...
01 Mar 24 GhozlaneGhozlane 1 - 1 El EulmaEl Eulma ...
04 Mar 24 USM El HarrachHarrach 1 - 1 RB OuarglaRB Ouargla 3
01 Mar 24 Khemis El KhechnaKhemis 1 - 0 TeleghmaTeleghma ...
01 Mar 24 KhroubKhroub 0 - 0 MO ConstantineConstantine 3
01 Mar 24 Aïn M'lilaAïn M'lila 1 - 4 MSP BatnaMSP Batna ...
01 Mar 24 Olympique AkbouOlympique 3 - 0 Oued MagraneOued ...
Jornada 19
16 Mar 24 JS Bordj MénaïelBordj 0 - 2 Olympique AkbouOlympique ...
16 Mar 24 El EulmaEl Eulma 1 - 0 HB Chelghoum LaidChelghoum ...
16 Mar 24 USM El HarrachHarrach 1 - 0 Aïn M'lilaAïn M'lila ...
16 Mar 24 MO ConstantineConstantine 1 - 1 USM AnnabaUSM Annaba ...
16 Mar 24 MSP BatnaMSP Batna 1 - 0 Khemis El KhechnaKhemis ...
16 Mar 24 Oued MagraneOued 2 - 0 CA BatnaCA Batna ...
16 Mar 24 RB OuarglaRB Ouargla 1 - 0 GhozlaneGhozlane ...
16 Mar 24 TeleghmaTeleghma 1 - 0 KhroubKhroub ...
Jornada 20
05 Abr 24 USM AnnabaUSM Annaba 3 - 0 Oued MagraneOued ...
23 Mar 24 CA BatnaCA Batna 3 - 2 JS Bordj MénaïelBordj ...
23 Mar 24 HB Chelghoum LaidChelghoum 1 - 2 MO ConstantineConstantine ...
23 Mar 24 GhozlaneGhozlane 2 - 1 TeleghmaTeleghma ...
23 Mar 24 Khemis El KhechnaKhemis 1 - 0 USM El HarrachHarrach ...
23 Mar 24 KhroubKhroub 3 - 0 MSP BatnaMSP Batna ...
23 Mar 24 Aïn M'lilaAïn M'lila 1 - 0 RB OuarglaRB Ouargla ...
23 Mar 24 Olympique AkbouOlympique 4 - 1 El EulmaEl Eulma ...
Jornada 21
30 Mar 24 El EulmaEl Eulma 0 - 0 CA BatnaCA Batna ...
30 Mar 24 USM El HarrachHarrach 2 - 1 KhroubKhroub ...
30 Mar 24 Aïn M'lilaAïn M'lila 3 - 0 Khemis El KhechnaKhemis ...
30 Mar 24 MSP BatnaMSP Batna 4 - 0 GhozlaneGhozlane ...
30 Mar 24 RB OuarglaRB Ouargla 1 - 0 HB Chelghoum LaidChelghoum ...
30 Mar 24 TeleghmaTeleghma 4 - 1 Oued MagraneOued ...
23 Abr 24 JS Bordj MénaïelBordj 0 - 0 USM AnnabaUSM Annaba 13
05 Abr 24 MO ConstantineConstantine 0 - 2 Olympique AkbouOlympique ...
Jornada 22
14 Abr 24 USM AnnabaUSM Annaba 2 - 0 USM El HarrachHarrach ...
14 Abr 24 CA BatnaCA Batna 1 - 0 MSP BatnaMSP Batna ...
14 Abr 24 HB Chelghoum LaidChelghoum 2 - 1 TeleghmaTeleghma ...
14 Abr 24 GhozlaneGhozlane 2 - 1 MO ConstantineConstantine ...
14 Abr 24 Khemis El KhechnaKhemis 3 - 0 El EulmaEl Eulma ...
14 Abr 24 KhroubKhroub 2 - 0 Aïn M'lilaAïn M'lila ...
14 Abr 24 Olympique AkbouOlympique 4 - 0 RB OuarglaRB Ouargla ...
14 Abr 24 Oued MagraneOued 3 - 1 JS Bordj MénaïelBordj ...
Jornada 23
19 Abr 24 El EulmaEl Eulma 1 - 1 USM AnnabaUSM Annaba ...
19 Abr 24 USM El HarrachHarrach 2 - 0 HB Chelghoum LaidChelghoum ...
19 Abr 24 Khemis El KhechnaKhemis 1 - 1 KhroubKhroub ...
19 Abr 24 Aïn M'lilaAïn M'lila 1 - 1 GhozlaneGhozlane ...
19 Abr 24 MO ConstantineConstantine 2 - 0 Oued MagraneOued ...
19 Abr 24 MSP BatnaMSP Batna 0 - 0 Olympique AkbouOlympique ...
19 Abr 24 RB OuarglaRB Ouargla 1 - 0 CA BatnaCA Batna ...
19 Abr 24 TeleghmaTeleghma 2 - 0 JS Bordj MénaïelBordj ...
Jornada 24
27 Abr 24 USM AnnabaUSM Annaba 3 - 1 TeleghmaTeleghma ...
27 Abr 24 JS Bordj MénaïelBordj 1 - 2 MO ConstantineConstantine ...
27 Abr 24 CA BatnaCA Batna 1 - 2 Aïn M'lilaAïn M'lila ...
27 Abr 24 HB Chelghoum LaidChelghoum 2 - 0 MSP BatnaMSP Batna ...
27 Abr 24 GhozlaneGhozlane 1 - 0 Khemis El KhechnaKhemis ...
27 Abr 24 KhroubKhroub 1 - 2 RB OuarglaRB Ouargla ...
27 Abr 24 Olympique AkbouOlympique 2 - 0 USM El HarrachHarrach ...
27 Abr 24 Oued MagraneOued 1 - 0 El EulmaEl Eulma ...
Jornada 25
04 May 24 El EulmaEl Eulma 0 - 2 JS Bordj MénaïelBordj ...
04 May 24 USM El HarrachHarrach 1 - 1 CA BatnaCA Batna ...
04 May 24 Khemis El KhechnaKhemis 1 - 0 HB Chelghoum LaidChelghoum ...
04 May 24 KhroubKhroub 3 - 0 GhozlaneGhozlane ...
04 May 24 Aïn M'lilaAïn M'lila 1 - 0 Olympique AkbouOlympique ...
04 May 24 MSP BatnaMSP Batna 2 - 1 USM AnnabaUSM Annaba ...
04 May 24 RB OuarglaRB Ouargla 2 - 0 Oued MagraneOued ...
04 May 24 TeleghmaTeleghma 2 - 3 MO ConstantineConstantine ...
Jornada 26
11 May 24 USM AnnabaUSM Annaba
16:00
RB OuarglaRB Ouargla ...
11 May 24 JS Bordj MénaïelBordj
16:00
Khemis El KhechnaKhemis ...
11 May 24 CA BatnaCA Batna
16:00
KhroubKhroub ...
11 May 24 HB Chelghoum LaidChelghoum
16:00
Aïn M'lilaAïn M'lila ...
11 May 24 GhozlaneGhozlane
16:00
USM El HarrachHarrach ...
11 May 24 MO ConstantineConstantine
16:00
El EulmaEl Eulma ...
11 May 24 Olympique AkbouOlympique
16:00
TeleghmaTeleghma ...
11 May 24 Oued MagraneOued
16:00
MSP BatnaMSP Batna ...

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 Olympique Akbou Olympique 25 50 14 61
2 MSP Batna MSP Batna 25 38 19 48
3 CA Batna CA Batna 25 22 13 41
4 MO Constantine Constantine 25 27 27 38
5 JS Bordj Ménaïel Bordj 25 27 23 36
6 Khemis El Khechna Khemis 25 24 18 35
7 RB Ouargla RB Ouargla 25 17 24 34
8 Khroub Khroub 25 32 23 33
9 Teleghma Teleghma 25 34 35 32
10 Oued Magrane Oued Magrane 25 23 32 32
11 Aïn M'lila Aïn M'lila 25 22 29 30
12 USM El Harrach Harrach 25 27 31 29
13 HB Chelghoum Laid Chelghoum 25 23 28 27
14 USM Annaba USM Annaba 25 20 26 27
15 Ghozlane Ghozlane 25 23 38 25
16 El Eulma El Eulma 25 14 43 16

  USO DE MEMORIA  
6,307,616 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3946
Total Execution Time  0.3966
  CADENA URL  
/ligue_2_argelia2024/grupo1/calendario
  GET DATOS  
$_GET['/ligue_2_argelia2024/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (18)  
0.0126  SELECT type FROM routes WHERE alias = 'ligue_2_argelia2024'
0.0255  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ligue_2_argelia' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=400 AND type_rel = 3
0.0129  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 400 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0129  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 (1083754,961158,245286,244317,87628) ORDER BY n.cover_points DESC, update_date DESC
0.0125  SELECT id,name,alias,stepParent FROM categories WHERE parentId=400 ORDER BY order_id ASC
0.0126  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 400 GROUP BY l.categoryId
0.0126  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=400 GROUP BY l.year ORDER BY l.year DESC
0.0126  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 = 73814 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0137  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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 73814 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-05-05 05:28:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0128  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 05:28:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-05 05:28:03' 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-05-05 05:28:03' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  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 events2024 e ON e.player_id = p.id AND e.league_id = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 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.0126  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 events2024 e ON e.player_id = p.id AND e.league_id = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0133  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 events2024 e ON e.player_id = p.id AND e.league_id = 73814 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73814 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0142  SELECT *,(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 = 73814 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC