Jornada 1
23 Oct 21 AFF FFV Fribourg Sub 17Fribourg 3 - 0 Schaffhausen Sub 17Schaffhause ...
04 Sep 21 Concordia Sub 17Concordia 4 - 4 FC Vaduz Sub 17Vaduz ...
04 Sep 21 BSC Young Boys Sub 17Young Boys 3 - 0 Team Vaud Sub 17Team Vaud ...
04 Sep 21 Luzern Sub 17Luzern 0 - 9 FC St. Gallen 1879 Sub 17Gallen 1879 ...
04 Sep 21 Fc Basel 1893 Sub 17Basel 1893 2 - 0 Servette FC Sub 17Servette ...
05 Sep 21 Rapperswil-Jona Sub 17Rapperswil- 2 - 1 FC Zürich Sub 17Zürich ...
Jornada 2
11 Sep 21 FC Zürich Sub 17Zürich 1 - 3 Luzern Sub 17Luzern ...
11 Sep 21 Schaffhausen Sub 17Schaffhause 1 - 6 Rapperswil-Jona Sub 17Rapperswil- ...
11 Sep 21 Südostschweiz Sub 17Südostschw 0 - 3 AFF FFV Fribourg Sub 17Fribourg ...
11 Sep 21 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 5 Fc Basel 1893 Sub 17Basel 1893 ...
11 Sep 21 Servette FC Sub 17Servette 1 - 3 Concordia Sub 17Concordia ...
11 Sep 21 FC Vaduz Sub 17Vaduz 1 - 0 BSC Young Boys Sub 17Young Boys ...
Jornada 3
18 Sep 21 Team Vaud Sub 17Team Vaud 0 - 3 FC Vaduz Sub 17Vaduz ...
18 Sep 21 BSC Young Boys Sub 17Young Boys 5 - 2 Servette FC Sub 17Servette ...
18 Sep 21 Concordia Sub 17Concordia 2 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
18 Sep 21 Luzern Sub 17Luzern 4 - 1 Schaffhausen Sub 17Schaffhause ...
18 Sep 21 Fc Basel 1893 Sub 17Basel 1893 2 - 2 FC Zürich Sub 17Zürich ...
18 Sep 21 Rapperswil-Jona Sub 17Rapperswil- 4 - 1 Südostschweiz Sub 17Südostschw ...
Jornada 4
25 Sep 21 Südostschweiz Sub 17Südostschw 3 - 0 Luzern Sub 17Luzern ...
26 Sep 21 Rapperswil-Jona Sub 17Rapperswil- 3 - 3 AFF FFV Fribourg Sub 17Fribourg ...
25 Sep 21 Schaffhausen Sub 17Schaffhause 1 - 6 Fc Basel 1893 Sub 17Basel 1893 ...
25 Sep 21 FC Zürich Sub 17Zürich 2 - 2 Concordia Sub 17Concordia ...
25 Sep 21 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 0 BSC Young Boys Sub 17Young Boys ...
25 Sep 21 Servette FC Sub 17Servette 2 - 2 Team Vaud Sub 17Team Vaud ...
Jornada 5
09 Oct 21 Luzern Sub 17Luzern 2 - 0 AFF FFV Fribourg Sub 17Fribourg ...
09 Oct 21 Concordia Sub 17Concordia 5 - 1 Schaffhausen Sub 17Schaffhause ...
09 Oct 21 BSC Young Boys Sub 17Young Boys 2 - 1 FC Zürich Sub 17Zürich ...
09 Oct 21 Team Vaud Sub 17Team Vaud 1 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
09 Oct 21 FC Vaduz Sub 17Vaduz 2 - 1 Servette FC Sub 17Servette ...
09 Oct 21 Fc Basel 1893 Sub 17Basel 1893 1 - 1 Südostschweiz Sub 17Südostschw ...
Jornada 6
16 Oct 21 FC St. Gallen 1879 Sub 17Gallen 1879 5 - 2 FC Vaduz Sub 17Vaduz ...
16 Oct 21 AFF FFV Fribourg Sub 17Fribourg 4 - 0 Fc Basel 1893 Sub 17Basel 1893 ...
16 Oct 21 Südostschweiz Sub 17Südostschw 4 - 4 Concordia Sub 17Concordia ...
16 Oct 21 Schaffhausen Sub 17Schaffhause 1 - 6 BSC Young Boys Sub 17Young Boys ...
17 Oct 21 FC Zürich Sub 17Zürich 5 - 0 Team Vaud Sub 17Team Vaud ...
17 Oct 21 Rapperswil-Jona Sub 17Rapperswil- 2 - 0 Luzern Sub 17Luzern ...
Jornada 7
30 Oct 21 Servette FC Sub 17Servette 4 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
30 Oct 21 FC Vaduz Sub 17Vaduz 2 - 1 FC Zürich Sub 17Zürich ...
30 Oct 21 Team Vaud Sub 17Team Vaud 2 - 2 Schaffhausen Sub 17Schaffhause ...
30 Oct 21 BSC Young Boys Sub 17Young Boys 3 - 2 Südostschweiz Sub 17Südostschw ...
31 Oct 21 Concordia Sub 17Concordia 1 - 1 AFF FFV Fribourg Sub 17Fribourg ...
30 Oct 21 Fc Basel 1893 Sub 17Basel 1893 2 - 0 Rapperswil-Jona Sub 17Rapperswil- ...
Jornada 8
06 Nov 21 FC Zürich Sub 17Zürich 4 - 1 Servette FC Sub 17Servette ...
06 Nov 21 AFF FFV Fribourg Sub 17Fribourg 3 - 1 BSC Young Boys Sub 17Young Boys ...
06 Nov 21 Schaffhausen Sub 17Schaffhause 2 - 2 FC Vaduz Sub 17Vaduz ...
06 Nov 21 Südostschweiz Sub 17Südostschw 1 - 4 Team Vaud Sub 17Team Vaud ...
06 Nov 21 Luzern Sub 17Luzern 0 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
07 Nov 21 Rapperswil-Jona Sub 17Rapperswil- 3 - 3 Concordia Sub 17Concordia ...
Jornada 9
13 Nov 21 FC St. Gallen 1879 Sub 17Gallen 1879 5 - 3 FC Zürich Sub 17Zürich ...
13 Nov 21 FC Vaduz Sub 17Vaduz 1 - 3 Südostschweiz Sub 17Südostschw ...
13 Nov 21 Servette FC Sub 17Servette 4 - 2 Schaffhausen Sub 17Schaffhause ...
13 Nov 21 Team Vaud Sub 17Team Vaud 0 - 3 AFF FFV Fribourg Sub 17Fribourg ...
13 Nov 21 BSC Young Boys Sub 17Young Boys 5 - 2 Rapperswil-Jona Sub 17Rapperswil- ...
13 Nov 21 Concordia Sub 17Concordia 2 - 1 Luzern Sub 17Luzern ...
Jornada 10
20 Nov 21 Schaffhausen Sub 17Schaffhause 0 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
20 Nov 21 Südostschweiz Sub 17Südostschw 2 - 2 Servette FC Sub 17Servette ...
20 Nov 21 AFF FFV Fribourg Sub 17Fribourg 2 - 1 FC Vaduz Sub 17Vaduz ...
20 Nov 21 Luzern Sub 17Luzern 2 - 0 BSC Young Boys Sub 17Young Boys ...
20 Nov 21 Fc Basel 1893 Sub 17Basel 1893 2 - 0 Concordia Sub 17Concordia ...
21 Nov 21 Rapperswil-Jona Sub 17Rapperswil- 3 - 2 Team Vaud Sub 17Team Vaud ...
Jornada 11
27 Nov 21 FC Zürich Sub 17Zürich 1 - 1 Schaffhausen Sub 17Schaffhause ...
27 Nov 21 Servette FC Sub 17Servette 4 - 0 AFF FFV Fribourg Sub 17Fribourg ...
27 Nov 21 FC St. Gallen 1879 Sub 17Gallen 1879 7 - 4 Südostschweiz Sub 17Südostschw ...
27 Nov 21 FC Vaduz Sub 17Vaduz 1 - 4 Rapperswil-Jona Sub 17Rapperswil- ...
27 Nov 21 Team Vaud Sub 17Team Vaud 5 - 1 Luzern Sub 17Luzern ...
28 Nov 21 Fc Basel 1893 Sub 17Basel 1893 3 - 1 BSC Young Boys Sub 17Young Boys ...
Jornada 12
04 Dic 21 Concordia Sub 17Concordia 1 - 2 BSC Young Boys Sub 17Young Boys ...
04 Dic 21 Luzern Sub 17Luzern 3 - 1 FC Vaduz Sub 17Vaduz ...
05 Dic 21 AFF FFV Fribourg Sub 17Fribourg 2 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
04 Dic 21 Südostschweiz Sub 17Südostschw 4 - 1 FC Zürich Sub 17Zürich ...
04 Dic 21 Fc Basel 1893 Sub 17Basel 1893 3 - 1 Team Vaud Sub 17Team Vaud ...
05 Dic 21 Rapperswil-Jona Sub 17Rapperswil- 2 - 2 Servette FC Sub 17Servette ...
Jornada 13
26 Feb 22 Team Vaud Sub 17Team Vaud 2 - 6 Concordia Sub 17Concordia ...
26 Feb 22 FC Vaduz Sub 17Vaduz 1 - 4 Fc Basel 1893 Sub 17Basel 1893 ...
23 Oct 21 Servette FC Sub 17Servette 1 - 6 Luzern Sub 17Luzern ...
26 Feb 22 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 3 Rapperswil-Jona Sub 17Rapperswil- ...
26 Feb 22 FC Zürich Sub 17Zürich 2 - 3 AFF FFV Fribourg Sub 17Fribourg ...
26 Feb 22 Schaffhausen Sub 17Schaffhause 4 - 1 Südostschweiz Sub 17Südostschw ...
Jornada 14
05 Mar 22 Team Vaud Sub 17Team Vaud 3 - 0 BSC Young Boys Sub 17Young Boys ...
05 Mar 22 FC Vaduz Sub 17Vaduz 5 - 2 Concordia Sub 17Concordia ...
05 Mar 22 Servette FC Sub 17Servette 0 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
05 Mar 22 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 4 Luzern Sub 17Luzern ...
06 Mar 22 FC Zürich Sub 17Zürich 1 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
06 Mar 22 Schaffhausen Sub 17Schaffhause 3 - 3 AFF FFV Fribourg Sub 17Fribourg ...
Jornada 15
19 Mar 22 AFF FFV Fribourg Sub 17Fribourg 6 - 0 Südostschweiz Sub 17Südostschw ...
12 Mar 22 Luzern Sub 17Luzern 0 - 0 FC Zürich Sub 17Zürich ...
12 Mar 22 Concordia Sub 17Concordia 2 - 1 Servette FC Sub 17Servette ...
12 Mar 22 BSC Young Boys Sub 17Young Boys 0 - 1 FC Vaduz Sub 17Vaduz ...
12 Mar 22 Fc Basel 1893 Sub 17Basel 1893 2 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
13 Mar 22 Rapperswil-Jona Sub 17Rapperswil- 5 - 3 Schaffhausen Sub 17Schaffhause ...
Jornada 16
26 Mar 22 FC Vaduz Sub 17Vaduz 2 - 1 Team Vaud Sub 17Team Vaud ...
26 Mar 22 Servette FC Sub 17Servette 1 - 3 BSC Young Boys Sub 17Young Boys ...
26 Mar 22 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 1 Concordia Sub 17Concordia ...
26 Mar 22 FC Zürich Sub 17Zürich 2 - 4 Fc Basel 1893 Sub 17Basel 1893 ...
26 Mar 22 Schaffhausen Sub 17Schaffhause 2 - 2 Luzern Sub 17Luzern ...
26 Mar 22 Südostschweiz Sub 17Südostschw 2 - 5 Rapperswil-Jona Sub 17Rapperswil- ...
Jornada 17
02 Abr 22 Luzern Sub 17Luzern 2 - 3 Südostschweiz Sub 17Südostschw ...
02 Abr 22 Concordia Sub 17Concordia 0 - 2 FC Zürich Sub 17Zürich ...
02 Abr 22 BSC Young Boys Sub 17Young Boys 2 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
27 Abr 22 Team Vaud Sub 17Team Vaud 1 - 0 Servette FC Sub 17Servette ...
02 Abr 22 Fc Basel 1893 Sub 17Basel 1893 4 - 0 Schaffhausen Sub 17Schaffhause ...
04 Jun 22 AFF FFV Fribourg Sub 17Fribourg 3 - 3 Rapperswil-Jona Sub 17Rapperswil- ...
Jornada 18
10 Abr 22 Schaffhausen Sub 17Schaffhause 5 - 1 Concordia Sub 17Concordia ...
09 Abr 22 Südostschweiz Sub 17Südostschw 0 - 8 Fc Basel 1893 Sub 17Basel 1893 ...
10 Abr 22 AFF FFV Fribourg Sub 17Fribourg 3 - 2 Luzern Sub 17Luzern ...
09 Abr 22 FC Zürich Sub 17Zürich 2 - 3 BSC Young Boys Sub 17Young Boys ...
09 Abr 22 FC St. Gallen 1879 Sub 17Gallen 1879 4 - 3 Team Vaud Sub 17Team Vaud ...
10 Abr 22 Servette FC Sub 17Servette 3 - 2 FC Vaduz Sub 17Vaduz ...
Jornada 19
23 Abr 22 Concordia Sub 17Concordia 7 - 1 Südostschweiz Sub 17Südostschw ...
23 Abr 22 Luzern Sub 17Luzern 1 - 1 Rapperswil-Jona Sub 17Rapperswil- ...
23 Abr 22 BSC Young Boys Sub 17Young Boys 6 - 0 Schaffhausen Sub 17Schaffhause ...
23 Abr 22 Team Vaud Sub 17Team Vaud 5 - 1 FC Zürich Sub 17Zürich ...
23 Abr 22 FC Vaduz Sub 17Vaduz 2 - 2 FC St. Gallen 1879 Sub 17Gallen 1879 ...
24 Abr 22 Fc Basel 1893 Sub 17Basel 1893 1 - 1 AFF FFV Fribourg Sub 17Fribourg ...
Jornada 20
30 Abr 22 AFF FFV Fribourg Sub 17Fribourg 3 - 3 Concordia Sub 17Concordia ...
30 Abr 22 Südostschweiz Sub 17Südostschw 2 - 2 BSC Young Boys Sub 17Young Boys ...
30 Abr 22 Schaffhausen Sub 17Schaffhause 2 - 4 Team Vaud Sub 17Team Vaud ...
30 Abr 22 FC Zürich Sub 17Zürich 1 - 1 FC Vaduz Sub 17Vaduz ...
30 Abr 22 FC St. Gallen 1879 Sub 17Gallen 1879 0 - 2 Servette FC Sub 17Servette ...
01 May 22 Rapperswil-Jona Sub 17Rapperswil- 3 - 1 Fc Basel 1893 Sub 17Basel 1893 ...
Jornada 21
07 May 22 Servette FC Sub 17Servette 3 - 2 FC Zürich Sub 17Zürich ...
07 May 22 FC Vaduz Sub 17Vaduz 0 - 4 Schaffhausen Sub 17Schaffhause ...
07 May 22 Team Vaud Sub 17Team Vaud 3 - 0 Südostschweiz Sub 17Südostschw ...
07 May 22 BSC Young Boys Sub 17Young Boys 2 - 2 AFF FFV Fribourg Sub 17Fribourg ...
07 May 22 Concordia Sub 17Concordia 1 - 2 Rapperswil-Jona Sub 17Rapperswil- ...
07 May 22 Fc Basel 1893 Sub 17Basel 1893 5 - 0 Luzern Sub 17Luzern ...
Jornada 22
14 May 22 Luzern Sub 17Luzern 3 - 6 Concordia Sub 17Concordia ...
14 May 22 AFF FFV Fribourg Sub 17Fribourg 3 - 0 Team Vaud Sub 17Team Vaud ...
14 May 22 Südostschweiz Sub 17Südostschw 3 - 7 FC Vaduz Sub 17Vaduz ...
15 May 22 Schaffhausen Sub 17Schaffhause 3 - 2 Servette FC Sub 17Servette ...
14 May 22 FC Zürich Sub 17Zürich 4 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
15 May 22 Rapperswil-Jona Sub 17Rapperswil- 4 - 2 BSC Young Boys Sub 17Young Boys ...
Jornada 23
21 May 22 Concordia Sub 17Concordia 1 - 3 Fc Basel 1893 Sub 17Basel 1893 ...
21 May 22 BSC Young Boys Sub 17Young Boys 2 - 0 Luzern Sub 17Luzern ...
21 May 22 Team Vaud Sub 17Team Vaud 1 - 4 Rapperswil-Jona Sub 17Rapperswil- ...
21 May 22 FC Vaduz Sub 17Vaduz 3 - 3 AFF FFV Fribourg Sub 17Fribourg ...
21 May 22 Servette FC Sub 17Servette 5 - 1 Südostschweiz Sub 17Südostschw ...
21 May 22 FC St. Gallen 1879 Sub 17Gallen 1879 4 - 0 Schaffhausen Sub 17Schaffhause ...
Jornada 24
29 May 22 Schaffhausen Sub 17Schaffhause 5 - 1 FC Zürich Sub 17Zürich ...
04 Jun 22 Südostschweiz Sub 17Südostschw 2 - 3 FC St. Gallen 1879 Sub 17Gallen 1879 ...
28 May 22 AFF FFV Fribourg Sub 17Fribourg 3 - 2 Servette FC Sub 17Servette ...
28 May 22 Luzern Sub 17Luzern 1 - 3 Team Vaud Sub 17Team Vaud ...
28 May 22 BSC Young Boys Sub 17Young Boys 1 - 2 Fc Basel 1893 Sub 17Basel 1893 ...
29 May 22 Rapperswil-Jona Sub 17Rapperswil- 3 - 2 FC Vaduz Sub 17Vaduz ...
Jornada 25
11 Jun 22 BSC Young Boys Sub 17Young Boys 1 - 4 Concordia Sub 17Concordia ...
11 Jun 22 Team Vaud Sub 17Team Vaud 3 - 1 Fc Basel 1893 Sub 17Basel 1893 ...
11 Jun 22 FC Vaduz Sub 17Vaduz 4 - 1 Luzern Sub 17Luzern ...
11 Jun 22 Servette FC Sub 17Servette 1 - 2 Rapperswil-Jona Sub 17Rapperswil- ...
11 Jun 22 FC St. Gallen 1879 Sub 17Gallen 1879 1 - 2 AFF FFV Fribourg Sub 17Fribourg ...
11 Jun 22 FC Zürich Sub 17Zürich 1 - 0 Südostschweiz Sub 17Südostschw ...
Jornada 26
18 Jun 22 AFF FFV Fribourg Sub 17Fribourg 3 - 2 FC Zürich Sub 17Zürich ...
18 Jun 22 Südostschweiz Sub 17Südostschw 0 - 1 Schaffhausen Sub 17Schaffhause ...
18 Jun 22 Luzern Sub 17Luzern 2 - 2 Servette FC Sub 17Servette ...
18 Jun 22 Concordia Sub 17Concordia 6 - 2 Team Vaud Sub 17Team Vaud ...
18 Jun 22 Fc Basel 1893 Sub 17Basel 1893 6 - 2 FC Vaduz Sub 17Vaduz ...
18 Jun 22 Rapperswil-Jona Sub 17Rapperswil- 4 - 4 FC St. Gallen 1879 Sub 17Gallen 1879 ...
Clasificación
Equipo PJ GF GC Puntos
1 Fc Basel 1893 Sub 17 Basel 1893 24 73 27 55
2 Rapperswil-Jona Sub 17 Rapperswil-J 24 71 44 52
3 AFF FFV Fribourg Sub 17 Fribourg 24 62 38 48
4 FC St. Gallen 1879 Sub 17 Gallen 1879 24 68 54 39
5 Concordia Sub 17 Concordia 24 67 54 35
6 BSC Young Boys Sub 17 Young Boys 24 52 43 35
7 FC Vaduz Sub 17 Vaduz 24 52 58 32
8 Team Vaud Sub 17 Team Vaud 24 48 58 29
9 Servette FC Sub 17 Servette 24 46 57 25
10 Luzern Sub 17 Luzern 24 40 60 25
11 Schaffhausen Sub 17 Schaffhausen 24 44 74 23
12 FC Zürich Sub 17 Zürich 24 43 55 21
13 Südostschweiz Sub 17 Südostschwe 24 40 84 16
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,997,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3300
Total Execution Time  0.3319
  CADENA URL  
/liga_suiza_sub172022/grupo1/calendario
  GET DATOS  
$_GET['/liga_suiza_sub172022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0105  SELECT type FROM routes WHERE alias = 'liga_suiza_sub172022'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_sub17' 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.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2116 AND type_rel = 3
0.0105  SELECT id,name,alias,stepParent FROM categories WHERE parentId=2116 ORDER BY order_id ASC
0.0105  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 2116 GROUP BY l.categoryId
0.0105  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=2116 GROUP BY l.year ORDER BY l.year DESC
0.0106  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 = 63918 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0114  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 = 63918 ORDER BY round ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 06:18:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 06:18:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 06:18:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 06:18:05' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_suiza_sub17' 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.0192  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 = 63918 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63918 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.0193  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 = 63918 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63918 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0114  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 = 63918 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63918 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0115  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 = 63918 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC