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,
wios.,
(bar.);
ŚLJM;
okr.: 1,
2.
Trampkarz starszy:
CLJ U-15,
wios.,
(bar.);
Ś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ł.
|
Unknown column 'inne' in 'where clause' SELECT * FROM competitions WHERE CompID = inne
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
Unknown column 'inne' in 'where clause' SELECT MIN(COALESCE(m.Date, r.Date)) AS Date
FROM matches m
INNER JOIN rounds r ON m.RoundID = r.RoundID
WHERE r.CompID = inne AND ADDDATE(COALESCE(m.Date, r.Date), INTERVAL +1 DAY) > '2021-03-03 13:49:20'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
Ostatnie spotkania |
Unknown column 'inne' in 'where clause' SELECT MAX(COALESCE(m.Date, r.Date)) AS Date
FROM matches m
INNER JOIN rounds r ON m.RoundID = r.RoundID
WHERE r.CompID = inne AND COALESCE(m.Date, r.Date) < '2021-03-03 13:49:20'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
|
Unknown column 'inne' in 'where clause' SELECT COUNT(*) FROM rounds INNER JOIN matches USING (RoundID) WHERE CompID = inne
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
Unknown column 'inne' in 'where clause' SELECT COUNT(*) FROM tablelineinfo WHERE CompID = inne
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/db.inc on line 37
Unknown column 'inne' in 'where clause'
SELECT
c.CompId, cl.Type, c.Season, c.FullName
FROM
competitionlinks cl
INNER JOIN competitions c ON cl.CompIdB = c.CompID
WHERE cl.CompIdA = inne
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 = inne
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/competition.php on line 170
Unknown column 'inne' in 'where clause'
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 = inne
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/kielecka/www/engine/competition.php on line 204
Terminarz |
Unknown column 'inne' in 'where clause' 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 = inne
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 = inne AND i.TeamID = t.TeamID
INNER JOIN names n ON n.NameID = t.NameID
WHERE i.CompID = inne
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
Unknown column 'inne' in 'where clause'
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 = inne GROUP BY r.RoundID ORDER BY r.Date, r.Number, p.Number Unknown column 'inne' in 'where clause' SELECT /* SMPL: inne, , , 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 = inne
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
|
|