3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php print_r(wordwrap('SELECT DISTINCT posting FROM \Common\Model\Entity\Posting posting WHERE posting.id = (SELECT max(subposting.id) FROM \Common\Model\Entity\Posting subposting INNER JOIN subposting.playlistPosting playlistPosting INNER JOIN playlistPosting.playlist playlist INNER JOIN subposting.postingLiveFeatures postingLiveFeatures LEFT JOIN subposting.video video LEFT JOIN subposting.audio audio LEFT JOIN subposting.pdf pdf WHERE subposting.studio=:currentStudio AND playlist.id = 1 AND subposting.isOnPlayer = 1 AND playlist.isOn = 1 AND playlist.type = 1 AND ((subposting.isVideoPlayer = 1 and video.mediaPath is not null) or (subposting.isAudioPlayer = 1 and audio.mediaPath is not null) or (subposting.isPdf = 1 and pdf.inProgress = 0) or (postingLiveFeatures.isOn = 1)))'));
Output for 5.2.0 - 5.6.28, hhvm-3.10.0 - 3.12.0, 7.0.0 - 7.1.0
SELECT DISTINCT posting FROM \Common\Model\Entity\Posting posting WHERE posting.id = (SELECT max(subposting.id) FROM \Common\Model\Entity\Posting subposting INNER JOIN subposting.playlistPosting playlistPosting INNER JOIN playlistPosting.playlist playlist INNER JOIN subposting.postingLiveFeatures postingLiveFeatures LEFT JOIN subposting.video video LEFT JOIN subposting.audio audio LEFT JOIN subposting.pdf pdf WHERE subposting.studio=:currentStudio AND playlist.id = 1 AND subposting.isOnPlayer = 1 AND playlist.isOn = 1 AND playlist.type = 1 AND ((subposting.isVideoPlayer = 1 and video.mediaPath is not null) or (subposting.isAudioPlayer = 1 and audio.mediaPath is not null) or (subposting.isPdf = 1 and pdf.inProgress = 0) or (postingLiveFeatures.isOn = 1)))
Output for 4.3.0 - 5.1.6
SELECT DISTINCT posting FROM \Common\Model\Entity\Posting posting WHERE posting.id = (SELECT max(subposting.id) FROM \Common\Model\Entity\Posting subposting INNER JOIN subposting.playlistPosting playlistPosting INNER JOIN playlistPosting.playlist playlist INNER JOIN subposting.postingLiveFeatures postingLiveFeatures LEFT JOIN subposting.video video LEFT JOIN subposting.audio audio LEFT JOIN subposting.pdf pdf WHERE subposting.studio=:currentStudio AND playlist.id = 1 AND subposting.isOnPlayer = 1 AND playlist.isOn = 1 AND playlist.type = 1 AND ((subposting.isVideoPlayer = 1 and video.mediaPath is not null) or (subposting.isAudioPlayer = 1 and audio.mediaPath is not null) or (subposting.isPdf = 1 and pdf.inProgress = 0) or (postingLiveFeatures.isOn = 1)))