global $wpdb;
$row = $wpdb->get_results("SELECT page_id, status FROM wp_wpcreviews WHERE page_id = $post->ID AND status = 1");
$the_content .= $wpdb->num_rows . ' Reviews';
$wpdb->flush();
Basically I just removed the single quotes, they are not necessary, and selected 2 fields used to filter, then used $wpdb->num_rows variable to count the rows, and of course, added the flush() method to clean up the $wpdb query after we are done.
