3v4l.org

run code in 300+ PHP versions simultaneously
<?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 "; ";
Output for 5.6.38, 7.1.0 - 7.1.24, 7.2.0 - 7.2.12
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.

preferences:
176.63 ms | 1395 KiB | 46 Q