User kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connectionsUser kieleckasql2 already has more than 'max_user_connections' active connections
User kieleckasql2 already has more than 'max_user_connections' active connections
SELECT *,
DATEDIFF(NOW(), COALESCE(Born, CAST(CONCAT(BornYear, '-07-01') AS DATE))) / 365.25 AS Age
FROM people WHERE PersonID = 7324
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/db.inc on line 32 User kieleckasql2 already has more than 'max_user_connections' active connections
SELECT m.Season, m.TeamID, m.PersonID, m.CompType, m.ShortName, SUM(TimeTo - TimeFrom + 1) AS TimePld, m.CompType,
SUM(FirstSquad) AS FirstSquad, SUM(Bench) AS Bench, SUM(SubOut) AS SubOut, SUM(FullTime) AS FullTime
FROM (
SELECT
p.PersonID, --p.FirstName, p.LastName,
c.Type AS CompType, c.ShortName, c.Season, t.TeamID, c.CompID, c.Level,
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,
e.Minute, 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.SubApp IS NOT NULL AS SubOut,
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')
WHERE 1 AND NOT (a.ViewNum > 11 AND a.SubApp IS NULL)
AND p.PersonID = 7324
) AS m
GROUP BY m.Season, m.PersonID, m.CompType, m.ShortName, m.TeamID, m.CompID, m.Level
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/statClass.php on line 210 User kieleckasql2 already has more than 'max_user_connections' active connections
SELECT
c.Season, t.TeamID, p.PersonID, c.Type AS CompType, c.ShortName, c.CompID, c.Level,
COUNT(*) AS Num, e.Type AS EventType
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 1
AND p.PersonID = 7324
GROUP BY c.Season, t.TeamID, p.PersonID, c.Type, e.Type, c.ShortName, c.CompID, c.Level
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/kielecka/www/engine/statClass.php on line 229
User kieleckasql2 already has more than 'max_user_connections' active connections
SELECT
pr.TeamID, pr.DateFrom, ADDDATE(pr.DateTo, INTERVAL 1 DAY) AS DateTo, n.Name AS TeamName, c.Region, pr.Info
FROM peopleroles pr
LEFT JOIN teams t USING (TeamID)
LEFT JOIN clubs c ON c.ClubID = t.ClubID
LEFT JOIN names n ON n.NameID = t.NameID AND ValidFrom = (SELECT MAX(ValidFrom) FROM names q WHERE q.NameID = t.NameID AND q.ValidFrom < pr.DateFrom)
WHERE pr.PersonID = 7324
ORDER BY pr.DateFrom