4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Jornada 1
14 Ago 21 SSGCSSGC 0 - 1 WAPDAWAPDA ...
14 Ago 21 Pakistan ArmyPakistan 0 - 1 Pakistan Air ForcePakistan ...
15 Ago 21 KRLKRL 1 - 1 PCAAPCAA ...
16 Ago 21 Pakistan NavyPakistan 0 - 1 Muslim FCMuslim FC ...
16 Ago 21 SNGPLSNGPL 2 - 3 Lyallpur FCLyallpur ...
17 Ago 21 Khi UnitedKhi United 4 - 2 Humma FCHumma FC 2
20 Ago 21 WAPDAWAPDA 2 - 1 Pakistan Air ForcePakistan 1
20 Ago 21 SSGCSSGC 0 - 1 PCAAPCAA ...
21 Ago 21 Pakistan ArmyPakistan 6 - 0 Humma FCHumma FC ...
21 Ago 21 KRLKRL 0 - 0 Lyallpur FCLyallpur ...
03 Sep 21 Pakistan ArmyPakistan 0 - 1 Muslim FCMuslim FC ...
05 Sep 21 Humma FCHumma FC 2 - 6 SSGCSSGC ...
05 Sep 21 PCAAPCAA 1 - 3 Pakistan Air ForcePakistan ...
06 Sep 21 Muslim FCMuslim FC 0 - 8 KRLKRL ...
06 Sep 21 Lyallpur FCLyallpur 2 - 1 Pakistan ArmyPakistan ...
07 Sep 21 Pakistan NavyPakistan 2 - 4 Khi UnitedKhi United ...
07 Sep 21 SNGPLSNGPL 1 - 2 WAPDAWAPDA ...
08 Sep 21 PCAAPCAA 0 - 0 Lyallpur FCLyallpur ...
09 Sep 21 Pakistan Air ForcePakistan 0 - 1 Muslim FCMuslim FC ...
10 Sep 21 SSGCSSGC 5 - 2 Pakistan NavyPakistan ...
Jornada 2
22 Ago 21 Khi UnitedKhi United 2 - 3 Muslim FCMuslim FC ...
23 Ago 21 SNGPLSNGPL 1 - 0 Pakistan NavyPakistan 2
23 Ago 21 Pakistan Air ForcePakistan 2 - 1 SSGCSSGC 1
24 Ago 21 Humma FCHumma FC 0 - 2 KRLKRL ...
25 Ago 21 PCAAPCAA 0 - 3 Pakistan ArmyPakistan ...
26 Ago 21 Pakistan NavyPakistan 0 - 2 WAPDAWAPDA ...
27 Ago 21 Lyallpur FCLyallpur 1 - 0 Khi UnitedKhi United ...
27 Ago 21 KRLKRL 1 - 1 SNGPLSNGPL ...
28 Ago 21 SSGCSSGC 2 - 1 Muslim FCMuslim FC ...
29 Ago 21 PCAAPCAA 2 - 1 Humma FCHumma FC ...
10 Sep 21 KRLKRL 6 - 0 Khi UnitedKhi United ...
11 Sep 21 Pakistan ArmyPakistan 3 - 1 SNGPLSNGPL ...
14 Oct 21 Pakistan Air ForcePakistan 2 - 2 KRLKRL ...
16 Oct 21 Humma FCHumma FC Apl SNGPLSNGPL ...
16 Oct 21 PCAAPCAA 0 - 1 Khi UnitedKhi United ...
17 Oct 21 WAPDAWAPDA 3 - 0 Muslim FCMuslim FC ...
17 Oct 21 SSGCSSGC 0 - 0 Pakistan ArmyPakistan ...
19 Oct 21 Khi UnitedKhi United 0 - 3 Pakistan Air ForcePakistan ...
19 Oct 21 Pakistan NavyPakistan 4 - 3 Humma FCHumma FC ...
Jornada 3
29 Ago 21 PCAAPCAA 2 - 1 Humma FCHumma FC ...
29 Ago 21 Pakistan Air ForcePakistan 1 - 1 Lyallpur FCLyallpur ...
30 Ago 21 WAPDAWAPDA 5 - 1 Khi UnitedKhi United ...
01 Sep 21 SSGCSSGC 1 - 0 Lyallpur FCLyallpur 5
01 Sep 21 Pakistan Air ForcePakistan 2 - 1 Humma FCHumma FC ...
02 Sep 21 Khi UnitedKhi United 0 - 2 SNGPLSNGPL 2
03 Sep 21 KRLKRL 5 - 2 Pakistan NavyPakistan ...
03 Sep 21 Pakistan ArmyPakistan 0 - 1 Muslim FCMuslim FC ...
02 Sep 21 WAPDAWAPDA 1 - 2 PCAAPCAA 1
20 Oct 21 Muslim FCMuslim FC 4 - 3 Lyallpur FCLyallpur ...
20 Oct 21 SNGPLSNGPL Apl PCAAPCAA ...
21 Oct 21 KRLKRL 0 - 3 SSGCSSGC ...
21 Oct 21 Pakistan ArmyPakistan 1 - 1 WAPDAWAPDA ...
22 Oct 21 PCAAPCAA 0 - 2 Pakistan NavyPakistan ...
23 Oct 21 Humma FCHumma FC 5 - 0 Muslim FCMuslim FC ...
23 Oct 21 Pakistan Air ForcePakistan Apl SNGPLSNGPL ...
26 Oct 21 Muslim FCMuslim FC 1 - 2 PCAAPCAA ...
26 Oct 21 Pakistan NavyPakistan 0 - 3 Pakistan Air ForcePakistan ...
27 Oct 21 Lyallpur FCLyallpur 1 - 0 Humma FCHumma FC ...
Jornada 4
05 Sep 21 Humma FCHumma FC 2 - 6 SSGCSSGC ...
06 Sep 21 Muslim FCMuslim FC 0 - 8 KRLKRL 3
06 Sep 21 Lyallpur FCLyallpur 2 - 1 Pakistan ArmyPakistan ...
07 Sep 21 Pakistan NavyPakistan 2 - 4 Khi UnitedKhi United ...
07 Sep 21 SNGPLSNGPL 1 - 2 WAPDAWAPDA ...
05 Sep 21 PCAAPCAA 1 - 3 Pakistan Air ForcePakistan ...
10 Sep 21 KRLKRL 6 - 0 Khi UnitedKhi United ...
11 Sep 21 Pakistan ArmyPakistan 3 - 1 SNGPLSNGPL ...
09 Sep 21 Pakistan Air ForcePakistan 0 - 1 Muslim FCMuslim FC ...
08 Sep 21 PCAAPCAA 0 - 0 Lyallpur FCLyallpur ...
14 Oct 21 Pakistan Air ForcePakistan 2 - 2 KRLKRL ...
27 Oct 21 SNGPLSNGPL Apl SSGCSSGC ...
28 Oct 21 Khi UnitedKhi United 0 - 1 Pakistan ArmyPakistan ...
28 Oct 21 KRLKRL 0 - 0 WAPDAWAPDA ...
29 Oct 21 Pakistan NavyPakistan 1 - 1 Lyallpur FCLyallpur ...
31 Oct 21 Khi UnitedKhi United 0 - 0 PCAAPCAA ...
31 Oct 21 Muslim FCMuslim FC 1 - 1 WAPDAWAPDA ...
01 Nov 21 Humma FCHumma FC 0 - 5 Pakistan Air ForcePakistan ...
01 Nov 21 Pakistan NavyPakistan 1 - 1 KRLKRL ...
02 Nov 21 Pakistan ArmyPakistan 0 - 0 SSGCSSGC ...
02 Nov 21 Lyallpur FCLyallpur Apl SNGPLSNGPL ...
Jornada 5
08 Sep 21 PCAAPCAA 0 - 0 Lyallpur FCLyallpur 2
14 Oct 21 Pakistan Air ForcePakistan 2 - 2 KRLKRL 7
16 Oct 21 PCAAPCAA 0 - 1 Khi UnitedKhi United ...
17 Oct 21 SSGCSSGC 0 - 0 Pakistan ArmyPakistan ...
16 Oct 21 Humma FCHumma FC Apl SNGPLSNGPL ...
17 Oct 21 WAPDAWAPDA 3 - 0 Muslim FCMuslim FC ...
19 Oct 21 Pakistan NavyPakistan 4 - 3 Humma FCHumma FC ...
19 Oct 21 Khi UnitedKhi United 0 - 3 Pakistan Air ForcePakistan ...
20 Oct 21 Muslim FCMuslim FC 4 - 3 Lyallpur FCLyallpur ...
20 Oct 21 SNGPLSNGPL Apl PCAAPCAA ...
21 Oct 21 KRLKRL 0 - 3 SSGCSSGC 3
21 Oct 21 Pakistan ArmyPakistan 1 - 1 WAPDAWAPDA ...
03 Nov 21 PCAAPCAA 1 - 0 Muslim FCMuslim FC ...
03 Nov 21 WAPDAWAPDA 2 - 0 Pakistan NavyPakistan ...
04 Nov 21 Humma FCHumma FC 0 - 1 Khi UnitedKhi United ...
05 Nov 21 SNGPLSNGPL Apl Pakistan Air ForcePakistan ...
05 Nov 21 Lyallpur FCLyallpur 1 - 0 PCAAPCAA ...
06 Nov 21 Pakistan ArmyPakistan 1 - 1 KRLKRL ...
06 Nov 21 Muslim FCMuslim FC 2 - 1 Pakistan NavyPakistan ...
07 Nov 21 Humma FCHumma FC 0 - 2 Lyallpur FCLyallpur ...
07 Nov 21 SSGCSSGC 1 - 0 Khi UnitedKhi United ...
09 Nov 21 Lyallpur FCLyallpur 0 - 0 Muslim FCMuslim FC ...
Jornada 6
21 Oct 21 Pakistan ArmyPakistan 1 - 1 WAPDAWAPDA ...
22 Oct 21 PCAAPCAA 0 - 2 Pakistan NavyPakistan ...
23 Oct 21 Pakistan Air ForcePakistan Apl SNGPLSNGPL ...
23 Oct 21 Humma FCHumma FC 5 - 0 Muslim FCMuslim FC ...
06 Nov 21 Pakistan ArmyPakistan 1 - 1 KRLKRL 1
26 Oct 21 Muslim FCMuslim FC 1 - 2 PCAAPCAA ...
26 Oct 21 Pakistan NavyPakistan 0 - 3 Pakistan Air ForcePakistan ...
27 Oct 21 Lyallpur FCLyallpur 1 - 0 Humma FCHumma FC 3
27 Oct 21 SNGPLSNGPL Apl SSGCSSGC ...
28 Oct 21 Khi UnitedKhi United 0 - 1 Pakistan ArmyPakistan ...
28 Oct 21 KRLKRL 0 - 0 WAPDAWAPDA ...
29 Oct 21 Pakistan NavyPakistan 1 - 1 Lyallpur FCLyallpur ...
09 Nov 21 SSGCSSGC 8 - 0 Humma FCHumma FC ...
10 Nov 21 PCAAPCAA Apl SNGPLSNGPL ...
12 Nov 21 KRLKRL Apl Muslim FCMuslim FC ...
12 Nov 21 Pakistan NavyPakistan Apl PCAAPCAA ...
13 Nov 21 Pakistan Air ForcePakistan Apl Khi UnitedKhi United ...
13 Nov 21 WAPDAWAPDA Apl Humma FCHumma FC ...
14 Nov 21 SSGCSSGC Apl SNGPLSNGPL ...
14 Nov 21 Muslim FCMuslim FC Apl SSGCSSGC ...
14 Nov 21 Lyallpur FCLyallpur Apl Pakistan NavyPakistan ...
15 Nov 21 KRLKRL Apl Humma FCHumma FC ...
Jornada 7
27 Oct 21 SNGPLSNGPL Apl SSGCSSGC ...
28 Oct 21 KRLKRL 0 - 0 WAPDAWAPDA 5
28 Oct 21 Khi UnitedKhi United 0 - 1 Pakistan ArmyPakistan ...
29 Oct 21 Pakistan NavyPakistan 1 - 1 Lyallpur FCLyallpur ...
31 Oct 21 Khi UnitedKhi United 0 - 0 PCAAPCAA ...
31 Oct 21 Muslim FCMuslim FC 1 - 1 WAPDAWAPDA ...
02 Nov 21 Pakistan ArmyPakistan 0 - 0 SSGCSSGC ...
01 Nov 21 Humma FCHumma FC 0 - 5 Pakistan Air ForcePakistan ...
01 Nov 21 Pakistan NavyPakistan 1 - 1 KRLKRL ...
02 Nov 21 Lyallpur FCLyallpur Apl SNGPLSNGPL ...
03 Nov 21 PCAAPCAA 1 - 0 Muslim FCMuslim FC ...
03 Nov 21 WAPDAWAPDA 2 - 0 Pakistan NavyPakistan ...
04 Nov 21 Humma FCHumma FC 0 - 1 Khi UnitedKhi United ...
05 Nov 21 SNGPLSNGPL Apl Pakistan Air ForcePakistan ...
15 Nov 21 PCAAPCAA Apl WAPDAWAPDA ...
16 Nov 21 Muslim FCMuslim FC Apl Pakistan Air ForcePakistan ...
16 Nov 21 Pakistan NavyPakistan Apl SSGCSSGC ...
17 Nov 21 Humma FCHumma FC Apl Pakistan ArmyPakistan ...
17 Nov 21 Khi UnitedKhi United Apl KRLKRL ...
18 Nov 21 WAPDAWAPDA Apl Lyallpur FCLyallpur ...
19 Nov 21 Muslim FCMuslim FC Apl SNGPLSNGPL ...
19 Nov 21 Pakistan Air ForcePakistan Apl Pakistan NavyPakistan ...
20 Nov 21 Khi UnitedKhi United Apl SSGCSSGC ...
20 Nov 21 KRLKRL Apl Pakistan ArmyPakistan ...
Jornada 8
03 Nov 21 PCAAPCAA 1 - 0 Muslim FCMuslim FC ...
04 Nov 21 Humma FCHumma FC 0 - 1 Khi UnitedKhi United ...
05 Nov 21 Lyallpur FCLyallpur 1 - 0 PCAAPCAA ...
05 Nov 21 SNGPLSNGPL Apl Pakistan Air ForcePakistan 11
06 Nov 21 Muslim FCMuslim FC 2 - 1 Pakistan NavyPakistan ...
10 Nov 21 PCAAPCAA Apl SNGPLSNGPL ...
09 Nov 21 Lyallpur FCLyallpur 0 - 0 Muslim FCMuslim FC ...
03 Nov 21 WAPDAWAPDA 2 - 0 Pakistan NavyPakistan ...
09 Nov 21 SSGCSSGC 8 - 0 Humma FCHumma FC ...
06 Nov 21 Pakistan ArmyPakistan 1 - 1 KRLKRL ...
07 Nov 21 Humma FCHumma FC 0 - 2 Lyallpur FCLyallpur ...
07 Nov 21 SSGCSSGC 1 - 0 Khi UnitedKhi United ...
12 Nov 21 KRLKRL Apl Muslim FCMuslim FC ...
12 Nov 21 Pakistan NavyPakistan Apl PCAAPCAA ...
21 Nov 21 Lyallpur FCLyallpur Apl WAPDAWAPDA ...
22 Nov 21 SNGPLSNGPL Apl Pakistan ArmyPakistan ...
23 Nov 21 Lyallpur FCLyallpur Apl Pakistan Air ForcePakistan ...
24 Nov 21 WAPDAWAPDA Apl KRLKRL ...
24 Nov 21 Pakistan ArmyPakistan Apl Pakistan NavyPakistan ...
26 Nov 21 Humma FCHumma FC Apl WAPDAWAPDA ...
26 Nov 21 Pakistan ArmyPakistan Apl Khi UnitedKhi United ...
27 Nov 21 SNGPLSNGPL Apl KRLKRL ...
28 Nov 21 Pakistan NavyPakistan Apl Pakistan ArmyPakistan ...
29 Nov 21 Khi UnitedKhi United Apl WAPDAWAPDA ...
Jornada 9
13 Nov 21 WAPDAWAPDA Apl Humma FCHumma FC ...
14 Nov 21 Lyallpur FCLyallpur Apl Pakistan NavyPakistan ...
07 Nov 21 SSGCSSGC Apl Khi UnitedKhi United ...
13 Nov 21 Pakistan Air ForcePakistan Apl Khi UnitedKhi United ...
12 Nov 21 Pakistan NavyPakistan Apl PCAAPCAA ...
15 Nov 21 KRLKRL Apl Humma FCHumma FC ...
12 Nov 21 KRLKRL Apl Muslim FCMuslim FC ...
15 Nov 21 PCAAPCAA Apl WAPDAWAPDA ...
14 Nov 21 Muslim FCMuslim FC Apl SSGCSSGC ...
14 Nov 21 SSGCSSGC Apl SNGPLSNGPL ...
16 Nov 21 Muslim FCMuslim FC Apl Pakistan Air ForcePakistan ...
16 Nov 21 Pakistan NavyPakistan Apl SSGCSSGC ...
17 Nov 21 Humma FCHumma FC Apl Pakistan ArmyPakistan ...
15 Dic 21 KRLKRL Apl Pakistan Air ForcePakistan ...
16 Dic 21 Lyallpur FCLyallpur Apl SSGCSSGC ...
17 Dic 21 Muslim FCMuslim FC Apl Pakistan ArmyPakistan ...
18 Dic 21 SNGPLSNGPL Apl Khi UnitedKhi United ...
19 Dic 21 WAPDAWAPDA Apl SNGPLSNGPL ...
19 Dic 21 Khi UnitedKhi United Apl Pakistan NavyPakistan ...
20 Dic 21 PCAAPCAA Apl KRLKRL ...
20 Dic 21 Pakistan Air ForcePakistan Apl Pakistan ArmyPakistan ...
21 Dic 21 Pakistan ArmyPakistan Apl Lyallpur FCLyallpur ...
22 Dic 21 Pakistan Air ForcePakistan Apl PCAAPCAA ...
Jornada 10
19 Nov 21 Muslim FCMuslim FC Apl SNGPLSNGPL ...
24 Nov 21 Pakistan ArmyPakistan Apl Pakistan NavyPakistan 12
18 Nov 21 WAPDAWAPDA Apl Lyallpur FCLyallpur ...
25 Dic 21 SNGPLSNGPL Apl Humma FCHumma FC ...
15 Dic 21 KRLKRL Apl Pakistan Air ForcePakistan ...
25 Dic 21 SSGCSSGC Apl KRLKRL ...
28 Dic 21 Humma FCHumma FC Apl Pakistan NavyPakistan ...
24 Nov 21 WAPDAWAPDA Apl KRLKRL ...
26 Nov 21 Pakistan ArmyPakistan Apl Khi UnitedKhi United ...
19 Nov 21 Pakistan Air ForcePakistan Apl Pakistan NavyPakistan ...
20 Nov 21 Khi UnitedKhi United Apl SSGCSSGC ...
20 Nov 21 KRLKRL Apl Pakistan ArmyPakistan ...
21 Nov 21 Lyallpur FCLyallpur Apl WAPDAWAPDA ...
17 Nov 21 Khi UnitedKhi United Apl KRLKRL ...
22 Nov 21 SNGPLSNGPL Apl Pakistan ArmyPakistan ...
23 Nov 21 Lyallpur FCLyallpur Apl Pakistan Air ForcePakistan ...
23 Dic 21 WAPDAWAPDA Apl SSGCSSGC ...
23 Dic 21 Pakistan NavyPakistan Apl SNGPLSNGPL ...
24 Dic 21 Pakistan Air ForcePakistan Apl WAPDAWAPDA ...
24 Dic 21 Lyallpur FCLyallpur Apl KRLKRL ...
25 Dic 21 WAPDAWAPDA Apl Pakistan ArmyPakistan ...
25 Dic 21 Muslim FCMuslim FC Apl Humma FCHumma FC ...
25 Dic 21 Muslim FCMuslim FC Apl Khi UnitedKhi United ...
26 Dic 21 SNGPLSNGPL Apl Muslim FCMuslim FC ...
Jornada 11
24 Nov 21 Pakistan ArmyPakistan Apl Pakistan NavyPakistan ...
26 Nov 21 Humma FCHumma FC Apl WAPDAWAPDA ...
27 Dic 21 Khi UnitedKhi United Apl Lyallpur FCLyallpur ...
29 Dic 21 Humma FCHumma FC Apl PCAAPCAA ...
29 Dic 21 PCAAPCAA Apl SSGCSSGC ...
29 Dic 21 Pakistan ArmyPakistan Apl PCAAPCAA ...
30 Dic 21 SSGCSSGC Apl Pakistan Air ForcePakistan ...

