3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $test = sprintf("SELECT R.rateTypeId FROM rateType R LEFT JOIN rateSellPeriod S ON (S.rateTypeId=R.rateTypeId AND '%s'>=fromTime AND '%s'<toTime) WHERE R.rateTypeId IN (%s) AND (R.enableSellPeriods=0 OR S.rateTypeId IS NOT NULL)", 'a', 'b', 'c'); echo $test;
Output for 4.3.0 - 7.2.0
SELECT R.rateTypeId FROM rateType R LEFT JOIN rateSellPeriod S ON (S.rateTypeId=R.rateTypeId AND 'a'>=fromTime AND 'b'<toTime) WHERE R.rateTypeId IN (c) AND (R.enableSellPeriods=0 OR S.rateTypeId IS NOT NULL)