How do I select two meta_value by $ wpdb-> get_row mode?

PHP
1

How do I select two meta_value via $ wpdb-> get_row or a lighter way?

global $wpdb;
$id = get_the_ID();
$selecttwovalue = $wpdb->get_row("SELECT  PM.meta_value, DU.meta_value
FROM $wpdb->posts AS P
LEFT JOIN $wpdb->postmeta AS PM on PM.meta_key = 'australian_brother_1'
   JOIN $wpdb->postmeta AS DU on DU.meta_key = 'australian_brother_2'
WHERE p.ID = '$id'");
        
        
       echo $selecttwovalue->PM;

From different meta keys please

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.