Unknown column 'RAZEM' in 'where clause' SELECT * FROM competitions WHERE CompID = RAZEM
, /
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` 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
Unknown column 'RAZEM' 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 = RAZEM AND ADDDATE(COALESCE(m.Date, r.Date), INTERVAL +1 DAY) > '2024-03-19 08:38:30' AND m.Date > '1910-01-01'
Ostatnie spotkania
Unknown column 'RAZEM' 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 = RAZEM AND COALESCE(m.Date, r.Date) < '2024-03-19 08:38:30'
Unknown column 'RAZEM' in 'where clause' SELECT COUNT(*) FROM rounds INNER JOIN matches USING (RoundID) WHERE CompID = RAZEM Unknown column 'RAZEM' in 'where clause' SELECT COUNT(*) FROM tablelineinfo WHERE CompID = RAZEM Unknown column 'RAZEM' 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 = RAZEM
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 = RAZEM Unknown column 'RAZEM' 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 = RAZEM
Terminarz
Unknown column 'RAZEM' 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 = RAZEM
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 = RAZEM AND i.TeamID = t.TeamID
INNER JOIN names n ON n.NameID = t.NameID
WHERE i.CompID = RAZEM
ORDER BY ValidFrom ASC Unknown column 'RAZEM' 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 = RAZEM GROUP BY r.RoundID ORDER BY r.Date, r.Number, p.Number Unknown column 'RAZEM' in 'where clause' SELECT /* SMPL: RAZEM, , , 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.Guid, ps.Url, ps.Stadium as ExStadium,
c.Type AS CompType,
TIMESTAMPDIFF(MINUTE, NOW(), m.Date) AS TimeToMatch
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 pzpnmatches ps ON ps.MatchID = m.MatchID
WHERE r.CompID = RAZEM
GROUP BY r.RoundID, m.MatchID
ORDER BY r.Date, r.Number, m.Date, m.MatchID