wpml_posts_count_query.php

<?php
function _wpml_posts_sql_query($post_type = 'post', $post_status = 'publish', $language_code = ICL_LANGUAGE_CODE)
{
    global $wpdb;

    $post_type = "post_$post_type";
 
    $query = "SELECT COUNT( {$wpdb->prefix}posts.ID )
                FROM {$wpdb->prefix}posts
                LEFT JOIN {$wpdb->prefix}icl_translations ON {$wpdb->prefix}posts.ID = {$wpdb->prefix}icl_translations.element_id
                WHERE {$wpdb->prefix}icl_translations.language_code = '{$language_code}'
                AND {$wpdb->prefix}icl_translations.element_type = 'post_{$post_type}'
                AND {$wpdb->prefix}posts.post_status = '$post_status'";

    return $query;
}

function wpml_count_posts($post_type = 'post', $post_status = 'publish', $language_code = ICL_LANGUAGE_CODE)
{ 
    global $wpdb;
 
    return $wpdb->get_var( _wpml_posts_sql_query($post_type, $post_status, $language_code) );
}