3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php $str = <<< EOF SELECT * FROM EventManager_user_d2 as u LEFT JOIN EventManager_answer as a ON u.uid = a.user LEFT JOIN EventManager_question as q ON a.question = q.qid WHERE ( UPPER(REPLACE(q.label, " ", "")) LIKE UPPER(REPLACE(:label0, " ", "")) AND UPPER(REPLACE(a.answer, " ", "")) LIKE UPPER(REPLACE(:value0, " ", "")) ) AND ( UPPER(REPLACE(q.label, " ", "")) LIKE UPPER(REPLACE(:label2, " ", "")) AND UPPER(REPLACE(a.answer, " ", "")) = UPPER(REPLACE(:value2, " ", "")) ) ORDER BY u.uid DESC EOF; echo substr($str, 50);
based on coQ8h
Output for 4.3.0 - 7.1.0
EventManager_answer as a ON u.uid = a.user LEFT JOIN EventManager_question as q ON a.question = q.qid WHERE ( UPPER(REPLACE(q.label, " ", "")) LIKE UPPER(REPLACE(:label0, " ", "")) AND UPPER(REPLACE(a.answer, " ", "")) LIKE UPPER(REPLACE(:value0, " ", "")) ) AND ( UPPER(REPLACE(q.label, " ", "")) LIKE UPPER(REPLACE(:label2, " ", "")) AND UPPER(REPLACE(a.answer, " ", "")) = UPPER(REPLACE(:value2, " ", "")) ) ORDER BY u.uid DESC