3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = sprintf("SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE '%s%%'", 'x'); echo $sql;
Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.24 - 5.5.35, 5.6.7 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.25, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.27, 8.2.0 - 8.2.17, 8.3.0 - 8.3.4
SELECT ul.user_id, u.nickname, u.avatar ,u.intro, u.gender, u.points, ul.lng, ul.lat, ul.car_no FROM user_location ul INNER JOIN user u ON ul.user_id=u.id GROUP BY ul.user_id WHERE geohash LIKE 'x%'

preferences:
233.95 ms | 406 KiB | 324 Q