Online PHP editor | vld for Jac4A

@ 2013-09-18T18:00:21Z

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

Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/Jac4A
function name:  (null)
number of ops:  10
compiled vars:  !0 = $select, !1 = $from, !2 = $where, !3 = $sql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   ASSIGN                                                   !0, 'SELECT+DISTINCT+t.id+as+%22t.id%22%2Ct.creation_date+as+%22t.creation_date%22%2Ct.default_language_code+as+%0A+%22t.default_language_code%22%2Ct.name+as+%22t.name%22%2Ct.description+as+%22t.description%22%2Ct.document_store_path+as+%0A+%22t.document_store_path%22%2Ct.type+as+%22t.type%22%2Ct.left_value+as+%22t.left_value%22%2Ct.right_value+as+%22t.right_value%22%2Ct.event_id+as+%0A+%22t.event_id%22%2Ct.parent_id+as+%22t.parent_id%22%2Ct2.id+as+%22t2.id%22%2Ct2.creation_date+as+%0A+%22t2.creation_date%22%2Ct2.default_language_code+as+%22t2.default_language_code%22%2Ct2.name+as+%22t2.name%22%2Ct2.description+%0A+as+%22t2.description%22%2Ct2.document_store_path+as+%22t2.document_store_path%22%2Ct2.type+as+%22t2.type%22%2Ct2.left_value+as+%0A+%22t2.left_value%22%2Ct2.right_value+as+%22t2.right_value%22%2Ct2.event_id+as+%22t2.event_id%22%2Ct2.parent_id+as+%22t2.parent_id%22'
   10     1        ASSIGN                                                   !1, 'FROM+team+t+%2C+%28SELECT+t.%2A+FROM+team+t+LEFT+JOIN+team_role+tr+ON+%28t.id+%3D+tr.team_id%29+WHERE+%0A+tr.participant_id+%3D+%3F+UNION+SELECT+t.%2A+FROM+team+t+LEFT+JOIN+team_role+tr+ON+%28t.id+%3D+tr.team_id%29+LEFT+JOIN+%0A+unit_role+ur+ON+%28tr.unit_id+%3D+ur.unit_id%29+WHERE+ur.participant_id+%3D+%3F%29+as+dt+LEFT+JOIN+team+t2+ON+%28%22t.parent_id%22+%3D+t2.id%29'
   13     2        ASSIGN                                                   !2, 'WHERE+t.left_value+%3C+dt.left_value+and+t.right_value+%3E+dt.right_value+and+t.event_id+%3D+dt.event_id'
   14     3        CONCAT                                           ~7      !0, '+'
          4        CONCAT                                           ~8      ~7, !1
          5        CONCAT                                           ~9      ~8, '+'
          6        CONCAT                                           ~10     ~9, !2
          7        ASSIGN                                                   !3, ~10
   16     8        ECHO                                                     !3
          9      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0

preferences:dark modelive preview