JUGADORES DESTACADOS

Clasificación

Equipo PJ GF GC Puntos
1 WAPDA WAPDA 20 32 11 41
2 Lyallpur FC Lyallpur FC 23 26 17 40
3 SSGC SSGC 18 45 11 37
4 Pakistan Air Force Pakistan 18 41 15 37
5 Muslim FC Muslim FC 26 25 53 34
6 PCAA PCAA 24 17 23 33
7 KRL KRL 22 48 21 32
8 Pakistan Army Pakistan 22 26 15 31
9 Khi United Khi United 23 20 40 26
10 Pakistan Navy Pakistan 23 27 49 17
11 SNGPL SNGPL 8 10 14 7
12 Humma FC Humma FC 23 25 73 6

  USO DE MEMORIA  
6,269,536 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1250
Total Execution Time  0.1268
  CADENA URL  
/liga_pakistan2022/grupo1/calendario
  GET DATOS  
$_GET['/liga_pakistan2022/grupo1/calendario']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (16)  
0.0020  SELECT type FROM routes WHERE alias = 'liga_pakistan2022'
0.0043  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_pakistan' 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.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=334 AND type_rel = 3
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 334 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0023  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 (1121480,966106,866282,621886) ORDER BY n.cover_points DESC, update_date DESC
0.0021  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 = 63896 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0049  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 = 63896 ORDER BY round ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 12:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-24 12:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-24 12:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-24 12:51:23' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0025  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_pakistan' 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.0078  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 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.0020  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  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 = 63896 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 63896 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0030  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 = 63896 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC