<?php
$sql = "
SELECT e.*
FROM ( SELECT personaId
, MIN(alternateEventDurationInMilliseconds) AS latest
FROM EVENT_DATA
GROUP BY personaId
) f
JOIN EVENT_DATA e
ON e.personaId = f.personaId
JOIN PERSONA p
ON p.ID = e.personaId
LEFT JOIN CUSTOMCAR cc
ON cc.ownedCarId = e.carId
;
SELECT p.ID
, e.personaId
, MIN(e.carId) AS carId
, MIN(e.alternateEventDurationInMilliseconds) AS alternateEventDurationInMilliseconds
, p.name AS p_name
, MIN(cc.name) AS c_name
, MIN(cc.ownedCarId) AS c_ownedCarId
, MIN(cc.carClassHash) AS c_hash
, MIN(ccs.full_name) AS cs_name
, MIN(e.EVENTID)
FROM ( SELECT personaId
, MIN(alternateEventDurationInMilliseconds) AS latest
FROM EVENT_DATA
GROUP BY personaId
) AS f
JOIN EVENT_DATA e
ON e.personaId = f.personaId
JOIN PERSONA p
ON p.ID = e.personaId
JOIN CUSTOMCAR cc
ON cc.ownedCarId = e.carId
JOIN CAR_CLASSES ccs
ON ccs.store_name = cc.name
JOIN USER u
ON u.ID = p.USERID
WHERE e.EVENTID = 28
AND e.alternateEventDurationInMilliseconds > 0
GROUP BY personaId
ORDER BY alternateEventDurationInMilliseconds ASC
";
";
Parse error: syntax error, unexpected end of file, expecting variable (T_VARIABLE) or ${ (T_DOLLAR_OPEN_CURLY_BRACES) or {$ (T_CURLY_OPEN) in /in/udeB5 on line 50
Process exited with code 255.