Transfery 2024
Rozgrywki
2023/2024
Ekstraklasa
I liga
II liga
III liga,
gr.: 1,
2,
3
IV liga
Klasa okręgowa
Klasa A, gr. I
Klasa A, gr. II
Klasa A, gr. III
Klasa B, gr. I
Klasa B, gr. II
Klasa B, gr. III
Puchar Polski
Okręgowy PP
Junior starszy:
CLJ U-19, ŚLJS, makro,
okr.:
1,
2,
3.
Junior młodszy:
CLJ U-17,
gr. B;
ŚLJM, ŚLJM U-16;
okr.:
1,
2,
3,
4.
Trampkarz starszy:
CLJ U-15,
gr.: A,
B,
C;
wiosna,
gr.: A,
B,
C.
ŚLTS,
(bar.),
okr.:
1,
2,
3,
4.
Trampkarz młodszy:
ŚLTM 1,
ŚLTM 2,
ŚLTM 3,
okr.:
1,
2,
3,
4.
Młodzik starszy:
ŚLMS1, ŚLM2 gr 1,
gr. 2,
okr.:
1,
2,
3,
4,
5,
6.
Młodzik młodszy:
ŚLMM 1,
ŚLMM 2,
okr.:
1,
2,
3,
4,
5,
6.
Kobiety:
Ekstraliga,
I liga,
II liga płd., ( płn.),
III liga,
IV liga,
CLJ U-18.
CLJ U-16.
Puchar Polski.
2022/2023
Ekstraklasa
I liga
II liga
III liga
IV liga
Klasa okręgowa
Klasa A, gr. I
Klasa A, gr. II
Klasa A, gr. III
Klasa B, gr. I
Klasa B, gr. II
Klasa B, gr. III
Puchar Polski
Okręgowy PP
Junior starszy:
CLJ U-19, makr.;
ŚLJS 1, wiosna,
ŚLJS 2, wiosna;
okr.:
1,
2,
3,
4.
Junior młodszy:
CLJ U-17, bar., fin.;
ŚLJM, ŚLJM U-16;
okr.:
1,
2,
3,
4.
Trampkarz starszy:
CLJ U-15 ( bar.),
wiosna, bar., fin.;
ŚLTS 1, wiosna,
ŚLTS 2, wiosna;
okr.:
1,
2,
3,
4,
5,
6.
Trampkarz młodszy:
ŚLTM 1, wiosna,
ŚLTM 2, wiosna;
okr.:
1,
2,
3,
4.
Młodzik starszy:
ŚLMS 1, wiosna,
ŚLMS 2, wiosna,
ŚLMS 3, wiosna;
okr.:
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12.
Młodzik młodszy:
ŚLMM 1, wiosna,
ŚLMM 2, wiosna;
okr.:
1,
2,
3,
4,
5,
6,
7,
8.
Kobiety:
Ekstraliga,
I liga,
II liga płd., ( płn.),
III liga,
IV liga,
CLJ U-17.
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.Season = 2014 AND e.Cancelled <> 1
GROUP BY p.PersonID, e.Type, c.Typ' at line 13
SELECT
p.PersonID, p.FirstName, p.LastName, COUNT(*) AS Num, e.Type AS EventType,
c.Type AS CompType, c.ShortName
FROM
mevents e
INNER JOIN people p USING (PersonID)
INNER JOIN teams t USING (TeamID)
INNER JOIN matches m USING (MatchID)
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
WHERE
p.PersonID IN (11008, 667, 1444, 3544, 16772, 296, 466, 5105, 2104, 2376, 118, 3086, 41, 2267, 119, 13804, 14089, 1178, 141, 95, 4341, 4710, 17422, 17322, 2647, 539, 11007, 2262, 1666, 1374, 4548, 5004, 4192) AND
t.ClubID = AND c.Season = 2014 AND e.Cancelled <> 1
GROUP BY p.PersonID, e.Type, c.Type, c.ShortName You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND c.Season = 2014 AND NOT (a.ViewNum > 11 AND a.SubApp IS NULL) AND NOT (m.HFu' at line 24
SELECT m.PersonID, m.CompType, m.ShortName, SUM(TimeTo - TimeFrom + 1) AS TimePld,
SUM(FirstSquad) AS FirstSquad, SUM(Bench) AS Bench, SUM(FullTime) AS FullTime
FROM (
SELECT
p.PersonID, --p.FirstName, p.LastName,
c.Type AS CompType, c.ShortName,
a.SubApp, CASE WHEN a.SubApp IS NULL THEN 1 ELSE COALESCE(a.SubTime, 66) END AS TimeFrom,
COALESCE(CASE WHEN sa.SubApp IS NULL THEN NULL ELSE COALESCE(sa.SubTime, 66)-1 END,
m.InterruptedAt, CASE WHEN m.HFullExtra IS NOT NULL THEN 120 ELSE COALESCE(c.MatchLength, 90) END) AS TimeTo,
a.SubApp IS NULL AS FirstSquad,
a.SubApp IS NOT NULL AS Bench,
sa.MatchID IS NULL AND a.SubApp IS NULL AS FullTime
FROM
mapps a
INNER JOIN people p USING (PersonID)
INNER JOIN teams t USING (TeamID)
INNER JOIN matches m USING (MatchID)
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
LEFT JOIN mapps sa ON sa.SubApp = a.MAppID
LEFT JOIN mevents e ON e.MatchID = m.MatchID AND e.PersonID = p.PersonID AND e.Type IN ('R', 'S', 'T') AND e.Cancelled <> 1
WHERE
p.PersonID IN (11008, 667, 1444, 3544, 16772, 296, 466, 5105, 2104, 2376, 118, 3086, 41, 2267, 119, 13804, 14089, 1178, 141, 95, 4341, 4710, 17422, 17322, 2647, 539, 11007, 2262, 1666, 1374, 4548, 5004, 4192) AND
t.ClubID = AND c.Season = 2014 AND NOT (a.ViewNum > 11 AND a.SubApp IS NULL) AND NOT (m.HFullTime IS NULL AND m.vo > 0)
) AS m
GROUP BY m.PersonID, m.CompType, m.ShortName You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'THEN COALESCE(m.HFullExtra, m.HFullTime) ELSE COALESCE(m.AFullExtra, m.AFullTime' at line 4
SELECT m.Type, m.ShortName, SUM(m.Goals) AS Goals, SUM(m.GoalsKnown) AS Known
FROM
(SELECT m.MatchID,
CASE WHEN ht.ClubID = THEN COALESCE(m.HFullExtra, m.HFullTime) ELSE COALESCE(m.AFullExtra, m.AFullTime) END AS Goals,
m.Date, c.Type, c.ShortName, COUNT(e.EventID) AS GoalsKnown
FROM matches m
INNER JOIN teams ht ON m.HTeamID = ht.TeamID
INNER JOIN teams at ON m.ATeamID = at.TeamID
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
LEFT JOIN mevents e ON e.MatchID = m.MatchID AND (e.PersonID > 0 OR e.Type = 'O') AND (e.Type IN ('G', 'P', 'O'))
AND ((ht.TeamID = e.TeamID AND ht.ClubID = ) OR (at.TeamID = e.TeamID AND at.ClubID = )) AND e.Cancelled <> 1
WHERE
(ht.ClubID = OR at.ClubID = ) AND Season = 2014 AND c.CompID > 0 AND c.AgeCategory = 0
GROUP BY m.MatchID
ORDER BY m.Date DESC) AS m
GROUP BY m.Type, m.ShortName You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') OR (at.TeamID = e.TeamID AND at.ClubID = )) AND e.Cancelled <> 1
WHE' at line 11
SELECT m.Type, m.ShortName, COUNT(m.MatchID) AS Cards, SUM(m.CardsKnown) AS Known
FROM
(SELECT m.MatchID,
m.Date, c.Type, c.ShortName, COUNT(e.EventID) > 0 AS CardsKnown
FROM matches m
INNER JOIN teams ht ON m.HTeamID = ht.TeamID
INNER JOIN teams at ON m.ATeamID = at.TeamID
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
LEFT JOIN mevents e ON e.MatchID = m.MatchID AND (e.PersonID > 0 OR e.Type = 'O') AND (e.Type IN ('Y', 'R', 'S', 'T'))
AND ((ht.TeamID = e.TeamID AND ht.ClubID = ) OR (at.TeamID = e.TeamID AND at.ClubID = )) AND e.Cancelled <> 1
WHERE
(ht.ClubID = OR at.ClubID = ) AND Season = 2014 AND c.CompID > 0 AND c.AgeCategory = 0 AND (HFullTime IS NOT NULL OR HFulLExtra IS NOT NULL)
GROUP BY m.MatchID
ORDER BY m.Date DESC) AS m
GROUP BY m.Type, m.ShortName You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Season = 2014 AND c.CompID > 0 AND c.AgeCategory = 0 AND (HFullTime IS NOT N' at line 14
SELECT m.Type, m.ShortName, COUNT(MatchID) AS Num, SUM(Squad) AS Squad, SUM(Timing) AS Timing
FROM
(SELECT
m.MatchID, COUNT(a.MAppID) > 8 AS Squad, CASE WHEN COUNT(a.MAppID) > 8 THEN 1-(COUNT(sa.MAppID)-COUNT(sa.SubTime))/ COUNT(a.MAppID)/2 ELSE 0 END AS Timing,
c.Type AS Type, c.ShortName
FROM
matches m
INNER JOIN teams t ON t.TeamID = m.HTeamID OR t.TeamID = m.ATeamID
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
LEFT JOIN mapps a USING (MatchID, TeamID)
LEFT JOIN mapps sa ON sa.SubApp = a.MAppID
WHERE
t.ClubID = AND Season = 2014 AND c.CompID > 0 AND c.AgeCategory = 0 AND (HFullTime IS NOT NULL OR HFulLExtra IS NOT NULL)
GROUP BY MatchID) AS m
GROUP BY m.Type, m.ShortName
Kompletność informacji dotyczących strzelców: /.
Kompletność informacji dotyczących kartek: –%.
Kompletność informacji dotyczących występów: –%.
Kompletność informacji dotyczących czasu gry: –%.
Legenda:
bramki ( w tym z karnych)
bezpośrednie czerwone kartki + za dwie żółte
żółte kartki
mecze w pierwszym składzie/ pełne mecze/wejścia z ławki
czas na boisku (min.)
|