Александр

SELECT
    f.*
FROM
    films f
LEFT JOIN meta_films m ON
    m.id_films = f.id
    AND m.meta_value IN(13, 23)
WHERE
	m.id_films IS NOT NULL

$order_ids_approved = $wpdb->get_results( "SELECT `ID` FROM `avt_posts` WHERE `post_status` = 'wc-approved' AND (`post_date` BETWEEN '{$start_day}' AND '{$end_day}')", ARRAY_A );

$count = $wpdb->get_var( "SELECT count(*) FROM `avt_posts` WHERE `post_type` = 'shop_order'" );
echo $count;