3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $s = "SELECT DISTINCT p0_.id AS id0, p0_.title AS title1, p0_.on_air AS on_air2, p0_.description AS description3, p0_.keywords AS keywords4, p0_.posted AS posted5, p0_.is_on_player AS is_on_player6, p0_.is_on_rss AS is_on_rss7, p0_.private AS private8, p0_.is_display_date AS is_display_date9, p0_.is_audio_download AS is_audio_download10, p0_.is_audio_player AS is_audio_player11, p0_.is_video_download AS is_video_download12, p0_.is_video_player AS is_video_player13, p0_.is_srt_on AS is_srt_on14, p0_.is_notes_on AS is_notes_on15, p0_.created AS created16, p0_.updated AS updated17, p0_.is_pdf AS is_pdf18, p0_.series_number AS series_number19, p0_.alt_location AS alt_location20, p0_.video_start_time AS video_start_time21, p0_.video_stop_time AS video_stop_time22, p0_.audio_start_time AS audio_start_time23, p0_.audio_stop_time AS audio_stop_time24, p0_.studio_id AS studio_id25, p0_.artwork_id AS artwork_id26, p0_.speaker_id AS speaker_id27, p0_.language_id AS language_id28, p0_.liveSchedule_id AS liveSchedule_id29 FROM posting p0_ WHERE p0_.id = (SELECT max(p1_.id) AS dctrn__1 FROM posting p1_ INNER JOIN playlist_posting p2_ ON p1_.id = p2_.posting_id INNER JOIN playlist p3_ ON p2_.playlist_id = p3_.id INNER JOIN posting_live_features p4_ ON p1_.id = p4_.posting_id LEFT JOIN posting_has_video p6_ ON p1_.id = p6_.posting_id LEFT JOIN video v5_ ON v5_.id = p6_.video_id LEFT JOIN posting_has_audio p8_ ON p1_.id = p8_.posting_id LEFT JOIN audio a7_ ON a7_.id = p8_.audio_id LEFT JOIN posting_has_pdf p10_ ON p1_.id = p10_.posting_id LEFT JOIN pdf p9_ ON p9_.id = p10_.pdf_id WHERE p0_.studio_id = ? AND p3_.id = 1 AND p1_.is_on_player = 1 AND p3_.is_on = 1 AND p3_.type = 1 AND ((p1_.is_video_player = 1 AND v5_.media_path IS NOT NULL) OR (p1_.is_audio_player = 1 AND a7_.media_path IS NOT NULL) OR (p1_.is_pdf = 1 AND p9_.in_progress = 0) OR (p4_.is_on = 1)))"; var_dump(wordwrap($s));
Output for 5.2.0 - 7.1.0
string(1869) "SELECT DISTINCT p0_.id AS id0, p0_.title AS title1, p0_.on_air AS on_air2, p0_.description AS description3, p0_.keywords AS keywords4, p0_.posted AS posted5, p0_.is_on_player AS is_on_player6, p0_.is_on_rss AS is_on_rss7, p0_.private AS private8, p0_.is_display_date AS is_display_date9, p0_.is_audio_download AS is_audio_download10, p0_.is_audio_player AS is_audio_player11, p0_.is_video_download AS is_video_download12, p0_.is_video_player AS is_video_player13, p0_.is_srt_on AS is_srt_on14, p0_.is_notes_on AS is_notes_on15, p0_.created AS created16, p0_.updated AS updated17, p0_.is_pdf AS is_pdf18, p0_.series_number AS series_number19, p0_.alt_location AS alt_location20, p0_.video_start_time AS video_start_time21, p0_.video_stop_time AS video_stop_time22, p0_.audio_start_time AS audio_start_time23, p0_.audio_stop_time AS audio_stop_time24, p0_.studio_id AS studio_id25, p0_.artwork_id AS artwork_id26, p0_.speaker_id AS speaker_id27, p0_.language_id AS language_id28, p0_.liveSchedule_id AS liveSchedule_id29 FROM posting p0_ WHERE p0_.id = (SELECT max(p1_.id) AS dctrn__1 FROM posting p1_ INNER JOIN playlist_posting p2_ ON p1_.id = p2_.posting_id INNER JOIN playlist p3_ ON p2_.playlist_id = p3_.id INNER JOIN posting_live_features p4_ ON p1_.id = p4_.posting_id LEFT JOIN posting_has_video p6_ ON p1_.id = p6_.posting_id LEFT JOIN video v5_ ON v5_.id = p6_.video_id LEFT JOIN posting_has_audio p8_ ON p1_.id = p8_.posting_id LEFT JOIN audio a7_ ON a7_.id = p8_.audio_id LEFT JOIN posting_has_pdf p10_ ON p1_.id = p10_.posting_id LEFT JOIN pdf p9_ ON p9_.id = p10_.pdf_id WHERE p0_.studio_id = ? AND p3_.id = 1 AND p1_.is_on_player = 1 AND p3_.is_on = 1 AND p3_.type = 1 AND ((p1_.is_video_player = 1 AND v5_.media_path IS NOT NULL) OR (p1_.is_audio_player = 1 AND a7_.media_path IS NOT NULL) OR (p1_.is_pdf = 1 AND p9_.in_progress = 0) OR (p4_.is_on = 1)))"
Output for 4.3.0 - 5.1.6
string(1869) "SELECT DISTINCT p0_.id AS id0, p0_.title AS title1, p0_.on_air AS on_air2, p0_.description AS description3, p0_.keywords AS keywords4, p0_.posted AS posted5, p0_.is_on_player AS is_on_player6, p0_.is_on_rss AS is_on_rss7, p0_.private AS private8, p0_.is_display_date AS is_display_date9, p0_.is_audio_download AS is_audio_download10, p0_.is_audio_player AS is_audio_player11, p0_.is_video_download AS is_video_download12, p0_.is_video_player AS is_video_player13, p0_.is_srt_on AS is_srt_on14, p0_.is_notes_on AS is_notes_on15, p0_.created AS created16, p0_.updated AS updated17, p0_.is_pdf AS is_pdf18, p0_.series_number AS series_number19, p0_.alt_location AS alt_location20, p0_.video_start_time AS video_start_time21, p0_.video_stop_time AS video_stop_time22, p0_.audio_start_time AS audio_start_time23, p0_.audio_stop_time AS audio_stop_time24, p0_.studio_id AS studio_id25, p0_.artwork_id AS artwork_id26, p0_.speaker_id AS speaker_id27, p0_.language_id AS language_id28, p0_.liveSchedule_id AS liveSchedule_id29 FROM posting p0_ WHERE p0_.id = (SELECT max(p1_.id) AS dctrn__1 FROM posting p1_ INNER JOIN playlist_posting p2_ ON p1_.id = p2_.posting_id INNER JOIN playlist p3_ ON p2_.playlist_id = p3_.id INNER JOIN posting_live_features p4_ ON p1_.id = p4_.posting_id LEFT JOIN posting_has_video p6_ ON p1_.id = p6_.posting_id LEFT JOIN video v5_ ON v5_.id = p6_.video_id LEFT JOIN posting_has_audio p8_ ON p1_.id = p8_.posting_id LEFT JOIN audio a7_ ON a7_.id = p8_.audio_id LEFT JOIN posting_has_pdf p10_ ON p1_.id = p10_.posting_id LEFT JOIN pdf p9_ ON p9_.id = p10_.pdf_id WHERE p0_.studio_id = ? AND p3_.id = 1 AND p1_.is_on_player = 1 AND p3_.is_on = 1 AND p3_.type = 1 AND ((p1_.is_video_player = 1 AND v5_.media_path IS NOT NULL) OR (p1_.is_audio_player = 1 AND a7_.media_path IS NOT NULL) OR (p1_.is_pdf = 1 AND p9_.in_progress = 0) OR (p4_.is_on = 1)))"