@ 2014-07-23T04:17:01Z <?php
$yesterday = date('Y-m-d', strtotime("-1 days"));
$sql = "SELECT fc.forum_id,count(fc.forum_id)as total_comments ".
"FROM ForumComments as fc ".
"WHERE $yesterday <= fc.updated_at ".
"GROUP BY fc.forum_id ".
"ORDER BY total_comments DESC ";
echo($sql);
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 4.3.0 - 4.3.11 , 4.4.0 - 4.4.9 , 5.0.0 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.0 - 5.5.38 , 5.6.0 - 5.6.28 , 7.0.0 - 7.0.20 , 7.1.0 - 7.1.20 , 7.2.0 - 7.2.33 , 7.3.12 - 7.3.33 , 7.4.0 - 7.4.33 , 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 SELECT fc.forum_id,count(fc.forum_id)as total_comments FROM ForumComments as fc WHERE 2014-07-22 <= fc.updated_at GROUP BY fc.forum_id ORDER BY total_comments DESC preferences:dark mode live preview
239.07 ms | 406 KiB | 354 Q