Kielecka Piłka - , /

Logowanie

Nie masz jeszcze konta?
Zarejestruj się

Nie możesz się zalogować?
Poproś o nowe hasło

Transfery 2020

Korona i III liga
IV liga i kl. okręgowa
Klasa A i B

Dafi Morawicka LF

I liga
II liga
Puchar Ligi

Nowińska LF

I Liga Futsalu
Amatorska LF
RS Active Puchar Ligi

Zagnańska LF

Kielecka LF

Rozgrywki

2020/2021

Klasa okręgowa

Klasa A, gr. II

Klasa A, gr. III

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ł.

Serwis

Redakcja (kontakt)
Patronat medialny

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