3v4l.org

run code in 300+ PHP versions simultaneously
<?php $sql = "SELECT vysledky2.cisloobch, vysledky2.datum, vysledky2.vysledek, dealersdata.nazevobch, dealersdata.mesto, dealersdata.zeme, psc, " + " (CASE WHEN prod_smlouva = 'True' OR serv_smlouva = 'True' THEN 'Ano' ELSE 'Ne' END) as skoda," + " (CASE WHEN prod_smlouva_v = 'True' OR serv_smlouva_v = 'True' OR serv_smlouva_a = 'True' OR prod_smlouva_a = 'True' OR serv_smlouva_n = 'True' OR prod_smlouva_n = 'True' OR serv_smlouva_s = 'True' OR prod_smlouva_s = 'True' THEN 'Ano' ELSE 'Ne' END) as ost_koncern" + " FROM vysledky2 JOIN" + " (select cisloobch, max(datum) as datum from vysledky2 where dotazid = 94 and vysledek not like '%ORA%' group by cisloobch) as nejvyssi"+ " on vysledky2.cisloobch = nejvyssi.cisloobch and vysledky2.datum = nejvyssi.datum"+ " JOIN dealersdata on vysledky2.cisloobch = dealersdata.cisloobch"+ " WHERE dealersdata.vyrazeny = 'False' AND jiny != 'True' "; echo $sql; ?>
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/cS6DU
function name:  (null)
number of ops:  10
compiled vars:  !0 = $sql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   ADD                                              ~1      'SELECT+vysledky2.cisloobch%2C+vysledky2.datum%2C+vysledky2.vysledek%2C+dealersdata.nazevobch%2C+dealersdata.mesto%2C+dealersdata.zeme%2C+psc%2C+', '+%28CASE+WHEN+prod_smlouva+%3D+%27True%27+OR+serv_smlouva+%3D+%27True%27+THEN+%27Ano%27+ELSE+%27Ne%27+END%29+as+skoda%2C'
    4     1        ADD                                              ~2      ~1, '+%28CASE+WHEN+prod_smlouva_v+%3D+%27True%27+OR+serv_smlouva_v+%3D+%27True%27+OR+serv_smlouva_a+%3D+%27True%27+OR+prod_smlouva_a+%3D+%27True%27+OR+serv_smlouva_n+%3D+%27True%27+OR+prod_smlouva_n+%3D+%27True%27+OR+serv_smlouva_s+%3D+%27True%27++OR+prod_smlouva_s+%3D+%27True%27+THEN+%27Ano%27+ELSE+%27Ne%27+END%29+as+ost_koncern'
    5     2        ADD                                              ~3      ~2, '+FROM+vysledky2+JOIN'
    6     3        ADD                                              ~4      ~3, '+%28select+cisloobch%2C+max%28datum%29+as+datum+from+vysledky2+where+dotazid+%3D+94+and+vysledek+not+like+%27%25ORA%25%27+group+by+cisloobch%29+as+nejvyssi'
    7     4        ADD                                              ~5      ~4, '+on+vysledky2.cisloobch+%3D+nejvyssi.cisloobch+and+vysledky2.datum+%3D+nejvyssi.datum'
    8     5        ADD                                              ~6      ~5, '+JOIN+dealersdata+on+vysledky2.cisloobch+%3D+dealersdata.cisloobch'
    9     6        ADD                                              ~7      ~6, '+WHERE+dealersdata.vyrazeny+%3D+%27False%27+AND+jiny+%21%3D+%27True%27+'
    2     7        ASSIGN                                                   !0, ~7
   11     8        ECHO                                                     !0
   12     9      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
148.79 ms | 1394 KiB | 13 Q