Cacher is the code snippet organizer for pro developers

<h3>This is the code:<?php $numpost = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' AND post_date > '2007-01-01' AND post_date < '2014-01-01' "); echo $numpost; ?></h3>