• marcosnakamine

• in reply to: How to order by date field
• March 26, 2019 at 2:04 am

This answer marked as private, so this is my contribution:

<?php
global $wpdb;
$posts = $wpdb->get_results( '
	SELECT
		wp_posts.ID,
		wp_posts.post_title,
		wp_posts.post_content
	FROM wp_posts
	INNER JOIN wp_postmeta
		ON wp_posts.ID = wp_postmeta.post_id
	WHERE
		wp_postmeta.meta_key = "your_acf_date_var"
		AND wp_posts.post_type = "your_post_type"
		AND wp_posts.post_status = "publish"
	GROUP BY wp_posts.ID
	ORDER BY wp_postmeta.meta_value ASC
' );
foreach ( $posts as $key => $value ) {
	var_dump( $value->post_title );
}
?>