3v4l.org

run code in 300+ PHP versions simultaneously
<?php $select = 'SELECT DISTINCT t.id as "t.id",t.creation_date as "t.creation_date",t.default_language_code as "t.default_language_code",t.name as "t.name",t.description as "t.description",t.document_store_path as "t.document_store_path",t.type as "t.type",t.left_value as "t.left_value",t.right_value as "t.right_value",t.event_id as "t.event_id",t.parent_id as "t.parent_id",t2.id as "t2.id",t2.creation_date as "t2.creation_date",t2.default_language_code as "t2.default_language_code",t2.name as "t2.name",t2.description as "t2.description",t2.document_store_path as "t2.document_store_path",t2.type as "t2.type",t2.left_value as "t2.left_value",t2.right_value as "t2.right_value",t2.event_id as "t2.event_id",t2.parent_id as "t2.parent_id"'; $from = 'FROM team t , (SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) WHERE tr.participant_id = ? UNION SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) LEFT JOIN unit_role ur ON (tr.unit_id = ur.unit_id) WHERE ur.participant_id = ?) as dt LEFT JOIN team t2 ON ("t.parent_id" = t2.id)'; $where = 'WHERE t.left_value < dt.left_value and t.right_value > dt.right_value and t.event_id = dt.event_id'; $sql = $select . ' ' . $from . ' ' . $where; echo $sql;
Output for git.master, git.master_jit, rfc.property-hooks
SELECT DISTINCT t.id as "t.id",t.creation_date as "t.creation_date",t.default_language_code as "t.default_language_code",t.name as "t.name",t.description as "t.description",t.document_store_path as "t.document_store_path",t.type as "t.type",t.left_value as "t.left_value",t.right_value as "t.right_value",t.event_id as "t.event_id",t.parent_id as "t.parent_id",t2.id as "t2.id",t2.creation_date as "t2.creation_date",t2.default_language_code as "t2.default_language_code",t2.name as "t2.name",t2.description as "t2.description",t2.document_store_path as "t2.document_store_path",t2.type as "t2.type",t2.left_value as "t2.left_value",t2.right_value as "t2.right_value",t2.event_id as "t2.event_id",t2.parent_id as "t2.parent_id" FROM team t , (SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) WHERE tr.participant_id = ? UNION SELECT t.* FROM team t LEFT JOIN team_role tr ON (t.id = tr.team_id) LEFT JOIN unit_role ur ON (tr.unit_id = ur.unit_id) WHERE ur.participant_id = ?) as dt LEFT JOIN team t2 ON ("t.parent_id" = t2.id) WHERE t.left_value < dt.left_value and t.right_value > dt.right_value and t.event_id = dt.event_id

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

preferences:
50.2 ms | 403 KiB | 8 Q