<?php
$post_type = 'post';
$post_type2 = 'listing';
$post_type3 = 'answer';
$post_type4 = 'question';
global $wpdb;
/**/
$count = $wpdb->get_col( "SELECT COUNT(ID) FROM $wpdb->posts WHERE post_author = '" . $curauth->ID . "' AND post_type = '".$post_type." or ".$post_type2." or ".$post_type3."' or ".$post_type4."' and post_status = 'publish'" );
echo $post_type; 
echo $post_type2;
echo $post_type3;
echo $post_type4
?>