Transfery 2020
Rozgrywki
2020/2021
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-18, makr.,
ŚLJS;
okr.:
1,
2,
3,
4.
Junior młodszy:
CLJ U-17 wiosna, (bar.);
CLJ U-17, ŚLJM;
okr.: 1,
2.
Trampkarz starszy:
CLJ U-15 wiosna, (bar.);
CLJ U-15, ŚLTS;
okr.: 1,
2,
3,
4.
Trampkarz młodszy:
I ŚLTM, II ŚLTM;
okr.: 1,
2,
3,
4.
Młodzik starszy:
I ŚLMS, II ŚLMS;
okr.: 1,
2,
3,
4.
Młodzik młodszy:
ŚLMM;
okr.: 1,
2,
3,
4,
5,
6.
Kobiety:
Ekstraliga,
I liga,
II liga wsch., ( zach.),
III liga,
IV liga.
2019/2020
Ekstraklasa
I liga
II liga
III liga ( bar.)
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
Okręgowy Puchar Polski
Junior starszy:
CLJ U-18, makr. ( bar.),
ŚLJS 1, 2, wiosna;
okr.: 1, 2.
Junior młodszy:
CLJ U-17, wiosna;
ŚLJM, wiosna;
okr.: 1,
2,
3,
4,
5.
okr.: A,
B,
C,
D.
Trampkarz starszy:
CLJ U-15, wiosna;
ŚLTS;
okr.: 1,
2.
Trampkarz młodszy:
ŚLTM;
okr.: 1,
2,
3,
4.
Młodzik starszy:
ŚLMS;
okr.: 1,
2,
3,
4,
5,
6,
7,
8.
Młodzik młodszy:
ŚLMM;
okr.: 1,
2,
3,
4,
5.
Kobiety
I liga płd., płn.
II liga
III liga
Puchar Polski
Puchar okręgowy
CLJ U-15, Mł. Liga Jun. Mł.
|
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 'A' at line 1 SELECT * FROM competitions WHERE CompID = klasa A
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/db.inc on line 32
, / 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 = AND AgeCategory = AND Type = '' ORDER BY Season DESC, `Group`' at line 1 SELECT * FROM competitions WHERE (Region IS NULL OR REGION = "") AND Level = AND Season = AND AgeCategory = AND Type = '' ORDER BY Season DESC, `Group`
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/competition.inc on line 255
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 Type = '' ORDER BY Season DESC' at line 1 SELECT * FROM competitions WHERE (Region IS NULL OR REGION = "") AND ((Level = 0 AND Season < 2008) OR (Level = 1 AND Season >= 2008)) AND (`Group` IS NULL OR `Group` = 1) AND AgeCategory = AND Type = '' ORDER BY Season DESC
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/competition.inc on line 236
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 'A AND ADDDATE(COALESCE(m.Date, r.Date), INTERVAL +1 DAY) > '2021-01-26 19:02:32'' at line 4 SELECT MIN(COALESCE(m.Date, r.Date)) AS Date
FROM matches m
INNER JOIN rounds r ON m.RoundID = r.RoundID
WHERE r.CompID = klasa A AND ADDDATE(COALESCE(m.Date, r.Date), INTERVAL +1 DAY) > '2021-01-26 19:02:32'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
Ostatnie spotkania |
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 'A AND COALESCE(m.Date, r.Date) < '2021-01-26 19:02:32'' at line 4 SELECT MAX(COALESCE(m.Date, r.Date)) AS Date
FROM matches m
INNER JOIN rounds r ON m.RoundID = r.RoundID
WHERE r.CompID = klasa A AND COALESCE(m.Date, r.Date) < '2021-01-26 19:02:32'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
|
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 'A' at line 1 SELECT COUNT(*) FROM rounds INNER JOIN matches USING (RoundID) WHERE CompID = klasa A
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
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 'A' at line 1 SELECT COUNT(*) FROM tablelineinfo WHERE CompID = klasa A
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
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 'A
UNION SELECT
c.CompId, cl.Type, c.Season, c.FullName
FROM
comp' at line 6
SELECT
c.CompId, cl.Type, c.Season, c.FullName
FROM
competitionlinks cl
INNER JOIN competitions c ON cl.CompIdB = c.CompID
WHERE cl.CompIdA = klasa A
UNION SELECT
c.CompId, cl.Type, c.Season, c.FullName
FROM
competitionlinks cl
INNER JOIN competitions c ON cl.CompIdA = c.CompID
WHERE cl.CompIdB = klasa A
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/competition.php on line 170
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 'A' at line 6
SELECT g.*, m.HTeamID, m.ATeamID, m.Date, c.FullName
FROM galleries g
INNER JOIN matches m USING (MatchID)
INNER JOIN rounds r USING (RoundID)
INNER JOIN competitions c USING (CompID)
WHERE c.CompID = klasa A
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/competition.php on line 204
Terminarz |
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 'A
GROUP BY t.TeamID) AS t
INNER JOIN names n ON n.NameID =' at line 7 SELECT t.TeamID, n.ValidFrom, n.Name, n.ShortName, n.Location
FROM
(SELECT t.TeamID, t.NameID
FROM teams t
INNER JOIN matches m ON m.HTeamID = t.TeamID OR m.ATeamID = t.TeamID
INNER JOIN rounds r ON r.RoundID = m.RoundID
WHERE r.CompID = klasa A
GROUP BY t.TeamID) AS t
INNER JOIN names n ON n.NameID = t.NameID
UNION DISTINCT
SELECT t.TeamID, n.ValidFrom, n.Name, n.ShortName, n.Location
FROM
teams t
INNER JOIN tablelineinfo i ON i.CompID = klasa A AND i.TeamID = t.TeamID
INNER JOIN names n ON n.NameID = t.NameID
WHERE i.CompID = klasa A
ORDER BY ValidFrom ASC
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/names.inc on line 37
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 'A GROUP BY r.RoundID ORDER BY r.Date, r.Number, p.Number' at line 4
SELECT r.*, p.ShortName
FROM rounds r
LEFT JOIN compphases p ON p.CompID = r.CompID AND r.Number BETWEEN p.StartingRound AND p.EndingRound
WHERE r.CompID = klasa A GROUP BY r.RoundID ORDER BY r.Date, r.Number, p.Number 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 'A
GROUP BY r.RoundID, m.MatchID
ORDER BY r.Date, r.Number, m.Date, m.Ma' at line 34 SELECT /* SMPL: klasa A, , , DumpFixture */
r.RoundID, r.Name as RoundName, cp.ShortName AS PhaseName, m.MatchID, m.HTeamID, m.ATeamID, COALESCE(m.Date, r.Date) AS Date,
COALESCE(m.HRes, lv.HRes) AS HRes, COALESCE(m.ARes, lv.ARes) AS ARes,
m.HFullTime, m.AFullTime, m.HHalfTime, m.AHalfTime,
lv.Phase, lv.Minute, lv.HReds, lv.AReds, lv.Source, lv.RefTime, lv.ExtID,
m.HHalfExtra, m.AHalfExtra, m.HFullExtra, m.AFullExtra, m.HPen, m.APen,
m.vo, m.Comments, m.InterruptedAt, mli.Info,
COALESCE(m.StadiumID, ht.DefaultStadium, hc.DefaultStadium) as StadiumID,
COALESCE(ht.DefaultStadium, hc.DefaultStadium) as DefaultStadium,
s.Name as StadiumName,
htci.Icon AS HomeIcon, atci.Icon AS AwayIcon,
1 AS InfoCount,
NOW() > m.Date AS Started,
c.CompID,
c.Level,
c.AgeCategory,
c.Region AS CompRegion,
COALESCE(c.MatchLength, 90) AS MatchLength,
m.RefereeComments,
ps.ExtranetID, ps.Url,
c.Type AS CompType
FROM rounds r
LEFT JOIN matches m ON r.RoundID = m.RoundID
LEFT JOIN teams ht ON m.HTeamID = ht.TeamID
LEFT JOIN clubs hc ON ht.ClubID = hc.ClubID
INNER JOIN competitions c ON r.CompID = c.CompID
LEFT JOIN compphases cp ON cp.CompID = r.CompID AND r.Number BETWEEN cp.StartingRound AND cp.EndingRound
LEFT JOIN matcheslive lv ON lv.MatchID = m.MatchID AND m.HRes IS NULL
LEFT JOIN matchliveinfo mli ON mli.MatchID = m.MatchID
LEFT JOIN teamcompinfo htci ON htci.TeamID = m.HTeamID AND htci.Season = c.Season
LEFT JOIN stadiums s ON s.StadiumID = COALESCE(m.StadiumID, ht.DefaultStadium, hc.DefaultStadium)
LEFT JOIN teamcompinfo atci ON atci.TeamID = m.ATeamID AND atci.Season = c.Season
LEFT JOIN __pzpnscan ps ON ps.MatchID = m.MatchID
WHERE r.CompID = klasa A
GROUP BY r.RoundID, m.MatchID
ORDER BY r.Date, r.Number, m.Date, m.MatchID
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/fixtures.inc on line 135
|
|