<?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)))'));
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)))
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)))