3v4l.org

run code in 200+ php & hhvm versions
Bugs & Features
<?php $sql = "SELECT fc.forum_id,count(fc.forum_id)as total_comments ". "FROM ForumComments as fc ". "WHERE DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= fc.updated_at ". "GROUP BY fc.forum_id ". "ORDER BY total_comments DESC "; echo($sql);
Output for 4.3.0 - 7.2.0
SELECT fc.forum_id,count(fc.forum_id)as total_comments FROM ForumComments as fc WHERE DATE_SUB( CURDATE( ) , INTERVAL 1 DAY ) <= fc.updated_at GROUP BY fc.forum_id ORDER BY total_comments DESC