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 = 12319
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 /* statClass|12319| */
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 NOT (m.HFullTime IS NULL AND m.vo > 0)
AND p.PersonID = 12319
) 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 = 12319
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, t.Category
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 = 12319
ORDER BY pr.DateFrom